Workflows · 1 min read
Create and Update Multiple Rows in Google Sheets
The Google Sheets action can add or update more than one row in a single step. Use it to log several entries at once, keep a sheet in sync, or refresh a block of existing rows.
Before you start
- Connect your Google account.
- Put clear column headers in the first row of the sheet.
- Check the tab name you'll pick.
- After adding, renaming, or moving columns, click Refresh Headers in the action.
Create multiple rows
- Go to Automation > Workflows and open a workflow with a trigger, such as Form Submitted.
- Click +, search for Google Sheets, and choose it.
- Choose Create Multiple Spreadsheet Row(s) as the action.
- Choose your Google account, the Drive, the spreadsheet, and the worksheet tab.
- Optionally click Refresh Headers to load the latest column names.
- Choose the Starting Column and Ending Column. Columns are labeled with the header names from the first row.
- Map your data and click Save Action.
Update multiple rows
- Add the Google Sheets action and choose Update Multiple Spreadsheet Row(s).
- Choose your Google account, the Drive, the spreadsheet, and the worksheet tab.
- Enter the row number where the update should start.
- Choose the Starting Column and Ending Column, and refresh the headers if needed.
- Map your data and click Save Action.
Use update when the rows already exist and you want to refresh their values without adding duplicates.