{"product_id":"n8n-workflow-google-sheets-gmail-quote-follow-ups","title":"n8n Workflow: Google Sheets + Gmail Quote Follow-Ups","description":"\u003ch3\u003eAutomate quote follow-ups with Google Sheets + Gmail—without chasing clients\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically sends timed Gmail nudges for unanswered quotes, tracks every step in your Google Sheet, and monitors incoming Gmail replies to stop follow-ups and update status instantly.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns every morning\u003c\/strong\u003e using a \u003cem\u003eSchedule\u003c\/em\u003e trigger and reads your Google Sheets tab named \u003cstrong\u003e“Quotes”\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates elapsed time\u003c\/strong\u003e since each quote was sent, applies stop rules (including states like \u003cstrong\u003eReplied\/Won\/Lost\/Closed\/Do not chase\u003c\/strong\u003e), and flags which rows are due for a nudge today.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSelects the correct follow-up stage\u003c\/strong\u003e based on timing: \u003cstrong\u003eday 3\u003c\/strong\u003e, \u003cstrong\u003eday 7\u003c\/strong\u003e, or \u003cstrong\u003eday 12\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends the matching follow-up email\u003c\/strong\u003e via \u003cstrong\u003eGmail\u003c\/strong\u003e to the client for all quotes due for that day.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates the Google Sheets row\u003c\/strong\u003e with the new \u003cstrong\u003eStatus\u003c\/strong\u003e, \u003cstrong\u003eNudge Stage\u003c\/strong\u003e, and \u003cstrong\u003eLast Nudge Sent\u003c\/strong\u003e date.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonitors Gmail for replies\u003c\/strong\u003e every \u003cstrong\u003e15 minutes\u003c\/strong\u003e, matches messages to open quotes using reference info in the subject and\/or sender address, and marks the quote as \u003cstrong\u003eReplied\u003c\/strong\u003e in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators who send proposals\/quotes and want consistent, timed nudges while tracking outcomes in a single spreadsheet.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building a simple CRM-light process using Google Sheets as the source of truth and Gmail as the communication channel.\u003c\/li\u003e\n  \u003cli\u003eTeams handling multiple quote stages where follow-ups must stop immediately once a client replies or a quote is closed.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets (OAuth) and Gmail (sending + Gmail Trigger for reply monitoring).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic nodes:\u003c\/strong\u003e \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003emerge\u003c\/strong\u003e, \u003cstrong\u003efilter\u003c\/strong\u003e, \u003cstrong\u003eswitch\u003c\/strong\u003e, and supporting notes (including sticky notes).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup requirements:\u003c\/strong\u003e create a “Quotes” tab with columns including \u003cem\u003eQuote Ref, Client Name, Email, Amount, Date Sent, Status, Nudge Stage, Last Nudge Sent\u003c\/em\u003e, replace the placeholder spreadsheet ID, and customize the three Gmail email templates.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45872821600435,"sku":"N8N-18469","price":45.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/J9iBJXSuXMFUoBjXDfd0R_7rNBJ13a.png?v=1787217183","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-google-sheets-gmail-quote-follow-ups","provider":"N8N Commerce","version":"1.0","type":"link"}