The Scenario
You inherited this Formcarry form from someone who left the team six weeks ago. The form has 800 submissions sitting in the account, spread across multiple API pages. You've been asked to produce a funnel analysis — how many leads came through, what their stated budget was, and which stage of the funnel they indicated.
You went into the Formcarry dashboard. You can see the submissions. The export only pulls the current page view, and you can't figure out how many pages there are or how to get them all at once without clicking through manually.
The bad version:
- Attempt to export page by page from the dashboard UI, track which pages you've already downloaded in a sticky note, miss page 4, realize later when the counts don't add up
- Combine the CSVs in Excel manually, discover that page 3's export had a slightly different column order, spend 20 minutes re-aligning before you can even start the analysis
- Get 780 rows instead of 800, send the analysis to the director of growth, and get a reply back asking why the number doesn't match what they see in the dashboard
This was never going to be a 15-minute job. But nobody told you that when they asked for it by end of week.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook, understands the context, and through its built-in Formcarry integration it can call the API, paginate through all result pages automatically, and write every submission into a single worksheet. One ask.
Fetch all pages of submissions from my Formcarry form and write every submission into this Excel sheet — paginate automatically until no more results are returned
What You Get
- Every submission lands in the workbook, regardless of how many API pages the dataset spans
- Rows write sequentially with no gaps, duplication, or page-break artifacts
- Column headers reflect actual field names from the form, including any fields that only appear on certain submissions
- The final row count in the worksheet matches what Formcarry reports as the total submission count
What If the Data Is Not Quite Ready
The form ID needs to come from the workbook rather than being hardcoded
You have multiple Formcarry forms and the form ID is tracked in cell A1 so the same workbook template can be reused.
Pull all Formcarry submissions from the form ID in cell A1 and write them to this sheet starting at row 2, then write the total submission count into cell B1
Submissions span multiple forms and you need them combined
Your lead capture flow uses two different Formcarry forms depending on which landing page the visitor came from.
Fetch all submissions from Formcarry form IDs listed in A1 and A2, combine them into a single dataset, add a column called 'form_source' that records which form each submission came from, and write everything to this sheet
You only need submissions from the last 90 days, not the full history
800 submissions is too much history for this particular analysis — the director only wants the trailing quarter.
Pull all Formcarry submissions, filter to only those submitted in the last 90 days, and write them to this sheet with headers in row 1
Full pipeline: fetch all pages, add metadata, filter, and count in one shot
Fetch all Formcarry submissions from the form ID in cell A1, paginate through all pages, filter to submissions from the last 90 days, write them to this sheet with a 'form_source' column set to the form ID, then write the count of qualifying submissions into cell B1
That's one prompt to handle pagination, filtering, column augmentation, and the summary count simultaneously — rather than doing each as a separate pass.
Try It
Open an Excel workbook set up for lead intake or funnel tracking, then get the 7-day free trial of SheetXAI and ask it to fetch all pages of your Formcarry submissions. For source segmentation once the data is in the workbook, see the lead analysis spoke. For comparing submission volumes across time periods, see the quarterly comparison spoke.