Triage new Google reviews with Airtop and draft owner replies

Every four hours (cron), triage new Google reviews for my business. This is an agent workflow because the core value is drafting empathetic, on-brand replies to unhappy customers, and that judgement has to be human-quality.

Step 1: Pull the reviews with Airtop. Create a cloud browser session, open a window on my Google Maps business listing URL, and use Paginated Extraction to pull the 25 most recent reviews. For each review, capture the star rating, reviewer name, review text, and posted date. Terminate the session when the extraction is done so the browser does not sit idle.

Step 2: Dedupe against Google Sheets. Read the Reviews tab in my Google Sheets file with Get Values. Match each extracted review against the existing rows on the combination of reviewer name and posted date. Anything already recorded is a duplicate and should be dropped. Anything new gets appended to the tab with Append Values in a single call, keeping the columns consistent with what is already there (rating, reviewer, review text, posted date, and a run timestamp).

Step 3: Draft replies for low ratings. For every new review that is three stars or fewer, draft an on-brand, empathetic reply that acknowledges the specific complaint in the review text (do not use a generic apology template) and offers a concrete next step: a callback, a refund path, a manager introduction, a link to a fix. Keep it short, warm, and specific to what the reviewer actually said.

Step 4: Post one Slack thread per low-rating review to the #reviews channel using Send a Message. Each message includes the reviewer name, the star rating, the full review text, the drafted reply, and a link back to the Google Maps listing so the owner can approve, edit, and post the reply on Google themselves. Do not auto-post replies back to Google. Approval in Slack is the safety valve.

Step 5: Celebrate the wins in Gmail. At the top of each run, roll up all the newly discovered four- and five-star reviews into a single email digest. Group by star rating, quote each review, and credit the reviewer by name. Create a Draft in Gmail and Send it to the business owner. If there are no new four- or five-star reviews this run, skip the email entirely.

Config the workflow should expose: the Google Maps listing URL, the Google Sheets file and tab name, the Slack channel, the Gmail recipient, and the low-rating threshold (default: 3).