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 | 100 |
Text field character limit | 2000 |
Collection name character limit | 50 |
Field name character limit | 50 |
Update data | Automatically |
To create a Google Sheets collection:
- In the left panel, click “Content”, click “Collections”, and then click “+ New Collection”.
- Click “Google Sheets”.
- Click “Sign in With Google”.
- Sign in to the Google Account that contains the collection.
- Select the Google Sheet you want to use as your collection.
- Click “Connect Spreadsheet”.
- Define the correct data type for each field.
- Click “Done”.
Supported Fields
Field Type | Example Content |
---|---|
Text | Welcome to my dentist office |
Image | https://www.domain.com/img/name.jpg |
Link | https://goo.gl/maps/F81HPm4CBTQSTsJ5A |
Video | https://www.youtube.com/watch?v=8EsYwAKxAFU |
Phone | 123456789 |
email@email.com | |
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; |
The next step is to create or convert a Dynamic Page so you can connect it to your newly created collection.