Introduction
Every time a customer leaves you a review, they’re handing you free content. The words they use to describe your business are exactly the words other potential customers are searching for online — but most small business owners let those reviews sit untouched on Google or Yelp instead of turning them into traffic-driving blog posts.
This tutorial walks you through a workflow that takes a customer review, sends it to an AI writing tool, and produces a polished, publish-ready blog draft in minutes. Once it’s set up, each new review you receive can become a new piece of content with almost no extra work on your part.
Time to set up: About 45–60 minutes the first time. Time per blog post after setup: 5–10 minutes to review and publish.
What You’ll Need
Before you start, make sure you have the following ready:
- A Google account — to access your Google Business Profile reviews (free)
- A Zapier account — the automation layer that connects everything (free plan works for basic use; paid plan needed for multi-step automations)
- An OpenAI account — for the AI writing step; you’ll need a paid API key (costs a few cents per post)
- A Google Sheet — where your reviews will be collected (free, just needs a Google account)
- Your blog platform login — WordPress, Squarespace, Wix, or wherever you publish
Set up accounts for Zapier and OpenAI if you haven’t already. For OpenAI, go to platform.openai.com, create an account, then navigate to Settings → API Keys and click Create new secret key. Copy it somewhere safe — you’ll need it later.
Step-by-Step Setup
Phase 1: Create Your Review Collection Sheet (10 minutes)
Step 1. Open Google Sheets and create a new blank spreadsheet. Name it “Customer Reviews — Blog Pipeline.”
Step 2. In Row 1, create four column headers: Review Text, Reviewer Name, Star Rating, and Date Received. These columns will auto-populate once Zapier is connected.
Step 3. In a fifth column, add the header Blog Post Draft. This is where the AI output will land.
Phase 2: Connect Your Reviews to the Sheet via Zapier (20 minutes)
Step 4. Log into Zapier and click the + Create button, then select Zap.
Step 5. In the trigger step, search for Google My Business in the app search bar. Select it, then choose the trigger event New Review. Click Continue.
Step 6. Click Sign in to Google My Business and connect your Google account. Once authorized, Zapier will ask you to select your business location — choose it from the dropdown and click Continue.
Step 7. Click Test trigger to make sure Zapier can find your recent reviews. You should see a review appear with the reviewer’s name, star rating, and review text. If it works, click Continue.
Step 8. Now add your first action. Click the + button below the trigger, search for Google Sheets, and select it. Choose the action event Create Spreadsheet Row.
Step 9. Connect your Google account if prompted. Then select the spreadsheet you created in Phase 1 and choose the correct sheet tab (usually “Sheet1”).
Step 10. Map the fields: set Review Text to the review body from the trigger, Reviewer Name to the reviewer’s name, Star Rating to the rating value, and Date Received to the review date. Click Continue, then Test action to confirm a row gets added to your sheet.
Phase 3: Add the AI Writing Step (15 minutes)
Step 11. Click + again to add another action. Search for OpenAI and select it. Choose the action Send Prompt (sometimes listed as Send Chat Message).
Step 12. Click Connect a new account and paste in the API key you copied earlier. Click Yes, Continue.
Step 13. In the Model field, select gpt-4o from the dropdown for best results.
Step 14. In the User Message field, paste the following prompt — then use Zapier’s field picker (the + icon) to insert the Review Text value from Step 2 where indicated:
You are a content writer for a small business blog. A customer just left this review:
"[INSERT REVIEW TEXT HERE]"
Write a helpful, friendly blog post of about 400 words inspired by this review.
The post should:
- Have a compelling title
- Address the topic the customer mentioned
- Offer useful tips or context related to that topic
- End with a short call to action
Write in a warm, approachable tone. Format with a title, intro paragraph, 2–3 short sections with subheadings, and a closing paragraph.
Step 15. Click Continue, then Test action. Within a few seconds, you should see a full blog post draft appear in the results panel.
Step 16. Add one more action: Google Sheets → Update Spreadsheet Row. Map the Blog Post Draft column to the AI response from Step 15. This saves the draft directly into your sheet alongside the original review.
Step 17. Give your Zap a name like “Reviews → Blog Drafts” and click Publish.
Testing It Works
To confirm everything is running correctly:
- Ask a friend or family member to leave a test review on your Google Business Profile — something genuine, a few sentences long.
- Wait 5–15 minutes (Zapier checks for new reviews on a schedule on free plans; faster on paid).
- Open your Google Sheet and check whether a new row appeared with the review text and a completed blog draft in the last column.
If the row is there and the draft looks reasonable, your pipeline is live.
Troubleshooting
The Zap triggers but the blog draft column stays empty. This usually means the OpenAI step failed silently. Go to Zapier’s Zap History (left sidebar), find the recent run, and click it. Look for a red error on the OpenAI step — it often says “invalid API key” or “quota exceeded.” Double-check your API key is entered correctly and that your OpenAI account has a payment method added.
No new row appears in the sheet after a review comes in. Check that your Google My Business account is fully verified and that the location you selected in Step 6 matches the one receiving reviews. Also confirm your Zap is turned on (toggle in the top-right corner of the Zap editor should show green).
The blog draft is generic and doesn’t sound like your business. Edit your prompt in Step 14. Add a sentence describing your business: “This blog is for [Your Business Name], a [type of business] in [city].” Specificity dramatically improves AI output quality.
Next Steps
Once you’re comfortable with the basics, add a Slack or email notification as a final Zap step. Each time a draft is generated, you’ll get a message with the blog post pasted directly into it — so you can review and copy it to your CMS without even opening the spreadsheet. In Zapier, just add an action after the Google Sheets update step: search for Gmail or Slack, choose Send Email or Send Channel Message, and paste the AI output into the message body. You’ll have fresh blog content waiting in your inbox every time a happy customer hits submit.