Email remains the most common way to receive third-party invoices, but it comes with several drawbacks, including manual data entry from PDFs, the hassle of downloading attachments, and inconsistent layouts that make automated parsing and data extraction difficult. In this article, we’ll explore how to overcome these challenges using AI-powered OCR to extract financial data from invoices received via email, and seamlessly transfer it to Google Sheets with Zapier.
Software Engineer
Before we begin, make sure you’ve created a Cradl AI account.
Once you’re logged into Cradl AI, create your first AI model with just a few clicks by cloning the invoice model.
Customise the model to suit your needs by adding or removing fields based on the data you want to extract from your invoices. Save your model, and that's all you need to do to create an AI model that understands your invoices.
Got tabular data or line items in your invoices that you also want to extract? No problem - just use the Line Items field. For more information on that, this article goes into detail about data extraction from tables.
There are several ways to import your invoices into Cradl AI for data extraction.
Connecting your mailbox to Cradl AI with a forwarding address is an easy and efficient way to automate your imports. Cradl AI auto-generates an email address you can forward your invoice emails to - any email attachment that arrives at this address will be automatically parsed.
Manually downloading your invoices and uploading them to Cradl AI in bulk is always an option for those who prefer a simple and manual approach. This works particularly well if you only process invoices occasionally.
Zapier can monitor your mailbox (i.e., with Gmail's New Email trigger) for trigger events—such as emails moved to a specific folder or titles containing certain keywords—and send them to the AI tool for processing. If you choose this approach, you want to add Cradl AI's Parse Document or Parse Document With Human-In-The-Loop actions.
In this example, we'll go with the Email forwarding approach.
Test the integration by sending an email with a document attached to the newly generated address. The document will be automatically processed, and you can view the extracted data inside the Validator in Cradl AI.
Now that your AI model is working, we'll connect it with a Google Sheet.
Head over to your Google Drive and create a blank spreadsheet. Add headers that correspond with the fields you want to extract from your documents. In Google Sheets you add headers by simply typing values into the topmost cells:
When you're mapping Cradl AI's extracted data fields to your spreadsheet's headers, you'll notice that you can choose from way more fields than the handful you defined in your spreadsheet's headers.
99% of the time you are looking for those values that are prefixed with Validated Predictions and suffixed with Value, such as Validate Predictions Purchase Date Value, Validate Predictions Total Amount Value, and so on.
Once your Zap is activated, the automation is ready to run:
Clicking Validate triggers the Zap, sending the data directly to your Google Sheet. Within seconds, your spreadsheet will update with the extracted values.
If you would like a version of this tutorial that does into more detail, this video has got you covered.
PDF.co provides a range of PDF-related functionality, including OCR for extracting invoice data from PDFs.
While PDF.co is largely template-based, its AI-powered invoice OCR is an exception, making it more flexible for invoices that do not follow a fixed format.
Dedicated error handling and data validation are crucial for 100% accuracy in processing large volumes of financial documents, as unchecked errors can cause critical inaccuracies. Since PDF.co lacks this feature, using it for high-volume financial data carries risk.
Best suited for businesses handling smaller invoice volumes where manual verification of extracted data is feasible. If accuracy is a primary concern, extracted data should be reviewed before being used in financial workflows.
Zapier offers a built-in Email Parser designed to extract structured data from email bodies and use it within automation workflows.
Email Parser by Zapier is free and easy to set up. Users can define simple parsing rules to extract key details from structured email content, making it a straightforward solution for specific use cases.
This tool does not support OCR, meaning it cannot extract text from PDF or image attachments. Additionally, it relies on structured email formats, requiring emails to follow a predictable pattern. If invoice details are presented inconsistently or sent as attachments, this method will not work.
This is a viable option for extracting structured plain-text invoices directly from email bodies. However, in practice, invoices are rarely sent as plain text, making this tool impractical for most real-world invoice processing needs.
We’ll help get you started with your document automation journey.
Schedule a free demo with our team today!
Internal document processing on autopilot.
