Reference

updateGoogleSheet

Update a Google Spreadsheet with new data.
mindstudio.updateGoogleSheet({ text, spreadsheetId, range, operationType }) → Result

Update a Google Spreadsheet with new data.

Parameters
text
string
RequiredCSV data to write to the spreadsheet
connectionId
string
Google OAuth connection ID
spreadsheetId
string
RequiredGoogle Spreadsheet ID to update
range
string
RequiredTarget cell range in A1 notation (used with "range" operationType)
operationType
string
RequiredHow to apply the data: "addToBottom", "overwrite", or "range"
addToBottomoverwriterange
Call from a method
import { mindstudio } from '@mindstudio-ai/agent';

const result = await mindstudio.updateGoogleSheet({
  text: /* ... */,
  spreadsheetId: /* ... */,
  range: /* ... */,
  operationType: /* ... */
});