{"product_id":"automate-japanese-invoice-checks-with-gmail-and-sheets","title":"Automate Japanese Invoice Checks with Gmail and Sheets","description":"\u003ch3\u003eAutomate Japanese Invoice Checks with Gmail and Sheets\u003c\/h3\u003e\n\n\u003cp\u003eStreamline and safeguard your Japanese invoicing process using the \"Automate Japanese Invoice Checks with Gmail and Sheets\" workflow. This efficient n8n automation harnesses the power of Gmail, Google Gemini, and the NTA Invoice Web-API to ensure your invoice details are correctly processed and verified. Say goodbye to manual checks and hello to accuracy and efficiency.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMonitors your Gmail account every hour to scan for unread emails containing invoices with PDF attachments.\u003c\/li\u003e\n  \u003cli\u003eDownloads the first attachment and extracts the textual content from the invoice PDF using Google Gemini, structuring it into key fields such as the T-registration number, issuer name, invoice date, and amounts.\u003c\/li\u003e\n  \u003cli\u003eNormalizes the extracted T-registration number to verify its adherence to the “T + 13 digits” format.\u003c\/li\u003e\n  \u003cli\u003ePerforms a validation check against the National Tax Agency (NTA) Invoice Web-API to interpret the registration number's status as valid, invalid, or not found.\u003c\/li\u003e\n  \u003cli\u003eLogs detailed invoice information and verification results into a Google Sheets worksheet for easy access and tracking.\u003c\/li\u003e\n  \u003cli\u003eAlerts your team via Slack for immediate follow-up on invalid, missing, or inconclusive checks or marks the email as read upon successful verification.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eIdeal for automation engineers looking to eliminate manual invoice verification tasks in multinational companies dealing with Japanese vendors.\u003c\/li\u003e\n  \u003cli\u003ePerfect for SaaS operators who are required to maintain compliance with Japanese tax regulations through reliable invoice validation.\u003c\/li\u003e\n  \u003cli\u003eSuitable for n8n users aiming to integrate automatic invoice processing within existing workflows for enhanced operational efficiency.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eIntegrations: Gmail, Google Gemini (PaLM), Google Sheets, Slack, NTA Invoice Web-API\u003c\/li\u003e\n  \u003cli\u003eNodes used: if, code, gmail, slack, switch, sticky note\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45700727406771,"sku":"N8N-17229","price":41.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/o2O9iwdmONHHOqIRhuthH_ba8236af992148f1beed77f7723aff0e.jpg?v=1784451657","url":"https:\/\/buyflowscripts.com\/products\/automate-japanese-invoice-checks-with-gmail-and-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}