Update website through sheets

Hi,

Is there any way to connect different components of the pro theme to e.g. a Google sheet? We are looking to make the management of all our campaigns more efficient and an idea that came up is that perhaps it would be possible to have all our product campaigns in a google sheet, and connect the sheet to different components in Cornerstone to fetch data from the sheet. An example would be that we have a sheet where we list all the interest rates for mortgages and connect our components that are displaying these products to the sheet so that when we update the interest rate in the sheet, it is reflected on the website.

Is something like this possible?

Thanks in advance and sorry if I’m being unclear with what we are trying to achieve.

should work if you can structure the CSV properly

How would you go about importing it into the components/text fields etc.?

Hey @Sandberg,

Theoretically, it might be possible if you know how to convert the Google Sheets to a JSON feed. Please take a look at this tutorial: