🎣 Enrich Google Sheets data with the Tavily Research API
⚡ 4 views · 🎣 Lead Generation & Enrichment
Description
Enrich your CSV data with web-sourced information using Tavily’s AI-powered research API. This workflow fills in missing data for existing columns without creating new ones.
Video Link: https://youtu.be/8g8v3vNyhe4
How it works
- Reads rows from a Google Sheet
- For missing values, finds information from the web using Tavily Research
- Maps results to existing columns
- Writes the enriched data to a new sheet
- Retries automatically until results are ready (up to ~5 minutes)
Setup steps
- Prepare your sheet
- Create the columns you want filled (e.g. CEO, revenue, HQ - if the data is related to company information)
- Create an empty output sheet
- Add credentials
- Google Sheets OAuth for both sheet nodes
- Tavily API key for the research nodes
- Configure and run
- Enter the Google Sheet ID and sheet names (For both the CSV nodes)
- Click Start
Requirements: Google account (For sheets) and Tavily API key
🔗 Nodes Used
Google Sheets, HTTP Request
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File