Google Sheets can be used as a collection for generating Dynamic Pages. For more information on collections, see Define a Collection for Dynamic Pages.
Follow the steps below to create a collection for Dynamic Pages using Google Sheets:
Navigate to Content > Business Content > Collections and click New Collection.
Select 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 (see Supported Data Types below).
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 | https://www.youtube.com/watch?v=8EsYwAKxAFU |
Phone | 123456789 |
email@email.com | |
Location | streetAddress, postalCode, region, city, country577 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.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article