Use THIS n8n Node To Auto-Enrich Google Sheets (Free Workflow)
Workflow Link: https://leonardo467.gumroad.com/l/sypis
I evaluate the process of building a seamless data enrichment n8n workflow from scratch using the new Firecrawl agent integrated with Google Sheets. In this video, I demonstrate how to set up the necessary API connections, configure the AI agent to dynamically scrape and identify key company details like CEO names and contact info, and solve common data structure challenges to ensure the output is clean.
I also show how to automate the entire system to trigger instantly upon adding a new row, transforming a simple spreadsheet into a powerful, self-updating lead database.
Timestamp:
00:00 Firecrawl Agent Workflow
01:39 Connecting Google Sheets API & Setting Permissions (boring)
04:41 Configuring the AI Agent for Data Enrichment
08:41 Parsing JSON Results & Updating Rows Automatically
14:12 Setting Up the Automatic Sheet Trigger
📱 X: https://x.com/leonardogrig
💼 LinkedIn: / leonardogrig