Learn how to use the Google Sheets integration with Julep
Configure Your Authentication
Basic Configuration
Tool Configuration
integration
in this context.google_sheets
for Google Sheets integration.read_values
: Read data from a rangewrite_values
: Write or update data in a rangeappend_values
: Append new rows to a sheetclear_values
: Clear data from a rangebatch_read
: Read from multiple ranges at oncebatch_write
: Write to multiple ranges at onceAuthentication Methods
Method Arguments
https://docs.google.com/spreadsheets/d/{SPREADSHEET_ID}/edit
use_julep_service
, share your spreadsheet with Julep’s service account email: julep-sheets-assistant@julep-471013.iam.gserviceaccount.com
base64 -i service-account.json