Links

Send data

Tags: #googlesheets #gsheet #data #naas_drivers #operations #snippet
Author: Florent Ravenel
Description: This notebook allows users to send data from Google Sheets to other applications.

Input

Import library

from naas_drivers import gsheet
import pandas as pd

Setup Google Sheets

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

Variables

data = [
{"name": "Jean", "email": "[email protected]"},
{"name": "Bunny", "email": "[email protected]"},
]
df = pd.DataFrame(data)

Model

Send dataframe to Google Sheets spreadsheet

result = gsheet.connect(SPREADSHEET_URL).send(
sheet_name=SHEET_NAME, data=df, append=False
)

Output

Display result

result