Setup - Free version

Install Google Sheets for Coda pack from here:

⁠

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 a 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 from this Spreadsheet:

⁠

Like this:

FetchCellData("

https://docs.google.com/spreadsheets/d/1HvzdrPtpHFYSBTAEEQbDYG0O6Nr39RvEY_eT5u0Q23s/edit?usp=sharing⁠

", "Overview", "C5")

And this is the result:

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.