Develofly Autopilot
Templates › Email & Inbox › Receipt / invoice extractor

Receipt / invoice extractor

Receipts and invoices in your inbox → amounts + files in a sheet.

Email & InboxDaily, or trigger: When a new email arrives

Download the app, freeOpen in Autopilot

Receipt / invoice extractor: what it does, step by step

What it does

Finds receipts and invoices in your inbox (by subject, sender or both), reads the amount, currency and invoice number from the email and its PDF attachments, and puts one row per email in a sheet with the files. Optionally copies the attachments to a folder. Emails handled in an earlier run are skipped. Amounts are found by pattern: check unusual layouts. (The “Invoice and attachment downloader” only saves the files.)

How it works

  1. Signs in to your email
  2. Reads your inbox
  3. Decides what to do next
  4. Goes through each item
  5. Reads the file
  6. Picks out the values
  7. Adds rows to your sheet
  8. Saves the files where you want them
All 20 steps (as they appear in the app)
  1. Email account {{email_address}} ({{email_provider}})
  2. Check {{folder}} (1 steps each)
  3. If email_message_id seen in past runs
  4. _docs =
  5. For each att in {{email_attachments}} (1 steps)
  6. If att matches \.pdf$
  7. Read text of {{att}} → _pdf
  8. _docs = {{_docs}} {{_pdf}}
  9. _all = {{email_subject}} {{email_body}} {{_docs}}
  10. Find…
  11. Find /([\d.,\s]+)$/ → _number
  12. Find /([$€£]|\bUSD\b|\bEUR\b|\bGBP\b|\bCAD\b|\bAUD\b)/ → _currency
  13. Find /(?:invoice|receipt|order)\s*(?:no\.?|number|num|#|id)\s*[:#]?\s*([A-Z0-9][A-Z0-9-]{2,})/ → _invoice_no
  14. _vendor = {{email_from_name}}
  15. If _vendor empty
  16. Find /@([^>\s]+)/ → _vendor
  17. Add row: date, vendor, from, subject, amount, currency, invoice_number, files
  18. If save_folder not empty
  19. If email_attachments not empty
  20. Save files to {{save_folder}}

Get this template

1. Download Develofly Autopilot: free, for Ubuntu and other Linux desktops.

Download Develofly Autopilot

2. The app comes with every template, so this one is already in your library. Click below to open it (or find it under Templates).

Open in Autopilot

What you need

  • An email account (Gmail, Outlook, Yahoo or any IMAP)

You fill in: Email provider, Your email address, App password, Subject contains, From contains (optional), Mail folder, Look back (days), Also copy attachments to this folder (optional).

Make it yours

Every step is editable in the app: change the site, the columns, the schedule, or chain it with other bots. Run it once, on a schedule, or sell it as your own bot.

More Email & Inbox templates

AI email triage and labellingAI sorts, scores and summarises your unread email.Auto-attachment saverSave inbound attachments to Google Drive (or a folder) by rule.Daily AI email digestA daily AI summary of your unread email.Inbox assistantAI drafts replies to your email; you approve each one.