Excel PowerQuery and Google sheets expert

General information for the business: Consulting business Description of requirements/functionality: I'm having problems connecting from Excel Power Query to a Google spreadsheet that has been published to the web. Please see the attached image. The job can be done as an hourly or fixed rate, please tell me which option is preferred. Extra notes: I was able to connect to a Google spreadsheet from Excel Power Query thru the Get option from the web but not working this time.