Skip to content
Gallery
Untitled doc
Untitled page
Home
Building Block Definitions
Getting Started & Examples
Full Page Sheet Embed
More
Share
Explore
Getting Started & Examples

icon picker
Updating Rows

(Example) Updating Multiple Values + Transpose
Depending on your use-case you may want to update rows in your spreadsheet. This is completely possible using the Google Sheets Pack. Follow the instructions below to set up your first two-way sync.

Written Instructions

Pull in the Sheet you want to use. See
Installing and syncing
⁠
for details.
The table options should then be displayed automatically, if not you can hover over the table and select ‘Edit’ or ‘Options’ then ‘Google Sheets Sheet’
Sync the table by clicking Sync Now
Create a column on the table for users to write their updates into
Create another 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 → Update Row
Set the Account value to a shared account or the user’s private account
Set your Spreadsheet Id - It should autocomplete as you type the name
Select your Sheet Id - This should also be autocomplete supported
Set your Row range - This will be the range of cells you want to update
Based on the size of your row range set your ‘Values’ to update, this should be a List() with a value for each cell in the targeted range. Example: ‘Row Range’ A1:G1 should be given a value list with 7 values. Row Range G1 would only require 1 value.

⁠
Loading…
⁠
⁠

Video & Example:

⁠
Loading…
⁠
⁠
People (Without Header)
The Google Sheets Pack requires a subscription.
Row Data Object
Name
Department
Department Edit
Target Cell
Update Cell
1
A1:G1
Sandra
Engineering
Engineering
G1
Update Cell
2
A2:G2
Rocco
DevOps
​
G2
Update Cell
3
A3:G3
Terrell
Engineering
Engineering
G3
Update Cell
4
A4:G4
Kaila
Marketing
​
G4
Update Cell
5
A5:G5
Oliver
Marketing
​
G5
Update Cell
6
A6:G6
Kiera
Marketing
​
G6
Update Cell
7
A7:G7
Beckett
Marketing
​
G7
Update Cell
8
A8:G8
Gael
Engineering
​
G8
Update Cell
9
A9:G9
Frankie
Marketing
​
G9
Update Cell
10
A10:G10
Lailah
People
​
G10
Update Cell
11
A11:G11
Brendan
People
​
G11
Update Cell
12
A12:G12
Miriam
People
​
G12
Update Cell
13
A13:G13
Ayla
Sales
​
G13
Update Cell
14
A14:G14
Finley
DevOps
​
G14
Update Cell
15
A15:G15
Delilah
Executive
​
G15
Update Cell
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.