Links

Get data

Tags: #googlesheets #gsheet #data #naas_drivers #operations #snippet #dataframe
Author: Florent Ravenel
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.

Input

Import libraries

from naas_drivers import gsheet

Setup variables

Share your Google Sheets spreadsheet with our service account : 🔗 [email protected]
  • spreadsheet_url: Google Sheets spreadsheet URL
  • sheet_name: Google Sheets sheet name
# Mandatory
spreadsheet_url = "https://docs.google.com/spreadsheets/d/1RdwdYXDFDSFSFxxxxxxxx/edit#gid=XXXXXXXX33"
sheet_name = "MY_SHEET"

Model

Get data

df = gsheet.connect(spreadsheet_url).get(sheet_name=sheet_name)
df

Output

Display result

print('Row fetched:', len(df))