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.
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
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!