Skip to content
Pozvánka na UXWell Summer Camp 2024
Share
Explore
Adding New Rows
You may want to add new rows to your Google Sheet. Luckily we have a solution in the AddRow() action formula. Here we will describe how to use the function in your docs.

Written Instructions

Choose any new or existing table
Create a new column and set the column to be a button column
Go to Button options, under Actions open the dropdown and scroll to Packs → Google Sheets → Add Row
Set the Spreadsheet Id and the Sheet Id of the Sheet you want to target
Set the Row Range to target a specific area you’d like to insert rows below, by default it will find first empty row in the sheet
Set the Value Parameter, this expects a List() each column will be filled out in order from left to right.

Video

⁠
This embedded link can't be shown.
⁠
Meeting Notes
Name
Department
Date
Notes
Send To Sheet
Archived
Results
Spooky Marketing Meeting
10/31/2022
Open
Add row
1
Big People Event
8/19/2022
Open
Add row
1
Engineering All Hands
6/13/2022
Open
Add row
1
Test Meeting
2/28/2023
Open
Add row
1
New Meeting
5/31/2023
Open
Add row
1
Example Meeting
5/3/2023
Open
Add row
1
⁠


Meeting Notes Archive
Row Data Object
Name
Department
Date
Notes
Google Sheets icon
A2:D2
Spooky Marketing Meeting
Marketing
10/31/2022
Google Sheets icon
A3:D3
Engineering All Hands
Engineering
6/13/2022
Google Sheets icon
A4:D4
Big People Event
People
8/19/2022
Google Sheets icon
A5:D5
Test Meeting
Sales
2/28/2023
Google Sheets icon
A6:D6
New Meeting
DevOps
5/31/2023
Google Sheets icon
A7:D7
Example Meeting
People
5/3/2023
⁠
Departments
Name
Marketing
Sales
People
Engineering
DevOps
Executive
⁠
Gallery
 
Want to print your doc?
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.