The Scenario
You're a developer advocate. Five Basin forms have been running for the past week. You need to review every "new" (unread) submission from the last 7 days across all five forms and check whether any genuine leads got misclassified as spam before the weekly sales handoff. The sales team wants the triage sheet by 3 PM.
The bad version:
- Open each Basin form one at a time
- Click through submissions, manually filtering by status
- Copy anything suspicious into a Google Sheet
- Realize form 3 has 80 new submissions and you're already at 2:45 PM
You don't have time for that.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet that reads the data and talks to Basin for you. No clicking through forms, no manual copying.
Open the SheetXAI sidebar and type:
Fetch all Basin submissions with status 'new' from the last 7 days for form IDs in column A and write submission date, email, and all field values into my sheet — one row per submission
What You Get
- Every new submission from all five forms in one sheet, sorted by date so you see the freshest leads first
- Full field values per row so you can eyeball the content without opening Basin
- A consistent structure across forms so you can apply a single spam-review filter column
What If the Data Is Not Quite Ready
When you also want to pull spam-flagged submissions alongside the new ones
Fetch Basin submissions from the last 7 days for form IDs in column A where status is 'new' or 'spam', write each to my sheet with a Status column, and sort by submission date descending
When the date range is in cells rather than hardcoded
Fetch Basin submissions for each form ID in column A where the submission date falls between the dates in cells B1 and B2 — write email, date, status, and all field values to Sheet2
When you only want submissions where the email domain is not a freemail provider
Fetch new Basin submissions from the last 7 days for form IDs in column A, filter out rows where the email column ends in gmail.com, yahoo.com, or hotmail.com, and write the remaining rows to Sheet2 for sales review
When you want it all in one shot
Fetch all Basin submissions from the last 7 days for form IDs in column A, combine new and spam statuses, filter out freemail email addresses, deduplicate by email keeping the most recent, sort by date descending, and write to Sheet2 — add a header row and a total count in cell A1
The pattern: instead of pulling data first and then filtering it, you ask for both in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open any sheet with Basin form IDs. Ask it to pull the filtered submissions and write them for review. The Basin integration is included in every SheetXAI plan. For related tasks, see Pull All Basin Form Submissions Into a Google Sheet for Analysis or the Basin in Google Sheets overview.