Google-sheet-import

main.py

engine = create_engine('postgresql://username:password@host/dbname')
scope = ['https://spreadsheets.google.com/feeds']
creds = ServiceAccountCredentials.from_json_keyfile_name('credentials.json', scope)
client = gspread.authorize(creds)
workbook = client.open_by_url('google-sheet-url')

sheet = workbook.worksheet("Tab/sheet to import")
data = sheet.get_all_records(head=1, default_blank=None)
data = pd.DataFrame(data)
data.to_sql(name='table-name', con= engine, if_exists='replace')

requirements.txt

pandas==0.20.3
gspread
sqlalchemy==1.1.14
oauth2client
psycopg2