This guide explains how to clear all values from a specific row while keeping the row structure intact.
Step 1: Add Block #
- Go to Automation → Add App
- Search for Google Sheets
- Select Clear Row
Step 2: Configure Settings #
- Select authentication
- Choose the spreadsheet
- Select the sub-sheet
Step 3: Define Row #
- Enter the row number to clear (e.g., 3 for third row)
Step 4: Run & Save #
- Click Run & Save
Step 5: Verify Output #
- Go to Run History → Output → Response
- Check the cleared range (e.g., A3:Z3)
- Save the workflow