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 an Excel workbook 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 workbook
- 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 Excel workbook 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:
For each row in my Excel table, create a Basin form with name from column A, project ID from column B, and redirect URL from column C — output the form IDs 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 workbook 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 workbook: 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 workbook 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 workbook, 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 workbook 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 an Excel workbook or the Basin in Excel overview.