Process hundreds or thousands of rows by connecting a Google Sheet. The agent opens URLs in parallel sub-agent tabs, performs extraction or actions for each row, and writes results back in real-time. It combines the dynamic capabilities of AI agents with the deterministic structure of spreadsheets.
We only access sheets you explicitly grant via the Google Drive Picker — we use the most restrictive drive.file scope. See Permissions & Privacy for details.
How It Works
- Upload your spreadsheet or connect an existing Google Sheet with input data
- Define the task using a natural-language prompt
- Specify which columns to use as context (URLs, names, search terms, etc.)
- The agent executes the task for each row, opening parallel tabs as needed
- Results are written back to new columns in real-time
Example: Lead Enrichment
Input sheet with company URLs. Prompt: "Visit the website and extract the CEO name and company size"
csv
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 extraction from company team pages
- Social media profile analysis and data collection
- Competitive research and market analysis
- Form submissions with personalized data per row
- Content scraping with structured JSON output
Tool Mapping in Sheets
You can map tool calls to run for every row. The agent intelligently pulls arguments from specific columns to populate tool parameters. Include details in your prompt like: "For each row upload as contact to HubSpot using the loadContact tool."
| Column A (Input) | Column B (Agent Action) |
|---|---|
| user@example.com | @hubspot_lookup(email=A1) |
| admin@test.org | @hubspot_lookup(email=A2) |
Best Practices
- Use clear column headers that describe the data
- Include example rows to guide the agent's extraction pattern
- Break complex tasks into smaller, focused workflows
- Test with a small subset (5-10 rows) before processing large datasets
- Use rate limiting for respectful web scraping
Keep your prompts specific and include examples of expected output format for best results.
Platform Availability
| Capability | Extension | Cloud | API |
|---|---|---|---|
| Google Sheets integration | ✅ | ✅ | ✅ (via dataInputs) |
| CSV / TSV upload | ✅ | ✅ | ✅ |
| Parallel sub-agent tabs | ✅ | ✅ | ✅ |
| Real-time sheet updates | ✅ | ✅ | — |
| Append mode (running logs) | ✅ | ✅ | ✅ |