Library / Customer Support & Helpdesk
Customer Support & Helpdesk
Draft Google review replies with OpenRouter and send approvals via Gmail and Sheets
Hourly, fetches new Google reviews, drafts on-brand AI replies with sentiment and urgency, logs them in Sheets and emails them for approval.
What it does
## Google Review Reply Drafter Never leave a Google review unanswered again. ### How it works 1. Every hour, new Google reviews are fetched for your location. 2. Reviews already in your sheet are skipped. 3. An AI model rates sentiment and urgency and drafts an on-brand reply. 4. Each review and draft is saved in Google Sheets. 5. The draft is emailed to you for approval. Reviews of 3 stars or less are marked URGENT. 6. Optional: turn on auto-posting to publish replies directly.
The steps
- Check for New Reviews Every Hour
- Workflow Settings
- Read Already-Logged Reviews
- Fetch Latest Google Reviews
- Prepare Error Log
- Log Error in Google Sheets
- Alert Owner — Workflow Error
- Keep Only New Reviews
- OpenRouter — Classify + Draft Reply
- OpenRouter Chat Model
- Validate AI Draft Safely
- Log Review and Draft in Sheets
- Email Owner the Draft for Approval
- Is Auto-Posting Turned On?
15 steps in total.
Similar automations
Tasks & Project ManagementReview agency asset readiness and approvals from Google Sheets and Gmail21 stepsLead Generation & EnrichmentDraft replies to portal enquiries with OpenAI, Gmail and Google Sheets9 stepsCRM & Sales PipelineRoute client onboarding and approvals with OpenAI, Gmail and Google Sheets15 stepsEmail AutomationRun procurement approvals with Google Sheets, Gmail, Google Docs, and Slack32 steps