{"product_id":"n8n-google-sheets-to-gmail-send-post-visit-review-requests","title":"n8n Google Sheets to Gmail: Send Post-Visit Review Requests","description":"\u003ch3\u003eAutomatically email Google review requests to customers after their visit—then let them unsubscribe with one click\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow reads completed visits from your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, waits a configurable delay, and sends customers an \u003cstrong\u003eHTML Gmail\/SMTP email\u003c\/strong\u003e containing your \u003cstrong\u003eGoogle review link\u003c\/strong\u003e. It also provides a personalized unsubscribe link via an \u003cstrong\u003en8n webhook\u003c\/strong\u003e and records when each request was sent.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns hourly\u003c\/strong\u003e on a schedule.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads visit records\u003c\/strong\u003e from the \u003cstrong\u003e“Visits”\u003c\/strong\u003e tab in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eFilters eligible customers by checking: \u003cstrong\u003ecompleted\u003c\/strong\u003e status, a \u003cstrong\u003evalid email\u003c\/strong\u003e, a configurable “ended at least X hours ago” rule, a configurable \u003cstrong\u003emax age\u003c\/strong\u003e, \u003cstrong\u003enot previously asked\u003c\/strong\u003e (based on \u003ccode\u003ereview_requested_at\u003c\/code\u003e), \u003cstrong\u003enot opted out\u003c\/strong\u003e (based on \u003ccode\u003eopt_out\u003c\/code\u003e), and \u003cstrong\u003equiet hours\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends the review request email\u003c\/strong\u003e using \u003cstrong\u003eEmail Send (SMTP)\u003c\/strong\u003e, including:\n    \u003cul\u003e\n      \u003cli\u003eYour \u003cstrong\u003eGoogle review link\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003eA \u003cstrong\u003eone-click unsubscribe\u003c\/strong\u003e link that points to the workflow’s webhook\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates the matching Google Sheets row\u003c\/strong\u003e by setting \u003ccode\u003ereview_requested_at\u003c\/code\u003e when the email is successfully sent.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eServes an opt-out webhook\u003c\/strong\u003e that validates the visit and email from the unsubscribe link, marks \u003ccode\u003eopt_out\u003c\/code\u003e as \u003cstrong\u003eTRUE\u003c\/strong\u003e for that email in Google Sheets, and returns an unsubscribe confirmation page.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eIncrease review volume for a service business by requesting reviews after completed appointments.\u003c\/li\u003e\n  \u003cli\u003eRun a compliant, trackable request process that avoids re-contacting opted-out customers.\u003c\/li\u003e\n  \u003cli\u003eReduce manual follow-up by letting n8n handle timing, quiet hours, and delivery tracking.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e integration (reads from and updates the \u003cem\u003eVisits\u003c\/em\u003e tab)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail Send (SMTP\/Email)\u003c\/strong\u003e to send HTML review request messages\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWebhook\u003c\/strong\u003e for unsubscribe handling\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes mentioned\u003c\/strong\u003e: if, set, code, webhook, email send, sticky note\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eWorks best when your sheet includes columns: \u003ccode\u003evisit_id, client_name, email, visit_end, timezone, status, review_requested_at, opt_out\u003c\/code\u003e, with \u003ccode\u003estatus\u003c\/code\u003e set to \u003cstrong\u003ecompleted\u003c\/strong\u003e for eligible visits.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46244547330227,"sku":"N8N-21138","price":58.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/5JGPyGHBxmRrhuVVIQte-_161Zkr1z.png?v=1792401327","url":"https:\/\/buyflowscripts.com\/products\/n8n-google-sheets-to-gmail-send-post-visit-review-requests","provider":"N8N Commerce","version":"1.0","type":"link"}