Extract Amazon invoice data with Airtop, OpenAI, and Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 25 nodes and runs on a schedule (every day at 03:00). Along the way it connects Airtop, Google Sheets, Google Drive and OpenAI Chat Model.
How it runs
Trigger: On a schedule (every day at 03:00).
- Get invoice links from sheet (Google Sheets): uses Google Sheets
- Keep only today's rows (Filter): keeps only the items that match a condition
- Loop over invoices (Loop Over Items (Split in Batches)): loops over the items in batches
- Start browser session (Airtop): uses Airtop
- Open the invoice page (Airtop): work with window
- Wait: waits 10 seconds
- Zoom out to fit the page (Airtop): type (interaction)
- Wait: waits 10 seconds
- Screenshot the invoice (Airtop): take screenshot (window)
- Is it a PDF or an image? (If): checks a condition and branches into true / false
…plus 11 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (14)
- Airtop
n8n-nodes-base.airtop - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Wait
n8n-nodes-base.wait - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Merge
n8n-nodes-base.merge - Google Drive
n8n-nodes-base.googleDrive - AI Agent
@n8n/n8n-nodes-langchain.agent - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Auto-fixing Output Parser
@n8n/n8n-nodes-langchain.outputParserAutofixing - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Code
n8n-nodes-base.code - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Filter
n8n-nodes-base.filter
From the author
Quick overview This workflow runs nightly, reads today’s Amazon invoice URLs from Google Sheets, captures each invoice in an Airtop cloud browser, stores the screenshot in Google Drive, uses OpenAI to extract invoice fields from the image, and appends the…