Vendor invoices arrive as email attachments and die in inboxes — or get entered by hand, slowly and with typos. This template turns the inbox into a pipeline: Gmail Trigger: Invoice Email fires on messages whose subject contains "invoice" with an attachment, Gmail: Download Attachment grabs the file, and OpenAI: Extract Invoice Data reads it into structured JSON — vendor name, amount, date, invoice number. Set: Normalize Fields cleans the values and stamps the row status = pending, then Google Sheets: Log Invoice appends it to your spreadsheet. The IF: Amount > 1000 gate routes big invoices to a human: Gmail: Approval Request emails finance the details plus an approval link, Wait: Finance Approval pauses until the Approve/Reject form is submitted, and the row becomes reconciled or rejected. Small invoices skip the gate entirely and land as auto-reconciled, with a Slack: Notify post to your finance channel confirming the auto-reconciliation.
Small business owner drowning in vendor bills
A 10-person company gets 40–60 vendor invoices a month — software subscriptions, suppliers, contractors — and the owner currently forwards them to the accountant in batches. With this pipeline, every invoice email is extracted and logged within minutes of arrival: the spreadsheet becomes the live payables list with vendor, amount, date, and invoice number in clean columns. Anything under your threshold (default $1,000, adjustable in IF: Amount > 1000) reconciles itself; anything over pauses for your approval via the email link, which opens an Approve/Reject form and resumes the workflow the moment you submit. Practical tip: send a test invoice email right after activation and check the extracted fields — one test catches attachment-format quirks before real money flows through.
Restaurant group with invoices from many locations
Three locations mean invoices from produce suppliers, linen services, and maintenance vendors arriving in one shared inbox — the classic pile nobody owns. The Gmail trigger's q filter can be narrowed per workflow (e.g. from:[email protected] has:attachment), so you can run one pipeline per location or per vendor category, each logging to its own sheet tab. The extraction handles varied layouts, though the guide notes adding an Extract from File node before OpenAI: Extract Invoice Data if your invoices arrive as PDFs. The approval gate is the control that matters in food businesses with tight margins: the manager approves anything over the threshold from their phone via the email link. Tip: normalize currency in Set: Normalize Fields if any vendors bill in another currency, so the >1000 comparison always runs in your base currency.
Startup finance lead building controls from day one
A startup's first finance hire needs audit trails, not spreadsheets-by-email. This workflow gives you both: every invoice logged with a status trail — pending → auto-reconciled / reconciled / rejected — and the Slack notification to #finance announcing each auto-reconciliation keeps the team informed without meetings. The human gate on large invoices is your segregation of duties: the person who received the invoice isn't the person who approved it. Because approval happens through the $execution.resumeUrl link, there's a timestamped record of who approved what and when. Practical variation: connect a Gmail send node after Google Sheets: Mark Rejected to notify the vendor automatically — the rejection reason can ride along, closing the loop instead of leaving the vendor guessing.
Ecommerce brand reconciling supplier and ad invoices
An ecommerce brand's payables are supplier invoices, freight bills, and agency retainers — high volume, mixed formats. The AI extraction shines here because supplier invoices rarely share a layout: the model reads vendor, amount, date, and invoice number regardless of template, which is exactly what breaks brittle template-based parsers. Set the approval threshold to match your delegation policy — maybe $500 for a lean team — and everything above it waits for the founder's tap. The sheet becomes the month-end close input: filter by reconciled and auto-reconciled for the booked payables, investigate the pending stragglers. Tip: review the extracted amounts for your first 20 invoices against the PDFs; the one field AI occasionally misreads is the total when invoices show subtotals and tax prominently — a quick spot-check habit beats a painful month-end surprise.
Agency owner who wants payables off their plate
Agency owners often approve every invoice personally because they don't trust the process — which doesn't scale past a dozen vendors. This template is the trustable middle: small recurring invoices (hosting, SaaS seats, freelancers under threshold) reconcile automatically with a Slack paper trail, and only the big ones interrupt you. The approval email contains the invoice details inline, so the decision takes 20 seconds from your phone. Practical tip: keep the finance approval email recipient as a distribution list, not one person — approvals shouldn't stall when someone's on leave.