Skip to content

Update expense records with receipt totals and upload receipts

Automatically detect new expense rows with receipt attachments across Zapier Tables and Google Drive. Extract totals with AI and update expense records with shareable receipt linksβ€”so you can speed up reimbursement processing without manual entry.

How this automation updates expense totals and protects receipt links

When new expense rows arrive with receipt attachments, delays can slow reimbursement approvals. This automation iterates attachments and uploads receipts, extracts paid totals with AI, and updates each Zapier Tables expense recordβ€”so your team can reconcile faster.

  1. 1.Detect new expense record

    Integrate Zapier Tables and attachment sources to detect new expense records and route receipt files to the next step.

    Zapier Tablesor swap with your favorite app
  2. 2.Iterates receipt attachments

    Integrate Looping by Zapier and attachment mapping to iterate each receipt file and process up to the first 10.

    Looping by Zapieror swap with your favorite app
  3. 3.Upload receipt file

    Integrate Google Drive and file storage permissions to upload the receipt file and return a file ID and shareable link.

    Google Driveor swap with your favorite app
  4. 4.Extract paid total from file

    Integrate AI by Zapier and OCR text extraction to parse the uploaded receipt and extract the paid total.

    AI by Zapieror swap with your favorite app
  5. 5.Aggregates totals across files

    Integrate Looping by Zapier and aggregation logic to sum extracted amounts and combine receipt links for multi-file expenses.

    Looping by Zapieror swap with your favorite app
  6. 6.Update expense record totals

    Integrate Zapier Tables and record updates to write the total, add receipt links, and store the attachments processed count.

    Zapier Tablesor swap with your favorite app

Automate your work, your way

Build custom automations across your tools in minutes. Describe what you need, connect your apps, and create workflows without the manual effort.

Trusted by 3.4 million companies

Calendly
Okta
Zendesk
Dropbox
Asana
Allstate
Airbnb
ActiveCampaign
Lyft
Webflow
Canva
Sysco
LA Clippers
Getaround
Grammarly
HelloFresh
Lululemon
Barry's
Hopper
Casper
Hudl
Miro
The New York Times
Ruggable
Calendly
Okta
Zendesk
Dropbox
Asana
Allstate
Airbnb
ActiveCampaign
Lyft
Webflow
Canva
Sysco
LA Clippers
Getaround
Grammarly
HelloFresh
Lululemon
Barry's
Hopper
Casper
Hudl
Miro
The New York Times
Ruggable

