It works perfectly> Thank you so much. Just remember to save the script before deploying. And also don't forget to check your google sheet as the form is sent in a new sheet (check the down tab in google sheet).
Thanks for this video. I understand that the data arrives at the sheet in different tabs. Is there a way to receive every email on the same tab one below the other?
Loved this. Can you make something like this but inverse ? Where google sheet data can be automatically updated on the website frontend through ACF maybe?
Thanks! What you ask is possible, but complex... Only people very good with JavaScript could make ready use of the exported google sheet data. If you are good with JS, then lookup 'Google sheet to JSON'. You will learn how to export the data in a JSON object, and then you can make use of that object in your webpage using Javascript.
Nice!! Anyway, if I have 2 different forms and want to make them into 2 separate google spreadsheet files, should I create a separate webApp URL for each? because I need to share the response with the client. many thanks!
Thank you so much for this. It works brilliantly. How can I add the means to have a unique ID number added to the row for each form submission? The idea being that if someone submits multiple forms over time then each of their submissions have unique ID number. Numbers and characters would be useful. Thank you Dan
i just follow the step by step guide. at final make sure you open the new sheet automatically created after the sheet1 called "New Form" the submissions go there.
Unfortunately it's not working for me :( For every form submission on my website there's a new table created in my google sheet document. But no data is being filled in. I just get sheet2 and sheet3 etc always everything empty... Do you have any clues on how I could fix this? EDIT: Oh it worked now! My mistake was in Elementor I had under Webhook the tab "advanced data" turned on. Just had to turn it off Thank you :)
Thank you for this video. The new tab in my sheet is still empty, I saw in other comments I have to turn off "advanced data" in the Webhook setting in Elementor, but I don't have this option. I can only see the "Webhook URL" field. Could anybody help ? Thank you
I have followed the instructions and cannot get it to work. Google has moved some stuff around. You now have to go to extensions and select "app script." From there the instructions are pretty much the same. Is the code not workable in the latest version of google forms? The google form just remains blank. Any ideas?
Hey John! It's still working. Yes indeed they changed a few things... they constantly mess with stuff. However everything should still work just fine. I have a form that is setup in this way, that received a new submission just 12 minutes ago. It's been working without fail since I set it up, about when I published this video here. So not only this is still working, but it's very reliable, I am glad to report! If it doesn't work for you probably there is something else preventing it. There are many small things that can break this so I can't really say what might be the problem in your case. Maybe the name of the sheet? Maybe it does work, and created a new sheet, and you didn't notice? Cheers!
@@elementhow691 I got it working! I am not sure what I did wrong but I noticed that the spreadsheet created a new tab at the bottom. I clicked on the new tab and the info was there. I just deleted the first tab and it works fine. So if this happens to someone else they should make sure there isn't a new tab created. Thank you so much for your quick response! It works great. Thanks for making the video.
For me it worked, but they are only coming with simple data (name, email, form_id and form_name), while yours came complete (Time, Date, Page URL, Remote IP, etc). Do you know how I can return the complete data?
@@elementhow691 It doesn't work, I already tried. The worksheet simply does not communicate when I activate the key "Advanced data". And, when you did, you also didn't activate the key and get richer data.
@@AleMaciel. Yes indeed... sorry I don't know why this happens actually. Maybe Elementor changed something with the data that is sent, since I recorded the video.
@@elementhow691 yes, it could be... the strange thing is that the data collected by the Subscriptions field, in Elementor inside WordPress, keeps coming with all this complete data.
@@elementhow691 I found out what happens. The 'Email' action must be activated and these options must be selected in the 'Meta' field. At least for me that's what solved it.
You can sort the data in the Google Sheet so that the IP and other stuff not wanted is at the end. Just reorganize your columns in your google Sheet! (See the written tutorial for more info on this)
It's been a year from your answer but I try :) The option "advanced data" doesn't appear in my webhook setting... Do you have any idea why ? Thanks a lot.
![เป็นไปได้ไหม - WanMai [Teaser] | 05-12-24](http://i.ytimg.com/vi/P5Uto6e453w/mqdefault.jpg)
It works perfectly> Thank you so much. Just remember to save the script before deploying. And also don't forget to check your google sheet as the form is sent in a new sheet (check the down tab in google sheet).
broo you saved my life, thx a lot
Men you are a GOD. Thank you so much
Thank you! Works perfectly.
Wonderful. This might be the 2nd time you help me bigtime!! Merci
It worked. Thank you.
Thanks for this video. I understand that the data arrives at the sheet in different tabs. Is there a way to receive every email on the same tab one below the other?
You did a great job .. Thx Bro Its worked for me :)
Important: Press Save Script (disk icon) before the Deploying Script button. (@ 1.36 )
Yes, thank you!
And if you rearrange the columns, the data will populate to the correct columns!
@@elementhow691 how about if you add new form fields etc?
it works for couple of columns up to 7, but more than that the column just display blank
form submitted sucessfully but record not saved in google sheet
Thank you, very useful. Does it have to be re-deployed after editing the script?
I think yes...
if I rename the tab sheet it will make a new form again and again
Is there an entry limit? becase not every entry is showing in the form
Loved this.
Can you make something like this but inverse ?
Where google sheet data can be automatically updated on the website frontend through ACF maybe?
Thanks!
What you ask is possible, but complex... Only people very good with JavaScript could make ready use of the exported google sheet data.
If you are good with JS, then lookup 'Google sheet to JSON'. You will learn how to export the data in a JSON object, and then you can make use of that object in your webpage using Javascript.
Thank You So much
You're most welcome
Nice!! Anyway, if I have 2 different forms and want to make them into 2 separate google spreadsheet files, should I create a separate webApp URL for each? because I need to share the response with the client. many thanks!
Yes, exactly! Essentially, you start from fresh for each new form!
Thank you so much for this.
It works brilliantly.
How can I add the means to have a unique ID number added to the row for each form submission?
The idea being that if someone submits multiple forms over time then each of their submissions have unique ID number.
Numbers and characters would be useful.
Thank you
Dan
thank you, it works!
mine did not work how did you do it
i just follow the step by step guide. at final make sure you open the new sheet automatically created after the sheet1 called "New Form" the submissions go there.
Unfortunately it's not working for me :( For every form submission on my website there's a new table created in my google sheet document. But no data is being filled in. I just get sheet2 and sheet3 etc always everything empty... Do you have any clues on how I could fix this?
EDIT:
Oh it worked now! My mistake was in Elementor I had under Webhook the tab "advanced data" turned on. Just had to turn it off
Thank you :)
Thank you for this video. The new tab in my sheet is still empty, I saw in other comments I have to turn off "advanced data" in the Webhook setting in Elementor, but I don't have this option. I can only see the "Webhook URL" field. Could anybody help ? Thank you
I have followed the instructions and cannot get it to work. Google has moved some stuff around. You now have to go to extensions and select "app script." From there the instructions are pretty much the same. Is the code not workable in the latest version of google forms? The google form just remains blank. Any ideas?
Hey John!
It's still working. Yes indeed they changed a few things... they constantly mess with stuff.
However everything should still work just fine.
I have a form that is setup in this way, that received a new submission just 12 minutes ago.
It's been working without fail since I set it up, about when I published this video here. So not only this is still working, but it's very reliable, I am glad to report!
If it doesn't work for you probably there is something else preventing it. There are many small things that can break this so I can't really say what might be the problem in your case.
Maybe the name of the sheet? Maybe it does work, and created a new sheet, and you didn't notice?
Cheers!
@@elementhow691 I got it working! I am not sure what I did wrong but I noticed that the spreadsheet created a new tab at the bottom. I clicked on the new tab and the info was there. I just deleted the first tab and it works fine. So if this happens to someone else they should make sure there isn't a new tab created. Thank you so much for your quick response! It works great. Thanks for making the video.
thats works great!
How can I get the date and time to show on google sheet when someone submits a form. current it doesn't show that
For me it worked, but they are only coming with simple data (name, email, form_id and form_name), while yours came complete (Time, Date, Page URL, Remote IP, etc). Do you know how I can return the complete data?
Hey Alexandre!
Under "Webhook" option in Elementor form, try to turn on "Advanced data". Let me know if that works!
@@elementhow691 It doesn't work, I already tried. The worksheet simply does not communicate when I activate the key "Advanced data". And, when you did, you also didn't activate the key and get richer data.
@@AleMaciel. Yes indeed... sorry I don't know why this happens actually. Maybe Elementor changed something with the data that is sent, since I recorded the video.
@@elementhow691 yes, it could be... the strange thing is that the data collected by the Subscriptions field, in Elementor inside WordPress, keeps coming with all this complete data.
@@elementhow691 I found out what happens. The 'Email' action must be activated and these options must be selected in the 'Meta' field. At least for me that's what solved it.
Yes!
hello sir I'm having a problem when submitting the form it says "webhook error, this message is not visible for the sites visitors"
Hey Ryo! I don't know what the problem might be... Maybe try again from the start, with a newly created form element?
@@elementhow691 hey, I made it hehe thank you very much. do you have facebook? Let's be friends
@@ryoekipranata5736 Find my facebook in the footer of my website!
Please help why did not work to my google sheet, it isnt filled to sheet ?
does this also work with file upload?
No I don't think so. Not a format accepted in a Google sheet...
May I know how to change the time zone?
Good question! I don't really know... probably it inherits it from your WordPress settings?
unfortunately note work for me after several attempts, no data reach my google sheets :'(
anybody can help how to edit code to only receive select data? Dont wang ip adress form code etc
You can sort the data in the Google Sheet so that the IP and other stuff not wanted is at the end. Just reorganize your columns in your google Sheet! (See the written tutorial for more info on this)
i can't see form information. still sheet is blank
Click on the second tap at the bottom.
bro not working... can you help me
Tip: Turn off the 'advanced Data" option in elementor webhook setting, if you are facing no data colection issue (Automatic new tabs issue)
Thanks for sharing!
It's been a year from your answer but I try :) The option "advanced data" doesn't appear in my webhook setting... Do you have any idea why ? Thanks a lot.
can anybody get access to my data?
sheets data, since were selecting anyone option
@@priyankpatwa7800 LOL. Then this solution is pretty crap. If anyone can get access to my leads database, this solution is not A solution.
Not working
Could you be more helpful? What's not working? Did you check to see if a new sheet wasn't created automatically in the document?
@@elementhow691 I prepared it as per the annotation.
But the message does not reach Google Sheet
thank you buddy it works