Everything you need is in Google’s Sheets API. You’ll just need to develop the desired interface (dropdowns, text fields, checkboxes, etc) and then add the appropriate API interface queries.
Thanks for your quick response. Highly appreciated.
Can you describe more.,
If you can attach links, that would be great.
Thanks again.
Chathuranga.
@usernavesta Refer to the Google Sheets API web services .
Thank you Yisrael! Sounds great!
How safe is this?
We are dealing with patients’ information (ePEI) and using GSuite.
Could someone reach out the data during transfer from Wix to Gsuite?
We should be HIPAA compliant.
Thanks,
Everything is handled in backend code. As long as you conform to “best practices” and make sure that all sensitive information is in backend code and is not exposed in frontend you should be OK.
@yisrael-wix thank you.
The example worked great with my GSuite.
Is there any edit necessary in the backend files? or just copy/paste works? (assuming all items IDs are identical)
I created a simple site identical to the example.
The configuration page works fine and I have all the values in the db. But, nothing happens when I press Save in Home page.
At the beginning, the form detected the non-configured db and showed the proper message as expected.
All items’ ID, permissions, page codes, backend files, installed googleapis, and Guite settings are identical.
The only thing I can think about is any required edit in the form page codes or any backend files.
Thanks,
Ali
Hi, Any idea?
My website is identical with the example.
This console message is similar for my website and the example.
The configuration is done and I have everything in db and Save button activated.
But, nothing happens when i click on Save on my website. The example is fine though.
I have this error in googleSheet.jsw of my site as well as the example. But, the example works.
any help is greatly appreciated.
Ali
@2971984 These errors are not related to the problem. try adding console.info() at your code and follow the logs in the dashboard → settings → site monitoring → site events.
Since you have no errors I suspect the event on your save button is not set correctly, try to remove the event from the button and recreate it.
On the server side, do not forget to add the npm package for googleapi.
@gal-morad Thanks, removing and recreating the Save button’s event did the job.
Cheers 
Hey guys,
Just thought you guys should know that the ‘refreshAccessToken’ is being deprecated now. Following is the message relayed during a call.
(node:1) [google-auth-library:DEP007] DeprecationWarning: The refreshAccessToken method has been deprecated, and will be removed in the 3.0 release of google-auth-library. Please use the getRequestHeaders method instead.
Hi, this is perfect thank you! Everything is working, but I need to add more data, please can you let me know what areas I need to edit to add this extra data.
If you need to add more data to the inserted row, just add it to this method call in the homepage.
saveFormData([$w(“#firstNameTxt”).value, $w(“#lastNameTxt”).value]).
Thank you
@gal-morad THANK YOU! it works perfectly
hi Yisrael
i was able to follow your test site and got it working.
However could you show in more detail how to do this on my own site thats already built.
i copied all the backend files already as well as added the googleapis.
which parts on the code to i need to customize to my google sheet ID etc and reference my own form in the code.
Thanks
Sholom
All the account and sheet customizations are in the configuration form.
thanks for your response.
still need to understand,
Are you are referring to the credentials file i download?
if yes where do i put this info in my own website.
thanks
The configuration form saves this data into a data base, you need to create data base at your site that will be the same as the db in the example.
hey,
can you Add GID so that we can update a specific sheet, not just the very first sheet