Google Sheets

Read and write data to Google Sheets.

Authentication

This connector uses OAuth 2.0 authentication.

info

Set up your connection in the Abstra Console before using it in your workflows.

How to use

Using the Smart Chat

Execute the action "CHOOSE_ONE_ACTION_BELOW" from my connector "YOUR_CONNECTOR_NAME" using the params "PARAMS_HERE".

Using the Web Editor

from abstra.connectors import run_connection_action

result = run_connection_action(
  connection_name="your_connection_name",
  action_name="your_action_name",
  params={
    "param1": "value1",
    "param2": "value2"
  })

Available Actions

This connector provides 17 actions:

Action	Parameters
spreadsheets_create	spreadsheetId (string) properties (undefined) sheets (array) namedRanges (array) spreadsheetUrl (string) developerMetadata (array) dataSources (array) dataSourceSchedules (array)
spreadsheets_get	No parameters
spreadsheets_get_by_data_filter	dataFilters (array) includeGridData (boolean) excludeTablesInBandedRanges (boolean)
spreadsheets_batch_update	requests (array) includeSpreadsheetInResponse (boolean) responseRanges (array) responseIncludeGridData (boolean)
values_get	No parameters
values_update	range (string) majorDimension (string) values (array)
values_append	range (string) majorDimension (string) values (array)
values_clear
values_batch_get	No parameters
values_batch_update	valueInputOption (string) data (array) includeValuesInResponse (boolean) responseValueRenderOption (string) responseDateTimeRenderOption (string)
values_batch_clear	ranges (array)
values_batch_get_by_data_filter	dataFilters (array) majorDimension (string) valueRenderOption (string) dateTimeRenderOption (string)
values_batch_update_by_data_filter	valueInputOption (string) data (array) includeValuesInResponse (boolean) responseValueRenderOption (string) responseDateTimeRenderOption (string)
values_batch_clear_by_data_filter	dataFilters (array)
developer_metadata_get	No parameters
developer_metadata_search	dataFilters (array)
sheets_copy_to	destinationSpreadsheetId (string)