Explore

Example

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(url, 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

⁠

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.