{"product_id":"n8n-gmail-quote-follow-ups-with-google-sheets-openrouter","title":"n8n Gmail Quote Follow-Ups with Google Sheets \u0026 OpenRouter","description":"\u003ch3\u003eAutomated Gmail quote follow-ups—powered by Google Sheets + OpenRouter\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow checks customer replies in Gmail for each sent quote stored in Google Sheets, then uses OpenRouter to classify responses or draft timely follow-up emails—updating quote status and follow-up counts automatically.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 9:00\u003c\/strong\u003e and loads follow-up settings (timing thresholds, tone, and owner email).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads open quotes\u003c\/strong\u003e from the Google Sheets \u003cem\u003e“Quotes”\u003c\/em\u003e tab, filtering for rows where \u003cem\u003eStatus\u003c\/em\u003e is \u003cem\u003esent\u003c\/em\u003e or \u003cem\u003efollowed up\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSearches Gmail per quote\u003c\/strong\u003e to find the most recent customer message since the quote’s \u003cem\u003eSent Date\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetermines next action\u003c\/strong\u003e based on days since sent, follow-up count, and defined windows:\n    \u003cul\u003e\n      \u003cli\u003eWait (no action yet)\u003c\/li\u003e\n      \u003cli\u003eSend a follow-up email\u003c\/li\u003e\n      \u003cli\u003eMark the quote as \u003cem\u003egone cold\u003c\/em\u003e when overdue with no response\u003c\/li\u003e\n      \u003cli\u003eTreat the quote as replied when a customer message is detected\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOn customer replies\u003c\/strong\u003e, fetches the reply from Gmail, uses \u003cstrong\u003eOpenRouter\u003c\/strong\u003e to classify intent and draft a \u003cem\u003esuggested response\u003c\/em\u003e, emails a summary to the owner, and updates Google Sheets (status + last contact date).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOn follow-up due\u003c\/strong\u003e, generates a short follow-up via OpenRouter, sends it through Gmail, and updates \u003cem\u003eFollow-ups\u003c\/em\u003e, \u003cem\u003eStatus\u003c\/em\u003e, and \u003cem\u003eLast Contact\u003c\/em\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 teams following up on quote requests without manually checking inboxes.\u003c\/li\u003e\n  \u003cli\u003eSales ops or founders using Google Sheets as the CRM-lite pipeline for quotes.\u003c\/li\u003e\n  \u003cli\u003eService businesses needing consistent, rules-based email follow-ups with reply summaries to the owner.\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\u003c\/strong\u003e OAuth2 connection (reads\/writes the “Quotes” tab columns like Quote ID, Status, Follow-ups, Last Contact).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e integration to search for messages and send follow-ups.\u003c\/li\u003e\n  \u003cli\u003eWorkflow logic using nodes such as \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003efilter\u003c\/strong\u003e, \u003cstrong\u003eswitch\u003c\/strong\u003e, and \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenRouter\u003c\/strong\u003e for drafting follow-up emails and classifying reply intent + suggested responses.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46326525100211,"sku":"N8N-21815","price":28.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/LnO-WV6ODNeEEULAB6ITO_kLuTQvzv.png?v=1793351514","url":"https:\/\/buyflowscripts.com\/products\/n8n-gmail-quote-follow-ups-with-google-sheets-openrouter","provider":"N8N Commerce","version":"1.0","type":"link"}