Add a new row to the bottom of a spreadsheet.

Options

  • Spreadsheet (drop-down): list of spreadsheets in your Google Sheets account
  • Worksheet (drop-down): list of worksheet tabs in your selected spreadsheet

Input

  • Columns: dynamically generated list of columns from Row 1 of your sheet (the header row must be created manually to generate this input)

Output

  • Updated Range (text): range address of the new row (e.g. “Sheet1!A20:M20”)
  • Row Number (number): number of the new row