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.
Note
Inner collections are currently not supported with Google Sheets.
Supported Data Types
|
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 |
|
|
Phone |
123456789 |
|
|
|
|
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.
Feedback on this article
0 comments
Please sign in to leave a comment.