Getting Started & Examples

icon picker
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

Loading…
Meeting Notes
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
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
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 (
CtrlP
) instead.