Log the key terms of emailed contracts in a sheet
Reads emailed contract attachments and logs vendor, cost, renewal and notice terms.
Apps it connects
Authenticate each one once and the workflow is ready to run.
What it does
Each integration step this workflow runs, in order, what it is for, and the conditions and loops that decide when it runs.
- 1GmailNew email triggerStarts on each new email that has a file attached.
- 2GmailDownload attachmentsSaves the attachments so the AI can read them.
If
contract.output.is_contractis “yes”- 3Google SheetsAppend rowLogs the contract's key terms.
- 3
How it works
What happens on each run, in plain English.
Auto-renewing contracts catch people out because nobody wrote down the notice period. When an email with an attachment arrives, an AI reads the file and decides whether it is a vendor contract.
If it is, one row goes in your Contracts sheet with the vendor, yearly cost, renewal date, whether it auto-renews and the days of notice needed to cancel. Other attachments are ignored.
You may also be interested in
Remind contract owners before a renewalEvery morning, emails the owner of any contract in your Google Sheet that renews in exactly 30 days.
Never miss a filing or renewal deadlineChecks your deadline sheet each morning and emails you as each licence, permit, tax filing or renewal comes due, with a calendar event.
Approve big invoices, then bill them in QuickBooksReads each emailed invoice, asks your finance director to approve big ones, then records the bill in QuickBooks and your log.File emailed invoices and approve the big onesReads each invoice emailed to you, files it in a Bills sheet, and sends large or unreadable ones to finance for approval first.Start from a workflow that already works.
Add "Log the key terms of emailed contracts in a sheet" to your workspace, connect its apps, and make it yours.
Free plan, no credit card