HomeRoadmapCommunity forum
Knowledge base
Go to Uplisting
Start typing to search…

Dynamic Content: Google Sheets Collections

Google Sheets can serve as a collection, allowing you to create Dynamic Pages see (Dynamic Content: Dynamic Pages as well as enhance regular pages. Using a collection on a regular page is similar to how Connected Data is used with the site's Business Info see (Dynamic Content: Collections for Regular Pages. For more information on Connected Data with Business Info, see Dynamic Content: Business Info, Text, and Images.

For an overview on Collections and formatting guidelines, see Dynamic Content: Collections

📘

NOTE

Only native Google Sheets are compatible. For example, spreadsheets that are uploaded to Google Drive and not saved as a Google Sheet will return an error if selected.

Limitations and Specifications per Collection Type














Available Fields



















































Connect a Google Sheets Collection

To connect a Google Sheets collection:

  1. In the side panel, click Content.
  2. Click Collections, then click +New Collection.
  3. Click Google Sheets.
  4. Click Sign in With Google.
  5. Sign in to the Google Account that contains the collection.
  6. Select the Google Sheet you want to use as your collection.
📘

NOTE

Only native Google Sheets are compatible. For example, spreadsheets that are uploaded to Google Drive and not saved as a Google Sheet will return an error if selected.

  1. Click Connect Spreadsheet.
  2. Define the correct data type for each field.
  3. Click Done.
📘

NOTE

Inner collections are currently not supported with Google Sheets.


Add a New Column to a Google Sheets Collection

To add a new column to a Google Sheets collection:

  1. In the side panel, click Content.
  2. Click Collections.
  3. Click to open the Google collection.
  4. Click +Add Field.
  5. Select the data type from the Data Type drop down menu and type the name of the field in the Field Name space.
  6. Click Refresh Data.

The new column appears in the available fields when connecting a widget.


Set Google Sheets Collection Sync Frequency

By default, external collection data is synced every hour. However, due to API call limits on different platforms, this can quickly deplete available calls and lead to service disruptions. To prevent this, you can set how often your external collection data is synced. This allows you to ensure you do not exceed the amount of API calls your external collection platform allows.

To set how often external collection data is synced:

  1. In the side panel, click Content.
  2. Click Collections and open the desired external collection.
  3. At the top of the external collection under Sync data every, use the arrows to select a number, then use the dropdown menu to select either Hours or Days. By default, Automatic is selected. This is the default and means your collection data is synced every hour. Note that the sync timing only applies to the current external collection. You must set each external collection sync timing individually.
  4. Click Save.




Troubleshooting

I received a This app is blocked error

The issue was caused by a security change on Google's end that we had to comply with.

To fix it:

  1. Navigate to myaccount.google.com/connections.
  2. Search for Website Builder.
  3. Click Delete all connections you have with Website Builder.
  4. Go back to the editor, and try to connect again.

Updated 17 days ago

What’s Next