The Scenario
You're a market researcher who got handed a new project Monday morning: 80 industry directory URLs, each one a page with dozens of listed companies, prices, and categories. Your job is to get structured data out of every one of them and into a single workbook for analysis. The previous researcher who owned this project left the company two weeks ago, and their notes are in a shared drive folder that nobody has permissions to access.
You piece together what they were doing: they had an Agenty list called something like "Directory Scrape" and an agent that ran against it. You have the URLs. You do not have the workflow.
What rebuilding it manually looks like:
- Go into Agenty, create a new list, manually paste 80 URLs one at a time (Agenty's list import wants a specific CSV format you have to figure out first)
- Configure the agent — you're not sure which agent the previous researcher used, so you have to test two or three to find the one with the right selectors
- Wait for the job to run, download the output, open it in a separate file, and manually match it to your original 80-row sheet
Rebuilding someone else's workflow from scratch, with a deliverable deadline in three days, while also managing two other active projects.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your sheet, understands the data, and through its Agenty integration can upload URLs to a named list, trigger an agent run, and write the results back into your workbook — in one instruction.
Upload all URLs from column A into a new Agenty list called 'Directory Scrape', run the agent named 'Directory Extractor' against that list, and paste the job results into Sheet2 when done
What You Get
- A new Agenty list named "Directory Scrape" created from your column A URLs
- The specified agent triggered against that list
- Job output written to Sheet2 starting at row 2, with one row per scraped result and column headers matching the agent's output fields
- A status note in your original sheet when the job completes, so you know the results are ready
What If the Data Is Not Quite Ready
You're not sure which agent to use
List all available Agenty agents in my account, then run the one whose name contains 'Directory' against the URLs in column A and write the results to Sheet2
You want to append to an existing list rather than create a new one
Add all URLs from column A to the existing Agenty list called 'Competitor Monitor' without duplicating any URLs already in that list, then trigger a new run and write results to the 'Latest Results' sheet
You need to join the scraped output back to your original data
Upload URLs from column A to a new Agenty list called 'Market Research Q2', run the 'Directory Extractor' agent, and when results arrive, join them back to column A by matching URL so each scraped row lines up with its source row
End-to-end in one prompt
Filter column A to rows where column B is blank (not yet scraped), upload those URLs to a new Agenty list called 'Remaining Directories', run the 'Directory Extractor' agent, write results into Sheet2 starting at the next empty row, and mark the corresponding rows in column B with today's date when done
That last prompt handles the gap-fill, the list creation, the run, the writeback, and the progress tracking — without you touching Agenty's UI.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a list of seed URLs you need to push into an Agenty workflow — then ask SheetXAI to create the list, run the agent, and return the results. See also how to bulk scrape product pages or visit the full Agenty overview.