Batch Retrieve Malaysia TIN for SSM/NRIC from Google Sheets

This n8n workflow enables efficient batch retrieval of Malaysia's Tax ID Numbers (TIN) for business entities using their SSM (Business Registration Numbers) or NRIC (MyKad). It overcomes the LHDN API's single-search restriction by reading a list from Google Sheets, processing each entry via API calls, and outputting the TINs—ideal for bulk data preparation.

Key benefits include significant time savings for accountants and businesses handling large lists, reducing manual API queries from hours to minutes. It's particularly valuable for e-invoicing compliance, populating internal databases with TINs required for Malaysia's MyInvois system.

Use cases: Preparing customer/supplier databases for mandatory e-invoicing starting 2024/2025; auditing tax compliance for multiple entities; integrating with ERPs/CRMs. Prerequisites: LHDN OAuth credentials (client ID/secret from myhasil.gov.my), Google Sheets credential in n8n, and a sheet with SSM/NRIC column.