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 Excel 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 Excel 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 Excel workbook that can call Jotform's usage statistics API and write the data into the workbook, so you never have to read numbers off a screen and type them by hand.
Open the SheetXAI sidebar and type:
Pull my Jotform account usage stats and add the submission count, storage used in MB, and plan limit into a new row in my Excel Usage tab.
SheetXAI calls Jotform's usage stats API and writes the current numbers into a new row in the Usage tab.
What You Get
A usage snapshot appended to the workbook:
- Monthly submission count — how many submissions have been recorded this month
- Storage used in MB — total file upload storage consumed in your account
- Plan limit — your monthly submission cap, for context
You have the number in the workbook, not on a browser tab you will close. Build a historical table by running the same prompt each week. Each run adds a row.
What If the Data Is Not Quite Ready
Usage tracking always benefits from context and alerts. SheetXAI can add them 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 a new row of the Usage tab. In a third column, calculate the percentage of the limit used.
When you want to flag when usage exceeds 80 percent of the plan limit
You want a warning in the workbook 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 a new row in the Usage tab. 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 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 tab 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 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 tab with today's date. Look at the previous rows in the workbook 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 an Excel workbook 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 in Excel or the Jotform in Excel overview.