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
Loading…
Meeting Notes
Name
Department
Date
Notes
Send To Sheet
Archived
Results
Name
Department
Date
Notes
Send To Sheet
Archived
Results
1
Spooky Marketing Meeting
Marketing
10/30/2022
Open
Add row
1
2
Big People Event
People
8/18/2022
Open
Add row
1
3
Engineering All Hands
Engineering
6/12/2022
Open
Add row
1
4
Test Meeting
Sales
2/27/2023
Open
Add row
1
5
New Meeting
DevOps
5/30/2023
Open
Add row
1
6
Example Meeting
People
5/2/2023
Open
Add row
1
There are no rows in this table
Meeting Notes Archive
The Google Sheets Pack requires a subscription.
Row Data Object
Name
Department
Date
Notes
Row Data Object
Name
Department
Date
Notes
1
A2:D2
Spooky Marketing Meeting
Marketing
10/31/2022
2
A3:D3
Engineering All Hands
Engineering
6/13/2022
3
A4:D4
Big People Event
People
8/19/2022
4
A5:D5
Test Meeting
Sales
2/28/2023
5
A6:D6
New Meeting
DevOps
5/31/2023
6
A7:D7
Example Meeting
People
5/3/2023
There are no rows in this table
Departments
Name
Name
1
Marketing
2
Sales
3
People
4
Engineering
5
DevOps
6
Executive
There are no rows in this table
Want to print your doc? This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (