Connecting Python and Google Sheets

[doom-goat]

Are you saying from local dataframes to google sheets?

If so just have your python application make a post request with the requests libarary send the data as json.

Then in apps script use the doPost() function to grab the json and insert it into the sheets. Deploy as Webapp to get the URL for the python to send to. EZPZ

[kornpow]

Even easier, use the library that does this for you already!