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
Cristine
Ahrens
Pink2222
1234
3
Maria
Santos
Blue
3214
4
Chagonight
will
green
29323
9
Busta
Rhytm
Orange
52000
7
Idiot
Fool
Red
87653
15
Fred
Flinstine
Sienna
8888
8
Willl
Smith
Green
500
5
Loki
Walhbergg
Blue
90210
10
Micheal
Scto
lRed
1
6
Bradd
Pitt
violet
fh
12
john
John
green
545254
14
tim
Attic
green
2048
13
yello
Rhythm
Yellow
13
11
tom
222
orange
10762
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