Enrich Company Data in Google Sheets with TinyFish AI (n8n)

Enrich your company spreadsheet automatically with TinyFish AI in n8n

This n8n workflow reads website URLs from your Google Sheets, uses TinyFish AI to extract verified company details from each site, then writes the enriched data back into the same sheet—marking each processed row as Completed.

What this workflow does

• Fetches rows from Google Sheets and filters to only those where the Status column is empty (pending enrichment).
• Processes up to five rows per run, iterating in batches.
• Sends each “Website URL” to TinyFish AI and retrieves structured company information as JSON.
• Merges the original row data with the TinyFish AI results and updates the matching Google Sheets row using the Website URL.
• Sets Status to Completed after enriching the row.
• Waits 6–15 seconds between items to reduce the likelihood of hitting rate limits.

Use cases

• Build and maintain a prospecting database by enriching leads stored in Google Sheets.
• Speed up research workflows for SaaS ops and growth teams using website-based company extraction.
• Continuously enrich company lists while keeping each enrichment run controlled (five rows per execution).
• Reduce manual data entry by automatically populating fields like Company Name, Email, Phone, LinkedIn, and founder/CEO fields (as columns in your sheet).

Technical details

• Google Sheets integration (credentials + Spreadsheet ID + sheet/tab name in both Google Sheets steps).
• TinyFish AI extraction step using your TinyFish credentials to return company data as JSON.
• Flow control and orchestration nodes: if, wait, limit, merge, plus a sticky note for workflow clarity.

Setup checklist

Ensure your sheet includes Website URL, Status, and the enrichment target columns you want populated. Then add TinyFish credentials in n8n, and run the workflow manually to enrich all pending rows.