Articles on: Dynamic data (CMS)

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



  • 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

Was this article helpful?

Share your feedback

Cancel

Thank you!