workflows.fit
Back to n8n workflows
n8n templateFreeBy Robert Breen

Extract local business contacts with Google Sheets, SerpAPI, Apify & GPT-4o

Extract Local Business Contacts with Google Sheets, SerpAPI & GPT‑4o Status: Ready for Use ✅ Disclaimer: This workflow relies on community nodes that are not part of n8n’s core package. Install the following from n8n ...

Data & StorageProductivityDevelopmentCore NodesAILangchainManual TriggerLm Chat Open Ai
Loading interactive preview...

Template notes

Extract Local Business Contacts with Google Sheets, SerpAPI & GPT‑4o

Status: Ready for Use ✅ Disclaimer: This workflow relies on community nodes that are not part of n8n’s core package. Install the following from n8n → Community Nodes before running:

- n8n-nodes-langchain - n8n-nodes-openai (Structured Output Parser) - n8n-nodes-apify

---

📝 Description This n8n workflow automates discovery of local‑business contact details by search term and location, then enriches the results with publicly listed email addresses using GPT‑4o AI.

---

🔑 Key Features

🔗 Google Sheets Integration - Reads search terms and locations from a Google Sheet. - Processes only rows that are not marked Complete, preventing duplicates.