Articles on: Dynamic data (CMS)

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.

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



Create a Google spreadsheet and add the name "page" to the first column.
The "page" column is mandatory and contains the names of the future pages of your website.
Page names should be written in lowercase without spaces or symbols.

For example:


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: 01/03/2024

Was this article helpful?

Share your feedback

Cancel

Thank you!