👥 Verify Australian supplier ABNs with ABR, Google Sheets and Gmail
⚡ 13 views · 👥 HR & Recruitment
Description
Quick Overview
This workflow collects supplier onboarding details via an n8n Form, verifies the provided ABN against the Australian Business Register (ABR) API, and for active ABNs saves the supplier to Google Sheets and notifies your team via Gmail while showing the supplier a success or rejection page.
How it works
- Receives a supplier submission from an n8n Form with business and contact details, including an ABN.
- Cleans and normalizes the submitted fields (for example, removing spaces/dashes from the ABN).
- Calls the Australian Business Register (ABR) “AbnDetails” endpoint to look up the ABN using your ABR GUID.
- Parses the ABR callback response to extract key fields such as ABN status, entity name, entity type, GST date, and address details.
- Checks whether the ABR status is “Active” and routes inactive or unverified ABNs to a rejection completion page.
- Appends verified supplier details and ABR response fields to a Google Sheets supplier register for active ABNs.
- Sends a Gmail notification with the verified supplier details to your team and then displays a success completion page to the supplier.
Setup
- Create an ABR GUID and replace the masked GUID value in the ABR lookup request parameters.
- Connect a Google Sheets OAuth2 credential and update the target spreadsheet/document and sheet tab used for the supplier register.
- Connect a Gmail OAuth2 credential and set the recipient email address for the team notification message.
- Review and publish the n8n Form fields and use the provided form URL wherever you collect supplier onboarding submissions.
🔗 Nodes Used
Google Sheets, HTTP Request, Gmail, n8n Form Trigger, n8n Form
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File