Workflow overview
Why this workflow matters
Relevant for managed services and support workflows. Supports knowledge capture and document intelligence use cases.
Quick Overview This workflow collects supplier onboarding details via an AlekSystem 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 AlekSystem 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 AlekSystem Form fields and use the provided form URL wherever you collect supplier onboarding submissions.
Best fit
Categories
Services
Use cases
Need another direction?