JavaScript Required
We’re sorry, but Coda doesn’t work properly without JavaScript enabled.
Share
Explore
Example
BB
Benno Baumgartner
Data shown in this document is coming from the the following google sheet:
https://docs.google.com/spreadsheets/d/1HvzdrPtpHFYSBTAEEQbDYG0O6Nr39RvEY_eT5u0Q23s
To fetch the value of a cell use the formula:
FetchCellData
(u
rl, sheetName, cellName
)
url: url of the spreadsheet from which to fetch a cell value.
sheetName: the name of the sheet in the spreadsheet from which to fetch a cell value.
cellName: name of the cell from which to fetch the value.
For coda to be able to fetch data from your sheet, you have to share the sheet, such that anyone with the link can view the data in the sheet:
Then copy the link and use it as first parameter for the function FetchCellData. For example you can fetch the total amount like this:
FetchCellData("
https://docs.google.com/spreadsheets/d/1HvzdrPtpHFYSBTAEEQbDYG0O6Nr39RvEY_eT5u0Q23s/edit?usp=sharing
", "Overview", "C5")
And this is the result:
Total amount is:
105CHF
Related Docs
$10k Work: How to increase your productivity using the magic of leverage
Khe Hy
Two-way writeups: Coda’s secret to shipping fast
Lane Shackleton
Peloton Analytics Tool for Workout Stats [+Template]
Al Chen
Mental Health Awareness Month
Jamie Forseth
Four Myths of Bundling
Shishir Mehrotra
OTF Planner (otfplanner.com)
Kenny
Random Quote Generator
Mark Davis
SpotRacer Database
kev null
Founders Mindset Bootcamp Shared
Nathalie Rafeh
1:1 & Career Development Template
Eric Glick
The Inbox-Zero Challenge: How long can you keep up your streak?
Shishir Mehrotra
Hiring List Template
SiNing Chan
BlockSplit Info
Block Split
Easy RSVP Tracker with the Gmail Pack
Kay Diaz-Ferrigno
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
Ctrl
P
) instead.