Skip to content
Gallery
Google Sheets Pack Documentation
Getting Started
Use Cases
Examples
Privacy Policy
Terms and Conditions
More
Share
Explore

icon picker
Examples

All of the examples below are pulling data from this spreadsheet:
⁠
https://docs.google.com/spreadsheets/d/1xZSWBe1IFRGejYfJSR8fZ2oxFQTgmTAd-XhhB6w-lZI/edit#gid=0
⁠
⁠

If you
specify a range in the URL
⁠
, you can pull in only part of a spreadsheet:
Very Important Spreadsheet - A1:F12
Not synced yet
Table from Google Sheet
Full Name
Job Title
Department
Business Unit
Gender
Ethnicity
Age
Hire Date
Annual Salary
Bonus
Country
City
Exit Date
1
E02387
Emily Davis
Sr. Manger
IT
Research & Development
Female
​
​
​
​
​
​
​
​
2
E04105
Theodore Dinh
Technical Architect
IT
Manufacturing
Male
​
​
​
​
​
​
​
​
3
E02572
Luna Sanders
Director
Finance
Speciality Products
Female
​
​
​
​
​
​
​
​
4
E02832
Penelope Jordan
Computer Systems Manager
IT
Manufacturing
Female
​
​
​
​
​
​
​
​
5
E01639
Austin Vo
Sr. Analyst
Finance
Manufacturing
Male
​
​
​
​
​
​
​
​
6
E00644
Joshua Gupta
Account Representative
Sales
Corporate
Male
​
​
​
​
​
​
​
​
7
E01550
Ruby Barnes
Manager
IT
Corporate
Female
​
​
​
​
​
​
​
​
8
E04332
Luke Martin
Analyst
Finance
Manufacturing
Male
​
​
​
​
​
​
​
​
9
E04533
Easton Bailey
Manager
Accounting
Manufacturing
Male
​
​
​
​
​
​
​
​
10
E03838
Madeline Walker
Sr. Analyst
Finance
Speciality Products
Female
​
​
​
​
​
​
​
​
11
E00591
Savannah Ali
Sr. Manger
Human Resources
Manufacturing
Female
​
​
​
​
​
​
​
​
There are no rows in this table
⁠


Because of how this Pack was made, if you want to pull in a singe cell, you actually have to select 2 cells in the same column. The Pack uses the first row as the table headers. If you just want a singe cell, you might want to try out this pack:
https://coda.io/@tabular/google-sheets-for-coda
⁠
⁠
In addition, you can control how frequently the data gets pulled from Google in the Table and Pack settings. To edit the table settings click the edit link on the table (you can only do this on documents that you can edit). You can the select the refresh to be Manual, Hourly or Daily. To manually refresh the table, click the little refresh arrow on the table and it should pull in fresh data from Google. Sometimes results are cached so it can take several minutes to actually update.
Single Cell
Not synced yet
Table from Google Sheet
Time of Last Sync
1
Wednesday, March 20, 2024 at 5:33 PM Pacific Time
Wednesday, March 20, 2024 at 5:33 PM Pacific Time
There are no rows in this table
⁠

When you click on a different tab in the spreadsheet, Google updates the “gid” parameter in the URL so you can just copy the URL from the top of the page to pull in the full tab, or if you
Get link to this range
⁠
you can pull in just part of the tab.
Very Important Spreadsheet - Heights of Friends - A1:C5
Not synced yet
Table from Google Sheet
Height
Year
1
Joe
6' 3"
2012
2
John
5' 9"
1982
3
Fred
5' 11"
2020
4
Frank
5' 7"
2017
There are no rows in this table
⁠

