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
16
Dan
Dan
Red
12345678
13
Buster
Rhythm
Yellow
13
12
Test Nicola
John
green
545254
10
Miicheal
Scott
green
1111
6
Brad
Pitt
violet
fh
8
Hello
World
Green
292
11
weaarrrr!!!
222
orange
10762
15
NANA
eric
white
123
3
wrwrwer
Runner
indigo
20000000
2
test
test
Blue
test test
9
Master
Chef
White
52000
7
Janee
House
Red
87653
5
Test
Walhbergg
Blue
90210
4
Brian
Smith
green
29323
14
Tsroy
Attic
Red
2048
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