[ 1 Connect Google Sheets with Devo SOAR ] [ 2 Actions for Google Sheets ] [ 2.1 Read Sheet ] [ 2.1.1 Input Field ] [ 2.1.2 Output ] [ 2.2 Read Sheet (Dynamic URL) ] [ 2.2.1 Input Field ] [ 2.2.2 Output ] [ 2.3 Copy Sheet ] [ 2.3.1 Input Field ] [ 2.3.2 Output ] [ 3 Release Notes ]

Google Sheets is a spreadsheet program included as part of the free, web-based Google Docs Editors suite offered by Google.

Connect Google Sheets with Devo SOAR

Navigate to Automations > Integrations.
Search for Google Sheets.
Click Details, then the + icon. Enter the required information in the following fields.
Label: Enter a connection name.
Reference Values: Define variables here to templatize integration connections and actions. For example, you can use https://www.{{hostname}}.com where, hostname is a variable defined in this input. For more information on how to add data, see 'Add Data' Input Type for Integrations.
Verify SSL: Select option to verify connecting server's SSL certificate (Default is Verify SSL Certificate).
Remote Agent: Run this integration using the Devo SOAR Remote Agent.
Keys File: JSON File containing service account keys and other details. Details about config file.

The sheet must be shared with a service account and follow here to create a service account.

Actions for Google Sheets

Read Sheet

Reads data from Google Sheets.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input Name	Description	Required

Input Name	Description	Required
Google Sheets URL	Enter the value for sheet url. Example: https\:\//docs.google.com/spreadsheets/d/1nrsLE/edit#gid=0	Required

Output

A JSON object containing multiple rows of results:

has_error: True/False
error: message/null
result: Sheet Value

``` {json}{ "error": null, "has_error": false, "result": [ "column1", "column2" ] }


## Write Sheet

Writes table data into Google Sheets.

### Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

| Input Name                    | Description                                                                                            | Required |
| :---------------------------- | :----------------------------------------------------------------------------------------------------- | :------- |
| Google Sheets URL             | Enter the value for the sheet URL. Example: https\:\//docs.google.com/spreadsheets/d/1nrsLE/edit#gid=0 | Required |
| Overwrite the existing sheet. | Overwrite the existing sheet and then write the input rows. (Default is No)                            | Optional |

### Output

A JSON object containing multiple rows of results:

- has_error: True/False
- error: message/null
- result: Success/Failure message


``` {json}{
  "result": "Sheet updated",
  "error": null,
  "has_error": false
}

Read Sheet (Dynamic URL)

Reads data from Google Sheets.

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input Name	Description	Required

Input Name	Description	Required
Google Sheets URL	Jinja-templated containing the value of sheet url.
Example: https://docs.google.com/spreadsheets/d/{{spreadsheetId}}/edit#gid={{gid}}	Required

Output

A JSON object containing multiple rows of results:

has_error: True/False
error: message/null
result: Sheet Value

``` {json}{ "error": null, "has_error": false, "result": [ "column1", "column2" ] }


## Write Sheet (Dynamic URL)

Writes table data into Google Sheets.

### Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

| Input Name | Description | Required |
| : --------  | : --------  | : --------  |
| Google Sheets URL | [Jinja-templated](doc:jinja-template) containing the value of sheet url.  
Example: &lt;https://docs.google.com/spreadsheets/d/{{spreadsheetId}}/edit#gid={{gid}}&gt; | Required |


### Output

A JSON object containing multiple rows of results:

- has_error: True/False
- error: message/null
- result: Success/Failure message


``` {json}{
  "result": "Sheet updated",
  "error": null,
  "has_error": false
}

Copy Sheet

Copy sheet from one Spreadsheet to another

Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

Input Name	Description	Required

Input Name	Description	Required
Google Sheets Source URL	Jinja-Templated text containing the value of source sheet url. Example: https\:\//docs.google.com/spreadsheets/d/{{spreadsheetId}}/edit#gid={{gid}}.	Required
Google Sheets Destination URL	Jinja-Templated text containing the value of destination sheet url. Example: https\:\//docs.google.com/spreadsheets/d/{{spreadsheetId}}/edit#gid={{gid}}.	Required

Output

A JSON object containing multiple rows of results:

``` {json}{ "result":"Sheet copied", "Copied Sheet":{ "sheetId":557468380, "title":"Copy of Sheet1 1", "index":2, "sheetType":"GRID", "gridProperties":{ "rowCount":1000, "columnCount":26 } }, "error":null, "has_error":false }


## Create Sheet

Create Blank Spreadsheet

### Input Field

Choose a connection that you have previously created and then fill in the necessary information in the following input fields to complete the connection.

| Input name          | Description                                                                                      | Required |
| :------------------ | :----------------------------------------------------------------------------------------------- | :------- |
| Google Sheets Title | [Jinja-Templated](doc:jinja-template) text containing the value of sheet title. Example: Invoice | Required |

### Output

A JSON object containing multiple rows of results:


``` {json}{
    "result": "",
    "error": null,
    "has_error": false
}

Additional Information
The created sheet will be accessible only to the user(service account) who has created the sheet.

Release Notes

v2.0.9 - Added Overwrite sheet option in write sheet action and added more stats regarding copy sheet action.
v2.0.0 - Updated architecture to support IO via filesystem