{"product_id":"n8n-workflow-send-timed-google-review-emails-from-google-sheets","title":"n8n Workflow: Send Timed Google Review Emails from Google Sheets","description":"\u003ch3\u003eSend Google Review Requests Automatically (and Remind at the Right Time)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow reads your Google Sheets job log every morning and sends customers a timed Google review email—either the initial request 2–4 days after completion or a single reminder once it’s been 5+ days.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 9am\u003c\/strong\u003e using a schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads all rows\u003c\/strong\u003e from a Google Sheets sheet that contains customer details plus the columns: \u003cem\u003eCustomer\u003c\/em\u003e, \u003cem\u003eEmail\u003c\/em\u003e, \u003cem\u003eJob\u003c\/em\u003e, \u003cem\u003eCompleted\u003c\/em\u003e, \u003cem\u003eHappy\u003c\/em\u003e, and \u003cem\u003eReviewAsked\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAdds your Google review link and business name\u003c\/strong\u003e to each row so your email templates can use them per recipient.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters to “Happy = yes”\u003c\/strong\u003e customers.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChecks how many days have passed\u003c\/strong\u003e since \u003cem\u003eCompleted\u003c\/em\u003e:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003e2–4 days:\u003c\/strong\u003e sends the initial Google review request email.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003e5+ days:\u003c\/strong\u003e sends a \u003cstrong\u003esingle reminder\u003c\/strong\u003e email.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTracks email status\u003c\/strong\u003e by using \u003cem\u003eReviewAsked\u003c\/em\u003e: set to \u003cem\u003eyes\u003c\/em\u003e after the first email and \u003cem\u003ereminded\u003c\/em\u003e after the reminder.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends emails via SMTP\u003c\/strong\u003e to the customer’s email address (one path for the initial request, one for the reminder).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomating customer feedback for a service business using an \u003cstrong\u003en8n automation workflow\u003c\/strong\u003e tied to real job completion dates.\u003c\/li\u003e\n  \u003cli\u003eReducing manual outreach by sending \u003cstrong\u003etimed Google review requests\u003c\/strong\u003e only to customers marked as happy.\u003c\/li\u003e\n  \u003cli\u003eEnsuring consistent follow-up with a single reminder after 5+ days—no duplicate spamming.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedule trigger\u003c\/strong\u003e (daily 9am)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e read operation (job log rows)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes\/logic:\u003c\/strong\u003e if, set, code, sticky note\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail sending:\u003c\/strong\u003e email send via SMTP for both the initial request and the reminder\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eSet up your sheet columns, add your Google review URL and business name, and configure SMTP credentials for both sending steps to start running immediately.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45938195759283,"sku":"N8N-19036","price":69.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/w0E2PjS1dgiUxMepR10lj_wjpukDFT.png?v=1788340158","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-send-timed-google-review-emails-from-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}