So I have a Google Drive doc spreadsheet, that team representatives can access - (its a basic statistics spreadsheet for a basketball league, where only a few members have the password and can edit the sheet). I don’t want these members to be updating anything on Wix themselves - but I don’t want to do all the Stats sheets myself!!
So I need the Wix database to populate from a Google Doc (first time via CSV done) but then I need the Wix database to auto update when the Google Doc is updated. (I do not want to keep exporting as a CSV file and relink the repeater after each game update).
The Wix database will link to a (filtered and sorted) repeater to show the Leagues top 10 scorers, and MVP leaders etc. [This I can do, no issues]. But needs a Wix database to link to a repeater since I want to style and format it to fit, rather than just importing an excel looking sheet.
Happy to simple code (copy and paste!) but would rather stay away from Zapier as I’ve had no luck with that!
The above solution is from Wix → Google Sheets. You need it the other way around. Have a look at Zapier Zaps or Integromat Scenarios. They have automations available to watch for a change in a sheet, and then do something, like updating a Wix db. Will need some coding, like setting up an endpoint on your Wix site.
I have been trying to find a solution to this same issue without luck. I looked into Make and Zapier. Zapier had a better How-To video on Youtube from Wixshow, but it’s from 2017. After reading the comments, it was difficult to tell if anyone had gotten it to work. Creating a Google Sheets API through Google’s Developer tools also sounds like a potential solution, but again, I’m unable to find a thorough explanation. I tried hiring a Wix expert, but I get ghosted once I explain the job. I feel like I’ll either invest money or time into solving this, and Wix will drop an update the next week, making this as simple as a dropdown menu.