Quick answer
To connect Coda to Google Sheets, open your Coda doc, add the Google Sheets Pack from the Packs menu, authorize your Google account, then choose the spreadsheet and range to sync. Coda creates a live synced table you can refresh manually or on a schedule, and push updates back using automation buttons.
Steps at a glance
- Open your Coda doc and click the Packs icon
- Search for and add the Google Sheets Pack
- Authorize your Google account and grant sheet access
- Pick the spreadsheet, sheet tab, and range to import
- Insert the synced table onto your page
- Set the refresh schedule or sync manually
- Add a button to push Coda data back to Sheets
Summary
Coda connects to Google Sheets through its official Google Sheets Pack, which pulls a spreadsheet range into a live-updating table inside your doc. It's the built-in way to bring spreadsheet data into Coda and, with a bit of setup, send Coda data back out again.
Step-by-step guide
Step 1
Open the Packs menu in your Coda doc
Open the Coda doc where you want the Google Sheets data to live. Click the Packs icon in the right-hand sidebar, or type "/Pack" in a page to bring up the Packs search panel.
Step 2
Add the Google Sheets Pack
Search for "Google Sheets" in the Packs panel and select the official Pack built by Coda. Click Install (or Add to Doc) to make it available in your current document.
Step 3
Authorize your Google account
Coda will prompt you to sign in with the Google account that owns or has access to the spreadsheet. Review the requested permissions, since Coda needs read (and optionally write) access to the specific sheet, then click Allow to complete the connection.
Step 4
Choose the spreadsheet and range to sync
Type "/Google Sheets" on a page and select the sync action from the menu. Pick the spreadsheet from the list, choose the exact sheet tab and cell range you want, and confirm to bring in the data.
Step 5
Insert and review the synced table
Coda builds a new table on your page that mirrors the selected range. Each column maps to a spreadsheet column, so it's worth checking headers and data types before you start building views or filters, and you can adjust structure the same way you would when you add columns to a table.
Step 6
Set your refresh schedule
Open the table's sync settings to choose how often Coda pulls fresh data from the sheet. Free-plan docs typically refresh on a set interval or manual trigger rather than instantly, so click Refresh Now whenever you need the latest numbers immediately.
Step 7
Push Coda data back to Google Sheets
To send updates in the other direction, add a button that calls the Google Sheets Pack's AddRow or ModifyRows action, similar to how you'd automate tasks with buttons elsewhere in Coda. This is also useful once you've started to add rows to a table and need those new records reflected in the spreadsheet.
Why this matters
You're tracking a project in Coda, but a teammate insists on updating numbers in a spreadsheet instead. Connecting the two means you stop copying rows by hand, keep both tools showing the same data, and avoid the version-mismatch headaches that come from manual exports and re-imports.
Frequently asked questions
Does Coda offer true two-way sync with Google Sheets?
Not automatically. The Google Sheets Pack pulls data into Coda on a schedule, and sending data back requires a manual action or automation button rather than continuous two-way syncing.
Is connecting Coda to Google Sheets free?
Yes, the Google Sheets Pack is available on Coda's free plan. Free-plan docs may have longer refresh intervals or lower automation limits compared to paid plans.
Do I need edit access to the Google Sheet?
You need at least view access to import data into Coda, but edit access is required if you want to push updates from Coda back into the spreadsheet.
Can I sync multiple sheets or tabs into one Coda doc?
Yes, you can repeat the sync setup for as many sheet tabs or spreadsheets as you need, each creating its own table inside the doc.
Related guides
Continue with more step-by-step guides for getting work done.
How to Automate Tasks with Buttons in CodaLearn how to create Coda buttons that automatically add, update, or assign tasks with pre-filled data to speed up your workflow.
How to Add Rows to a Coda TableLearn how to add rows to a Coda table using the plus icon, keyboard shortcuts, or right-click menu for precise row placement.
How to Add Columns to a Coda TableLearn how to add, rename, and configure new columns in a Coda table using the built-in plus button and column type menu.
Create interactive demos like this one — free, no coding required.
Start for free →