Automate PDF invoice data extraction to Google Sheets
This template watches a Google Drive folder for new invoice files, downloads each file, reads text with OCR Space, and uses JavaScript to pull date, vendor, and total into a Google Sheets row. Connect Google Drive, OCR Space, and Google Sheets, then point the trigger at the folder you use for incoming invoices. Put the OCR Space API key on the OCR Space connection.