P
AI for Restaurant General Manager

Automation Recipe: Auto-Draft Review Responses with Zapier + ChatGPT

Tools:Zapier, ChatGPT API
Time to build:1.5-2 hours
Difficulty:Intermediate-Advanced
Prerequisites:Comfortable with Claude or ChatGPT for review responses — see Level 3 guide: "Set Up a Consistent Review Response System with ChatGPT"

What This Builds

You'll create an automation that watches your Google Business Profile for new reviews, sends the review text to ChatGPT to draft a response, and delivers the draft to your email or Slack — ready for your approval with one click. Instead of manually checking for reviews and spending 20 minutes drafting responses, you'll receive a draft within minutes of a review posting and approve or post it in under 2 minutes.

Prerequisites

  • Zapier account — free tier works to start, Starter plan ($20/month) unlocks multi-step automations
  • OpenAI API account (different from ChatGPT — go to platform.openai.com). Cost: roughly $0.01-0.05 per review response using GPT-4o Mini
  • Google Business Profile for your restaurant (you should already have this)
  • Gmail or Slack for receiving drafts

The Concept

Zapier is like a set of digital pipes that connects apps automatically. When something happens in one app (a new Google review), Zapier triggers an action in another app (ask ChatGPT to draft a response), then sends the result somewhere useful (your email). You build this pipeline once and it runs forever — no manual checking required. Think of it as hiring a very fast intern who reads every review immediately and has a draft waiting in your inbox by the time you notice the notification.

Build It Step by Step

Part 1: Set Up Your Accounts

OpenAI API Setup (10 minutes)

  1. Go to platform.openai.com and create an account (separate from your ChatGPT account)
  2. Add a payment method — you'll need to add funds. Start with $5 (this handles 100-500 review responses at current pricing)
  3. Go to API Keys in the left sidebar → click Create new secret key → copy and save this key somewhere safe. You can't see it again after this screen.

Zapier Setup (5 minutes)

  1. Go to zapier.com and create a free account
  2. You'll build your automation as a "Zap" — a multi-step workflow

Part 2: Build the Zapier Workflow

  1. In Zapier, click + Create → New Zap

  2. Step 1 — Trigger: Google My Business (Note: Google Business Profile reviews)

    • Search for "Google My Business" in the trigger search
    • Select New Review as the trigger event
    • Connect your Google account (authorize Zapier to read your GMB)
    • Select your restaurant's location
    • Test the trigger to confirm it pulls a recent review

  3. Step 2 — Action: OpenAI (ChatGPT)

    • Click + to add a step → search for "OpenAI"
    • Select Send Prompt as the action
    • Connect your OpenAI account (paste your API key from Part 1)
    • In the Prompt field, paste this (customize your restaurant info):
    Copy and paste this
    You are writing a public review response for [Restaurant Name], a [type] restaurant in [City]. Our voice is warm, genuine, and never defensive.

Review star rating: {{star_rating}}
Review text: {{review_text}}
Reviewer name: {{reviewer_name}}

If this is a 4-5 star review: Write a warm, personalized thank-you response under 60 words that references something specific they said. Sign off as "The Team at [Restaurant Name]".

If this is a 1-3 star review: Write a professional response under 100 words that: (1) acknowledges their specific complaint, (2) apologizes genuinely without being defensive, (3) mentions what we'll look into, (4) invites them to contact us at [email/phone] to make it right. Never start with "I'm sorry you feel that way."

Return only the response text — no introduction, no "here is a draft," just the response itself.
    • Set the Model to "gpt-4o-mini" (cost-effective for this use case)
    • In the dynamic fields (where you see {{star_rating}}), use Zapier's field mapper to pull these values from your Google My Business trigger in Step 1

  4. Step 3 — Action: Send to Email or Slack

    • Click + to add another step
    • For email: select Gmail → Send Email to yourself
    • Subject line: New {{star_rating}}-star review from {{reviewer_name}} — Draft ready
    • Body:
    Copy and paste this
    NEW REVIEW — {{star_rating}} stars
Reviewer: {{reviewer_name}}

Their review:
{{review_text}}

--- DRAFT RESPONSE ---
{{output_from_chatgpt_step}}

To post: Open Google Business Profile → Reviews → Find this review → Reply

  5. Test and activate

    • Click Test on each step to confirm they work
    • Click Publish to turn the Zap on
    • The automation now runs automatically whenever a new review posts

Part 3: Test and Refine

After your Zap goes live, the next 3 reviews you receive will test the system. Check:

  • Does the email arrive quickly? (Usually within 5 minutes of a review posting)
  • Is the draft good enough to post with minor edits, or does it need significant rewriting?
  • If the draft needs significant rewriting often, refine the prompt in Step 2 — add more specific instructions about your restaurant's voice

Real Example: Full Workflow

Setup: Your Zap is active and connected to your Google Business Profile.

Input: A guest posts a 3-star review at 8pm Tuesday: "Food was decent but service felt rushed. Our server disappeared for 20 minutes after we ordered. Wouldn't say never coming back but it didn't live up to the hype."

Output (in your inbox at 8:04pm):

Copy and paste this
Subject: New 3-star review from Jennifer M. — Draft ready

NEW REVIEW — 3 stars
Reviewer: Jennifer M.

Their review:
Food was decent but service felt rushed...

--- DRAFT RESPONSE ---
Jennifer, thank you for taking the time to share this. You're right that a 20-minute gap during your meal isn't the standard we hold ourselves to, and I'm sorry your server's attention slipped during that stretch. This is helpful feedback that I'll bring directly to our floor team. We'd love to have you back and show you a dinner that lives up to our reputation — please reach out to us at [email] any time.

The Team at [Restaurant Name]

Time saved: You didn't check for the review — it found you. The draft is ready when you open your email. You approve and post in 2 minutes.

What to Do When It Breaks

  • "The Zap runs but the draft doesn't arrive" → Check the Zapier task history (Zaps → your Zap → Task History) to see which step failed and read the error message. Usually an expired API key or a disconnected Google account.
  • "The draft quality is inconsistent" → Make the ChatGPT prompt more specific. Add examples: "For 3-star reviews mentioning service speed, focus the response on acknowledging timing and inviting them back."
  • "The Google My Business trigger isn't working" → Google sometimes updates their API permissions. Reconnect your Google account in Zapier and re-authorize permissions.
  • "I'm running out of OpenAI credits" → Add $5-10 more via platform.openai.com. At GPT-4o Mini pricing, $10 covers 200-1,000 review responses.

Variations

  • Simpler version: Skip Zapier entirely and just check your reviews weekly — paste each one into ChatGPT using your saved template. No cost, no setup, just more manual.
  • Extended version: Add a Step 4 that sends a Slack notification to your management team channel with the draft — everyone sees the review and the planned response before it's posted.

What to Do Next

  • This week: Set up your OpenAI API account and fund it with $5
  • This month: Build and test the Zapier workflow; refine the prompt based on the first 10 drafts
  • Advanced: Add a Yelp reviews trigger (Zapier supports Yelp Business) to extend the same system to your second-most-important review platform

Advanced guide for restaurant general manager professionals. Zapier pricing, Google Business Profile API access, and OpenAI pricing may change. Verify current pricing at each platform before setup.