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

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"
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: 11/03/2025