Google Sheets

Batch update spreadsheet - Batch updates a spreadsheet

Spreadsheet ID - Choose the Google Sheet ID. Make sure the sheet is not a deleted sheet.

Requests - A list of updates to apply to the spreadsheet. Requests will be applied in the order they are specified. If any request is not valid, no requests will be applied

Example:

{ "addSheet": { "properties": { "sheetId": 123456 } } }, { "updateCells": { "start": { "sheetId": 123456 }, "rows": [ { "values": [ { "userEnteredValue": { "stringValue": "hello" } } ] }, { "values": [ { "userEnteredValue": { "stringValue": "world" } } ] } ], "fields": "userEnteredValue" } }, { "addNamedRange": { "namedRange": { "name": "newRange", "range": { "sheetId": 123456, "endRowIndex": 2 } } } }

Response ranges - Limits the ranges included in the response spreadsheet. Meaningful only if 'Include spreadsheet in response' is set to 'True'.

Include grid data in response - Whether grid data should be returned. Meaningful only if 'Include spreadsheet in response' is set to 'True'. This parameter is ignored if a field mask was set in the request.

Include spreadsheet in response - Whether or not the response should include the spreadsheet resource

Update cell - Updates a single cell in a spreadsheet

Sheet ID - Choose the Google Sheet ID. Make sure the sheet is not a deleted sheet.

Worksheet name - Choose the name of the worksheet tab in the sheet

Cell location - Enter the location of the cell to update

Example: A1

Value - Enter the cell value

Create a Google Sheet - Creates a Google Sheet from Claris Connect

Sheet filename - Enter the filename for the Google Sheet

Example: my_claris_connect_sheet

Sheet properties - Specify the properties of the Google Sheet

Worksheet name - Enter a name for the worksheet tab. The name must not be empty. This field cannot be changed once set.

Example: My Worksheet

Add sheet - Enter the worksheet data

Add row - Enter the row data in the grid, one entry per row

Create spreadsheet row - Adds one row to a specified spreadsheet

Spreadsheet ID - Choose the Google Sheet ID. Make sure the sheet is not a deleted sheet.

Worksheet name - Choose the name of the worksheet tab in the sheet

Update spreadsheet row - Updates a spreadsheet row in a specified spreadsheet

Spreadsheet ID - Choose the Google Sheet ID. Make sure the sheet is not a deleted sheet.

Worksheet name - Choose the name of the worksheet tab in the sheet