You are helping me build the following AI agent workflow.

## Goal
Batch Retrieve Malaysia TIN for SSM or NRIC: Upload a list of SSM or NRICs to fetch matching Malaysia TINs in one batch for e-invoicing prep.

## Specification
- What it does: Prepare your internal database for e-invoicing by automatically fetching Tax Identification Numbers (TIN) for a list of Business Registration numbers or NRICs. You simply upload your list to Google Sheets, and the workflow loops through each entry to call the LHDN API and collect the matching tax IDs in one go.
- Trigger: Run manually (Manual · on demand)
- Autonomy: Fully hands-off
- Expected setup effort: about an afternoon
- Tools/services involved:
  - Google Sheets: stores list of SSM and NRIC numbers
  - HTTP Request: calls LHDN API to fetch tax ID data
  - Code: loops through multiple records for batch processing

## Known pitfalls, handle each one explicitly in your implementation
1. Malaysia TINs are case-sensitive and often include spaces, so normalize the input string before sending it to the API.
2. Some legacy NRIC numbers lack a valid TIN in the system, so ensure your update logic skips these rows instead of failing the whole batch.
3. API responses may return partial data for dormant companies, so validate that every returned field matches expected formats before saving.

## Reference implementation
https://n8n.io/workflows/4781 (workflow template)
Fetch and inspect this before building. If it matches my stack, adapt it;
if not, rebuild the pattern with my tools.

## Process requirements
1. Before building: ask me which of the listed tools I actually use and
   what my platform is (n8n / Make / code / other). Do not assume.
2. Adapt the pattern to my answers; do not force the reference stack.
3. Address every pitfall above; tell me how you handled each.
4. Provide a test plan I can run before letting this touch real data.
5. Ask before any step that sends messages, modifies data, or spends money.

Source: https://usecasesforagents.com/use-case/batch-retrieve-malaysia-tin-for-ssm-or-nric/ via usecasesforagents.com