Dynamic Pages: Using Google Sheets to Create a Collection

One option for creating collections is Google Sheets. To select this option, select “Content,” “Business Content,” and “Collections.”

Note: you must have a Google account and populate the relevant Google Sheet prior to connecting in Without Code.

Click “+ New Collection.”

Select Google Sheets and follow these steps:

• Sign in with Google (ensure you’re logged in to the Google account containing the collection)
• Select the Google Sheet you want to use
• Select “Connect Spreadsheet”

Define the data type for each field and click done. The following table outlines the field types and examples.

Note: inner collections are not supported with Google Sheets.

Now, you can move on to Dynamic Pages, which will allow you to connect your collection.