> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.blab.co/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Dynamic Content: Google Sheets Collections

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](https://intercom.help/book-like-a-boss/en/articles/10378984-dynamic-content-collections-for-regular-pages)). For more information on *Connected Data* with Business Info, see [Dynamic Content: Business Info, Text, and Images](https://intercom.help/book-like-a-boss/en/articles/10379001-dynamic-content-business-info-text-and-images).

For an overview on Collections and formatting guidelines, see [Dynamic Content: Collections](https://intercom.help/book-like-a-boss/en/articles/10378970-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

|  | Internal Collections | Google Sheets | Airtable | External |
| ---- |
| Collection Number per Site | 100NoteLegacy Pro and Team plans are limited to 1 | 100 | 100 | 100 |
| A single collection's data | N/A | 20MB | 20MB | 20MB |
| Rows | 500NoteLegacy Pro and Team plans are limited to 10 | N/A | N/A | N/A |
| Fields (columns) | 50 | 100 | 100 | 100 |
| Collection name character limit | 50 | 50 | 50 | 50 |
| Field name character limit | 50 | 50 | 50 | 50 |
| Page item URL character limit | 350 | 350 | 350 | 350 |
| Text field character limit | 5000 | N/A | N/A | N/A |
| Inner collection Rows | Not supported | Not supported | Supported | N/A |
| Image Collection | Supported | N/A | N/A | N/A |
| Update data | Site/content library publish | Automatically | Automatically every hour | Automatically |

# Available Fields

| Data Type | Examples | Notes |
| ---- |
| Plain Text | Welcome to my dentist office. | Standard text, can be used for widgets such as title tags and text widgets. |
| Rich Text | Welcome to my dentist office. | Text styles will not carry over. Links added with an <a> tag (for example <a href="domain.com">Example LInk</a>) in Google Sheets will be retained. |
| Image | [https://irp.cdn-website.com/tr59jkwo/dms3rep/multi/name.jpg](https://irp.cdn-website.com/tr59jkwo/dms3rep/multi/name.jpg) | To upload an image in the editor and obtain its URL:In the In the left panel, click Content, click Media Manager.Upload an image or if it's already uploaded, locate it.Hover over the desired image and click Select.The image and additional information should appear. Under the larger thumbnail, click the name of the file (for example: name.jpg).The image should open in a new tab with it's URL in the browser's address bar. |
| Link | Example:  [https://goo.gl/maps/F81HPm4CBTQSTsJ5A](https://goo.gl/maps/F81HPm4CBTQSTsJ5A) | Pages will result in a 404 error if the URL contains a space at the beginning or end. |
| Number | 10,000 | After selecting the Number Data Type, click Format to format the number. |
| Date & Time | 2021-10-06 16:12:00 | The following formats are supported:Date and time. YYYY-MM-DD HH:MM:(SS) displays as 2021-10-07 10:15:(00)Date only. YYYY-MM-DD displays as 2021-10-07Time only. HH:MM:(SS) displays as 10:15:(00)When displaying date only, the time will default to 0:00. When displaying time only, the date will default to 1970-01-01.If the date and time are formatted differently than the supported formats, they will not be imported correctly and cannot be used to format or sort.This field can be used for sorting when using the filters or sort functionality in the Connected Data pop-up. |
| Business Hours | SAT, SUN: 08:00-20:00; THU, FRI: 08:00-12:00; |  |
| Location | 846 Kerry Way, 90017, CA, Los Angeles, US | Format: streetAddress, postalCode, region, city, country |
| Video | [https://www.youtube.com/watch?v=8EsYwAKxAFU](https://www.youtube.com/watch?v=8EsYwAKxAFU) | Vimeo, YouTube, and Dailymotion videos are supported (videos uploaded to the editor, aren't able to be added in Collections).The following formats must be used:YouTube: https://www.youtube.com/watch?v=8EsYwAKxAFU)Vimeo: https://player.vimeo.com/video/77523904Dailymostion: https://www.dailymotion.com/embed/video/x70n2l8 |
| Email | [email@email.com](mailto://email@email.com) |  |
| Phone | 123456789 |  |
| Social Accounts | email:  [my@gmail.com](mailto://my@gmail.com) ; whatsapp: 123456; facebook: Website Builder; | Format must be: name: value; name: value;Supported social networks: email, whatsapp, facebook, twitter, instagram, youtube, linkedin, yelp, pinterest, waze, vimeo, snapchat, reddit, tripadvisor, foursquare, rss. |
| Multi-Select |  | In Google Sheets, options must be separated by a semi colon, for example: first option; second option; third option. When you import the collection to the editor, click Options to add the options. Each row in the collection can be assigned one or more of the options you created.This field can be used to filter the displayed collection in widgets, such as photo gallery, list, accordion, and custom widgets that connect to collections. |

# Connect a Google Sheets Collection

To connect a Google Sheets collection:

1. In the left panel, click **Content**, click **Collections**, and then click **+ New Collection**.
2. Click **Google Sheets**.
3. Click **Sign in With Google**.
4. Sign in to the Google Account that contains the collection.
5. 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.

6. Click **Connect Spreadsheet**.

7. Define the correct data type for each field.

8. 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**, then click **Collections**.
2. Click to open the Google collection.
3. Click **+Add Field**.
4. Select the data type from the **Data Type** drop down menu and type the name of the field in the **Field Name** space.
5. Click **Refresh Data**.

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