Monitor Google reviews and draft GPT-4o-mini replies via Gmail daily

You activate this workflow once and it checks your Google reviews every morning at 9AM without any action from you. It fetches your latest reviews, classifies them as positive or negative, and uses GPT-4o-mini to write a personalised reply draft for each one. You receive a clean daily email with all drafts ready to copy and paste straight into your Google Business Profile. Built for local business owners, agencies, and reputation managers who want to stay on top of reviews without checking manually every day. --- What This Workflow Does Fetches live reviews daily — Pulls your latest Google reviews from the Places API every morning so you never miss a new one. Classifies each review automatically — Separates positive reviews (4–5 stars) from negative reviews (1–3 stars) so the AI writes the right tone for each. Skips days with no activity — If no reviews exist for your business, the workflow stops cleanly and sends no email — no noise in your inbox. Generates personalised reply drafts — GPT-4o-mini writes a unique reply for every review, referencing the reviewer's name and specific comments. Handles negative reviews professionally — Negative replies include a sincere apology and an offline resolution offer — never defensive or argumentative. Delivers a formatted daily digest — Gmail sends one clean email with a summary count and all reply drafts — plus step-by-step instructions for posting them. --- Setup Requirements Tools and accounts needed: - n8n instance (self-hosted or cloud) - Google Cloud account with Places API enabled (for fetching reviews) - Your Google Place ID (identifies your specific business listing) - OpenAI account with API access (for GPT-4o-mini) - Gmail account for sending the daily digest (OAuth2 credential) Estimated Setup Time: 12–18 minutes --- Step-by-Step Setup 1. Import the workflow — Open n8n → Workflows → Import from JSON. Paste the workflow JSON and import. Confirm all 9 nodes are connected in sequence. 2. Find your Google Place ID — Go to developers.google.com/maps/documentation/places/web-service/place-id and use the Place ID Finder. Search for your business name and copy the Place ID shown. You will paste this into the config step below. 3. Get your Google Places API key — Go to console.cloud.google.com. Create or select a project. Enable the Places API. Go to APIs & Services → Credentials → Create Credentials → API Key. Copy your new API key. 4. Edit your config values — Open the 2. Set — Config Values node. This is the only node you need to change. Replace all five placeholders: | Field | What to enter | |---|---| | YOURGOOGLEPLACEID | Your Place ID from step 2 | | YOURGOOGLEPLACESAPIKEY | Your API key from step 3 | | YOUR BUSINESS NAME | Your business name as it appears on Google | | [email protected] | The email address to receive daily reports | | YOUR NAME | Your name — appears at the end of every reply draft | > ⚠️ The Google Places API key is used directly in the URL of the 3. HTTP — Fetch Google Places Reviews node via the config values. Ensure you replace it in 2. Set — Config Values only — it flows through automatically. 5. Connect your OpenAI API key — Go to Credentials → New → OpenAI API in n8n. Paste your API key from platform.openai.com. Open the 7. OpenAI — GPT-4o-mini Model node and select this credential. 6. Connect your Gmail credential — Go to Credentials → New → Gmail OAuth2 in n8n. Complete the OAuth flow with the Gmail account you want to send reports from. Open the 9. Gmail — Send Review Report node and select this credential. 7. Activate the workflow — Toggle the workflow to Active. It will now run automatically every day at 9AM. --- How It Works (Step by Step) Step 1 — Schedule Trigger (Every Day 9AM) The workflow fires automatically each morning using a daily cron schedule. No manual action is needed once the workflow is active. Step 2 — Set (Config Values) Five configuration values are stored here: your Place ID, Google Places API key, business name, owner em