{"product_id":"n8n-weekly-open-quotes-digest-gmail-email-google-sheets","title":"n8n Weekly Open Quotes Digest: Gmail Email + Google Sheets","description":"\u003ch3\u003eGet a weekly “open quotes” nudge—automatically—straight from Google Sheets to Gmail\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs every Monday morning to scan your Google Sheets for quotes still marked \u003cem\u003eopen\u003c\/em\u003e, groups them by how long they’ve gone unanswered, and emails you a clean HTML digest via Gmail. It also logs a weekly snapshot back to Google Sheets so you don’t get duplicate sends.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule:\u003c\/strong\u003e executes every Monday at \u003cstrong\u003e8:00 AM\u003c\/strong\u003e based on your workflow timezone.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads your data from Google Sheets:\u003c\/strong\u003e pulls quote rows from your \u003cem\u003equotes\u003c\/em\u003e worksheet and checks an existing \u003cem\u003elog\u003c\/em\u003e worksheet for weekly digest history.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters \u0026amp; prioritizes:\u003c\/strong\u003e selects only quotes with \u003cstrong\u003estatus = open\u003c\/strong\u003e, calculates \u003cstrong\u003edays since sent_date\u003c\/strong\u003e, sorts by \u003cstrong\u003equote amount\u003c\/strong\u003e, and buckets results into categories like \u003cstrong\u003efresh\u003c\/strong\u003e, \u003cstrong\u003eneeds a nudge\u003c\/strong\u003e, or \u003cstrong\u003egoing cold\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents duplicates:\u003c\/strong\u003e verifies whether a digest for the current week_start date was already sent; if so, it stops.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends your digest:\u003c\/strong\u003e emails an \u003cstrong\u003eHTML\u003c\/strong\u003e digest to your configured recipient using \u003cstrong\u003eGmail\u003c\/strong\u003e. \u003cem\u003eNothing is sent to customers.\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates the weekly log:\u003c\/strong\u003e appends\/updates a snapshot row in the log worksheet (including \u003cstrong\u003eweek_start\u003c\/strong\u003e, counts, \u003cstrong\u003evalue at risk\u003c\/strong\u003e, and \u003cstrong\u003esent time\u003c\/strong\u003e).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSales or ops teams who track quotes in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e want a weekly reminder of which deals need attention first.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators monitoring pipeline health can quantify “value at risk” and reduce stale opportunities.\u003c\/li\u003e\n  \u003cli\u003en8n users building lightweight CRM-style workflows without a full CRM integration.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduler:\u003c\/strong\u003e runs every Monday at 8:00 AM.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets nodes:\u003c\/strong\u003e read from the quotes worksheet and the weekly digest log worksheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogic:\u003c\/strong\u003e uses \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, and \u003cstrong\u003ecode\u003c\/strong\u003e to filter open quotes, compute age, bucket results, and enforce “send once per week.”\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail:\u003c\/strong\u003e \u003cstrong\u003egmail\u003c\/strong\u003e node sends the HTML digest to \u003cstrong\u003eyourEmail\u003c\/strong\u003e (configured in settings).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOther:\u003c\/strong\u003e includes a \u003cstrong\u003esticky note\u003c\/strong\u003e for setup guidance.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup (quick checklist)\u003c\/h3\u003e\n\u003cp\u003eConnect Google Sheets for both the quotes sheet and the digest log sheet, then connect Gmail and set the recipient email (yourEmail). After selecting the log sheet in the last Google Sheets node, re-open it and restore \u003cem\u003eMap Automatically\u003c\/em\u003e so \u003cem\u003eweek_start\u003c\/em\u003e matching behaves correctly.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45738519527603,"sku":"N8N-17545","price":55.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/xnydJnmF_v6T0EKTPR9px_j1IVTVDu.png?v=1785229741","url":"https:\/\/buyflowscripts.com\/products\/n8n-weekly-open-quotes-digest-gmail-email-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}