How to Integrate Google Sheets with Wix Database

Lots of organizations use google sheets as their main database or run different formulas or calculations in there to analyse data. Most of them want that data to reflect on a website in a way that is appealing to an end user.

Data from Google Sheets can now be synced to Wix using a middleware tool called Integromat. This allows the entries in the sheet to be transferred to a Wix database.

In the previous solution, I showed how you can transfer data from Wix to Google sheets. This one goes the other way.


Click below for the sample Google Sheets file where you can find multiple entries in appropriate column. You can add/modify the data in the sheets.

Once you edit the data in the sheets, you can come back to this page to see the results of the data in a repeater table below which shows the same data.​

The data below is sorted by the latest modified data.

 

Repeater Table with all the database content

Title
FirstName
Last Name
Color
Number
2
v
BOB
This not work
242
15
Surya
Divya
Red
469
9
Busta
Rhytm
TESTING
2
5
Loki
Walhbergg
Try
90210
11
tom
asdasd
tt
10762
6
Bradd
Pitt
This not work
123
7
Idiot
Marcus
This not work
87653
14
putra
Attic
This not work
2048
12
john
John
Hello world
545254
8
Willl
Smith
This not work
500
4
Chagonight
will
This not work
29323
3
Maria
Santos
This not work
3214
13
yello
Rhythm
This not work
13
10
Micheal
Scto
lRed
1
13
Buster
Rhythm
Orange
37

Did the solution work for you?

Hit the button below to email me and get it integrated for your website today