How to set up excel-google sheets synchronization using gspread library?

Question

Data synchronization

hello. for a long time I wanted to try to work in parallel in excel and google tables in this way - in the excel table there is an area (a sheet or a named range or a smart table or a separate file in general), the data from which, when updating or executing a macro, is uploaded to a google table. the search returns a couple offers with a monthly fee and a few indistinct videos on YouTube. planetaexcel was told to look away https://scand.com/products/gspread/.with power query worked, with google cloud too. api key is and was perfectly used when converting longitude and latitude to an address in an excel spreadsheet. the user manual was stumbling. maybe someone worked with this library and was able to customize it to solve my or a similar question? maybe there are paid options for creating a manual for dummies? I really want to figure it out, but after the last page of the documentation I'm stuck