n8n Amazon Invoice OCR: Airtop + OpenAI + Google Sheets

Turn Amazon invoices into structured data—automatically every night

This n8n Amazon Invoice OCR workflow reads today’s Amazon invoice links from Google Sheets, opens each invoice in an Airtop cloud browser, captures a screenshot, and uses OpenAI OCR to extract invoice fields—then appends the results to a month-named tab in Google Sheets.

What this workflow does

• Runs nightly on a schedule to keep your invoice data continuously up to date.
• Reads invoice-link rows from Google Sheets and filters to only the rows whose Date matches today (formatted like DD Mon YYYY, en-GB).
• Processes invoices one at a time:
  • Opens each Invoice URL in an Airtop cloud browser session.
  • Zooms the page and takes a screenshot of the invoice.
• Stores and links the screenshot in the current month’s Google Drive folder:
  • Uploads the screenshot, downloads it back, and generates shareable file and folder links.
• Extracts invoice fields with OpenAI, converting the OCR output into strict structured JSON using an auto-fixing parser.
• Appends results to Google Sheets in a tab named for the current month, including extracted fields and Drive links, then closes the Airtop browser session.

Use cases

• SaaS and ops teams that need daily invoice capture from Amazon without manual copy/paste.
• Accounts payable workflows where screenshots + structured fields must be stored and auditable in Google Drive.
• Automation engineers building an end-to-end n8n pipeline for Amazon invoice OCR into Google Sheets.

Technical details

• n8n nodes/components referenced: if, code, wait, merge, airtop, filter
• Integrations: Airtop, OpenAI, Google Sheets, Google Drive
• Setup requirements: Airtop profile already logged into Amazon; Google Sheets columns named Invoice URL (note trailing space) and Date; configure Google Drive shared drive/drive ID for monthly folders.