Import Google audit logs to Power BI

I am hoping that someone has had better luck importing Google audit logs in to Power BI. Google provides these instructions: Google Developers Guide

I assume that I need to use an API key and have generated one within Google Cloud but cannot get a connection after trying a straight web connection and Odata.

Hoping that the brain trust here has already figured this out and can share the Power Query to get this going.