I am not a dev, so you will need to dumb this down for me. I managed to make a Database Collection and a form that submits to the database. Is there any way to sync a Wix database collection with Google Sheets? I have a bunch of people I want to access the data that have nothing to do with the Wix site itself. Thanks.
Hello Simon,
In order to achieve that, you will have to sync your Wix Code database with Google sheets by using Google Sheets API (available here ).
For a much simpler option you could create an ‘internal page’ directly on your Wix site that displays the information, either by writing custom code to pull the data from the database or by using a dataset and a table. You can then secure the page by adding a password.
Hi,
Could you explain a litle more, please?
Could you send some example?
I need to load spreadsheet infos (ms-excel) into wix colletions only one time.
How is the quickest way to do it? I’ve trying ‘copy and paste’ without sucess. All information are pasted into only one cellula…
yes, wee need more insight, please.
Hi Cesar,
If you only need to do a one time import use the import system.
See more info here
hey guys.
I’m trying to do the same thing here. I made a table and connected to a data set, but I get a “loading” message when trying to view the published table in a browser.
Any insight/solutions?
KG
Hi,
Make sure that your sandbox and live database are synced with the right permissions.
For more information:
https://support.wix.com/en/article/how-to-set-permissions-for-a-database-collection
Good luck!
Roi.
It is now possible using npm. Check out Yisrael’s cool example https://www.wix.com/code/home/forum/wix-tips-and-updates/example-google-sheets-npm
make sure you enable a wix cookies and 3rd party cookies in your browser
Hello Shan… Im trying to make an external database in google sheets with npm packages… can you help me?
@equipegamegratis Hi, I might be able to help,
What do you need?
@plomteuxquentin Hello Quentin! Thank you very much for your response.
Actually I have just managed to quickly send data from a sheet to a database using “wix-fetch” and the “shareble” link from a spreadsheet.
This will help me, but if I could turn this sheet into a actual external database (and not just send “sheet to wix”) using npm, would be perfect.
I tried to do this making some changes on Yisrael’s codes but it didnt worked, so I am really confused if it just need some code adjustment, or if I need to build an adapter or something harder.
Any suggestion or insight you can give me, it will be awesome! Thank you so much in advance!
@equipegamegratis I’m about to start the same project for a client of mine. I going to create an adapter based on google npm package. The first stage would be to read schema, data and filter data. The second stage will be about writing operation.
I don’t know your coding level, but adapters are pretty advance to build.
Would you mind sending me the details of your requirement at quentin@legmeup.be ?
In the meantime, I would be glad to share any insight I have, ask your question 