Automatically provision OneDrive for Business site for end user when adding O365 license

I’ve actually done this for one of my clients.  When the need to add a new users, they simply put the UPN/email address in a SharePoint list along with the two character location code.  Adding an item to the list, triggers some PowerShell running in Azure Automation to appropriate license the users in Office 365 as well as provision OneDrive for Business.

There are a few different ways you could trigger the PowerShell, but the end of the day, PowerShell is going to be at the heart of your solution for this.