Action: Create Spreadsheet Row

Google Sheets Operation

The Create Spreadsheet Row action inserts a new row into a specified sheet.

Example User Story

I want to append a new row of sales data to my Google Sheet so that I can keep my records up-to-date.

Fields

Field Name	Field Type	Required
spreadsheetId	String	Yes
range	String	Yes
values	Any	Yes
valueInputOption	String	No

Related Connections

Google Sheets

Related Automations

Example link

Code (Apache v2.0): Operation

{
  "handle": "create-spreadsheet-row",
  "state": "inDev",
  "meta": {
    "short": "Create Spreadsheet Row",
    "description": "Adds a new row to a specified Google Sheet."
  },
  "input": [
    {
      "name": "spreadsheetId",
      "type": "String",
      "required": true,
      "meta": {
        "description": "The spreadsheet to append a row to."
      }
    },
    {
      "name": "range",
      "type": "String",
      "required": true,
      "meta": {
        "description": "The A1 notation of the values to update."
      }
    },
    {
      "name": "values",
      "type": "Any",
      "required": true,
      "aggregate": true,
      "meta": {
        "description": "The list of arrays (rows) to append. In single-row format, supply one array of strings."
      }
    },
    {
      "name": "valueInputOption",
      "type": "String",
      "meta": {
        "default": "RAW",
        "description": "How the input data should be interpreted.",
        "options": [
          "RAW",
          "USER_ENTERED"
        ]
      }
    }
  ],
  "output": [
    {
      "name": "updatedRange",
      "type": "String",
      "selector": [
        "updates",
        "updatedRange"
      ],
      "meta": {
        "description": "The range of cells that were updated."
      }
    },
    {
      "name": "updatedRows",
      "type": "Integer",
      "selector": [
        "updates",
        "updatedRows"
      ],
      "meta": {
        "description": "The number of rows that were updated."
      }
    },
    {
      "name": "updatedColumns",
      "type": "Integer",
      "selector": [
        "updates",
        "updatedColumns"
      ],
      "meta": {
        "description": "The number of columns that were updated."
      }
    },
    {
      "name": "updatedCells",
      "type": "Integer",
      "selector": [
        "updates",
        "updatedCells"
      ],
      "meta": {
        "description": "The number of cells that were updated."
      }
    }
  ],
  "steps": [
    {
      "type": "http",
      "http": {
        "method": "POST",
        "path": {
          "value": "/{{spreadsheetId}}/values/{{range}}:append"
        },
        "headers": {
          "Content-Type": {
            "value": "application/json"
          }
        },
        "queryParams": {
          "valueInputOption": {
            "value": "{{valueInputOption}}"
          }
        },
        "bodyTemplate": {
          "value": "{\"values\": {{values}}}",
          "placeholders": [
            {
              "name": "values",
              "type": "Any",
              "description": "The data to insert into the spreadsheet.",
              "required": true,
              "default": ""
            }
          ]
        }
      }
    }
  ]
}