{"product_id":"n8n-amazon-invoice-ocr-airtop-openai-google-sheets","title":"n8n Amazon Invoice OCR: Airtop + OpenAI + Google Sheets","description":"\u003ch3\u003eTurn Amazon invoices into structured data—automatically every night\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n Amazon Invoice OCR\u003c\/strong\u003e workflow reads today’s Amazon invoice links from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, opens each invoice in an \u003cstrong\u003eAirtop cloud browser\u003c\/strong\u003e, captures a screenshot, and uses \u003cstrong\u003eOpenAI OCR\u003c\/strong\u003e to extract invoice fields—then appends the results to a month-named tab in Google Sheets.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns nightly on a schedule\u003c\/strong\u003e to keep your invoice data continuously up to date.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads invoice-link rows from Google Sheets\u003c\/strong\u003e and filters to only the rows whose \u003cstrong\u003eDate\u003c\/strong\u003e matches \u003cstrong\u003etoday\u003c\/strong\u003e (formatted like \u003cstrong\u003eDD Mon YYYY\u003c\/strong\u003e, en-GB).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProcesses invoices one at a time\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eOpens each \u003cstrong\u003eInvoice URL\u003c\/strong\u003e in an \u003cstrong\u003eAirtop cloud browser\u003c\/strong\u003e session.\u003c\/li\u003e\n      \u003cli\u003eZooms the page and takes a \u003cstrong\u003escreenshot\u003c\/strong\u003e of the invoice.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStores and links the screenshot\u003c\/strong\u003e in the current month’s \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e folder:\n    \u003cul\u003e\n      \u003cli\u003eUploads the screenshot, downloads it back, and generates \u003cstrong\u003eshareable file and folder links\u003c\/strong\u003e.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts invoice fields with OpenAI\u003c\/strong\u003e, converting the OCR output into \u003cstrong\u003estrict structured JSON\u003c\/strong\u003e using an \u003cstrong\u003eauto-fixing parser\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends results to Google Sheets\u003c\/strong\u003e in a tab named for the current month, including extracted fields and Drive links, then closes the Airtop browser session.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS and ops teams\u003c\/strong\u003e that need daily invoice capture from Amazon without manual copy\/paste.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAccounts payable workflows\u003c\/strong\u003e where screenshots + structured fields must be stored and auditable in Google Drive.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomation engineers\u003c\/strong\u003e building an end-to-end n8n pipeline for \u003cstrong\u003eAmazon invoice OCR\u003c\/strong\u003e into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003en8n nodes\/components referenced: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003ewait\u003c\/strong\u003e, \u003cstrong\u003emerge\u003c\/strong\u003e, \u003cstrong\u003eairtop\u003c\/strong\u003e, \u003cstrong\u003efilter\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: Airtop, \u003cstrong\u003eOpenAI\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eSetup requirements: Airtop profile already logged into Amazon; Google Sheets columns named \u003cstrong\u003eInvoice URL \u003c\/strong\u003e (note trailing space) and \u003cstrong\u003eDate\u003c\/strong\u003e; configure Google Drive shared drive\/drive ID for monthly folders.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45891843096755,"sku":"N8N-18623","price":50.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/4AhShpV1wEjf8_qy0xKe__GLTM6OjK.png?v=1787562341","url":"https:\/\/buyflowscripts.com\/products\/n8n-amazon-invoice-ocr-airtop-openai-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}