{"product_id":"n8n-workflow-google-sheets-trigger-gemini-note-gmail-review-request","title":"n8n Workflow: Google Sheets Trigger → Gemini Note → Gmail Review Request","description":"\u003ch3\u003eTurn Google Sheets updates into instant Gemini-generated job notes and automated Google review requests\u003c\/h3\u003e\n\u003cp\u003eThis n8n automation watches for a \u003cstrong\u003estatus change in Google Sheets\u003c\/strong\u003e, generates a single-sentence technician-style note using \u003cstrong\u003eGoogle Gemini (PaLM)\u003c\/strong\u003e, then sends a \u003cstrong\u003epersonalized Gmail review request\u003c\/strong\u003e. If the customer hasn’t marked the review as left, the workflow sends a follow-up reminder.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonitors your Google Sheets\u003c\/strong\u003e: Triggers when a row is updated and the watched \u003cstrong\u003eStatus\u003c\/strong\u003e column changes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWaits 10 minutes\u003c\/strong\u003e to allow data to settle, then sends job details to \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a short technician note\u003c\/strong\u003e: Produces a \u003cstrong\u003esingle-sentence\u003c\/strong\u003e note in a technician style.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a review request email via Gmail\u003c\/strong\u003e: Emails the customer with the generated note and a \u003cstrong\u003eGoogle review link\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates the same row\u003c\/strong\u003e in Google Sheets (e.g., to record that the review request email was sent).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWaits another 10 minutes\u003c\/strong\u003e, re-reads the row, and checks whether \u003cstrong\u003eReview Left\u003c\/strong\u003e equals \u003cstrong\u003e“Yes”\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFollows up if needed\u003c\/strong\u003e: If no review is marked as left, sends a reminder email through Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eHome service or repair businesses that want automated \u003cstrong\u003epost-job Google review requests\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators managing operational pipelines where \u003cstrong\u003estatus updates\u003c\/strong\u003e should trigger customer outreach.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building a reliable \u003cstrong\u003ereview follow-up loop\u003c\/strong\u003e tied to spreadsheet records.\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 Trigger\u003c\/strong\u003e (OAuth2) to detect row updates and \u003cstrong\u003eStatus\u003c\/strong\u003e changes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWait\u003c\/strong\u003e nodes for the two 10-minute delays.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Gemini (PaLM)\u003c\/strong\u003e to generate the technician-style \u003cstrong\u003esingle-sentence\u003c\/strong\u003e note.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e to send the initial and follow-up review request emails.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e read\/update steps to check \u003cstrong\u003eReview Left\u003c\/strong\u003e and update the row.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired columns\u003c\/strong\u003e: at least \u003cstrong\u003eStatus, Customer Name, Email, Job Type, Technician,\u003c\/strong\u003e and \u003cstrong\u003eReview Left\u003c\/strong\u003e; plus the \u003cstrong\u003eGoogle review URL\u003c\/strong\u003e in both email bodies.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46153974251699,"sku":"N8N-20305","price":37.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/rO0LsYhomE45jzJzAaBxX_gZd7CVi7.png?v=1790932237","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-google-sheets-trigger-gemini-note-gmail-review-request","provider":"N8N Commerce","version":"1.0","type":"link"}