{"product_id":"automate-contract-renewals-llamaparse-gpt-4o-mini-to-slack-sheets","title":"Automate Contract Renewals: LlamaParse + GPT-4o-mini to Slack \u0026 Sheets","description":"\u003ch3\u003eAutomate contract renewals end-to-end with LlamaParse, GPT-4o-mini, Slack approvals, and Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically watches a Google Drive folder for new contract PDFs, parses them with \u003cstrong\u003eLlamaParse\u003c\/strong\u003e, extracts key obligations using \u003cstrong\u003eGPT-4o-mini\u003c\/strong\u003e, and manages renewal\/termination decisions through \u003cstrong\u003eSlack\u003c\/strong\u003e button actions—while keeping a complete register in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and drafting termination notices in \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\u003eDetects new PDFs in Google Drive\u003c\/strong\u003e: Triggers when a new file is created in a specific folder and continues only if the file is a PDF.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eParses contracts with LlamaParse\u003c\/strong\u003e: Downloads the PDF, submits it to LlamaParse, polls until parsing completes, and alerts Slack if parsing fails or times out.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts structured terms with OpenAI\u003c\/strong\u003e: Retrieves the parsed markdown from LlamaParse and uses \u003cstrong\u003egpt-4o-mini\u003c\/strong\u003e to extract key contract terms, risks, and obligations.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRegisters data in Google Sheets\u003c\/strong\u003e: Calculates notice decision deadlines, upserts the contract into a \u003cem\u003eContracts\u003c\/em\u003e tab, and upserts each extracted obligation into an \u003cem\u003eObligations\u003c\/em\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends renewal\/termination prompts daily\u003c\/strong\u003e: Runs at \u003cstrong\u003e9 AM\u003c\/strong\u003e to detect notice milestones (90\/60\/30 days and overdue), posts Slack messages with \u003cstrong\u003eRenew\u003c\/strong\u003e\/\u003cstrong\u003eTerminate\u003c\/strong\u003e buttons, and marks milestones as sent in Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDelivers an obligations digest\u003c\/strong\u003e: Also runs at \u003cstrong\u003e9 AM\u003c\/strong\u003e to compile open obligations due within 7 days (or overdue) and posts a Slack digest.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles decisions via webhook approval\u003c\/strong\u003e: Receives button clicks, validates a one-time approval token against Google Sheets, records the decision, and either confirms renewal in Slack or drafts a termination notice in Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eLegal ops and contract managers who want \u003cstrong\u003eautomated renewal tracking\u003c\/strong\u003e for incoming PDF contracts.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators managing recurring agreements with \u003cstrong\u003estructured obligation extraction\u003c\/strong\u003e and timely notice alerts.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers deploying a reliable \u003cstrong\u003eSlack-based decision workflow\u003c\/strong\u003e tied to Google Sheets records.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003en8n nodes\/logic: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003ewait\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003eslack\u003c\/strong\u003e, \u003cstrong\u003eswitch\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eIntegrations: \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, \u003cstrong\u003eLlamaParse\u003c\/strong\u003e, \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eSlack\u003c\/strong\u003e, \u003cstrong\u003eGmail\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46172922937523,"sku":"N8N-20605","price":38.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Pt2MMAzazhaYJF-rEdlw7_vF7TVn4B.png?v=1791363839","url":"https:\/\/buyflowscripts.com\/products\/automate-contract-renewals-llamaparse-gpt-4o-mini-to-slack-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}