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!