Get data
Tags: #googlesheets #gsheet #data #naas_drivers #operations #snippet #dataframe
Last update: 2023-04-12 (Created: 2022-03-04)
Description: This notebook demonstrates how to get data from a Google Sheets spreadsheet and return a DataFrame.
from naas_drivers import gsheet
Share your Google Sheets spreadsheet with our service account : 🔗 [email protected]
spreadsheet_url
: Google Sheets spreadsheet URLsheet_name
: Google Sheets sheet name
# Mandatory
spreadsheet_url = "https://docs.google.com/spreadsheets/d/1RdwdYXDFDSFSFxxxxxxxx/edit#gid=XXXXXXXX33"
sheet_name = "MY_SHEET"
df = gsheet.connect(spreadsheet_url).get(sheet_name=sheet_name)
df
print('Row fetched:', len(df))
Last modified 1mo ago