INVOICE PROCESSING
Detect Price Creep in PDF Invoices Dropped into Google Drive
Triggers when a vendor invoice PDF is added to a Google Drive folder, extracts amounts, compares them to prior invoices.
How it runs
The automated pipeline, trigger to output.
- TriggerNew invoice PDF added to Google Drive folderGoogle Drive
- ActionDownload PDF and extract vendor and amountsOpenAI
- ActionLook up vendor's prior invoice amountsPostgres
- LogicCompute drift and assign pass or flagged verdict
- OutputLog invoice and verdict to Notion databaseNotion
What it does
For teams that collect invoices as PDFs rather than structured data, this workflow turns a shared Drive folder into a drift monitor. Each time a PDF lands, it reads the document, pulls out the vendor and line-item amounts, and checks them against what that vendor billed previously. Whether or not drift is detected, it records a full entry in a Notion database, building a searchable audit trail with a clear pass or flagged verdict on every invoice.
When to use it
Choose this when invoices arrive as PDF attachments saved to Drive and you want both detection and a durable, browsable history in Notion. Good for operations teams without a dedicated AP platform.
How it works
- 1A new PDF appears in the watched Google Drive folder and triggers the run.
- 2The workflow downloads the file and extracts vendor, totals, and line items.
- 3It queries Postgres for the vendor's previous invoice amounts.
- 4A logic step calculates drift and assigns a pass or flagged verdict.
- 5The new amounts are written back to Postgres for future comparisons.
- 6A Notion database row is created with the verdict, amounts, drift percentage, and a link to the PDF.
Set it up
What you configure once, before turning it on.
- 1Connect Google DriveDocs, sheets, slides, files.
- 2Connect PostgresAny Postgres URL — query, write, migrate.
- 3Connect NotionPages, databases, comments.
- 4Connect OpenAIModels, embeddings, files.
- 5Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 6Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 7Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More Invoice Processing workflows
Dollar-Threshold Match Variance Escalation Chain
Routes three-way match variances up an approval ladder by dollar size — small ones to the line manager, large ones to the controller.
Front vendor invoice to Airtable approval packet with line-item parse
Watches a Front inbox for vendor invoice emails, extracts header and line-item data from the body and PDF attachment, and writes a structured.
Gate invoice approvals on a duplicate cross-check
When an approver clicks Approve in your AP system, a webhook re-validates the invoice against paid history in Postgres and Stripe charges.
Three-Way Match Exception Router by Variance Type
When a new invoice fails three-way match against its PO and receiving record, this workflow classifies the mismatch (price, quantity, or missing receipt) and routes each variance…
Route parsed Front invoices to the right Slack approver by amount
Parses an incoming Front vendor invoice and posts an interactive Slack approval card to the approver whose spending threshold matches the invoice total.
Three-way match Front invoices against purchase orders in Postgres
Parses a Front vendor invoice and runs a three-way match against the matching purchase order and receipt records in Postgres, posting pass or exception results to Slack.
Run it inside a business
This workflow drops into a full company template. Import the org, and this is one of the playbooks its agents run.
Run this workflow in your colony.
14-day trial. No DevOps. No Sales call. Provisioned in under a minute.