Skip to content
Google Sheets Pack Documentation
Share
Explore

icon picker
Examples

All of the examples below are pulling data from this spreadsheet:

If you , you can pull in only part of a spreadsheet:
Very Important Spreadsheet - A1:F12
0
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:
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
0
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 you can pull in just part of the tab.
Very Important Spreadsheet - Heights of Friends - A1:C5
0
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
0
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