Skip to content
Untitled doc
Untitled page
Home
Building Block Definitions
Getting Started & Examples
Full Page Sheet Embed
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

⁠
⁠
⁠
Meeting Notes
Name
Department
Date
Notes
Send To Sheet
Archived
Results
Spooky Marketing Meeting
10/30/2022
Open
Add row
1
Big People Event
8/18/2022
Open
Add row
1
Engineering All Hands
6/12/2022
Open
Add row
1
Test Meeting
2/27/2023
Open
Add row
1
New Meeting
5/30/2023
Open
Add row
1
Example Meeting
5/2/2023
Open
Add row
1
There are no rows in this table
⁠


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
There are no rows in this table
⁠

Want to print your doc?
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.