Google Doc (excel) to Wix Database

Hey all,

new to coding so may need a proper guide through this.

Background. This is a basketball league website and the database is producing repeaters for fixtures (with scores, locations, logos etc.) all good. tick.
A second database, which is edited far more regularly (daily) has player statistics in. I can get the database again to produce what i need … however, updating the player stats is slow and tedious in wix database, since i cant use formula to populate percentages etc, or sort and search easily like i can in Excel.

id like to be able to edit my table in Google Docs, publish and then it to update my database in Wix… which leads to my repeaters populating my stats page

Secondly, (may be simple) how do input an image URL in excel for Wix to read it as an image and output it??
[All info i can find is going the other way, from Wix to Excel Doc]
Please help.

Zapier will format, calculate, get image url from Google drive or the service. Then post from zapier to your JavaScript in wix.

https://support.wix.com/en/article/uploading-a-google-spreadsheet-to-the-table-master-app
https://www.wix.com/app-market/google-docs/overview