AutomationMart
Home/Browse/Send weekly local review intelligence digests from Google Maps via MintAPI and OpenAI
n8n

Send weekly local review intelligence digests from Google Maps via MintAPI and OpenAI

n8nn8n10 modulesv1.0
SlackNotionAirtableGoogle SheetsOpenAI

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 manually. 2. Searches Google Maps via MintAPI for businesses matching your query, region, language, and maximum business limit. 3. For each business found, fetches the newest Google Maps reviews via MintAPI up to the configured per-business limit

At a glance

Send weekly local review intelligence digests from Google Maps via MintAPI and OpenAI is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Slack, Notion, Airtable, Google Sheets. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Slack, Notion, Airtable, Google Sheets, OpenAI
Modules
10
Price
Free
Version
v1.0
Send weekly local review intelligence digests from Google Maps via MintAPI and OpenAI workflow diagram

About this workflow

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 manually. 2. Searches Google Maps via MintAPI for businesses matching your query, region, language, and maximum business limit. 3. For each business found, fetches the newest Google Maps reviews via MintAPI up to the configured per-business limit. 4. Filters and structures reviews to highlight low ratings and keyword-matched complaints, then builds a single prompt for OpenAI. 5. Sends the prompt to the OpenAI Chat Completions API to generate a Markdown report, falling back to a raw Markdown summary if OpenAI fails. 6. Emails the final digest to the configured recipient using your SMTP/email connection. Setup 1. Create a MintAPI account and API key at 2. In n8n, create an HTTP Header Auth credential named MintAPI x-api-key header with header name x-api-key and your MintAPI API key as the value. 3. Create an HTTP Header Auth credential named OpenAI Authorization header with header name Authorization and value Bearer YOUROPENAIAPIKEY 4. Configure the email node with your SMTP or email credential. 5. Open Template Settings and update the search query, region, language, business limit, review limit, alert keywords, sender email, and recipient email. 6. Run the workflow manually once to verify the output, then activate the weekly schedule. Requirements - MintAPI API key: - OpenAI API key - SMTP or email credential in n8n - A local search query, for example med spas in Miami or roofers in Austin Customization - Change the local search query in Template Settings. - Adjust maxBusinesses and reviewsPerBusiness to control cost and report depth. - Edit alertKeywords to track issues that matter to your niche. - Replace the email node with Slack, Notion, Google Sheets, or Airtable. - Customize the OpenAI prompt in Build Review Intelligence Prompt` to change the report format. Additional info This template uses MintAPI's Google Maps endpoints for local business search and review data. API details are available at and in the MintAPI docs at

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Add Reddit posts to Notion

Use this template to automatically create a Notion database item (page) when a reddit post is created. The text content of the post is appended to the database item as page content (if it's less than 2000 characters long which is the Notion API limit). See this [database](https://www.notion.so/cb3b814501ca4efa8a3eaf0a071d0b81?v=0f9bd7a03cef4a668a22ae96a7f0993c) for reference.

Free

Send automated email notifications for new rows in Google Sheets with Perplexity AI and ChatGPT chat completions

Use this template to automatically send email notifications when new rows are added in Google Sheets using Perplexity AI, ChatGPT chat completions and Google Email integration.

Free

AI-powered student assistant for course information via Twilio SMS

This n8n template offers a simple yet capable chatbot assistant who can answer course enquiries over SMS. Given the right access to data, AI Agents are capable of planning and performing relatively complex research tasks to get their answers. In this example, the agent must first understand the database schema, retrieve lists of values before generating it's own query to search over the database. Checkout the example database here - How it works A Twilio trigger gives us the ability to receive

Free

Send Slack messages for new RSS feed posts containing a specific word

Every time a new article containing a specific word is posted to a selected RSS feed, Make will automatically send a message in Slack. This template includes a filter allowing to display only posts that contain a specific word.

Free

Save your Amplitude retention analysis in Google Sheets

Make will watch for your Amplitude retention analysis at regular intervals and send it to a specified Google Sheets spreadsheet.

Free

Create and update records in Airtable using  completions via a custom webhook

Streamline record management by integrating ChatGPT with Airtable via a custom webhook. Automate record creation and updates effortlessly.

Free

AI video generator with Google Veo3 API (Veo 3 fast)

Overview This workflow leverages the KIE. AI Veo3 model to generate AI videos from simple text descriptions. Users interact via a form interface, inputting a prompt (e.g., a scene description), and the system automatically submits the request to the KIE. AI API, monitors the generation status in real time, and retrieves the final video output. It's ideal for content creators, marketers, or developers exploring text-to-video AI creation, supporting intelligent video generation with minimal s

Free

Automated repository migration from GitLab groups to Gitea organizations

This flow migrates all repositories of a Gitlab group to a Gitea organization by triggering Gitea's integrated migration tool. Set up steps: 1. Copy this workflow 2. Create an empty Gitea-organization you want to migrate to. (The flow will skip all projects which have the same name of possibly already existing repos in the target Gitea organization.) 3. Create an access token in your Gitea ( set it up as a Header Auth with it's name being "Authorization" and value being "token [your-gitea-token]

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free