Generate personalized sales emails from Google Maps with OpenAI to Google Sheets
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 9 nodes and runs manually, when you click “Execute workflow”. Along the way it connects OpenAI, Google Sheets and Apify (community).
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Workflow Configuration (Edit Fields (Set)): sets 5 fields: searchQuery, maxPlaces, apifyActorId…
- Get user runs list (Apify): work with actor runs
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Check Website URL Exists (If): checks a condition and branches into true / false
- Fetch Website HTML (HTTP Request): calls an HTTP API
- Extract Text from HTML (Code): runs custom JavaScript code
- Generate Personalized Email (OpenAI): message
- Save to Google Sheets (Google Sheets): append or update
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @apify/n8n-nodes-apify is verified or supports 3.0 (used in Get user runs list).
Nodes used (9)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - OpenAI
@n8n/n8n-nodes-langchain.openAi - Google Sheets
n8n-nodes-base.googleSheets - Apify
@apify/n8n-nodes-apify.apify
From the author
Generate personalized sales emails from Google Maps results to Google Sheets This workflow automates the entire process of lead generation and personalized outreach drafting for local businesses. It utilizes Apify to scrape business data from Google Maps…