Google Sheets
Actions for handling Google Sheets data
Last updated
Actions for handling Google Sheets data
Last updated
To use this actions you need to configure Google Cloude. See more:
Base Google Sheets action. Subclass of .
client (): Google client that will be used for access.
name (Optional[str], optional): Name for identification. If equals to None, class name will be used. Defaults to None.
input_data (Dict[str, Any]): Expected keys:
"title" (str): Name of the spreadsheet;
"sheets" (List[str], optional): Sheets names to create. Defaults to ["Sheet1"].
Exception: If unable to create spreadsheet.
Dict[str, Any]: Expected keys:
"spreadsheet_id" (str): Spreadsheet ID;
input_data (Dict[str, Any]): Expected keys:
"spreadsheet_id" (str): Spreadsheet ID (can be found in url: https://docs.google.com/spreadsheets/d/spreadsheet_id/edit#gid=0);
"cells_range" (str): Range of cells provided in A1 notation. Examples: "B2:C2", "A1", "Sheet1", "Sheet1!A1:B1", etc..
Exception: If unable to read spreadsheet.
Dict[str, Any]: Expected keys:
"table" (List[List[Any]]): Table that represents sheet or part of it specified by "cells_range";
input_data (Dict[str, Any]): Expected keys:
"spreadsheet_id" (str): Spreadsheet ID (can be found in url: https://docs.google.com/spreadsheets/d/spreadsheet_id/edit#gid=0);
"cells_ranges" (List[str]): Ranges of cells provided in A1 notation. Examples: "B2:C2", "A1", "Sheet1", "Sheet1!A1:B1", etc..
Exception: If unable to read spreadsheet.
List[Dict[str, Any]]: List of items containing tables. Items expected keys:
"table" (List[List[Any]]): Table that represents sheet or part of it specified by "cells_range";
input_data (Dict[str, Any]): Expected keys:
"spreadsheet_id" (str): Spreadsheet ID (can be found in url: https://docs.google.com/spreadsheets/d/spreadsheet_id/edit#gid=0);
"cells_range" (str): Range of cells provided in A1 notation. Examples: "B2:C2", "A1", "Sheet1", "Sheet1!A1:B1", etc..
"table" (List[List[Any]]): Values to add to spreadsheet.
Exception: If unable to update spreadsheet.
Dict[str, Any]: Expected keys:
"spreadsheet" (Dict[str, Any]): Updated spreadsheet;
input_data (Dict[str, Any]): Expected keys:
"spreadsheet_id" (str): Spreadsheet ID (can be found in url: https://docs.google.com/spreadsheets/d/spreadsheet_id/edit#gid=0);
"inputs" (List[Dict[str, Any]]): List of write actions. Each action contain:
"cells_range" (str): Range of cells provided in A1 notation. Examples: "B2:C2", "A1", "Sheet1", "Sheet1!A1:B1", etc..
"table" (List[List[Any]]): Values to add to spreadsheet.
Exception: If unable to update spreadsheet.
Dict[str, Any]: Expected keys:
"spreadsheet" (Dict[str, Any]): Updated spreadsheet;
input_data (Dict[str, Any]): Expected keys:
"spreadsheet_id" (str): Spreadsheet ID (can be found in url: https://docs.google.com/spreadsheets/d/spreadsheet_id/edit#gid=0);
"cells_range" (str): Range of cells provided in A1 notation. Examples: "B2:C2", "A1", "Sheet1", "Sheet1!A1:B1", etc..
"table" (List[List[Any]]): Values to add to spreadsheet.
Exception: If unable to update spreadsheet.
Dict[str, Any]: Expected keys:
"spreadsheet" (Dict[str, Any]): Updated spreadsheet;
scopes (List[str]): Access scopes. Defaults to ["https://www.googleapis.com/auth/spreadsheets"] (Read and write acess to all spreadsheets).
service (str): Service name. Defaults to "sheets" (Google Spreadsheets service).
version (str): API version. Defaults to "v4".
Specify major dimension(i.e. what outer list represents)
Specify how input data should be formatted
Inputs as is
All inputs treated as input from the user (enabling formatting and formulas)
How data should be append to table
Insert new rows
Overwrite anything after table
Create spreadsheet. Subclass of . Type of [Dict[str, Any], Dict[str, Any]].
Read spreadsheet. Subclass of . Type of [Dict[str, Any], Dict[str, Any]].
"dimension" (, optional): Reading dimension. May be . or .. Defaults to..
Read spreadsheet batch. Subclass of . Type of [Dict[str, Any], List[Dict[str, Any]]].
"dimension" (, optional): Reading dimension. May be . or .. Defaults to..
Write to spreadsheet. Subclass of . Type of [Dict[str, Any], Dict[str, Any]].
"value_input_option" (, optional): Input option can be: . - All inputs treated as input from the user (enabling formatting and formulas), or. - all inputs as is. Defaults to ..
"dimension" (, optional): Reading dimension. May be . or .. Defaults to..
Write to spreadsheet batch. Subclass of . Type of [Dict[str, Any], Dict[str, Any]].
"value_input_option" (, optional): Input option can be: . - All inputs treated as input from the user (enabling formatting and formulas), or. - all inputs as is. Defaults to ..
"dimension" (, optional): Reading dimension. May be . or .. Defaults to..
Write to spreadsheet. Subclass of . Type of [Dict[str, Any], Dict[str, Any]].
"value_input_option" (, optional): Input option can be: . - All inputs treated as input from the user (enabling formatting and formulas), or. - all inputs as is. Defaults to ..
"insert_data_option" (, optional): Isert data option can be . - will overwrite anything after table, or . - will insert new rows. Defaults to ..
"dimension" (, optional): Reading dimension. May be . or .. Defaults to..
Google Sheets default configuration. Subclass of .