The Scenario
You're a web agency developer. Launch day is tomorrow. Fifteen client landing pages are going live simultaneously, each needing its own Basin form. You have a sheet with form names, project IDs, and timezones for all 15. Clicking through the Basin UI one form at a time is a 90-minute job you don't have.
The bad version:
- Open Basin, click "New Form," fill in the name, set the project, set the timezone, save
- Copy the form ID manually into your sheet
- Repeat 14 more times, hoping you don't transpose a project ID
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, no copy-pasting, no manual ID tracking.
Open the SheetXAI sidebar and type:
Create Basin forms from my sheet: column A = form name, column B = project ID, column C = timezone — create one form per row for all 15 rows and write the new form IDs back to column D
What You Get
- All 15 Basin forms provisioned in one pass with the correct project and timezone per row
- New form IDs written directly to column D so your sheet stays the source of truth
- Any rows that fail (duplicate name, invalid project ID) flagged in column E so you can fix and rerun
What If the Data Is Not Quite Ready
When the project IDs in column B are names, not IDs
Column B has Basin project names, not IDs. Look up each project by name to get its ID, then create Basin forms with column A as the name, the resolved project ID, and column C as the timezone — write form IDs to column D
When you also need a redirect URL per form
Create Basin forms from my sheet: form name in column A, project ID in column B, timezone in column C, redirect URL in column D — create one form per row and write the new form IDs to column E
When you want to skip rows that already have a form ID
Create Basin forms for all rows in my sheet where column D is empty — use column A for name, column B for project ID, column C for timezone — write new form IDs to column D
When you want it all in one shot
Read my sheet, skip any row where column D already has a value, create a Basin form for each remaining row using columns A–C, write form IDs to column D, and write a summary to cell F1 with total created and any rows that errored
The pattern: instead of provisioning forms first and then recording the IDs, you ask for both in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open any sheet with form configuration data. Ask it to bulk-create the Basin forms and write the IDs back. 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.