Action: Create Spreadsheet Row at Top

Google Sheets Operation

The Create Spreadsheet Row at Top action inserts a new row at the top of a specified sheet.

Example User Story

I want to add a new row at the top of a Google Sheet so that I can keep track of the latest data entries.

Fields

Field Name	Field Type	Required
spreadsheetId	String	Yes
sheetName	String	Yes
rowData	Any	Yes

Related Connections

Google Sheets

Related Automations

Example link

Code (Apache v2.0): Operation

{
  "handle": "create-spreadsheet-row-at-top",
  "state": "inDev",
  "meta": {
    "short": "Create Spreadsheet Row at Top",
    "description": "Adds a new row at the top of a specified Google Sheet."
  },
  "input": [
    {
      "name": "spreadsheetId",
      "type": "String",
      "required": true,
      "meta": {
        "description": "The spreadsheet to insert the row into."
      }
    },
    {
      "name": "sheetName",
      "type": "String",
      "required": true,
      "meta": {
        "description": "The name of the sheet within the spreadsheet."
      }
    },
    {
      "name": "rowData",
      "type": "Array",
      "required": true,
      "meta": {
        "description": "The data to insert as a new row at the top of the sheet."
      }
    }
  ],
  "output": [
    {
      "name": "updatedRange",
      "type": "String",
      "selector": [
        "updates",
        "updatedRange"
      ],
      "meta": {
        "description": "The range of cells that were updated."
      }
    }
  ],
  "steps": [
    {
      "type": "http",
      "http": {
        "method": "POST",
        "path": {
          "value": "/{{spreadsheetId}}/values/{{sheetName}}!A1:A1:append"
        },
        "headers": {
          "Content-Type": {
            "value": "application/json"
          }
        },
        "queryParams": {
          "insertDataOption": {
            "value": "INSERT_ROWS"
          },
          "valueInputOption": {
            "value": "RAW"
          }
        },
        "bodyTemplate": {
          "value": "{\"values\": [{{rowData}}]}",
          "placeholders": [
            {
              "name": "rowData",
              "type": "Array",
              "description": "The data to insert as a new row.",
              "required": true,
              "default": ""
            }
          ]
        }
      }
    }
  ]
}