Importing form submissions to a google sheet

Ask the community
,
1

Hi,
I want to get all my website subscribers and registration imported to a google sheet as soon as a visitor fills the form.

Is there a way to do this using Wix Code?

1 Like
2

Yes, look here
https://wixshow.com/p/send-form-data-to-google-sheet-using-wix-code

3

Hey Andreas,
I have used your code to send data to zapier and then to my google sheet but zapier cannot find the hook.
Can you let me know what I have done wrong in this code:

import {fetch} from ‘wix-fetch’;

export function button1_click(event, $w) {

const url = “https://hooks.zapier.com/hooks/catch/3199029/w3lfqo/”;

let name = $w(“#name”).value;
let emailId = $w(“#emailId”).value;
let companyName = $w(“#companyName”).value;
let phoneNumber = $w(“#phoneNumber”).value;
let additionalGuests = $w(“#additionalGuests”).value;

let data = {
“name”: name,
“emailId”: emailId,
“companyName”: companyName,
“phoneNumber”: phoneNumber,
“additionalGuests”: additionalGuests
};
console.log(data);

var bodyData=JSON.stringify(data);

fetch (url, {method: 'post',body: 'bodyData'}) 
    .then((httpResponse) => {

if (httpResponse.ok) {
return httpResponse.json();
}{
return Promise.reject(“Fetchdidnotsucceed”);
}
})
.then(json => {
console.log(JSON.stringify(json));
$w(“#button1”).disable();
$w(“#button1”).label=“Thanks for submitting the data!”;
})
. catch (err => console.log(err));
}

4

you can do it now with npm, you can find full exmple here:
https://www.wix.com/corvid/forum/community-discussion/example-google-sheets-npm

5

Damn Link is broken :frowning: Andreas have you given up on the wixshow.com? We are transitioning from Wordpress and Landing page builders. How much do you charge for travel site that sends data from database collection to active campaign after form submission and triggers button click to analytics software.

And I’ll pay you to show me how you did it, I want to learn Javascript and master wix code.

6

I purchased your code package but I still need help implementing. Check henryshere1@gmail.com in your buyers list. How much is your time worth? I can help you market the Wixshow, think it’s a great idea. Here is the link to the funnel framework we would use to build your engaged subscriber list and youtube channel → https://lh4.googleusercontent.com/Qkdyy3lqoNNqN-twp77JEHNYdIozJMVIufEfuNjSywh4tJJf8yP6j6-EyD36RnOHNObEQmAj-BUPn06IGxGoVlHyyQ1OtVjGQhvo3cmiuJD9yVWh9EyBUULUrCwC8-WDV2kRBh_S. Quit your day job my friend, don’t listen to friends and family :slight_smile: all you need is a better funnel, wixshow.com is the right idea.
I have a business that sell high ticket vacation memberships. Currently I use Active Campaign, Typeform, Checkfront.com and other popular 3rd party software embedded into wix as the page builder. I want to use only Wix. If you can help me I’ll pay you good. https://www.travelwise.co

7

@jaoshsethna you do not have to pay another middle man, you can do it with wix only , see below