You can also just copy the URL from the page and it will pull in the entire tab:
Very Important Spreadsheet - Employees
Not synced yet
Table from Google Sheet
Full Name
Job Title
Department
Business Unit
Gender
Ethnicity
Age
Hire Date
Annual Salary
Bonus
Country
City
Exit Date
1
E02387
Emily Davis
Sr. Manger
IT
Research & Development
Female
Black
55
4/8/2016
$141,604.00
15%
United States
Seattle
10/16/2021
2
E04105
Theodore Dinh
Technical Architect
IT
Manufacturing
Male
Asian
59
11/29/1997
$99,975.00
0%
China
Chongqing
​
3
E02572
Luna Sanders
Director
Finance
Speciality Products
Female
Caucasian
50
10/26/2006
$163,099.00
20%
United States
Chicago
​
4
E02832
Penelope Jordan
Computer Systems Manager
IT
Manufacturing
Female
Caucasian
26
9/27/2019
$84,913.00
7%
United States
Chicago
​
5
E01639
Austin Vo
Sr. Analyst
Finance
Manufacturing
Male
Asian
55
11/20/1995
$95,409.00
0%
United States
Phoenix
​
6
E00644
Joshua Gupta
Account Representative
Sales
Corporate
Male
Asian
57
1/24/2017
$50,994.00
0%
China
Chongqing
​
7
E01550
Ruby Barnes
Manager
IT
Corporate
Female
Caucasian
27
7/1/2020
$119,746.00
10%
United States
Phoenix
​
8
E04332
Luke Martin
Analyst
Finance
Manufacturing
Male
Black
25
5/16/2020
$41,336.00
0%
United States
Miami
5/20/2021
9
E04533
Easton Bailey
Manager
Accounting
Manufacturing
Male
Caucasian
29
1/25/2019
$113,527.00
6%
United States
Austin
​
10
E03838
Madeline Walker
Sr. Analyst
Finance
Speciality Products
Female
Caucasian
34
6/13/2018
$77,203.00
0%
United States
Chicago
​
11
E00591
Savannah Ali
Sr. Manger
Human Resources
Manufacturing
Female
Asian
36
2/11/2009
$157,333.00
15%
United States
Miami
​
12
E03344
Camila Rogers
Controls Engineer
Engineering
Speciality Products
Female
Caucasian
27
10/21/2021
$109,851.00
0%
United States
Seattle
​
13
E00530
Eli Jones
Manager
Human Resources
Manufacturing
Male
Caucasian
59
3/14/1999
$105,086.00
9%
United States
Austin
​
14
E04239
Everleigh Ng
Sr. Manger
Finance
Research & Development
Female
Asian
51
6/10/2021
$146,742.00
10%
China
Shanghai
​
15
E03496
Robert Yang
Sr. Analyst
Accounting
Speciality Products
Male
Asian
31
11/4/2017
$97,078.00
0%
United States
Austin
3/9/2020
16
E00549
Isabella Xi
Vice President
Marketing
Research & Development
Female
Asian
41
3/13/2013
$249,270.00
30%
United States
Seattle
​
17
E00163
Bella Powell
Director
Finance
Research & Development
Female
Black
65
3/4/2002
$175,837.00
20%
United States
Phoenix
​
18
E00884
Camila Silva
Sr. Manger
Marketing
Speciality Products
Female
Latino
64
12/1/2003
$154,828.00
13%
United States
Seattle
​
19
E04116
David Barnes
Director
IT
Corporate
Male
Caucasian
64
11/3/2013
$186,503.00
24%
United States
Columbus
​
20
E04625
Adam Dang
Director
Sales
Research & Development
Male
Asian
45
7/9/2002
$166,331.00
18%
China
Chongqing
​
21
E03680
Elias Alvarado
Sr. Manger
IT
Manufacturing
Male
Latino
56
1/9/2012
$146,140.00
10%
Brazil
Manaus
​
22
E04732
Eva Rivera
Director
Sales
Manufacturing
Female
Latino
36
4/2/2021
$151,703.00
21%
United States
Miami
​
23
E03484
Logan Rivera
Director
IT
Research & Development
Male
Latino
59
5/24/2002
$172,787.00
28%
Brazil
Rio de Janerio
​
24
E00671
Leonardo Dixon
Analyst
Sales
Speciality Products
Male
Caucasian
37
9/5/2019
$49,998.00
0%
United States
Seattle
​
25
E02071
Mateo Her
Vice President
Sales
Speciality Products
Male
Asian
44
3/2/2014
$207,172.00
31%
China
Chongqing
​
26
E02206
Jose Henderson
Director
Human Resources
Speciality Products
Male
Black
41
4/17/2015
$152,239.00
23%
United States
Columbus
​
27
E04545
Abigail Mejia
Quality Engineer
Engineering
Corporate
Female
Latino
56
2/5/2005
$98,581.00
0%
Brazil
Rio de Janerio
​
28
E00154
Wyatt Chin
Vice President
Engineering
Speciality Products
Male
Asian
43
6/7/2004
$246,231.00
31%
United States
Seattle
​
29
E03343
Carson Lu
Engineering Manager
Engineering
Speciality Products
Male
Asian
64
12/4/1996
$99,354.00
12%
China
Beijing
​
30
E00304
Dylan Choi
Vice President
IT
Corporate
Male
Asian
63
5/11/2012
$231,141.00
34%
China
Beijing
​
31
E02594
Ezekiel Kumar
IT Coordinator
IT
Research & Development
Male
Asian
28
6/25/2017
$54,775.00
0%
United States
Columbus
​
32
E00402
Dominic Guzman
Analyst
Finance
Manufacturing
Male
Latino
65
5/16/2004
$55,499.00
0%
Brazil
Manaus
​
33
E01994
Angel Powell
Analyst II
Sales
Research & Development
Male
Caucasian
61
7/11/2008
$66,521.00
0%
United States
Seattle
​
34
E03549
Mateo Vu
Account Representative
Sales
Speciality Products
Male
Asian
30
9/29/2016
$59,100.00
0%
China
Chongqing
​
35
E03247
Caroline Jenkins
Analyst
Finance
Research & Development
Female
Caucasian
27
5/6/2018
$49,011.00
0%
United States
Chicago
​
36
E02074
Nora Brown
Enterprise Architect
IT
Manufacturing
Female
Caucasian
32
2/11/2014
$99,575.00
0%
United States
Austin
​
37
E04152
Adeline Huang
Controls Engineer
Engineering
Manufacturing
Female
Asian
34
12/16/2019
$99,989.00
0%
China
Chengdu
​
38
E01628
Jackson Perry
Vice President
Marketing
Research & Development
Male
Caucasian
27
10/20/2019
$256,420.00
30%
United States
Phoenix
​
39
E04285
Riley Padilla
Technical Architect
IT
Manufacturing
Female
Latino
35
5/15/2013
$78,940.00
0%
United States
Miami
​
40
E01417
Leah Pena
Enterprise Architect
IT
Corporate
Female
Latino
57
1/3/1994
$82,872.00
0%
Brazil
Manaus
​
41
E01754
Owen Lam
Sr. Business Partner
Human Resources
Speciality Products
Male
Asian
30
5/29/2017
$86,317.00
0%
China
Chengdu
7/16/2017
42
E03749
Kennedy Foster
Manager
Marketing
Speciality Products
Female
Caucasian
53
11/23/2013
$113,135.00
5%
United States
Austin
​
43
E03574
John Moore
Vice President
IT
Speciality Products
Male
Caucasian
52
11/8/2005
$199,808.00
32%
United States
Seattle
​
44
E04600
William Vu
Account Representative
Sales
Speciality Products
Male
Asian
37
11/14/2013
$56,037.00
0%
China
Shanghai
​
45
E00586
Sadie Washington
Sr. Manger
Marketing
Research & Development
Female
Caucasian
29
5/24/2019
$122,350.00
12%
United States
Phoenix
​
46
E03538
Gabriel Holmes
Enterprise Architect
IT
Research & Development
Male
Caucasian
40
11/4/2010
$92,952.00
0%
United States
Seattle
​
47
E02185
Wyatt Rojas
Computer Systems Manager
IT
Corporate
Male
Latino
32
3/20/2013
$79,921.00
5%
United States
Austin
​
48
E03830
Eva Coleman
Director
IT
Research & Development
Female
Black
37
9/20/2009
$167,199.00
20%
United States
Seattle
​
49
E03720
Dominic Clark
Quality Engineer
Engineering
Research & Development
Male
Caucasian
52
10/17/2012
$71,476.00
0%
United States
Phoenix
​
50
E03025
Lucy Alexander
Director
Engineering
Manufacturing
Female
Caucasian
45
10/29/2014
$189,420.00
20%
United States
Seattle
​
51
E04917
Everleigh Washington
HRIS Analyst
Human Resources
Research & Development
Female
Caucasian
64
10/20/2001
$64,057.00
0%
United States
Phoenix
​
52
E00415
Leilani Butler
Analyst II
Marketing
Manufacturing
Female
Black
27
9/21/2021
$68,728.00
0%
United States
Phoenix
​
53
E02862
Peyton Huang
Sr. Manger
IT
Manufacturing
Female
Asian
25
7/2/2021
$125,633.00
11%
China
Beijing
​
54
E04207
John Contreras
Analyst II
Marketing
Manufacturing
Male
Latino
35
5/15/2011
$66,889.00