Unitalk Sheets icon

Unitalk Sheets

Read, update and write data to Google Sheets

Actions10

Sheet Within Document → Delete Rows or Columns

AI-generated

Summary

Delete specified rows or columns from a given sheet within a Google Sheets document.

Inputs

  • documentId (required) — The Google Sheets document from which to delete rows or columns; can be selected from a list, provided by URL, or by document ID.
  • sheetName (required) — The specific sheet within the document where rows or columns will be deleted; choice depends on the selected document.
  • toDelete (required) — Choose whether to delete rows or columns.
  • startIndex (required) — For rows, the starting row number to delete from (minimum 2); for columns, the starting column letter to delete from.
  • numberToDelete (required) — The number of rows or columns to delete starting from the specified start index (minimum 1).

Output shape

an object indicating the success of the delete operation; the node does not return the deleted data but confirms the action's completion

The operation modifies the specified sheet in the Google Sheets document by removing the indicated rows or columns starting at the given index for the specified count. No pagination or further data is returned.

Examples

Example 1: Delete 3 rows starting from row 2 in a sheet named 'Sheet1' within the selected document.

Select the document, choose 'Sheet1' as sheetName, set toDelete to 'Rows', startIndex to 2, numberToDelete to 3.

Example 2: Delete 2 columns starting from column B in a sheet within the document.

Select the document, pick the sheet, set toDelete to 'Columns', startIndex to 'B', numberToDelete to 2.

Links

Discussion