> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.unicornplatform.com/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 data from Google Sheets spreadsheet

Any updates you make in the spreadsheet will automatically reflect on your website — no manual editing required.

You can create a dynamic page that pulls data from a Google Sheet, allowing you to generate multiple pages from a single template.

||| For the best performance, your spreadsheet should not exceed 2,500 rows, as larger files can slow down loading times or even cause the page to freeze.

[1. Create a Page](#3-1-create-a-page)
[2. Connect Google Sheets to Your Website](#3-2-connect-google-sheets-to-your-website)
[3. Add Google Sheets Data to Your Website](#3-3-add-google-sheets-data-to-your-website)
[4. Automatic Updates](#3-4-automatic-updates)
[5. Video Tutorial](#3-5-video-tutorial)

[F.A.Q](#3-faq)

### 1. Create a Page
 
Сreate a new page and name it, for ex. "...unicornplatform.page/apps"

### 2. Connect Google Sheets to Your Website

* Create a Google Sheet with the information you want to display (e.g., a list of products with prices and descriptions).
 Make a copy of the spreadsheet template: [https://docs.google.com/spreadsheets/d/198Wywl-achpHVm7ouuqinDbQlwqJ8E3O49f91GysiWQ/edit?usp=sharing](https://docs.google.com/spreadsheets/d/198Wywl-achpHVm7ouuqinDbQlwqJ8E3O49f91GysiWQ/edit?usp=sharing)

* Set the sheet to be publicly viewable:
       -Click "Share" in Google Sheets.
       -Select "Anyone with the link can view".
       -Copy the link to your spreadsheet.

 ![](https://storage.crisp.chat/users/helpdesk/website/7e782a40c0560c00/image_ctqu84.png =900x900)

### 3. Add Google Sheets Data to Your Website

* Open "Page Settings" (3-dots button -> Settings)
* Go to "Data Source" → Select Google Sheets
* Paste the copied Google Sheets URL (in CSV format). Once connected, inner pages will be generated automatically
* Publish the parent page to make all inner pages accessible
* Insert data from your sheet into the page by using the following syntax `{{$column_name}}`
        (replace 'column_name' with the actual column title from your spreadsheet, for ex. `{{$title}}` )

![](https://storage.crisp.chat/users/helpdesk/website/-/7/e/7/8/7e782a40c0560c00/image_1ppey0h.png =500x500)  

![](https://storage.crisp.chat/users/helpdesk/website/-/7/e/7/8/7e782a40c0560c00/image_1ongt1o.png =1300x1300) 

### 4. Automatic Updates

Now you can easily manage content on your website by simply updating a spreadsheet.
Whenever you update your Google Sheets (add new products, change descriptions, update prices), your website will automatically refresh with the latest data.
No manual updates needed.

### 5. Video Tutorial

${youtube}[Dynamic Data From Google Sheet](x_Zo-KDlt58)
---

### F.A.Q

1) "Undefined" in a Directory Component
[How to Resolve "Undefined"  in a Directory Component](/en/article/how-to-resolve-undefined-in-a-directory-component-pxehmy/)