Get data

​​
​

Give Feedback | Bug report​
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))

Add new github member to team from spreadsheet

Send data to MongoDB

Last modified 1mo ago