{"product_id":"n8n-workflow-post-appointment-review-requests-email-sms","title":"n8n Workflow: Post-Appointment Review Requests (Email \u0026 SMS)","description":"\u003ch3\u003eAutomate Post-Appointment Reviews with Email—and optional SMS\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically sends post-appointment review requests via SMTP email and (optionally) SMS using an HTTP API—while using Google Sheets to prevent duplicates, enforce cooldowns, and respect SMS STOP and email unsubscribe opt-outs.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eReceives completed appointments\u003c\/b\u003e via a webhook protected with header authentication (or runs on an optional \u003cb\u003e15-minute schedule\u003c\/b\u003e to read completed appointments from a Google Sheets tab).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eValidates and normalizes appointment data\u003c\/b\u003e, immediately returns a \u003cb\u003e202 response\u003c\/b\u003e to the booking system, then waits your configured delay before messaging.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eChecks Google Sheets rules\u003c\/b\u003e by loading \u003cb\u003eReview_Log\u003c\/b\u003e and \u003cb\u003eOpt_Outs\u003c\/b\u003e to skip duplicates, honor opt-outs, and enforce a cooldown between review requests.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSends a review request email\u003c\/b\u003e through \u003cb\u003eSMTP\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eOptionally sends an SMS\u003c\/b\u003e via an \u003cb\u003eHTTP request\u003c\/b\u003e—only when enabled, within your configured send window, and consent rules are satisfied.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eLogs outcomes to Review_Log\u003c\/b\u003e (sent, skipped, or failure) so the same contact isn’t asked twice.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCaptures opt-outs\u003c\/b\u003e by recording inbound \u003cb\u003eSMS STOP\/START\u003c\/b\u003e replies and \u003cb\u003eemail unsubscribe link\u003c\/b\u003e clicks into \u003cb\u003eOpt_Outs\u003c\/b\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eReduce manual follow-ups for service bookings by sending review requests after each completed appointment.\u003c\/li\u003e\n  \u003cli\u003eLaunch a multi-channel review campaign (email + SMS) with guardrails to avoid over-messaging.\u003c\/li\u003e\n  \u003cli\u003eMaintain compliance-friendly behavior by tracking opt-outs across both channels in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003en8n nodes\/workflow logic:\u003c\/b\u003e \u003ci\u003ewebhook\u003c\/i\u003e, \u003ci\u003eif\u003c\/i\u003e, \u003ci\u003eset\u003c\/i\u003e, \u003ci\u003ecode\u003c\/i\u003e, \u003ci\u003ewait\u003c\/i\u003e, \u003ci\u003eswitch\u003c\/i\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eIntegrations:\u003c\/b\u003e \u003cb\u003eSMTP email\u003c\/b\u003e, \u003cb\u003eHTTP API\u003c\/b\u003e (for SMS), \u003cb\u003eGoogle Sheets\u003c\/b\u003e (Review_Log, Opt_Outs, and optional Appointments tab)\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup requirements\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCreate a Google Sheet with tabs named \u003cb\u003eReview_Log\u003c\/b\u003e, \u003cb\u003eOpt_Outs\u003c\/b\u003e, and (if using schedule mode) \u003cb\u003eAppointments\u003c\/b\u003e, using the columns expected by the workflow.\u003c\/li\u003e\n  \u003cli\u003eAdd Google Sheets OAuth credentials and update the Google Sheet document ID in all Google Sheets nodes.\u003c\/li\u003e\n  \u003cli\u003eConfigure \u003cb\u003eSMTP\u003c\/b\u003e credentials for email delivery.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46359763845299,"sku":"N8N-22189","price":14.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Ca3LbSmii62yhn49woiEu_bBmt7n7V.png?v=1793697199","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-post-appointment-review-requests-email-sms","provider":"N8N Commerce","version":"1.0","type":"link"}