Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Email Automation

Email Automation

Collect and track lien waivers with Google Sheets, Gmail, and GPT-4o-mini

When an API call/webhook arrives, it handles email with OpenAI / ChatGPT using Gmail, Google Sheets.

What it does

## Collect and chase lien waivers ### How it works 1. An invoice webhook starts the request. Incomplete or duplicate invoices are stopped and finance is told. 2. A GPT-6.1-sol agent drafts the vendor email, and a fact check swaps in a template if the invoice, amount or due date is missing. 3. The request is logged and sent with retries. The Gmail id or a send failure is written back to the row. 4. A receipt webhook marks the waiver received only when the invoice exists and is still open, then clears payment. 5. Every morning vendors get up to three reminders and finance gets an overdue escalation. 6. Every Monday finance gets a summary of open waivers. ### Setup steps - [ ] Create the Waivers tab with the tracking columns - [ ] Connect Google Sheets, Gmail and OpenAI - [ ] Set the finance address in both normalize nodes - [ ] Connect the intake and receipt webhooks ### Customization Change the reminder window in Pick Vendor Reminders, the template text in Check Draft Facts, or the 08:00 and Monday crons.

The steps

  1. When Payment Is Ready
  2. Normalize Invoice
  3. Validate Waiver Request
  4. Alert on Missing Details
  5. Draft Waiver Request
  6. Waiver Draft Model
  7. Prepare Email and Tracker Row
  8. Append Waiver Request to Tracker
  9. Email Waiver Request to Vendor
  10. When Waiver Comes Back
  11. Normalize Receipt
  12. Mark Waiver Received
  13. Email Payment Clearance Note
  14. Daily Overdue Check

41 steps in total.

Similar automations