Explore

Getting Started & Examples

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.

⁠

Video & Example:

⁠

People (Without Header)

People (Without Header)

Row Data Object

Name

Department

Department Edit

Target Cell

Update Cell

A1:G1

Sandra

Engineering

Update Cell

A2:G2

Rocco

DevOps

Update Cell

A3:G3

Terrell

Engineering

Update Cell

A4:G4

Kaila

Marketing

Update Cell

A5:G5

Oliver

Marketing

Update Cell

A6:G6

Kiera

Marketing

Update Cell

A7:G7

Beckett

Marketing

Update Cell

A8:G8

Gael

Engineering

Update Cell

A9:G9

Frankie

Marketing

Update Cell

A10:G10

Lailah

People

G10

Update Cell

A11:G11

Brendan

People

G11

Update Cell

A12:G12

Miriam

People

G12

Update Cell

A13:G13

Ayla

Sales

G13

Update Cell

A14:G14

Finley

DevOps

G14

Update Cell

A15:G15

Delilah

Executive

G15

Update Cell

There are no rows in this table

⁠

Departments

Departments

Name

Marketing

Sales

People

Engineering

DevOps

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.