Send pandas dataframe to Google Sheets

main.py

import pandas as pd
from sheets import send_to_sheets

df = pd.DataFrame.from_dict(data, orient='index')
send_to_sheets(df, 'Optional Sheet Name')

sheets.py

import pygsheets

def send_to_sheets(data, name='Sheets API'):
  gc = pygsheets.authorize(service_file='../credentials/sheet-credentials.json')

  sh = gc.create(name)
  wks = sh.sheet1

  wks.set_dataframe(data, 'A1', copy_index=True)

  sh.share('youremail@gmail.com', role='writer', type='user', sendNotificationEmail=False)

Create a Google project, enable the Sheets and Drive APIs, create service account credentials.

Docs created in a service account can't be accessed through the web UI so we share the doc after creating with a regular Google account.