Create film location database with Google Maps, AI analysis & Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 11 nodes and runs when a chat message arrives. Along the way it connects Google Sheets, Slack and OpenRouter Chat Model. It also calls maps.googleapis.com over HTTP.
How it runs
Trigger: When a chat message arrives.
- Workflow Configuration (Edit Fields (Set)): sets 3 fields: googleMapsApiKey, slackChannelId, googleSheetId
- Google Maps Places Search (HTTP Request): calls maps.googleapis.com
- Split Out: splits a list into separate items
- Limit: keeps the first few items
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Send Slack Notification (Slack): uses Slack
- AI Location Analyzer (AI Agent): runs an AI agent, with model: OpenRouter Chat Model
- Append to Google Sheets (Google Sheets): append
Services it uses
HTTP calls to: maps.googleapis.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (11)
- Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Sheets
n8n-nodes-base.googleSheets - Slack
n8n-nodes-base.slack - Limit
n8n-nodes-base.limit - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter - Split Out
n8n-nodes-base.splitOut
From the author
Who is this for? This workflow is ideal for filmmakers, video producers, content creators, and location managers who need to quickly build a database of potential shooting locations without manual research and data entry. How it works 1. Chat Input: Start the…