Automate Japanese Invoice Checks with Gmail and Sheets

Automate Japanese Invoice Checks with Gmail and Sheets

Streamline 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.

What this workflow does

• Monitors your Gmail account every hour to scan for unread emails containing invoices with PDF attachments.
• Downloads 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.
• Normalizes the extracted T-registration number to verify its adherence to the “T + 13 digits” format.
• Performs 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.
• Logs detailed invoice information and verification results into a Google Sheets worksheet for easy access and tracking.
• Alerts your team via Slack for immediate follow-up on invalid, missing, or inconclusive checks or marks the email as read upon successful verification.

Use cases

• Ideal for automation engineers looking to eliminate manual invoice verification tasks in multinational companies dealing with Japanese vendors.
• Perfect for SaaS operators who are required to maintain compliance with Japanese tax regulations through reliable invoice validation.
• Suitable for n8n users aiming to integrate automatic invoice processing within existing workflows for enhanced operational efficiency.

Technical details

• Integrations: Gmail, Google Gemini (PaLM), Google Sheets, Slack, NTA Invoice Web-API
• Nodes used: if, code, gmail, slack, switch, sticky note