Linking a Wix field to google sheet field

[mark-morton]

Hello! Some background before my question: I am only passing familiar with coding (I have not coded for 6 years), enough to read and be pointed in the right direction but not enough to understand the finer nuances of code, so be gentle with me

My task: I am trying to link particular text fields / image fields on a “Scoreboard” (which will most likely be a Container object holding text and image fields) to specific fields in a google spreadsheet .

For example, if I update the Total Score (in the spreadsheet) of a player, it will reflect this new value in the “Total” textfield of the “Scoreboard” container object.

Can this actually be done using wixcode? I already have a google sheet ready to link with and a sample site that is mostly done up; just need to find a way to efficiently update the data/info on this site instead of manually entering everything the scores change.

I am not really sure where to even begin looking, so even pointing me in the right direction would be immensely helpful. Thanks!!

[_tal]

Hi,
In order to do so, you need a REST API for the google spreadsheet. I’ve found this documentation which can be useful. In order to post / get information, you can use the fetch API .

Good luck,
Tal.

[mark-morton]

Alright cheers, will look into that and post again if I’m successful.