Connect to Google Sheets no-code

​

Before you begin

• Connect Google services in Next Matter with a service account and share data with this account. Learn more…

• Check the required scopes to learn more about which data is shared between the apps.

​

Integrate with Sheets

1. Click Workflows > + Create new… > Create a new workflow and give your workflow a name. If you have a workflow ready, click … > Edit workflow.
2. Click + Add step and select Integrations > Google Sheets (Low Code).
3. Click the step and click Configure integration.

​

Add a single row (no JSON body required)

1. Select Add single row in the Google Sheets operation drop-down as is and select the spreadsheet you will be updating. Note that you need editor access to the spreadsheet to use it in the integration.
2. Select the spreadsheet and worksheet.
3. Enter the number of the row, where you have header values. This doesn’t need to be row 1.
4. Add the column number and the value you want to place in this column. A new row will be created under the existing rows.
   When any of the specified columns is missing in the worksheet when the step runs, the step will fail.
5. (Optional) Select and add your variables.
6. Save changes.

​

Add row

1. Select Add row in the Google Sheets operation drop-down as is and select the spreadsheet you will be updating. Note that you need editor access to the spreadsheet to use it in the integration.
   
2. Enter or select the worksheet name. This is the worksheet to which you want to add rows.
3. In the JSON body field, enter the rows, names of columns, and values in the JSON format.
4. When everything is correct, click Save changes.

​

Update rows

1. Select Update rows in the Google Sheets operation drop-down as is and select the spreadsheet you will be updating. Note that you need editor access to the spreadsheet to use it in the integration.
2. Enter or select the spreadsheet and worksheet. This is the worksheet to which you want to update rows.
3. In the Start with row field, enter the number of the row which should be the first one to update. We’ll update values in this row, and, if specified in Body, the following rows.
4. Enter Body. It might look like the following
   Copy

   Ask AI

   {
   "Row1": {"ColumnName1": "Value1", "ColumnName2": "Value2"},
   "Row2": {"ColumnName1": "Value3"}
   }
   

   Note that Row1 or Row2 is only used for sequencing rows and are not the actual row numbers. For example, if you’ve entered 13 in the Start with row field then your Row1 changes will apply to row 13 in the worksheet, and Row2 changes to row 14, etc.
5. Save your changes.

​

Create spreadsheet

1. Select Create spreadsheet in the Google Sheets operation drop-down and provide the spreadsheet with a meaningful name. Note that the name doesn’t have to be unique but, we still advise it so that the sheet can easily be recognized. Tip: to make the name unique, you can use the data reference in the Name field, or add it to the entered phrase. For example, the instance ID will always be a unique number.
2. Save your changes.

​

Delete spreadsheet

1. Select Delete spreadsheet in the Google Sheets operation drop-down and provide the ID of the spreadsheet to delete. Note that the deletion is permanent. Tip: you can use data references in the Spreadsheet ID field. This is less error-prone than typing.
2. Save your changes.

​

Create worksheet

1. Select Create worksheet in the Google Sheets operation drop-down and select the name of the spreadsheet to which you are adding a worksheet.
2. Provide a name for the worksheet.
3. Select data you might want to reuse as variables (see the Variables section below).
4. Save your changes.

​

Delete worksheet

1. Select Delete worksheet in the Google Sheets operation drop-down and select the name of the spreadsheet from which you are deleting a worksheet.
2. Provide a name for the worksheet. Make sure it’s correct or else the step will fail.
3. Select data you might want to reuse as variables (see the Variables section below).
4. Save your changes.

​

Match values (Vlookup)

1. Select Search and find values in the Google Sheets operation drop-down.
2. Select the spreadsheet and worksheet.
3. Decide which row is the header row. It doesn’t need to be row 1. We will offer the values from this row as column names you can select.
4. Enter the value you want to search for and the column where this value should be located (Search column).
5. In the match columns, select the columns where you want to find corresponding values. You can add multiple columns.
6. Select your Match preference. First match is the default.
7. Enable the toggle to differentiate between uppercase and lowercase letters during comparisons and offer only matches when the letter case is the same.
8. (Optional) Add variables. Tip: We return an array, in which the returned results follow the order of the input columns. To create variables from the results, use numbers, for example, $.'Search results'.values.[0] (for the first search result), $.'Search results'.values.[1] (for the second), and so on.
9. Save your changes.

​

JSON formatting

{
"Row1": {"ColumnName1": "Value1", "ColumnName2": "Value2"},
"Row2": {"ColumnName1": "Value3"}
}

• The names of the columns need to already exist in the sheet. If you try to add rows to an empty sheet, the step will complete but the sheet will remain empty.
• The value can be a direct value or a formula, for example: =SUM(A1:A3).
• If you leave the column name empty but will enter the value, the value will be skipped. In the example below, the Comment value will not be added to the sheet.

• Make sure to number the rows so that all the values are transferred. The numbers define the sequence of rows (so row 1 should precede row 2, and so on). If you’re adding the following JSON:

{
    "Row1": {
        "Number": "ONE",
        "Name": "Blue"
    },
    "Row2": {
        "Number": "TWO",
        "Name": "Yellow"
    }
}

• If you use data references, make sure to wrap them in quotes, for example:

{
  "Row1": {"Name": "{Instance ID}"}
}

• You can use formulas - for formula details, see Google Sheet formulas (external page).

​

Variables