See llms.txt for all machine-readable content.

Back to Templates

Draft Google review replies with Gmail alerts and OpenAI

Created by

Created by: AI Agent Starter Kit || aiagentstarterkit
AI Agent Starter Kit

Last update

Last update 2 days ago

Categories

Quick overview

This workflow runs daily at 8 AM (or manually), pulls new Google Business Profile review notification emails from Gmail or reviews you paste in, uses OpenAI to draft safe reply suggestions, and saves a single summary as a Gmail draft to you without posting anything publicly.

How it works

  1. Runs every day at 8 AM or when triggered manually.
  2. Loads your configuration and either uses built-in sample reviews (test mode), parses reviews you paste into the workflow (paste mode), or fetches recent Google review notification emails from Gmail while skipping messages already labeled as processed.
  3. Screens each review with rule-based checks to flag legal/refund/safety/personal-data/link/prompt-injection content and only sends safe reviews to OpenAI for reply drafting.
  4. Uses OpenAI (chat model) with structured output to generate a short suggested public reply and an optional owner note for each eligible review.
  5. Guards the AI-generated replies by dropping risky drafts (for example refunds, discounts, legal language, or asking to change a review) and inserting [CONFIRM: ...] placeholders for sensitive details like prices, dates, or times.
  6. Compiles all suggested replies and “reply yourself” items into one summary email and saves it as a Gmail draft addressed to you.
  7. In Gmail mode, adds a Gmail label to the alert emails that were fully handled so the next run does not draft replies for the same notifications again.

Setup

  1. Connect a Gmail OAuth2 credential for the Gmail nodes so the workflow can read review alerts, create drafts, and manage labels.
  2. Add an OpenAI credential for the OpenAI chat model used to draft the replies.
  3. Update the Config values (at least my_email, business_name, city, keywords, sign_off, offline_contact, and optionally the Gmail search query and processed label name).
  4. Run once with test_mode set to yes to verify the generated Gmail draft, then set test_mode to no and keep source as gmail (or switch to paste) before activating the schedule.
  5. Ensure the processed_label value is acceptable in your mailbox, since the workflow creates the label if missing and uses it to mark handled alert emails.