Skip to content
Google Sheets for Coda
Google Sheets for Coda
Privacy Policy
More
Share
Explore

icon picker
Google Sheets for Coda

AG
Arjun Ganesan

Google Sheets for Coda pack allows you to import and sync existing google sheets to you Coda doc. You can read a single cell or multiple cells values in sheet. You can also create new google sheets, update data in existing sheet right from you Coda doc.


⁠
Install Pack
⁠
⁠

How it work

The below data is obtained from this
spreadsheet
⁠
(
https://docs.google.com/spreadsheets/d/16bP2nvPCS4U-UAdjKhXfbJAIQOZFT6MH-aQB_PHGvq4/edit?usp=sharing
⁠
). The sync tables works on the assumption that the first row in the sheet are headers, so that first row in the sheet will be used to create the columns as shown below.

Adding spreadsheet manually to the doc using url

⁠
manual_sheet.gif
⁠
⁠

The first sheet in the spreadsheet added manually using the url
https://docs.google.com/spreadsheets/d/16bP2nvPCS4U-UAdjKhXfbJAIQOZFT6MH-aQB_PHGvq4/edit?usp=sharing
⁠
⁠
Financial Sheet Manual
0
Connect your account to refresh data from Google Sheets for Coda.
Sheets
Year
Segment
Country
Product
Units Sold
Sale Price
Gross Sales
Profit
Date
1
1
2014
Government
Canada
Carretera
1618.5
$20.00
$32,370.00
$16,185.00
1/1/2014
2
2
2014
Government
Germany
Carretera
1321
$20.00
$26,420.00
$13,210.00
1/1/2014
3
3
2014
Midmarket
France
Carretera
2178
$15.00
$32,670.00
$10,890.00
6/1/2014
4
4
2014
Midmarket
Germany
Carretera
888
$15.00
$13,320.00
$4,440.00
6/1/2014
5
5
2014
Midmarket
Mexico
Carretera
2470
$15.00
$37,050.00
$12,350.00
6/1/2014
6
6
2014
Government
Germany
Carretera
1513
$350.00
$529,550.00
$136,170.00
12/1/2014
7
7
2014
Midmarket
Germany
Montana
921
$15.00
$13,815.00
$4,605.00
3/1/2014
8
8
2014
Channel Partners
Canada
Montana
2518
$12.00
$30,216.00
$22,662.00
6/1/2014
9
9
2014
Government
France
Montana
1899
$20.00
$37,980.00
$18,990.00
6/1/2014
There are no rows in this table
⁠

Adding the second sheet (2015) of the spreadsheet by directly using the url
https://docs.google.com/spreadsheets/d/16bP2nvPCS4U-UAdjKhXfbJAIQOZFT6MH-aQB_PHGvq4/edit#gid=244515385
⁠
⁠
Financial Sheet - 2015
0
Connect your account to refresh data from Google Sheets for Coda.
Sheets
Year
Segment
Country
Product
Units Sold
Sale Price
Gross Sales
Profit
Date
1
1
2015
Midmarket
Mexico
Carretera
1618.5
$20.00
$32,370.00
$16,185.00
1/1/2014
2
2
2015
Midmarket
Germany
Carretera
1321
$20.00
$26,420.00
$13,210.00
1/1/2014
3
3
2015
Government
Canada
Carretera
2178
$15.00
$32,670.00
$10,890.00
6/1/2014
4
4
2015
Midmarket
France
Carretera
888
$15.00
$13,320.00
$4,440.00
6/1/2014
5
5
2015
Channel Partners
Mexico
Carretera
2470
$15.00
$37,050.00
$12,350.00
6/1/2014
6
6
2015
Government
Germany
Carretera
1513
$350.00
$529,550.00
$136,170.00
12/1/2014
7
7
2015
Midmarket
Germany
Montana
921
$15.00
$13,815.00
$4,605.00
3/1/2014
8
8
2015
Channel Partners
Canada
Montana
2518
$12.00
$30,216.00
$22,662.00
6/1/2014
9
9
2015
Government
France
Montana
1899
$20.00
$37,980.00
$18,990.00
6/1/2014
There are no rows in this table
⁠

⁠

Automatically adding a sheet to doc from recent list

Drag drop the sheet from the recent list
⁠
recent_sheet.gif
⁠
⁠
By default first sheet will be imported automatically. You can edit the sync setting to change the sheet to sync with
Financial Sheet
0
Connect your account to refresh data from Google Sheets for Coda.
Sheet
Year
Segment
Country
Product
Units Sold
Sale Price
Gross Sales
Profit
Date
1
1
2015
Midmarket
Mexico
Carretera
1618.5
$20.00
$32,370.00
$16,185.00
1/1/2014
2
2
2015
Midmarket
Germany
Carretera
1321
$20.00
$26,420.00
$13,210.00
1/1/2014
3
3
2015
Government
Canada
Carretera
2178
$15.00
$32,670.00
$10,890.00
6/1/2014
4
4
2015
Midmarket
France
Carretera
888
$15.00
$13,320.00
$4,440.00
6/1/2014
5
5
2015
Channel Partners
Mexico
Carretera
2470
$15.00
$37,050.00
$12,350.00
6/1/2014
6
6
2015
Government
Germany
Carretera
1513
$350.00
$529,550.00
$136,170.00
12/1/2014
7
7
2015
Midmarket
Germany
Montana
921
$15.00
$13,815.00
$4,605.00
3/1/2014
8
8
2015
Channel Partners
Canada
Montana
2518
$12.00
$30,216.00
$22,662.00
6/1/2014
9
9
2015
Government
France
Montana
1899
$20.00
$37,980.00
$18,990.00
6/1/2014
There are no rows in this table
⁠

⁠

Get value of a single cell

⁠
2178
⁠
⁠

⁠

Get multiple values from a spreadsheet

⁠
CanadaGermanyFranceGermanyMexicoGermanyGermanyCanadaFrance
⁠
⁠
⁠
Blank
⁠
⁠
⁠

Create a new spreadsheet in google from the below table

Ages
0
Name
Age
1
John
26
2
Jill
32
3
Jack
46
There are no rows in this table
⁠
⁠
Create new age spreadsheet
⁠
⁠

⁠

Update an already existing spreadsheet

⁠
Update existing spreadsheet
⁠
⁠

⁠

Demo video

⁠
⁠
⁠
Google Sheets for Coda pack allows you to import and sync existing google sheets to you Coda doc. You can read a single cell or multiple cells values in sheet. You can also create new google sheets, update data in existing sheet right from you Coda doc.
How it work
Adding spreadsheet manually to the doc using url
Financial Sheet Manual
Financial Sheet - 2015
Automatically adding a sheet to doc from recent list
Financial Sheet
Get value of a single cell
Get multiple values from a spreadsheet
Create a new spreadsheet in google from the below table
Ages
Update an already existing spreadsheet
Demo video
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.