Process thousands of rows by connecting a Google Sheet. The agent opens URLs in parallel sub-agent tabs, performing extraction and writing results back in real-time.
Sheets Workflows represent the perfect blend of AI agent flexibility and spreadsheet structure. Upload a CSV or Google Sheet with your data, and rtrvr.ai will execute web agent tasks for each row, using other columns as context.
How It Works
The system processes your spreadsheet row by row, treating each row as an individual task execution:
- Upload your spreadsheet with input data
- Define the task using natural language prompts
- Specify which columns to use as context
- The agent executes the task for each row
- Results are written back to new columns
Example Workflow
Consider a lead generation workflow with the following spreadsheet:
Company Name,Website,Industry
Acme Corp,acme.com,Software
Beta Inc,beta.io,Healthcare
Gamma LLC,gamma.co,FinanceWith the prompt: "Visit the website and extract the CEO name and company size"
The agent will process each row and return:
Company Name,Website,Industry,CEO Name,Company Size
Acme Corp,acme.com,Software,John Smith,50-100 employees
Beta Inc,beta.io,Healthcare,Sarah Johnson,100-500 employees
Gamma LLC,gamma.co,Finance,Mike Wilson,10-50 employeesAdvanced Use Cases
- Price monitoring across multiple e-commerce sites
- Contact information extraction from company websites
- Social media profile analysis and data collection
- Competitive research and market analysis
- Form submissions with personalized data
- Content scraping with structured output
Best Practices
- Use clear column headers that describe the data
- Include example rows to guide the agent
- Break complex tasks into smaller, focused workflows
- Test with a small subset before processing large datasets
- Use rate limiting for respectful web scraping