To automate invoice data extraction from email, you can use Lido. Set up the invoice fields you need, then forward your invoice emails to Lido's dedicated email address, and Lido extracts the data from each invoice into a spreadsheet automatically.
In this tutorial, we will walk you through setting up automatic invoice data extraction from email, using a sample invoice to test the setup first.
Lido is the easiest way to automate invoice data extraction from email because it gives you a dedicated email address and reads invoices from any vendor without templates.
If you don't have a Lido account yet, you can create one for free here.
Once you're logged in, create a New File.

Select the Extract Data button at the top of the sheet.

Before you connect your email, test your setup on one invoice. Save an invoice from your inbox as a PDF and upload it by dragging and dropping it into Lido, or click to browse.
Testing first means every emailed invoice later lands in the right columns without any changes.

For the purpose of this tutorial, we will be using a sample invoice. Enter the columns you want to extract: Vendor, Invoice Number, Invoice Date, Description, Quantity, Unit Price, Amount, and Balance Due.
You can also add extra instructions if you'd like (this is optional). We used: "Extract each line item as a separate row. Vendor is the company that issued the invoice, not the Bill To company. Description is the item name only. Format dates as MM/DD/YYYY and amounts as plain numbers. Balance Due is the amount still owed after any deposit."
Leave Extract Multiple Rows per Document checked for one row per line item, or uncheck it for one row per invoice. Then click Process All Files.

Review the extracted data against the invoice. Our sample returned all five line items with the right quantities, prices, and a Balance Due of 4801.
If a value is wrong, adjust the column name or the extra instructions and process the invoice again. Reprocessing is free within 24 hours.

Click Extract Data again and open the Email tab. Lido shows a dedicated email address. Click the copy icon next to it.
Any invoice email you forward to this address is extracted with the columns and instructions you just tested. Lido processes a forwarded email in about 20 seconds, and the data appears as new rows in your sheet.
If you use Outlook, you can click Connect to Outlook instead of forwarding emails.

Create a rule in your email app so invoice emails reach Lido without anyone forwarding them by hand:
Gmail: Go to Settings, then See all settings, then Filters and Blocked Addresses, and click Create a new filter. Filter by "Has attachment" and words like "invoice" in the subject, or by vendor email address. Choose Forward it to and select your Lido address. Gmail asks you to add and confirm a new forwarding address under Forwarding and POP/IMAP before it can forward automatically.
Outlook: Go to Settings, then Mail, then Rules, and click Add new rule. Set conditions such as "Has attachment" and "Subject includes invoice", choose Forward to, and enter your Lido address. Some Microsoft 365 companies block automatic forwarding to outside addresses, so ask your IT team to allow it, or use Connect to Outlook.
To test the rule, send yourself an email with an invoice attached and check that a new row appears in Lido.
Click Export to Excel at any time to download every extracted invoice as a spreadsheet file.
To get a file without logging in, turn on Export Results. Lido saves an Excel or CSV file of your data to Google Drive or OneDrive every day, so your AP team can open it in Excel or Google Sheets. The same CSV can also feed a QuickBooks invoice import if your books live there.

A few habits keep email-based invoice extraction accurate as your volume grows.
Use one AP inbox: Ask vendors to send invoices to a single address like ap@yourcompany.com, and forward only that inbox to Lido. This keeps personal emails and newsletters out of your invoice data.
Make your forwarding rule specific: A rule that forwards every email with an attachment will also send contracts and quotes. Combine "Has attachment" with invoice keywords or a list of vendor addresses.
Watch for duplicates: Vendors sometimes send the same invoice twice, or send a reminder with the invoice attached again. Sort your sheet by Invoice Number before you pay to catch repeats. Our guide on organizing accounts payable invoices covers more checks.
Check new vendors once: Lido reads any invoice layout, but a quick look at the first invoice from each new vendor confirms your instructions fit their format. Learn more about extracting line items from invoices with complex layouts.
There are other ways to get invoice data out of email, but each one has limits:
Downloading attachments by hand: Someone opens each email, saves the PDF, and types the data into a spreadsheet. This works for a few invoices a week but takes hours at higher volumes.
Template-based email parsers: These tools forward emails to a parser that uses a template for each layout. Every new vendor needs a new template, and templates break when a vendor changes its invoice. Our list of the best Outlook email parser tools compares several options.
Zapier or Power Automate: These automation tools can save attachments from email to a folder or spreadsheet, but they need a separate extraction tool to read the invoice data inside the PDF.
Lido combines the email inbox and the extraction in one place. Esprigas uses email forwarding rules to send documents to Lido, which processes 27,000 of their documents each month, including 20,000 invoices.
Now that you know how to automate invoice data extraction from email, you can let invoices flow into your spreadsheet instead of downloading them one by one. Accounting teams that also receive partnership tax forms by email can compare K-1 data extraction tools next.
Set up your invoice columns in Lido, copy the address from the Email tab, and create a Gmail or Outlook rule that forwards invoice emails to it. Lido extracts each invoice into your sheet automatically.
Yes. You can forward emails from Gmail or Outlook to your Lido address, and Outlook users can also click Connect to Outlook in the Email tab.
Lido processes a forwarded email in about 20 seconds, and the extracted data appears as new rows in your sheet.
Yes. Create a forwarding rule on the shared inbox, such as ap@yourcompany.com, so every invoice it receives goes to Lido.
Yes. Click Export to Excel at any time, or turn on Export Results to save a daily Excel or CSV file to Google Drive or OneDrive.