The Scenario
You are the owner of a small professional services firm. You run Jotform for client intake, event signups, and a monthly newsletter opt-in. You are on a mid-tier Jotform plan with a monthly submission limit and a storage cap.
Last month you hit the submission limit mid-month and forms stopped accepting responses for four days before you noticed. You want to build a usage tracker in Google Sheets that you can check each week so you never get surprised again.
The bad version:
- You log into Jotform's My Account > Usage page
- You read the numbers on screen: monthly submissions used, storage used
- You open Google Sheets and type today's numbers manually
- You do this every week
- Three months later, you have 12 manually typed rows and no confidence they are accurate.
The fast version is one prompt, and then the same prompt each week.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that can call Jotform's usage statistics API and write the data into the sheet, so you never have to read numbers off a screen and type them by hand.
Open the SheetXAI sidebar and type:
Fetch the Jotform account usage statistics and write the monthly submission count, payment submissions, and storage used into my Usage Tracking sheet.
SheetXAI calls Jotform's usage stats API and writes the current numbers into the sheet. Run the same prompt next week and the row updates.
What You Get
A usage snapshot written into the sheet:
- Monthly submission count — how many submissions have been recorded this month
- Payment submissions — if you use Jotform Payments, how many payment transactions
- Storage used — total file upload storage consumed in your account
You have the number in the sheet, not on a browser tab you will close. Keep a weekly log by appending each run to a new row with a date stamp.
What If the Data Is Not Quite Ready
Usage tracking always benefits from context. SheetXAI can enrich the raw numbers in the same prompt.
When you want to add the plan limit alongside the current usage
Raw numbers without context are less useful. You want to see how close you are to the cap.
Fetch the Jotform account usage statistics. Write the current monthly submission count and the plan's monthly submission limit into the Usage Tracking sheet. In a third column, calculate the percentage of the limit used.
When you want to append a new row each week rather than overwrite
You want to build a historical table, not just a single-row snapshot.
Fetch the Jotform account usage statistics. Append a new row to the Usage Tracking sheet with today's date, the monthly submission count, the payment submission count, and the storage used in MB. Do not overwrite existing rows.
When you want to flag when usage exceeds 80 percent of the plan limit
You want a warning in the sheet when you are approaching the cap so you can act before forms stop.
Fetch the Jotform account usage statistics and the plan submission limit. Write the current count, the limit, and the percentage used into the Usage Tracking sheet. In a Status column, write "On track" if usage is below 80%, "Warning" if between 80% and 95%, and "Near limit — act now" if above 95%.
When you need the full monthly snapshot with all metrics, a trend note, and a projected end-of-month count
The complete weekly check-in: current usage, trend versus last week, and a projection.
Fetch the Jotform account usage statistics. Write monthly submission count, payment submissions, and storage used into a new row in the Usage Tracking sheet with today's date. Look at the previous rows in the sheet to calculate the week-over-week change in submission count. In a Notes column on today's row, write a one-sentence observation: whether submissions are trending up, down, or flat, and an estimated end-of-month count based on the current pace.
The pattern: the API gives you the numbers, the prompt adds the judgment about what they mean.
Try It
Get the 7-day free trial of SheetXAI and pull your Jotform usage stats into a sheet in one prompt, then add plan limit context and a status flag in the same pass. The Jotform integration is included in every SheetXAI plan. For more, see how to build a full forms inventory and activity audit or the Jotform in Google Sheets overview.