How can I have data auto send to Google Sheets from Ascend Contact Form?

Ask the community
,
1

Hi everyone!

I am looking for a way to have the data automatically sent from the Ascend Business Tool contact form to my Google Sheet. I am not sure on how to do the coding for this, and I have not been able to find a good tutorial online.

I have tried using the =importxml() function, but it is not populating the fields and I think this is because the URL is within my website’s dashboard.

Is there another way I can do web scanning or create the right command? And where would I enter the code?

Any help would be much appreciated.

2

Hello,

You can probably use the onWixFormSubmitted( ) handler to retrieve the information submitted into the form and then use a google sheets external library to send or receive that data from google sheets.

I found two these helpful posts that will give you a better idea:

Feel free to post your code here if you’re still having trouble, so we can try helping you out a little better.

Best regards,
Miguel