I have my data in google sheets. That data is basically parsed from the web through basic web scraping and thus it keeps on changing.
I want to display that on my website through the Wix content manager.
The data must sync automatically*
Is there any way to do that?
Thanks.
Example: Google Sheets NPM demonstrates how to interface with Google Sheets.
Thank you @pprathi189 for this post, it is still, one year later, a very important topic! And I can’t find any straightforward way to do it!
Were you able to make any sense of the Example: Google Sheets NPM , does it still work?
Or maybe you found any other, more robust solution?
I might be currently in half way of the process. By following the steps listed here:
Google Sheets Integration I was able to integrate Google Sheets in a way that I can pull cells from Google Sheets to front-end elements (for eg. text). However I have no idea how to connect Google Sheets to the Content Manager.
Does anyone know if this is the right direction I am heading, or is it a dead-end?
@yisrael-wix ?
Thank you for any hints!
What exactly do you mean by “connect Google Sheets to the Content Manager”? The Google Sheets Integration package provides a way to access Google sheets. You then will need to develop the code for the rest of the functionality - reading and writing data from the sheets, etc.
Good point! Let’s refer to the question in the post title and agree that we would like fulfill the condition:
“the data must sync automatically”
In other words, the moment we change a value in Google Sheets or we add a new column/row, the same happens in Content Manager, without exporting any csv or clicking any button.
You say, we "need to develop the code for (…) reading and writing data from sheets, etc. Is there anything more you could tell us about it? Do you know any examples showing any robust solution and how to do it step by step?
Syncing the data automatically from the Sheet to the Content Manager would be dependent on the capabilities of the Google Sheets environment. You’ll need to check with Google to see if their API and environment supports events and scripting. If so, you can expose a site API using HTTP functions that would accept fetch requests from Google and update your collections in the Content Manager.
Hey Chris
Via Zapier, I’m able to push new/modified records to wix collection in real time. You can dm to me to get more details on the solution.
Check this link, Im fetching this data live from googlesheet
Super new here, could even find how to DM you. But I would love this solution that you are proposing!
I have detailed the solution in my blog>
https://www.ditaps.com/post/view-google-sheets-contents-on-your-website-real-time
regards
sneha shah