Automate ABN Verification with n8n & Google Sheets

Automate ABN Verification with n8n & Google Sheets: Streamline Supplier Onboarding Effortlessly

Transform your supplier onboarding process with our n8n workflow that seamlessly integrates ABN verification and Google Sheets documentation. With real-time checks against the Australian Business Register (ABR), ensure compliance and keep your supplier records up-to-date without lifting a finger. Automate notifications, handle rejections systematically, and optimize your workflow like never before.

What this workflow does

• Gather Information: Start by collecting business and contact details, including the crucial ABN, through a user-friendly n8n Form.
• Normalize Data: Clean the data to ensure it’s correctly formatted—removing unnecessary spaces or dashes in the ABN entry.
• Verify ABN: Utilize the ABR "AbnDetails" endpoint with your ABR GUID to validate the supplied ABN.
• Analyze Response: Extract pertinent information from the ABR response, like ABN status, entity name, and address details.
• Decision Routing: Automatically direct verified ABNs to success and append data to Google Sheets, while unsuccessful ones are redirected to a rejection page.
• Notify Your Team: A Gmail notification, complete with all relevant supplier details, ensures your team stays informed in real-time.

Use cases

• Supplier Onboarding: Perfect for companies looking to automate and streamline the onboarding process by ensuring incoming suppliers have active and verified ABNs.
• Compliance Assurance: Essential for businesses requiring ABN validation to comply with regulations or business requirements effectively and efficiently.
• Data Management: For operation teams that need to maintain an updated and accurate supplier database without manual data entry effort.

Technical details

• Nodes Used: This workflow incorporates essential n8n nodes like if, set, form, gmail, sticky note, form trigger.
• Integrations: Connect seamlessly with Google Sheets for record-keeping and Gmail for team notifications, ensuring a fully automated pipeline.
• Setup Instructions: Requires configuring your ABR GUID, connecting Google Sheets and Gmail through OAuth2, and defining the specific spreadsheet and recipient email addresses.