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

What This Builds

Every time a new Google review appears for your practice, this automation detects it, passes the review text to ChatGPT, which drafts a professional response, and emails the draft to you. You approve or lightly edit, then post — what used to take 20 minutes of dreading and writing becomes a 2-minute approval. Over a year of 50+ reviews, this saves hours and ensures your practice is actually responding instead of ignoring reviews.

Prerequisites

• Comfortable using ChatGPT for basic writing tasks (Level 3)
• A Zapier account (free tier works; Paid tier required for multi-step automations — $20/month)
• ChatGPT API key (OpenAI platform account — separate from chatgpt.com; ~$0.01–0.05 per response)
• Google My Business account verified for your practice
• Gmail account for receiving drafted responses

The Concept

Think of Zapier as a connector that watches for things to happen ("triggers") and then takes actions in response. In this case: "When a new review appears on Google My Business (trigger) → Send the review to ChatGPT to draft a response (action) → Email the draft to you (action)." It's like having an assistant who drafts every response for your review — you just approve.

Build It Step by Step

Part 1: Set up your OpenAI API key

1. Go to platform.openai.com and create an account (separate from chatgpt.com)
2. Navigate to API Keys in the left menu > Create new secret key
3. Copy the key and save it somewhere safe — you'll only see it once
4. Add $10 in credit (billing > Add payment method). Each response costs ~$0.02, so this covers ~500 reviews

What you should see: A long string starting with "sk-..." — this is your API key.

Part 2: Set up Google My Business connection in Zapier

1. Go to zapier.com and create an account (free)
2. Click Create Zap
3. In the Trigger step, search for "Google My Business" and select it
4. Choose the trigger event: New Review (or "New or Updated Review")
5. Connect your Google account when prompted — make sure to authorize the Google account that owns your practice listing
6. Test the trigger by clicking "Test" — Zapier should pull your most recent review as a sample

What you should see: A preview of a recent review showing the reviewer name, star rating, and review text.

Troubleshooting: If Google My Business doesn't appear as a Zapier option, search for "Google Business Profile" — it may be listed under the newer name. If you manage multiple locations, select the correct one when prompted.

Part 3: Add the ChatGPT step

1. Click the + button to add a second step
2. Search for "OpenAI (ChatGPT)" and select it
3. Choose action: Send a Prompt
4. Connect your OpenAI account using the API key from Part 1
5. In the Prompt field, type this (copy exactly):

You are a professional dental office manager responding to a Google review. Write a response that is warm, professional, and under 80 words. Never mention specific patient details or treatment information (HIPAA). If it's a positive review: thank them sincerely and invite them back. If it's a negative review: acknowledge their concern empathetically, don't admit fault, and invite them to call the office directly to resolve it.

Review text: {{insert the review text from step 1 here using Zapier's variable picker}}
Star rating: {{insert star rating variable}}

In the last two lines, use Zapier's variable picker (the blue "+" button) to insert the actual review text and star rating from the Google My Business trigger.

What you should see: A test run that shows a draft response generated by ChatGPT based on your most recent real review.

Part 4: Add the Gmail notification step

1. Add a third step: search for "Gmail" and select it
2. Choose action: Send Email
3. Connect your Google/Gmail account
4. Set To: your own email address
5. Set Subject: "New Google Review — Draft Response Ready"
6. In the Body field, use Zapier variables to include:

   • Reviewer name
   • Star rating
   • Full review text
   • ChatGPT's draft response
   • A note at the bottom: "Review the draft above. Edit if needed, then post to Google My Business."

What you should see: A preview email with the review and draft response clearly formatted.

Part 5: Test and activate

1. Click Test Zap to run through all three steps with a real review
2. Check your inbox for the email with the draft response
3. If the response looks good, click Turn on Zap

Real Example: A Negative Review

Setup: Zapier watching for new Google reviews; ChatGPT prompt configured; Gmail notifications enabled.

Input (new review appears): 2-star review: "Waited 45 minutes past my appointment time with no explanation. When I asked at the front desk, they just said the doctor was running behind. Won't be back."

Output (email arrives in your inbox within minutes):

Draft response:
"We're truly sorry to hear about your experience and understand how frustrating
an unexpected wait can be. Your time is valuable and we apologize for not
communicating better about the delay. We'd love the opportunity to make this
right — please call us at [number] so we can speak with you directly.
— [Practice Name] Team"

Time saved: 20 minutes of dreading → 2 minutes to review and post.

What to Do When It Breaks

• "Google My Business trigger not firing" → Check that your Google account has management access to the listing (not just ownership). Re-authorize the connection in Zapier under Connected Accounts.
• "ChatGPT API returns an error" → Check your OpenAI billing — if your credit ran out, the API will fail. Add more credit at platform.openai.com/billing.
• "Response sounds too generic or weird" → Refine the system prompt in Part 3. Add a line like: "Our practice is [type, e.g. family-focused, cosmetic dentistry]. Mention this naturally if appropriate." More context = better responses.
• "Zapier says the Zap is on but nothing happens" → Log a test review yourself (from a different Google account) to verify the trigger is working. If it still doesn't fire, re-test the trigger step.

Variations

• Simpler version: Skip Zapier entirely. Instead, set a weekly reminder to check for new reviews, then copy-paste each one into Claude with the prompt from Part 3. Slower but zero technical setup.
• Extended version: Add a fourth step — after you approve the draft, have Zapier automatically post it to Google My Business via the API. This removes the manual posting step entirely (requires Google My Business API access, which requires additional setup).

What to Do Next

• This week: Build the automation and run the first test. Verify a draft arrives in your inbox for the next new review.
• This month: Review your response rate — you should now be responding to every review within 24–48 hours.
• Advanced: Add a branch in Zapier: if star rating is 5, use a more celebratory response prompt; if 1–2 stars, use the empathy/recovery prompt. Zapier's "Filter" step makes this easy.

Advanced guide for Dental Office Manager professionals. These techniques use more sophisticated AI features that may require paid subscriptions.