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: 1. Automatically extract data from the invoice (using AI or OCR, if necessary) 2. Parse and structure the data into rows where each line represents a separate item from the invoice 3. 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!