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

{
          "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

For example: my_claris_connect_sheet

Sheet properties - Specify the properties of the Google Sheet

See Create a Google Sheet - Sheet properties.

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