Send data
Tags: #googlesheets #gsheet #data #naas_drivers #operations #snippet
Description: This notebook allows users to send data from Google Sheets to other applications.
from naas_drivers import gsheet
import pandas as pd
- 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"
data = [
{"name": "Jean", "email": "[email protected]"},
{"name": "Bunny", "email": "[email protected]"},
]
df = pd.DataFrame(data)
result = gsheet.connect(SPREADSHEET_URL).send(
sheet_name=SHEET_NAME, data=df, append=False
)
result
Last modified 1mo ago