Clear Row

Clear a row in a Google Spreadsheet. You can indicate the row that you want to clear by manually typing the row number into the field or by mapping a user's selected row number to the field.

Options

Field	Definition	Type	Required
Use Spreadsheet ID?	Option to specify a Google Sheets spreadsheet by ID. If you select No, select a spreadsheet from the Spreadsheet dropdown and ignore the Spreadsheet ID field. If you select Yes, the list of spreadsheets from your account in the Spreadsheet dropdown will be depopulated; select -- Enter Spreadsheet ID -- from the Spreadsheet dropdown and enter an ID in the Spreadsheet ID field. The Spreadsheet ID is the last string of characters in the URL for your spreadsheet. For example, in the URL https://docs.google.com/spreadsheets/d/1qpyC0XzvTcKT6EISywvqESX3A0MwQoFDE8p-Bll4hps/edit#gid=0, the spreadsheet ID is 1qpyC0XzvTcKT6EISywvqESX3A0MwQoFDE8p-Bll4hps.	Dropdown	TRUE
Spreadsheet	List of spreadsheets in your Google Sheets account Due to an API limitation, a maximum of 100 spreadsheets are returned in a search. To search for a specific spreadsheet, use the Enter Spreadsheet ID option.	Dropdown	TRUE
Spreadsheet ID	Unique identifier for your selected spreadsheet	String	FALSE
Worksheets	List of worksheet tabs in your selected spreadsheet	Dropdown	TRUE

Input

Field	Definition	Type	Required
Row Number	Number of the row to clear	Number	FALSE

Output

Field	Definition	Type
Cleared Range	Range of rows that has been cleared	String

Related topics

Google Sheets connector

About the elements of Okta Workflows

Google Sheets API documentation