Log the key terms of emailed contracts in a sheet

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.

GmailWhen an email arrives. Save it as email.When an email arrives. Save it as email.

Contracts sheetSet contracts_sheet_url to blank.

The email's attachmentsDownload the attachments on email email. Save it as files.Gmail

What the contract saysRun an AI agent: Read the attached files. Say whether they are a vendor contract, and if so pull out its k… and save it as contract.

If contract.output.is_contract is yesIf contract.output.is_contract is yes

Yes

Add to the contracts sheetAdd a row in contracts_sheet_url. Save it as logged.Google Sheets

No

No steps