Enrich Google Sheets data with the Tavily Research API

by Mani Srinivasan · 8 views · created 2026-01-13 · Lead Generation, AI Summarization

What this workflow does

This workflow has 12 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets. It also calls api.tavily.com over HTTP.

How it runs

Trigger: Manually, when you click “Execute workflow”.

1. Read CSV file (Google Sheets): uses Google Sheets
2. Store Original Columns (Code): runs custom JavaScript code
3. Start Tavily Research (HTTP Request): calls api.tavily.com (POST)
4. Combine with Request IDs (Code): runs custom JavaScript code
5. Wait: waits 30 seconds
6. Check Research Status (HTTP Request): calls an HTTP API
7. Combine Status (Code): runs custom JavaScript code
8. Research Done? (If): checks a condition and branches into true / false
9. Merge All Data (Existing Columns Only) (Code): runs custom JavaScript code
10. Under 5 min? (If): checks a condition and branches into true / false

…plus 1 more step. See the full node list below.

Services it uses

Google Sheets

HTTP calls to: api.tavily.com

Before you upgrade to n8n 3.0

Nodes used (6)

• Manual Triggern8n-nodes-base.manualTrigger
• Coden8n-nodes-base.code
• Waitn8n-nodes-base.wait
• HTTP Requestn8n-nodes-base.httpRequest
• Ifn8n-nodes-base.if
• Google Sheetsn8n-nodes-base.googleSheets

From the author

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…

View the original on n8n.io → Check your own copy