Dynamic data from Google Sheets spreadsheet

Creating a dynamic page will allow you to display information from a Google Sheet on different pages by setting up just one page.

I'll walk you through how to set up your website and spreadsheet to display data from a Google Sheets spreadsheet on your web pages, step by step.

Use spreadsheets with up to 2500 rows. Otherwise the page loading speed will critically decrease, potentially leading to complete freezing.



Create a page and name it.
For example https://example.unicornic.com/apps



Create a Google Sheet and add a column header for the page names on your website.

Here's the order of priority:
pageUrl: This takes top priority for exact control of the link name.
title: This allows automatic link generation based on the provided info.
page: This is a backup option if neither of the above is available.



Add some data to the spreadsheet



Publish spreadsheet as a .сsv file and copy the resulting link





Add a spreadsheet .сsv file URL in the Page settings to the source field and save it:



The validation process will be quick, and you'll have access to information that will be useful to you in the future.

Let's move on to setting up the page.

Add any component and insert the syntax provided after validating the table {{ $heading }}, where the corresponding text from the spreadsheet will be displayed.
It's important to follow the syntax {{$column_name}}.
Make sure to specify the column name exactly as it appears in the spreadsheet .



Let's create a link to a dynamic page that is formed of the name of your page and the name in the "page" column in the spreadsheet .

For example:
/apps + /unicornplatform = https://example.unicornic.com/apps/unicornplatform


Now you can navigate to the dynamic page using the link
Results are visible in live only.

Updated on: 27/08/2024