Related automations

  • Apps: Knack, Filter by Zapier, Code by Zapier
    Swap with your favorite apps.

    Add collaborator entries to new reimbursement request records

    Your reimbursement requests often lack collaborator references, so approvers chase context and payments stall. Finance can approve faster, typically before the next payment run.

  • Apps: Zapier Forms, Filter by Zapier, Code by Zapier, Salesforce
    Swap with your favorite apps.

    Add driver expense entries from form submissions to ledger

    Driver expense forms arrive unstandardized, causing manual entry and reimbursement delays. They become structured expense records for billing staff to review and pay before the next pay run.

  • Apps: Wufoo, Google Sheets, Formatter by Zapier, Gmail
    Swap with your favorite apps.

    Add expense claims to approval tracker for faster review

    Your reimbursement submissions sit in the form, requiring manual entry and losing receipt context for approvers. The sheet captures each request so finance can verify and approve same day.

  • Apps: Google Forms, Formatter by Zapier, Code by Zapier, Google Drive, Google Sheets, Notion
    Swap with your favorite apps.

    Add expense form entries to refunds tracker for finance

    Expense form submissions and receipts often go untracked, delaying reimbursements. They get logged into your tracker so finance can review and approve before the next payout run.

  • Apps: Typeform, Filter by Zapier, Google Sheets
    Swap with your favorite apps.

    Add form reimbursement responses to the processing sheet

    Your teacher reimbursement form responses arrive untracked, delaying receipt verification and payroll prep. They are added to your processing sheet for timely review and same-day payment batching.

  • Apps: Zapier Forms, Code by Zapier, Microsoft Excel
    Swap with your favorite apps.

    Add new referral payment entries to payroll sheet

    Your referral and reimbursement form responses go unrecorded, causing missed payments and extra reconciliation. They go into a payroll-ready sheet so ops can act same day.

  • Apps: Fillout Forms, Google Sheets
    Swap with your favorite apps.

    Add private mileage submissions to company tracking sheet

    Your private mileage submissions go unrecorded, delaying reimbursements and obscuring route costs. Finance can process payouts when each submission is logged to the mileage sheet, ahead of payroll.

  • Apps: Jotform, Filter by Zapier, Google Sheets
    Swap with your favorite apps.

    Add reimbursable receipts and meals to budget sheet

    Reimbursement form receipts and meal claims often go unlogged, creating missing expense lines and delayed approvals. It records approved submissions to the budget sheet so finance can reconcile same day.

  • Apps: Webhooks by Zapier, Filter by Zapier, Formatter by Zapier, Paths by Zapier, TrackVia
    Swap with your favorite apps.

    Add reimbursement entries from nurse requests to records

    Your nurse reimbursement webhooks include multi-line expense submissions that cause manual copying and processing delays. You receive structured records for review and same-day payout.

  • Apps: Jotform, Filter by Zapier, Google Sheets
    Swap with your favorite apps.

    Add reimbursement form entries to project expense sheet

    Your reimbursement form responses often go unrecorded, causing delayed payouts and inaccurate job costing. The flow logs each receipt to your expense sheet so accounting can reconcile same day.

  • Apps: QuickBooks Online, Filter by Zapier, Code by Zapier, Google Sheets
    Swap with your favorite apps.

    Add reimbursement rows from expense entries

    Your reimbursement expenses in accounting lack clear labels and links, slowing approvals and payroll prep. Consolidated sheet rows give finance coordinators auditable records before the next payroll.

  • Apps: Zapier Tables, Formatter by Zapier
    Swap with your favorite apps.

    Add submission date to reimbursement request rows today

    Reimbursement rows often miss a submission date, slowing finance during batch runs. Get rows tagged with a submission date so payroll can complete processing same day.

  • Explore all reimbursement processing automations

    Accelerate reimbursements with automated request intake, approval routing, and payout tracking

    View all

Set up in minutes

Zapier connects your tools, triggers actions from real-time data, and streamlines workflows so your team can focus on what matters most.

  1. Step 1

    Connect your tools

    Bring your apps together so information can move automatically between the tools your team already uses.

  2. Step 2

    Define the trigger

    Choose the events that should start your workflow, like a new submission, updated record, completed task, or customer action.

  3. Step 3

    Automate and measure

    Let your workflow handle follow-ups, updates, notifications, and reporting so your team can track progress and act faster.

See how teams are automating with Zapier (and loving it!)

Smart Charge America

Without Zapier, we would have needed well over 100 employees today just to do what we're doing. We would have been out of business by now.

David Laderberg, VP of Sales

Remote

Without having automation, we would have to at least be double our size. Doubling is a bit of a euphemism β€” I think we would have died or fallen back into oblivion.

Marcelo Lebre, Co-Founder

SweepBright

Zapier helps us close far above 50% more deals than we would without it. It is a key element of our overall strategy and, therefore, of our sales pitch.

Raphael Bochner, Founder and CIO

Digioh

Zapier gives us unlimited flexibility and creativity. With Zapier, you're like an artist with a blank canvas. I don't know what we'd do without it.

Rishi Shah, CEO and Co-Founder

Otter.ai

We don't just want to patch holes; we want to build scalable, future-proof systems. Zapier is helping us do that.

Allen Lai, Head of Customer Experience

Superhuman

We've been able to scale our operations while staying lean. Zapier lets us do more without needing more people.

Jacob Sirrs, Marketing Operations Specialist

Ready to automate your workflow securely?

Streamline processes, uncover new opportunities, and respond faster to change. Empower your team to get more done, without the manual work.