Draft Google review reply emails with Gmail, OpenAI, and Google Sheets

Quick Overview

This workflow monitors Gmail for Google Business Profile “new review” alert emails, uses OpenAI to extract the rating and review text and draft a policy-safe reply, then emails the draft to you and logs the review and reply draft to Google Sheets.

How it works

1. Triggers when a new Google Business Profile review notification email arrives in Gmail.
2. Looks up the email’s message ID in a Google Sheets ledger to prevent drafting duplicate replies.
3. Sends the email content and your configured business details to OpenAI to extract the rating, reviewer first name, and review text and generate a reply draft as structured JSON.
4. Emails you a formatted message containing the review excerpt, the suggested reply, and a link to your Google reviews page.
5. Appends a new row to Google Sheets with the message ID, extracted review details, the reply draft, a timestamp, and a “draft-sent-to-owner” status.

Setup

1. Connect your Gmail account and ensure Google review alerts are delivered from [email protected].
2. Add an OpenAI API key/credential and select the chat model in the OpenAI node.
3. Create a Google Sheets “reply ledger” with columns like processed_at, gmail_message_id, rating, reviewer, review_excerpt, reply_draft, and status, then select the spreadsheet and sheet in both Google Sheets steps.
4. Update the settings values for business name, recipient email address, tone, contact channel, sign-off, and the Google reviews page URL used in the email.