Best way to create an automated workflow for extracting invoice data from a PDF into Google Sheets

Hi everyone, I'm working on creating an automated workflow where I can upload an invoice PDF, extract the relevant data from it (such as product descriptions, prices, quantities, taxes, subtotals, and totals), and then transfer that data into Google Sheets. Ideally, I would like each item in the invoice to be placed on a separate line in the sheet.

I'm wondering what the best approach would be to achieve this. Specifically, I’m looking for a solution that can:

Automatically extract data from the invoice (using AI or OCR, if necessary)
Parse and structure the data into rows where each line represents a separate item from the invoice
Push this data into Google Sheets.

Any recommendations on tools, libraries, or workflows to make this process as smooth as possible would be greatly appreciated!

1 comment