The Scenario
It's the third sprint in a row where your price-intelligence team has asked you to add new retailers to the scraping coverage. You're a developer at a SaaS firm, and the backlog now has 30 new domains waiting to be onboarded as Kadoa workflows. The URL, schema field definitions, and navigation mode for each one are already mapped out in a planning sheet a colleague built. What isn't done is the actual workflow creation — 30 separate trips through Kadoa's UI to paste in the URL, define the fields, pick the crawl mode, and hit save.
The bad version:
- Open Kadoa's workflow creation screen, paste in the URL from row 2 of the sheet, type out the field names from column C one by one, select "single-page" mode, save, and copy the returned workflow ID back into column D.
- Repeat this for all 30 rows, losing your place twice and creating three workflows with the wrong navigation mode because you clicked too fast.
- Come back the next day to add three more domains the sales team just identified and realize you have no memory of which rows in the sheet are already done.
You were supposed to spend this afternoon on the anomaly-detection feature. Instead you spent it doing data entry that a script could handle — except writing the script would take longer than just doing it manually, and you're already behind.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your planning sheet and talks to Kadoa's API to create the workflows you've mapped out. Open the sidebar and give it the job.
The prompt for this task:
Read rows 2 to 31 in this sheet — each row has a URL in column A, entity name in column B, and comma-separated field names in column C — and create a Kadoa scraping workflow for each row using 'single-page' mode. Write the returned workflow ID back to column D.
What You Get
- One Kadoa workflow created per row, using the URL, entity name, and field definitions from your sheet.
- The returned workflow ID written back to column D for each row so you have a durable reference.
- Any rows that fail — malformed URLs, API errors — flagged in a Status column with the error message, so the successful ones don't mask the broken ones.
- A summary line at the top of the status column showing how many workflows were created versus failed.
What If the Data Is Not Quite Ready
Some rows already have workflow IDs and shouldn't be recreated
You ran the first batch last week. Rows 2–15 already have IDs in column D. You only want to process the new ones:
For each row in this sheet where column D is empty, create a Kadoa scraping workflow using the URL in column A, entity in column B, and fields in column C with 'single-page' mode, and write the new workflow ID back to column D.
The field definitions include type annotations
Your planning sheet has fields like "price:number, title:string, inStock:boolean" and you need those types passed to Kadoa:
Read rows 2 to 31. Column C contains comma-separated field definitions in the format 'fieldName:type'. Parse each definition, create a Kadoa workflow per row using the URL in column A, entity in column B, and the parsed field schema, then write the workflow ID to column D.
Some URLs need multi-page crawl mode instead of single-page
Column E flags which domains need pagination — "multi-page" or "single-page":
For each row in this sheet (rows 2–31), create a Kadoa workflow using the URL in column A, entity in column B, fields in column C, and the navigation mode from column E. Write the workflow ID to column D.
Full pipeline: create, then immediately fetch validation status for each new workflow
For rows 2 to 31, create a Kadoa workflow per row using columns A, B, C, and E, write the workflow ID to column D, then immediately fetch each new workflow's validation status and write it to column F so you can see which ones need a schema review before the first run.
One prompt creates the workflows and surfaces the ones that need attention — no second pass, no separate validation check.
Try It
Get the 7-day free trial of SheetXAI and open your Kadoa planning sheet — a list of domains, field definitions, and crawl modes — then ask it to create all the workflows in one pass. For related reading, see how to pull extracted records into a sheet or the Kadoa overview.