{"product_id":"automate-contract-renewals-drive-pdfs-gemini-sheets-gmail-slack","title":"Automate Contract Renewals: Drive PDFs → Gemini, Sheets, Gmail \u0026 Slack","description":"\u003ch3\u003eAutomate contract renewals from Google Drive PDFs—extract terms with Gemini, track in Sheets, and alert via Gmail + Slack\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow scans a Google Drive folder for new contract PDF files on a weekly schedule, uses the Gemini API to extract key renewal terms, updates a Google Sheets contract registry, and sends renewal alerts through Gmail and Slack—plus a weekly digest email.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns weekly (or manually for testing):\u003c\/strong\u003e Loads configuration values such as the Drive folder ID, Google Sheet ID, alert email, and Slack channel.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects new contracts:\u003c\/strong\u003e Searches the target folder for PDFs and compares them against the existing records in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts renewal terms with Gemini:\u003c\/strong\u003e Downloads each new PDF, reads its text, and calls the Gemini API to extract structured contract renewal details.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMaintains a single contract registry:\u003c\/strong\u003e Appends new contract records to the Google Sheets Registry and merges them with existing entries.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates urgency and risk:\u003c\/strong\u003e Computes days-to-renewal, assigns urgency tiers (90\/60\/30\/notice_passed), and flags short-notice auto-renewals.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends targeted alerts:\u003c\/strong\u003e Filters contracts that entered a new alert tier since the last run, then generates a one-page renewal briefing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifies stakeholders:\u003c\/strong\u003e Sends the briefing via \u003cstrong\u003eGmail\u003c\/strong\u003e, posts a renewal notification to \u003cstrong\u003eSlack\u003c\/strong\u003e, and updates the registry with the last alerted tier.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDelivers a weekly digest:\u003c\/strong\u003e Builds a portfolio summary (tracked contracts, new contracts, alerts sent, items needing review) and emails it; also logs the run to a \u003cstrong\u003eRunLog\u003c\/strong\u003e sheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRenewal teams tracking vendor and customer contracts without missing notice windows.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators managing auto-renew agreements across multiple stakeholders.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers deploying a consistent, auditable contract registry in Google Sheets.\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 Drive, Google Sheets, Gmail, Slack.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGemini API:\u003c\/strong\u003e Extracts structured renewal terms from contract PDF text.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic\/nodes mentioned:\u003c\/strong\u003e if, set, code, no op, merge, gmail.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired setup:\u003c\/strong\u003e Create a Google Sheet with a \u003cem\u003eRegistry\u003c\/em\u003e tab (and a \u003cem\u003eRunLog\u003c\/em\u003e tab for logging).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46289346855091,"sku":"N8N-21338","price":31.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/QKgcIWBCdsEXRGBwSbIPT_ti6pAcfb.png?v=1793007105","url":"https:\/\/buyflowscripts.com\/products\/automate-contract-renewals-drive-pdfs-gemini-sheets-gmail-slack","provider":"N8N Commerce","version":"1.0","type":"link"}