Skip to content
Google Sheets for Coda
Share
Explore

Google Sheets for Coda

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
The below data is obtained from this (). 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
Financial Sheet Manual
0
Search
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
Financial Sheet - 2015
0
Search
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
Search
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
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.