Get data

​​
​

Template request | Bug report​
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
Share your Google Sheets spreadsheet with our service account : 🔗 [email protected]
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

Google Sheets

Send LinkedIn invitations from spreadsheet

Last modified 1mo ago