{"product_id":"n8n-workflow-google-sheets-gemini-renewal-briefings-via-gmail-slack","title":"n8n Workflow: Google Sheets + Gemini Renewal Briefings via Gmail \u0026 Slack","description":"\u003ch3\u003eSend renewal briefings every morning—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow checks your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e renewals register daily, calculates time-to-expiry and notice deadlines, generates a tailored \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e renewal briefing, then delivers the right urgency alert via \u003cstrong\u003eGmail\u003c\/strong\u003e and \u003cstrong\u003eSlack\u003c\/strong\u003e—while updating the sheet to prevent duplicate reminders.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 08:00\u003c\/strong\u003e using a schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads the “Renewals” sheet\u003c\/strong\u003e from your Google Sheets workbook (e.g., Item, Type, Vendor, Expiry Date, Annual Cost, Owner email, Notice Period Days, Last Alert Stage).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates urgency windows\u003c\/strong\u003e based on days until expiry (90\/30\/7-day stages), and computes the \u003cstrong\u003enotice-period deadline\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSkips items already alerted\u003c\/strong\u003e at the same urgency stage using “Last Alert Stage”.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses Google Gemini\u003c\/strong\u003e to draft a concise owner briefing including the decision required, deadline, next steps, and the appropriate urgency.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a Gmail alert\u003c\/strong\u003e to the item owner with a subject line that matches the urgency window.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePosts urgent items to Slack\u003c\/strong\u003e in a selected channel with key details.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates the Google Sheets row\u003c\/strong\u003e with the latest alert stage to avoid repeat alerts.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eProactively manage SaaS and vendor renewals without missing notice deadlines.\u003c\/li\u003e\n  \u003cli\u003eEnsure owners receive consistent, structured renewal updates generated by \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eEscalate only high-urgency renewals (30\/7-day windows) to a Slack channel for faster action.\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, Google Gemini (PaLM) API, Gmail, Slack\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic nodes:\u003c\/strong\u003e if, code, form, switch (and sticky note\/documentation nodes)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore behavior:\u003c\/strong\u003e schedule at 08:00 → read “Renewals” → compute deadlines\/stages → Gemini drafting → Gmail send → Slack post for urgent items → write back updated “Last Alert Stage”\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45822096670899,"sku":"N8N-18066","price":60.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/krUMi1Ru806efu1bZIRkk_drBBRXDg.png?v=1786526093","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-google-sheets-gemini-renewal-briefings-via-gmail-slack","provider":"N8N Commerce","version":"1.0","type":"link"}