Send weekly local review intelligence digests from Google Maps via MintAPI and OpenAI
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 10 nodes and runs on a schedule (every week at 09:00) (plus 1 other trigger). It uses only n8n's built-in nodes. It also calls api.mintapi.dev and api.openai.com over HTTP.
How it runs
Trigger: On a schedule (every week at 09:00) (plus 1 other trigger).
- Set Template Parameters (Edit Fields (Set)): sets 8 fields: searchQuery, region, language…
- Fetch Google Maps Businesses (HTTP Request): calls api.mintapi.dev
- Prepare Competitor Data (Code): runs custom JavaScript code
- Fetch Latest Business Reviews (HTTP Request): calls api.mintapi.dev
- Build AI Review Prompt (Code): runs custom JavaScript code
- Generate Review Digest via OpenAI (HTTP Request): calls api.openai.com (POST)
- Prepare Final Email Report (Code): runs custom JavaScript code
- Send Final Email Report (Send Email): sends an email over SMTP
HTTP calls to: api.mintapi.dev, api.openai.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 (6)
- Manual Trigger
n8n-nodes-base.manualTrigger - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Send Email
n8n-nodes-base.emailSend
From the author
Quick overview Monitor local competitor reviews from Google Maps, summarize complaint themes with OpenAI, and email a weekly action digest for local SEO, reputation management, and marketing teams. How it works 1. Runs on a weekly schedule or is started…