Skip to content
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.
Google Sheets for Coda Pack - Overview
Important Update: Transitioning Google Sheets for Coda to a Paid Model
We regret to inform you that we are discontinuing the free version of the Google Sheets for Coda pack. To maintain high performance and reliability, we can no longer sustain the high volume of API traffic—currently exceeding 150,000 requests per month—under a free tier.
What this means for you: To continue using this integration without interruption, please upgrade to the paid version here: . The API of the paid version is fully compatible with the free version.
We appreciate your understanding as we make this change to ensure a stable service.
The Google Sheets for Coda Pack allows fetching data from a Google sheet to your coda document.
Install Google Sheets for Coda pack from here:
To fetch the value of a cell use the formula:
FetchCellData(url, sheetName, cellName)
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/1QCwlRM6DaKKAO7sO3UoAp6DXcKyMiQpChBaMiSOMx8o/edit?usp=sharing", "Overview", "C5")
And this is the result:
Total amount is:105
105
Usually you want to fetch more than just a single cell, you can do that as well with this addon:
Synchronise Sheet
See the video to learn how to synchronise a whole sheet Google Sheets for Coda:
Fetch named range
See the video to learn how to fetch a named range:
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.