Google Sheets Collections in Sites
Mindy Worley avatar
Written by Mindy Worley
Updated over a week ago

Google Sheets can be used as a collection for generating Dynamic Pages. For more information on collections, see Define a Collection for Dynamic Pages.

Google sheets collections have the following limitations:

Google Sheets

Collection Number per Site

100

Fields (columns)

100

Collection name character limit

50

Field name character limit

50

Page item URL

350 characters

Update data

Automatically

To create a Google Sheets collection:

  1. In the left panel, click Content, click Collections, and then click + New Collection.

  2. Click Google Sheets.

  3. Click Sign in With Google.

  4. Sign in to the Google Account that contains the collection.

  5. Select the Google Sheet you want to use as your collection.

  6. Click Connect Spreadsheet.

  7. Define the correct data type for each field.

  8. Click Done.

Inner collections are currently not supported with Google Sheets.

To add a new column to a Google Sheets collection:

  1. In the side panel, click Content, then click Collections.

  2. Click to open the Google Sheets collection.

  3. Click +Add Field.

  4. Select the data type from the Data Type drop down menu and type the name of the field in the Field Name space.

  5. Click Refresh Data.

The new column appears in the available fields when connecting a widget.

Supported Fields

Field Type

Example Content

Rich Text

Welcome to my dentist office

Plain Text

welcome to my office

Number

10,000

Note

Must only contain numbers, and periods (for decimals).

Image

Link

Note

Pages will result in a 404 error if the URL contains a space at the beginning or end.

Video

Phone

123456789

Email

Location

streetAddress, postalCode, region, city, country

577 College Ave, 94306, CA, Palo Alto, US

Business Hours

SAT, SUN: 08:00-20:00; THU, FRI: 08:00-12:00;

Social accounts

Must be formatted as name: value; name: value;

email: my@gmail.com; whatsapp: 123456; facebook: Website Builder;

Note

Supported social networks: email, whatsapp, facebook, x (twitter), instagram, youtube, linkedin, yelp, pinterest, google_my_business, waze, vimeo, snapchat, reddit, tripadvisor, foursquare, rss.

Date & Time

The following formats are supported:

  • Date and time. YYYY-MM-DD HH:MM:(SS) displays as 2021-10-07 10:15:(00)

  • Date only. YYYY-MM-DD displays as 2021-10-07

  • Time only. HH:MM:(SS) displays as 10:15:(00)

When displaying date only, the time will default to 0:00. When displaying time only, the date will default to 1970-01-01.

  • If the date and time are formatted differently than the supported formats, they will not be imported correctly and cannot be used to format or sort.

  • This field can be used for sorting when using the filters or sort functionality in the Connected Data pop-up.

Multi Select

In Google Sheets, options must be separated by a semi colon, for example: first option; second option; third option. When you import the collection to the editor, click Options to add the options. Each row in the collection can be assigned one or more of the options you created.

Note

This field can be used to filter the displayed collection in widgets, such as photo gallery, list, accordion, and custom widgets that connect to collections.

The next step is to create or convert a Dynamic Page so you can connect it to your newly created collection.

Did this answer your question?