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
ggreat
test123
Blue
test test
15
sheela
Khoury
Teal
9000
12
john
John
green
545254
16
sheela
Khoury
Teal
9000
14
tim
Attic
green
2048
13
yello
Rhythm
Yellow
13
11
tom
222
orange
10762
9
lalalaa
Chef
White
52000
7
lalalaa
House
Red
87653
8
lalalaa
World
Green
292
6
lalalaa
Pitt
violet
fh
5
lalalaa
Walhbergg
Blue
90210
4
lalalaa
Smith
green
29323
3
lalalaa
Runner
indigo
20000000
10
1
1
1
1
13
Buster
Rhythm
Orange
37
12
Test Nicola
John
Doe
545254
10
Miicheal
Scott
Red
1111

Did the solution work for you?

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