{"product_id":"n8n-contract-renewal-digest-google-sheets-gmail-openai","title":"n8n Contract Renewal Digest: Google Sheets + Gmail + OpenAI","description":"\u003ch3\u003eStay ahead of contract renewals—without chasing spreadsheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically checks your contract renewal schedule in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, calculates notice deadlines and urgency tiers, and—only when action is needed—uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to generate a concise internal digest email sent via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily on weekdays\u003c\/strong\u003e at 08:00 (or can be started manually).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads renewal data\u003c\/strong\u003e from the Google Sheets \u003cstrong\u003e“Contracts”\u003c\/strong\u003e tab, using your configured spreadsheet selection and alert email settings.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates notice deadlines\u003c\/strong\u003e for each contract (renewal date minus notice days), then assigns an urgency tier such as \u003cem\u003eurgent\u003c\/em\u003e, \u003cem\u003ewarning\u003c\/em\u003e, \u003cem\u003enotice missed\u003c\/em\u003e, or \u003cem\u003eunparseable\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIgnores irrelevant entries\u003c\/strong\u003e, including contracts marked \u003cstrong\u003ecancelled\u003c\/strong\u003e and renewals that are already passed.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a digest only when necessary\u003c\/strong\u003e: contracts that require no action are filtered out, and only flagged items are summarized.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses an OpenAI chat model\u003c\/strong\u003e to turn the flagged digest into a short internal to-do style email.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends one email via Gmail\u003c\/strong\u003e to your configured recipient—sending nothing when there are no flagged contracts.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eFor SaaS operators managing vendors: get one renewal alert digest instead of constant spreadsheet monitoring.\u003c\/li\u003e\n  \u003cli\u003eFor automation engineers: a ready-made \u003cstrong\u003en8n contract renewal digest\u003c\/strong\u003e workflow combining Google Sheets, urgency logic, OpenAI drafting, and Gmail delivery.\u003c\/li\u003e\n  \u003cli\u003eFor legal\/ops teams: highlight missed notice deadlines and time-sensitive renewals with clear urgency tiers.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduling:\u003c\/strong\u003e weekday automation at 08:00 (manual start supported).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets integration:\u003c\/strong\u003e reads contract rows from the \u003cstrong\u003eContracts\u003c\/strong\u003e tab (expects headers like Renewal Date, Notice Days, Status; optional fields such as Value and Owner).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogic \u0026amp; filtering:\u003c\/strong\u003e \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, and \u003cstrong\u003efilter\u003c\/strong\u003e nodes to tier renewals and exclude fine\/passed\/cancelled items.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI drafting:\u003c\/strong\u003e \u003cstrong\u003eOpenAI chat model\u003c\/strong\u003e to convert the urgent-first digest into a concise internal email.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail delivery:\u003c\/strong\u003e \u003cstrong\u003eGmail\u003c\/strong\u003e node to send the summary digest only when items are flagged.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46132923728051,"sku":"N8N-20146","price":14.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/N6uiv-G88Z62HjDdhp1gD_R8hOrNpv.png?v=1790760154","url":"https:\/\/buyflowscripts.com\/products\/n8n-contract-renewal-digest-google-sheets-gmail-openai","provider":"N8N Commerce","version":"1.0","type":"link"}