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
2. Connect Google Sheets to Your Website
3. Add Google Sheets Data to Your Website
4. Automatic Updates
5. Video Tutorial
F.A.Q
Сreate a new page and name it, for ex. "...unicornplatform.page/apps"
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
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.
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}} )
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.
1) "Undefined" in a Directory Component
How to Resolve "Undefined" in a Directory Component
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
2. Connect Google Sheets to Your Website
3. Add Google Sheets Data to Your Website
4. Automatic Updates
5. Video Tutorial
F.A.Q
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
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.
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}} )
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
F.A.Q
1) "Undefined" in a Directory Component
How to Resolve "Undefined" in a Directory Component
Updated on: 16/04/2025
Thank you!