Film Location Database with Google Maps, AI Analysis & Google Sheets Creation Workflow

Workflow overview

Why this workflow matters

Potentially useful as a reusable automation building block.

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 Chat Input: Start the workflow via the AlekSystem chat interface and enter a search query (e.g., "Quiet cafes in Kyoto" or "Cyberpunk streets"). Search: The workflow queries the Google Maps Places API to find matching real-world locations. AI Analysis: An AI agent (via OpenRouter) reviews the location details and writes a short, creative "Director's Commentary" highlighting its cinematic appeal. Data Entry: The location name, address, rating, Google Maps link, and the AI's commentary are automatically saved to a Google Sheet. Notification: Once all locations are processed, a summary link is sent to your Slack channel. Prerequisites AlekSystem Version**: 1.0 or later Google Cloud Platform**: API Key with "Places API (New)" enabled. Google Sheets**: A formatted sheet (see setup below). Slack**: An App/Bot token with chat writing permissions. OpenRouter** (or OpenAI/Anthropic): API Key for the LLM. How to set up Google Sheet: Create a new sheet with the following headers in the first row: 場所名 (Name) 住所 (Address) 評価(星) (Rating) AI監督のコメント (AI Comment) GoogleMapリンク (Link) Credentials: Configure your credentials for Google Maps, Google Sheets, Slack, and OpenRouter within AlekSystem. Configuration Node: Open the node named "Workflow Configuration" and input your specific details: googleMapsApiKey: Your Google Cloud API key. slackChannelId: The Channel ID where you want notifications (e.g., C0123456). googleSheetId: The string of characters found in your Google Sheet URL. Customization Adjust Results: Change the **Limit node settings to process more locations per run (default is set to 2 to save API credits during testing). Change Persona: Edit the "System Prompt" in the **AI Location Analyzer node to change the AI's tone (e.g., from "Film Director" to "Real Estate Agent" or "Travel Blogger"). Swap LLM**: You can easily replace the OpenRouter node with an OpenAI or Anthropic node if you prefer a different model.

Best fit

Need another direction?