Action: Create Multiple Spreadsheet Rows

Google Sheets Operation

The Create Multiple Spreadsheet Rows action inserts multiple new rows into a specified sheet.

Example User Story

I want to append multiple rows of sales data to a Google Sheet so that I can keep track of daily transactions efficiently.

Fields

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

Related Connections

Google Sheets

Related Automations

Example link

Code (Apache v2.0): Operation

{
  "handle": "create-multiple-spreadsheet-rows",
  "state": "inDev",
  "meta": {
    "short": "Create Multiple Spreadsheet Rows",
    "description": "Adds multiple rows of data to a Google Sheet."
  },
  "input": [
    {
      "name": "spreadsheetId",
      "type": "String",
      "required": true,
      "meta": {
        "description": "The spreadsheet to append rows 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": "A 2D array of values to append."
      }
    },
    {
      "name": "valueInputOption",
      "type": "String",
      "meta": {
        "default": "RAW",
        "description": "How the input data should be interpreted.",
        "options": [
          "RAW",
          "USER_ENTERED"
        ]
      }
    },
    {
      "name": "insertDataOption",
      "type": "String",
      "meta": {
        "default": "INSERT_ROWS",
        "description": "How the input data should be inserted.",
        "options": [
          "INSERT_ROWS",
          "OVERWRITE"
        ]
      }
    }
  ],
  "output": [
    {
      "name": "spreadsheetId",
      "type": "String",
      "selector": [
        "spreadsheetId"
      ],
      "meta": {
        "description": "The ID of the spreadsheet that was updated."
      }
    },
    {
      "name": "updatedRange",
      "type": "String",
      "selector": [
        "updates",
        "updatedRange"
      ],
      "meta": {
        "description": "The range of the spreadsheet that was 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": {
          "insertDataOption": {
            "value": "{{insertDataOption}}"
          },
          "valueInputOption": {
            "value": "{{valueInputOption}}"
          }
        },
        "bodyTemplate": {
          "value": "{\"values\": {{values}}}",
          "placeholders": [
            {
              "name": "values",
              "type": "Any",
              "description": "A 2D array of values to append.",
              "required": true,
              "default": ""
            }
          ]
        }
      }
    }
  ]
}