Google Sheets Collections

Available on Agency plan and higher

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 Site100
Collection name character limit50
Field name character limit50
Page item URL350 characters
Update dataAutomatically

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.

Supported Fields

Field Type

Example Content

Rich Text

Welcome to my dentist office

Plain Textwelcome to my office



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








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:; whatsapp: 123456; facebook: duda;


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

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

Was this article helpful?
0 out of 0 found this helpful

Please Log in as a Pro

Priority Phone Support is available exclusively to Pros. Log in to your Pro account now to see our international support numbers.

Log In
Not a Pro? Purchase a Pro plan!