Send data

​​
​

Template request | Bug report​
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
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"
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

Send data to MongoDB

Add new github member to team from spreadsheet

Last modified 1mo ago