1.Runs daily and outputs run date
Integrate Schedule by Zapier and automation scheduling tools to run daily and output the run datetime.
Update renewal notification flag on expiring vendor contracts
Automatically monitor renewal dates across Notion databases and automation steps in Zapier. Create and update when the daily run finds matching vendor contracts, renewal date matches, or qualifying records existβso you can toggle the renewal notification flag, reset it after a pause, and surface contracts without manual contract review.
How this automation protects renewal follow-up
When the daily run fires, renewal owners can miss expiring vendor contracts and lose renewal timing. This automation monitors renewal dates, updates the notification flag, and resets it after a delayβso your team can act on expiring contracts without chasing spreadsheets.
Schedule by Zapieror swap with your favorite app
2.Formats trigger date for filtering
Integrate Formatter by Zapier and data formatting tools to format the trigger datetime into YYYY-MM-DD.
Formatter by Zapieror swap with your favorite app
3.Finds matching vendor contracts
Integrate Notion and database query tools to query the configured database for the formatted renewal date.
Notionor swap with your favorite app
4.Stops when no matches are found
Integrate Filter by Zapier and conditional logic tools to continue only when the Notion query returns results.
Filter by Zapieror swap with your favorite app
5.Sets renewal notification flag to true
Integrate Notion and record update tools to update each page and set the renewal notification flag to true.
6.Waits one minute before reset
Integrate Delay by Zapier and workflow timing tools to pause for one minute before clearing the flag.
Delay by Zapieror swap with your favorite app
Automate your work, your way
Build custom automations across your tools in minutes. Describe what you need, connect your apps, and create workflows without the manual effort.
Trusted by 3.4 million companies
Related automations
- Apps: Schedule by Zapier, Notion, Looping by Zapier, Code by Zapier, Filter by ZapierSwap with your favorite apps.
Activate contracts on effective date for operations team
Your contract records often remain Not started past effective dates, delaying handoffs and start tasks. Automatic activation marks contracts Active so contract managers can action items same day.
- Apps: Docusign, Google Drive, LeadConnector, Zapier TablesSwap with your favorite apps.
Add contact and save signed agreement to files
Signed agreements arrive uncaptured, leaving reps without a contact record or contract link for follow-up. Save the PDF to central storage and add or update the contact with the link so sales can follow up same day.
- Apps: PandaDoc, Email by Zapier, AirtableSwap with your favorite apps.
Add contract signed timestamp to client database records
Signed contracts aren't reflected in your client records, blocking billing and onboarding. The signed timestamp is added to records so teams can invoice and onboard clients same day.
- Apps: Webhooks by Zapier, Filter by ZapierSwap with your favorite apps.
Add external legal approvals to tracker records automatically
External approval replies arrive via webhook but don't update your legal tracker, leaving contracts without recorded sign-off. Updates record approvals so coordinators can move agreements forward within minutes.
- Apps: monday.com, Delay by Zapier, Filter by ZapierSwap with your favorite apps.
Add MSA status and form link to project item
New project items missing legal tags force intake to identify agreements manually and delay prep. This adds a status and form link so coordinators have agreement context before kickoff.
- Apps: Docusign, Formatter by Zapier, Jira Software CloudSwap with your favorite apps.
Add NDA view updates to issue comments for stakeholders
Your MNDA ticket lacks visibility when recipients only view the agreement without other updates. You get ticket-level visibility for view events so reviewers see status updates same day.
- Apps: Salesforce, Formatter by Zapier, Slack, Google Sheets, NotionSwap with your favorite apps.
Add onboarding record and alert teams on accepted contract
Your accepted contracts often miss structured handoff details, delaying project setup and invoice readiness. It creates onboarding records and notifies coordinators so work starts same day.
- Apps: Webhooks by Zapier, Filter by Zapier, SmartsheetSwap with your favorite apps.
Add or update contract records in tracking sheet
Your completed contract records arrive untracked, leaving owners without expiry or tenant context. Rows are added or updated so managers have accurate status ahead of renewal.
- Apps: eSignatures, Code by Zapier, Paths by Zapier, Google Sheets, PodioSwap with your favorite apps.
Add sent agreement links to partner application records
Your partner application and claims records lack signed agreement links, leaving intake and processing stalled. The link is added to the record so intake coordinators can proceed same day.
- Apps: Docusign, Filter by Zapier, Google SheetsSwap with your favorite apps.
Add signed agreement signers to master account list
Your completed agreements sit scattered, delaying follow-up and audit readiness. Capture signer names and signed PDF links into one master sheet for visibility within minutes.
- Apps: Docusign, Filter by Zapier, KeapSwap with your favorite apps.
Add signed agreement tags to contact record for onboarding
When signed agreement PDFs aren't logged to contact records, your onboarding stalls and teams can't find the executed files. It tags the contact so coordinators and billing start setup the same day.
- Apps: SignNow, Formatter by Zapier, Email by Zapier, Google SheetsSwap with your favorite apps.
Add signed agreement to tracker and email signer
Your signed access agreements sit in email threads and delay onboarding verification for integrations. It logs the signed file and notifies the signer so provisioning can proceed same day.
- View all
Explore all contract lifecycle management automations
Accelerate contract workflows with automated intake routing, approval tracking, and renewal alerts
Set up in minutes
Zapier connects your tools, triggers actions from real-time data, and streamlines workflows so your team can focus on what matters most.
Step 1
Connect your tools
Bring your apps together so information can move automatically between the tools your team already uses.
Step 2
Define the trigger
Choose the events that should start your workflow, like a new submission, updated record, completed task, or customer action.
Step 3
Automate and measure
Let your workflow handle follow-ups, updates, notifications, and reporting so your team can track progress and act faster.
See how teams are automating with Zapier (and loving it!)
Without Zapier, we would have needed well over 100 employees today just to do what we're doing. We would have been out of business by now.
David Laderberg, VP of Sales
Without having automation, we would have to at least be double our size. Doubling is a bit of a euphemism β I think we would have died or fallen back into oblivion.
Marcelo Lebre, Co-Founder
Zapier helps us close far above 50% more deals than we would without it. It is a key element of our overall strategy and, therefore, of our sales pitch.
Raphael Bochner, Founder and CIO
Zapier gives us unlimited flexibility and creativity. With Zapier, you're like an artist with a blank canvas. I don't know what we'd do without it.
Rishi Shah, CEO and Co-Founder
We don't just want to patch holes; we want to build scalable, future-proof systems. Zapier is helping us do that.
Allen Lai, Head of Customer Experience
We've been able to scale our operations while staying lean. Zapier lets us do more without needing more people.
Jacob Sirrs, Marketing Operations Specialist
Ready to automate your workflow securely?
Streamline processes, uncover new opportunities, and respond faster to change. Empower your team to get more done, without the manual work.