Writing database contents automatically to a google sheet!!!

Ask the community
,
1

Hello,

Is it possible to write the contents of the database automatically to a google sheets once it is updated using wix code?

The use case is like this:
I have added a google calendar app to show some events to my users. And I want everyone to add events to my calendar. But google calendar don’t allow everyone to add events to my calendar. I can only invite specific people to add events to my calendar.

So If I can write the contents of a wix database(collect the calendar events using a user input) automatically to a google sheet, I can use some tools available in internet(also officially from google) to automatically add the contents of the google sheet to the calendar.

I can now use a google form to collect and update my sheet and then the calendar but I want wix database to do it to make the look and feel of the webite same everywhere

Any help regarding this use case will be helpful. Thanks.

2

You can probably craft something like this using the Google Sheets APIs. Take a look at their API REST docs - you can use those APIs from Wix Code backend files.

3

Hello Yoav,
Thanks for your reply. Can you explain more about " Wix Code backend files ". What do you mean by this? is there any documentation where I can read about it?

4

Checkout this article - Velo Web Modules: Calling Backend Code from the Frontend | Help Center | Wix.com

5

Hey Nithin,

Were you successful in crafting something ?

6

Hi,
Nope. I didnt tried doing it. I started using wix database and tables instead of google calendar

7

You can do it now with npm modules, look at this example
https://www.wix.com/corvid/forum/community-discussion/example-google-sheets-npm

8

There is another (simpler) approach - one can expose API from a Google Spreadsheet using Google App Script (simply implement doGet / doPost method) and consume it with a regular http (server) client on a Wix side