This template turns inbound invoice email into spreadsheet rows. Gmail starts the run when a message lands on the invoices label you choose.
Latenode downloads the attachment, OCR Space reads the text, and ChatGPT returns invoice number, supplier, and totals. Google Sheets appends the row, then Gmail labels the message as processed. Connect Gmail, OCR Space, and Google Sheets. 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 message lands on the Gmail label you use for invoices.
Gmail downloads the attachment. OCR Space returns the document text. Put the OCR Space API key on the OCR Space connection.
ChatGPT pulls invoice number, supplier, dates, and totals from the OCR text.
Google Sheets gets a new reconciliation row. Gmail adds a processed label so later runs can skip the same message.
Add a Gmail connection. Watch the label you use for invoices, or apply that label with a Gmail filter. Download the attachment on each run.
Add an OCR Space connection and paste your OCR Space API key there.
Add a Google Sheets connection. Use a sheet with columns for invoice number, supplier, date, total, and message id.
Send the OCR text to ChatGPT for invoice number, supplier, date, and total. Append a Google Sheets row, including the Gmail message id. Add a processed label on the email after a successful row.
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.
