Invoice Data Extractor
Read invoices from Drive, extract key data, and store in a database
Example Prompt
Find all invoices from this month in Google Drive, extract the key data, and save it to our database
About
Searches Google Drive for invoice documents, reads their contents, and uses structured reasoning to extract vendor names, amounts, dates, and line items. Inserts the extracted data into a PostgreSQL database for accounting and reporting workflows.
Workflow Steps
Search Google Drive for invoice files matching the target date range or folder
📂 Search DriveRead the content of each discovered invoice document
📄 Read Drive FileExtract structured fields such as vendor, amount, date, and line items from the text
🧠 Structured ReasoningInsert the extracted invoice data into the accounting database
📊 Run SQL QueryTools Used
Read Drive File
Read the contents of a file from Google Drive by file ID
Search Drive
Search Google Drive for files and folders by name, type, or content
Run SQL Query
Execute a read-only SQL query against a PostgreSQL database and return results
Structured Reasoning
Break down a complex problem into sequential reasoning steps with explicit chain-of-thought