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 |
|---|---|---|---|---|
5 | Joe | Walhbergg | Try | 90210 |
15 | testestsetsets | testestsetsets | testestsetsets | 123456789 |
10 | Micheal C | CZ | FUCKING GOLD | 1 |
2 | red | brasil | This not work | 342 |
11 | tom | dacad | tt | 10762 |
7 | Idiot | vcacavcad | This not work | 87653 |
9 | Busta | Rhytm | TESTING | 2 |
6 | Bradd | Pitt | This not work | 123 |
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 |
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