Hi, is not easy, I have done it in C#, C# reading google sheet and updating the excel file.
But you have to create a Google App, then get the Token, and thats just to read the Google Sheet.
Don't know if it can be done straight from excel with VBA (I have done in VBA a lot of stuff, reading/Write SQL Server, Reading/Writing Access, Reading directly from CSV file etc), but google sheet depends on Google API Libraries, that are available as Nuget Packages for C# in Visual Studio as to other languages, but VBA is very old, on VBA you can't consume nuget packages
What I offer is a single form, with a button that you click it, and will synchronize you Google Sheet and Excel Sheet.
I can put a timer if you want to automate that
Thanks
Felice