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.
Latenode bills workflow runtime in CPU seconds. The first 10,000 CPU seconds are free each month, then usage follows pay-as-you-go CPU-second pricing. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.
Full pricing — how CPU seconds work →Workflow preview
The scenario starts when a file appears or changes in the Google Drive folder you choose.
Latenode downloads the file so OCR Space can read it.
OCR Space returns the document text. Put the API key on the OCR Space connection.
JavaScript pulls those fields from the OCR text and shapes a Sheets row.
Google Sheets gets a new row with date, vendor, total, and the Drive file id so later runs can skip files you already logged.
Add a Google Drive connection with access to the invoice folder.
Add a Google Sheets connection. Use a sheet with columns for date, vendor, total, invoice number, and file id.
Add an OCR Space connection and paste your OCR Space API key there.
Watch the folder, download the file, read it with OCR Space, pull date, vendor, and total in JavaScript, then append a Google Sheets row. Look up the file id in the sheet first if you want to skip documents you already logged.
FAQ
More templates
This template watches a Google Drive folder for new invoice or receipt 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 documents. Put the OCR Space API key on the OCR Space connection.
This template creates a FreshBooks invoice when your billing source posts a payload. A webhook starts the run. JavaScript maps client email, line items, and due date. FreshBooks finds the client, creates one if needed, then creates the invoice. Connect FreshBooks and point the source at the Latenode webhook URL.
This template starts when Eventbrite records a new attendee, maps name, email, event title, and ticket amount in JavaScript, then finds or creates the QuickBooks customer and creates an invoice for the sale. Connect Eventbrite and QuickBooks. Point the trigger at the event whose registrations should land in QuickBooks.
