{"product_id":"nightly-amazon-invoice-link-extractor-with-n8n-airtop-openai","title":"Nightly Amazon Invoice Link Extractor with n8n, Airtop \u0026 OpenAI","description":"\u003ch3\u003eAutomatically extract Amazon invoice links every night and store them in Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n workflow\u003c\/strong\u003e runs nightly to open your \u003cstrong\u003eAmazon order history\u003c\/strong\u003e in an \u003cstrong\u003eAirtop\u003c\/strong\u003e cloud browser, scrape the page, and use \u003cstrong\u003eOpenAI\u003c\/strong\u003e to extract \u003cstrong\u003eorder IDs\u003c\/strong\u003e and \u003cstrong\u003einvoice links\u003c\/strong\u003e—then appends cleaned results to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedules execution\u003c\/strong\u003e to run every night at \u003cstrong\u003e2:00 AM\u003c\/strong\u003e (Schedule Trigger).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLaunches Airtop\u003c\/strong\u003e using a saved profile that is already logged into Amazon, then opens the \u003cstrong\u003eAmazon order history\u003c\/strong\u003e page for your region.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWaits 15 seconds\u003c\/strong\u003e for the page to fully load, then uses Airtop scraping to capture the visible page text.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses OpenAI extraction\u003c\/strong\u003e to convert scraped content into structured \u003cstrong\u003eJSON\u003c\/strong\u003e containing \u003cstrong\u003eorder IDs\u003c\/strong\u003e and \u003cstrong\u003einvoice URLs\u003c\/strong\u003e, including an \u003cstrong\u003eauto-fix\u003c\/strong\u003e step to correct formatting issues.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters and cleans results\u003c\/strong\u003e: removes items without an invoice link and strips \u003cstrong\u003eAmazon tracking parameters\u003c\/strong\u003e from each invoice URL.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites to Google Sheets\u003c\/strong\u003e: appends \u003cstrong\u003eOrder ID\u003c\/strong\u003e, \u003cstrong\u003eInvoice URL\u003c\/strong\u003e, and the current \u003cstrong\u003eDate\u003c\/strong\u003e, then terminates the Airtop browser session.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators who need a reliable, daily feed of Amazon invoice links for bookkeeping.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building an auditable workflow to collect order\/invoice data without manual copying.\u003c\/li\u003e\n  \u003cli\u003eTeams that want Google Sheets as a lightweight “invoice index” for later review or processing.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes\/steps\u003c\/strong\u003e: if, code, wait, Airtop, sticky note, Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAirtop\u003c\/strong\u003e: cloud browser session via your saved profile (must be logged into Amazon).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI\u003c\/strong\u003e: extracts order IDs and invoice URLs as structured JSON with an output auto-fix model step.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: appends results to your specified spreadsheet ID and sheet name (columns: Order ID, Invoice URL, Date).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup checklist\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAdd an \u003cstrong\u003eAirtop API credential\u003c\/strong\u003e and confirm the correct \u003cstrong\u003eAmazon order history URL\u003c\/strong\u003e for your region.\u003c\/li\u003e\n  \u003cli\u003eAdd an \u003cstrong\u003eOpenAI API key\u003c\/strong\u003e for extraction and auto-fix.\u003c\/li\u003e\n  \u003cli\u003eConnect \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and set the target spreadsheet and sheet name.\u003c\/li\u003e\n  \u003cli\u003eAdjust the \u003cstrong\u003ewait time\u003c\/strong\u003e if your page needs longer to render.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45891847585971,"sku":"N8N-18618","price":41.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/txXz9NEcCQAq22y7Eg2E5_oQ7YH3Kz.png?v=1787562474","url":"https:\/\/buyflowscripts.com\/products\/nightly-amazon-invoice-link-extractor-with-n8n-airtop-openai","provider":"N8N Commerce","version":"1.0","type":"link"}