🎣 Enrich company data from website URLs using TinyFish AI and Google Sheets
⚡ 6 views · 🎣 Lead Generation & Enrichment
💡 Pro Tip — For lead enrichment, ScraperNode can pull LinkedIn profiles, company data, and job listings directly into your pipeline — useful for building prospect lists without manual research.
Description
Quick overview
This workflow reads website URLs from Google Sheets, uses TinyFish AI to extract verified company details from each site, and writes the enriched fields back to the same sheet while marking processed rows as Completed.
How it works
- Starts manually and fetches rows from a Google Sheets spreadsheet.
- Filters to only rows where the Status column is empty (pending enrichment).
- Limits processing to five rows per run and iterates through them in batches.
- Sends each Website URL to TinyFish AI to extract structured company data as JSON.
- Combines the original row data with the TinyFish AI results.
- Updates the matching Google Sheets row (by Website URL) with the enriched fields and sets Status to Completed.
- Waits a random 6–15 seconds between items to reduce the likelihood of hitting rate limits.
Setup
- Create a Google Sheets credential in n8n and set the correct Spreadsheet (document) ID and sheet/tab name in both Google Sheets steps.
- Ensure your sheet includes the required columns (Website URL, Status, and the enrichment target columns like Company Name, Email, Phone, LinkedIn, CEO/Founder fields, and others).
- Add your TinyFish credentials in n8n so the workflow can call the TinyFish AI extraction step.
- Populate Website URL for each company and leave Status blank for rows you want the workflow to process.
🔗 Nodes Used
Google Sheets
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File