Automate vendor contract renewals & reminders with GPT-4.1 mini, Slack & Gmail

📝 Smart Vendor Contract Renewal & Reminder Workflow With GPT 4.1 mini Watch the demo video below: [](https://www.youtube.com/watch?v=zBmFGT5Xlng) Never miss a vendor renewal again! This smart workflow automatically tracks expiring contracts, reminds your finance team via Slack, and helps initiate renewal with vendors through email — all with built-in approval and logging. Perfect for managing both auto-renew and manual contracts. 📌 Who’s it for This workflow is designed for Finance and Procurement teams responsible for managing vendor/service contracts. It ensures timely notifications for expiring contracts and automates the initiation of renewal conversations with vendors.

⚙️ How it works / What it does

1. ⏰ Daily Trigger - Runs every day at 6:00 AM using a scheduler.

2. 📄 Retrieve Contract List - Reads vendor contract data from a Google Sheet (or any data source). - Filters for contracts nearing their end date, using a Notice Period (days) field.

3. 🔀 Branch Based on Renewal Type - Auto-Renew Contracts: - Compose a Slack message summarizing the auto-renewal. - Notify the finance contact via Slack.

- Manual Renewal Contracts: - Use an OpenAI-powered agent to generate a meaningful Slack message. - Send message and wait for approval from the finance contact (e.g., within 8 hours). - Upon approval, generate a formal HTML email to the vendor. - Send the email to initiate the contract extension process.

4. 📊 (Optional) Logging - Can be extended to log all actions (Slack messages, emails, approvals) to Google Sheets or other databases.

🛠️ How to set up