{"product_id":"n8n-workflow-auto-request-google-reviews-via-gmail","title":"n8n Workflow: Auto Request Google Reviews via Gmail","description":"\u003ch3\u003eAutomatically request Google reviews from completed clients—every day\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow reads your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e projects, finds clients who completed work \u003cstrong\u003eat least 2+ days ago\u003c\/strong\u003e, and sends each of them a \u003cstrong\u003epersonalized Google review request email via Gmail\u003c\/strong\u003e. After sending, it updates the sheet so clients aren’t contacted twice.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 11:00\u003c\/strong\u003e using a Schedule Trigger.\u003c\/li\u003e\n  \u003cli\u003eLoads your business settings (business name, owner name, Google review link, and email signature) and pulls all rows from the \u003cstrong\u003eProjects\u003c\/strong\u003e tab in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eFilters projects where:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003estatus\u003c\/strong\u003e is \u003cem\u003eCompleted\u003c\/em\u003e\n\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003ecompleted_on\u003c\/strong\u003e is at least \u003cstrong\u003etwo days old\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003ereview_requested\u003c\/strong\u003e is blank\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eproject_id\u003c\/strong\u003e and \u003cstrong\u003eclient_email\u003c\/strong\u003e are valid\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003eCreates a \u003cstrong\u003ethank-you + review link\u003c\/strong\u003e email tailored to each client.\u003c\/li\u003e\n  \u003cli\u003eSends the email to the client using \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eUpdates the matching Google Sheets row (by \u003cstrong\u003eproject_id\u003c\/strong\u003e) to set \u003cstrong\u003ereview_requested\u003c\/strong\u003e to today’s date.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators and agencies who need a consistent \u003cstrong\u003eGoogle reviews\u003c\/strong\u003e pipeline after project completion.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers implementing reliable post-delivery outreach without manual follow-ups.\u003c\/li\u003e\n  \u003cli\u003eBusinesses managing client communications from a single \u003cstrong\u003eProjects\u003c\/strong\u003e sheet and preventing duplicate review requests.\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 at 11:00)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e steps to read and update project rows\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e to send personalized review request messages\u003c\/li\u003e\n  \u003cli\u003eUses nodes including \u003cstrong\u003eset\u003c\/strong\u003e and \u003cstrong\u003ecode\u003c\/strong\u003e to prepare content and control logic\u003c\/li\u003e\n  \u003cli\u003eRequires a Projects tab with headers: \u003cem\u003eproject_id, client_name, client_email, project, status, completed_on, review_requested\u003c\/em\u003e (with dates in \u003cem\u003eYYYY-MM-DD\u003c\/em\u003e format)\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46288999481523,"sku":"N8N-21672","price":4.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/jw8WNJWfdzgqohIvP_78o_hE7adldR.png?v=1793005892","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-auto-request-google-reviews-via-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}