What it does
Watches a Google Drive folder for new PDF invoices, reads their content with OCR and uses OpenAI to extract fields such as invoice number, date, total, vendor, line items, tax and category. The data is validated against a JSON schema and stored in Google Sheets.
Use cases
- 01Turn PDF invoices dropped in Drive into spreadsheet rows
- 02Extract vendor, total and tax from scanned invoices
- 03Build a searchable invoice list for review and reporting
Connects
Google Sheets · Google Drive · AI Agent · OpenAI Chat Model · Structured Output Parser