Links

Get data

Tags: #googlesheets #gsheet #data #naas_drivers #operations #snippet #dataframe
Author: Florent Ravenel
Description: This notebook provides a guide to using Google Sheets to access and analyze data.

Input

Import library

from naas_drivers import gsheet

Setup Google Sheets

SPREADSHEET_URL = (
"https://docs.google.com/spreadsheets/d/1RdwdYXDFDSFSFxxxxxxxx/edit#gid=XXXXXXXX33"
)
SHEET_NAME = "MY_SHEET"

Model

Get data from Google Sheets spreadsheet

df = gsheet.connect(SPREADSHEET_URL).get(sheet_name=SHEET_NAME)

Output

Display result

df