Enrich Google Sheets company data with the Tavily Research API

Enrich your CSV data with web-sourced company 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

1. Prepare your sheet
2. Create the columns you want filled (e.g. CEO, revenue, HQ - if the data is related to company information)
3. Create an empty output sheet
4. Add credentials
5. Google Sheets OAuth for both sheet nodes
6. Tavily API key for the research nodes
7. Configure and run
8. Enter the Google Sheet ID and sheet names (For both the CSV nodes)
9. Click Start

Requirements: Google account (For sheets) and Tavily API key