Skip to content

TKCN

Inventory & Orders

More

Share

Explore

Archive

h

Table 3

Table 3

Name

Column 2

Column 3

Notes

File

1

Open

2

Open

3

Open

There are no rows in this table

⁠

Intro

The

Google Sheets Pack⁠

has the purpose to facilitate data interaction and integration between Google Sheets documents and Coda docs.

Start here → Due to the very different nature of how data is organized, it is important to understand how Google Sheets (and all spreadsheets tools) and Coda structure data. If you’re not familiar with these concepts, you can have a quick overview on

Building Block Definitions⁠

.

Getting Started

Level 1:
`Installing and syncing`⁠

Google Sheets data into Coda in (less than) 60 seconds!

Level 2:
`Manage your sync`⁠
⁠

How to configure your sync tables and retrieve data via formula

Level 3:
`Adding New Rows`⁠

How to add new rows to your sheets

Level 4:
`Updating Rows`⁠

How to configure your sync tables and retrieve data via formula

Building Blocks

Here you can find a convenient reference by building block with one page fully dedicated to each block

⁠

Sheets⁠

: Mapping a Google Sheets range into a Coda Sync Table by selecting the document and the tab via a dynamic dropdown.

⁠

GetSheetValues()⁠

: A formula allowing to retrieve data directly from one or multiple cells

⁠

UpdateRow()⁠

: An action formula used to update cells in a row.

⁠

AddRow()⁠

: An action formula used to add new rows to a sheet.

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.