Nightly Amazon Invoice Link Extractor with n8n, Airtop & OpenAI

Automatically extract Amazon invoice links every night and store them in Google Sheets

This n8n workflow runs nightly to open your Amazon order history in an Airtop cloud browser, scrape the page, and use OpenAI to extract order IDs and invoice links—then appends cleaned results to Google Sheets.

What this workflow does

• Schedules execution to run every night at 2:00 AM (Schedule Trigger).
• Launches Airtop using a saved profile that is already logged into Amazon, then opens the Amazon order history page for your region.
• Waits 15 seconds for the page to fully load, then uses Airtop scraping to capture the visible page text.
• Uses OpenAI extraction to convert scraped content into structured JSON containing order IDs and invoice URLs, including an auto-fix step to correct formatting issues.
• Filters and cleans results: removes items without an invoice link and strips Amazon tracking parameters from each invoice URL.
• Writes to Google Sheets: appends Order ID, Invoice URL, and the current Date, then terminates the Airtop browser session.

Use cases

• SaaS operators who need a reliable, daily feed of Amazon invoice links for bookkeeping.
• Automation engineers building an auditable workflow to collect order/invoice data without manual copying.
• Teams that want Google Sheets as a lightweight “invoice index” for later review or processing.

Technical details

• Nodes/steps: if, code, wait, Airtop, sticky note, Google Sheets.
• Airtop: cloud browser session via your saved profile (must be logged into Amazon).
• OpenAI: extracts order IDs and invoice URLs as structured JSON with an output auto-fix model step.
• Google Sheets: appends results to your specified spreadsheet ID and sheet name (columns: Order ID, Invoice URL, Date).

Setup checklist

• Add an Airtop API credential and confirm the correct Amazon order history URL for your region.
• Add an OpenAI API key for extraction and auto-fix.
• Connect Google Sheets and set the target spreadsheet and sheet name.
• Adjust the wait time if your page needs longer to render.