The Scenario
You're a market-research analyst and you have twelve Kadoa workflows each pulling about 500 product listings from competitor sites. Every Monday morning you open the results tab in Kadoa, stare at the twelve separate run views, and figure out how to get all 6,000 rows into one sheet so you can build the week's price-delta report.
The bad version:
- Open each of the twelve workflows one by one in Kadoa's UI, export the latest run as a CSV, and download all twelve files into your downloads folder.
- Open each CSV in a separate tab, check that the column headers match your master sheet format (they never quite do), copy the data rows, paste them into the master tab, fix the misaligned columns.
- Build the Price Delta formula in column I by hand after realizing the export labeled the price field "price_usd" this week instead of "price."
You're a researcher. Your job is the analysis that comes after the data exists in one place. The hour it takes to assemble the sheet is an hour you're not doing that job — and it happens every single week.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It connects to Kadoa, reads your sheet, and knows how to pull workflow results and write them exactly where you need them. Drop in the demo to see it in action.
The prompt for this task:
Pull the latest data from all my Kadoa workflows named 'competitor-pricing-*' and paste the results into this sheet starting at A2, then add a Price Delta column comparing column D to my catalog prices in column H.
What You Get
- All records from the matching workflow runs written to the sheet starting at A2, one row per extracted product listing.
- Column headers from Kadoa's output schema written to row 1, normalized to match your existing column naming.
- A Price Delta column computed inline, comparing each extracted price (column D) to your catalog price (column H) and writing the difference or a flag where the catalog entry is missing.
- Rows where the price field is null or zero marked with a flag in a Status column so they stand out in the report.
What If the Data Is Not Quite Ready
The workflow name pattern doesn't match exactly
Sometimes the naming convention drifted — some workflows are 'competitor-pricing-us' and some are 'CompetitorPricingEU'. You can be explicit:
Fetch the latest run results from Kadoa workflows with IDs wf_001, wf_002, wf_003, wf_004, wf_005, wf_006 and paste all records into this sheet starting at A2, skipping duplicate rows where the 'productUrl' field matches an existing entry.
The catalog sheet is on a separate tab
Your catalog prices live in a tab called "Catalog" with SKUs in column A and prices in column B, and you want the delta computed against that:
Pull the latest results from all my Kadoa 'competitor-pricing-*' workflows into the 'Extracted' tab starting at A2, then for each row look up the SKU in column C against the Catalog tab column A and write the catalog price to column E and the delta to column F.
Some workflow runs haven't finished yet
If a workflow is still in progress, you don't want a partial pull corrupting the report:
Fetch the latest completed run results from each of my Kadoa workflows named 'competitor-pricing-*' — skip any workflow whose most recent run status is not 'completed' — and paste only the finished results into this sheet starting at A2.
Full pipeline: pull, dedup, enrich, and flag in one shot
Pull the latest completed results from all Kadoa workflows named 'competitor-pricing-*', deduplicate by 'productUrl', look up each SKU in the Catalog tab, compute a Price Delta column, flag rows where the delta exceeds 15% in a 'Alert' column, and sort the final output by Alert descending so the biggest gaps are at the top.
The prompt does the dedup, the lookup, and the analysis in a single pass — no intermediate steps, no manual reconciliation afterward.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet that tracks competitor data or Kadoa workflow IDs — then ask it to pull the latest extracted records and enrich them against your catalog. For related reading, see how to bulk create Kadoa workflows from a sheet or the Kadoa overview.