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 that corresponds to 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
Great compliments sorry for my English but use the translator from Italian. With a similar script it would be possible to ensure that the attachments sent with the form end up in a Google Drive folder
Hi Suryanshu! You are pretty awesome! I have a question; i am (really) inexperienced at this! lol I am following along step-by-step and everything looks the same as what you are doing except right after I click "deploy". You get "authorize" but I get 2 links; one says "deployment ID" and the other says "web app" and i have the option to "copy" either one. Aaaaannnd then I'm lost ahah. I look after the website for a non-profit advocacy group for people with disabilities and I am trying to automate our membership list. I hope you can help me! Tks!
I continued watching and I think i found my answer! Looks like mine skips authorize! I will continue working on it and come back to let you know if i succeeded! You are really amazing at this tutorial!
How do I insert the newly sent data from the form to row two instead of the last row? I need the code to shift down the data on row two and be ready for the new data. We would like to see the information on top instead of scrolling down. Any Idea? Regards
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?
Hi Bakshi, as this video is quite old, not 100% sure you will reply but I'll try.... Is there any method to get the Elementor Form fields ordered as in the form? In my case, those are "spread-out" through the Google Sheet
@@SuryanshuBakshi thanks for the reply. I found the solution... easier than expected. Just repositioning the columns inside the google sheet... they remains "linked" with the Elementor form
great !!.............. is there a way to show the data from the google sheets to a field in contact from 7 ( for eg: if the user updates the a cell named "gold rate", the amount should be shown in the contact form 7 text field.
Thanks bro, btw How to make many item of drop down list. In Google Form we make it with script to tranfer alot of list to the Google Form drop down list question
Hey there, there is an option "Advanced Data" just below where you paste the Webhook code. Turn it On and check if it's working or not. If it still doesn't work, let me know 😊
You probably have to edit the code and I don't have much experience in that but you can always hide that particular columns in the sheet if that works for you
Once you paste the script in the script editor, make sure you save it before deploying. Even I used to miss this step in the beginning. If it's not working even after that, let me know. I'll help you out with it.
@@SuryanshuBakshi Thank you for your respond, i did save and then deploy and did all the steps exactly like in the video. but still it doesnt come to the sheet.
@@SuryanshuBakshi i just got 1 of the forms but after 12 hours, so it works great but does it usually takes this long to appear in the google sheet? and thank you for you help, you are amazing ;)
@@herwinjuniorsitumorang5785 I won't be able to help you here, can you drop me a text on Instagram if it's Okay with you? Link - instagram.com/suryanshubakshi/
I was searching copper but I found gold...thanks
You're welcome Man, you just made my day 😊
@@SuryanshuBakshi😊likewise thanks!!
Still working perfectly. It returns the mixed columns, but you just have to manually adjust! Thx man. 👍
WOW a tutorial that actually worked I have spent hours today, thank you!
It's very informative video sir appreciate you for producing this kind of content
I just tried it today, and it worked perfectly. Thanks for the tutorial
Thanks man. A simple and concise walkthrough. Really helped me link my wordpress form to google sheets.
You're welcome 🙂🙂
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 that corresponds to 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 very much. Everything works fine!
Thank You so much for delivering actual content
You're welcome 🙂🙂
Great compliments sorry for my English but use the translator from Italian.
With a similar script it would be possible to ensure that the attachments sent with the form end up in a Google Drive folder
Thanks For This Important video.
But How To Edit Time Zone On That Script
thank you so much, I would like to know how can make many element or form in same google sheet just to add section in the bottom the page ?
How can i exclude labels like: form_id, powered by, pageURL,UserAgent, RemoteIP? I try to delete in the sheet but it doesn`t work :((((
I need it too
Delete it in the script
Thanks for the tutorial, i was really in need of it, may shri shyam bless you ❤🙏
Comments like these makes my day ❤️ you're welcome
Bhai maja aagya ... Thanks yrr ... Love from jaipur ❤️
You're welcome bro 😄
excellent video, thank you Suryanshu
Thanks for the tutorial! So if we have several forms with different google sheet destinations, we should make an app for each document?
No, just one webhook code will work on all the forms. Remember to change the Form name otherwise it will mix all the leads
Clean and simple explanation thank youuuuu!
The only think that I don't like from this video is that I only can like it once
Great JOb
You just made my day 😍 thank you so much
what about when i have many forms on website with different fields ?
I follow the same step. Form shows ( the form has been sent successfully ) but I'm unable to find that data in sheet
+1
Hi! Thanks for the great video
Could you do another tutorial to add another form in a new tab please ? Thanks!!
It works perfectly, thank you!
You're welcome 🙂
Thx man how you made the form ? are you using the Elementor pro ? what kind of theme your using ?
Elementor Pro and Generate Press theme 😊
@@SuryanshuBakshi thx ❤️
Your submission failed because of an error. Webhook Webhook error. This message is not visible to site visitors.
How used copy one submited form to multiple sheets . Thanks
Thank you! Very clear and free option instead of zapier :)
You're welcome mate
from where to open github code for paste, I did not find any
Hi Suryanshu! You are pretty awesome! I have a question; i am (really) inexperienced at this! lol I am following along step-by-step and everything looks the same as what you are doing except right after I click "deploy". You get "authorize" but I get 2 links; one says "deployment ID" and the other says "web app" and i have the option to "copy" either one. Aaaaannnd then I'm lost ahah. I look after the website for a non-profit advocacy group for people with disabilities and I am trying to automate our membership list. I hope you can help me! Tks!
I continued watching and I think i found my answer! Looks like mine skips authorize! I will continue working on it and come back to let you know if i succeeded! You are really amazing at this tutorial!
Ok i've done the whole thing, exactly the same but I'm not getting the Query tab. Anyone know why? Pleaaaaase.
@@murielle126 hey, can you screen record and send me the video?
What and absolute hero you are. Thanks for this!
You're welcome mate :)
How do I insert the newly sent data from the form to row two instead of the last row? I need the code to shift down the data on row two and be ready for the new data. We would like to see the information on top instead of scrolling down. Any Idea? Regards
I guess you can sort the sheet by submission date for that
@@SuryanshuBakshi I did, but I have to do it every time on less you know a method to automate the process. We are getting a lot of form submissions.
Thank You Suryanshu!
You're welcome 😁
thanks
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?
i too
how to connect wp forms to google sheets. make a video on it
Hi Bakshi, as this video is quite old, not 100% sure you will reply but I'll try.... Is there any method to get the Elementor Form fields ordered as in the form? In my case, those are "spread-out" through the Google Sheet
Sorry bro but I don't have much idea about the script. You can play around with the code in the script i guess it will work
@@SuryanshuBakshi thanks for the reply. I found the solution... easier than expected. Just repositioning the columns inside the google sheet... they remains "linked" with the Elementor form
@@webfotografica96 awesome buddy thanks ❤️
great !!.............. is there a way to show the data from the google sheets to a field in contact from 7 ( for eg: if the user updates the a cell named "gold rate", the amount should be shown in the contact form 7 text field.
is it still work if I put file upload on the form?
Great video!!!! This Works
Very helpful - Thank you!
You're welcome!
amazing !!!! great help
Glad to hear that!
Congratulations what an excellent contribution
Glad you likes it 😊
How to get information from my sheet to make my WordPress from dropdown list?
So helpful! Thank you😄
You're welcome 😁
how do you get remote ip, timestamp, etc?
Thanks, you save my campaign!
You're Welcome 😊
keep making videos bro thank you
Thanks for the video, looking forward to having more Elementor tutorials. 💥
Thanks mate ❤️
Good, its work
Thank you, very helpful brother👌
you're welcome brother
Would you do a tutorial about: WPSyncSheets for Elementor
Good work, thank you for helping me!!
You're welcome 😁
Amazing.
Can this metode apply to woocommerce field?
Thanks😊
Which woocommerce field are you talking about?
@@SuryanshuBakshi at checkout form. It is direct to email, if add direct to spreadsheet can do it?
@@geraisepatuonline8549 Honestly, I haven't tried this on checkout form but if there is an option of Webhook, it might work 😊
@@SuryanshuBakshi oh yes understand. How webhooks integrate to woocommerce so can do it that?
@@geraisepatuonline8549 Yes, it it connects, it will work
Very useful tutorial, thanks!!
you're welcome Kevin
Thank you bro for help. It works
Happy to help 🙂
I can't see "actions after submit" and the other options in the "edit form" menu:( Do I need elementor pro or something?
Yes, it works with Elementor forms only which is available in Elementor Pro
Thanks bro, btw How to make many item of drop down list. In Google Form we make it with script to tranfer alot of list to the Google Form drop down list question
You want to make a dropdown list in Elementor form?
i created form using WPForm, i dont see webhost ? any idea ?
This only works with Elementor forms
Thank you so much. It works.
You're Welcome 😊
if i rename my tab sheet it will create new form automaticly
Yes, it creates a new tab of the form name. You can change the Form Name in elementor
Thanks man it works !
you're welcome mate
this work with upload files?
Hey Sir! Can I send the file to Gsheet and email also? like can I receive messages at both?
At the beginning of the script, you will find option for email notification. Mention your email there
@@SuryanshuBakshi thank you very much, appriciate
@@louie4509 You're welcome mate 😀
maaaaan, this is cool, thanks bro
You're welcome bro ☺️
An error occurred.
Webhook Webhook Error
This Message is not visible for site visitors.
It's showing error
Did you fix it ?
same here
sorry sir, but can i know how come my sheet does not have time and date while yours have it?
Hey there, there is an option "Advanced Data" just below where you paste the Webhook code. Turn it On and check if it's working or not. If it still doesn't work, let me know 😊
@@SuryanshuBakshi THANK YOU...it is working now. thank you for your reply.hope you have a nice day
@@rusyaidironzi9926 Happy to Help 😊 Have a great day 😃
@@SuryanshuBakshi Hi i have the same issue. i turnred on the advance data, now nothing shows on google sheet.
very helpful thaks a lot
Glad it helped ☺️
wow.. very nice
Superb SIr ,
Pleasure bro 🙂
Keep up the great work bhai ji
Thank bro ❤️❤️
Mon amie s'ils te plaît donné moi le nom de form que tu est choisi ninjaform ?? Ou wpform ?? ...
Thank you it steel working
I just need Date, Time, Name, Email, Phone Number, Message
How can I remove other fields?
You probably have to edit the code and I don't have much experience in that but you can always hide that particular columns in the sheet if that works for you
mera ye error aa raha h
Script function not found: doGet
Thanks man
You're welcome!
it didnt works in my app. after i refresh gsheet, idont find anything
Is it possible to send data from the same form to different Google Sheets?
Don't think so as Elementor forms accepts only one webhook
Hello, mine doesnt come to google sheet, the data is not getting saved there.
Once you paste the script in the script editor, make sure you save it before deploying. Even I used to miss this step in the beginning. If it's not working even after that, let me know. I'll help you out with it.
@@SuryanshuBakshi Thank you for your respond, i did save and then deploy and did all the steps exactly like in the video. but still it doesnt come to the sheet.
@@atabayat That's weird. I can drop my Instagram here if you want to connect and get this issue resolved
@@SuryanshuBakshi i just got 1 of the forms but after 12 hours, so it works great but does it usually takes this long to appear in the google sheet?
and thank you for you help, you are amazing ;)
@@atabayat Usually it happens instantly but sometimes it does take some time. Thank you so much ❤️
Script editor nhi dikh rha tools me
THANK YOU
You're welcome
its not working....it says webhook errors
Ajudou demais, muito obrigado!!
De nada companheiro
Leads not visible on the sheet
This is amazing. 🔥
thanks mate ❤️
How can I get the code to paste on the script, it's not in the description
Check the description, you'll see "get code here"
How I do if I don't want all the fields?
You have to do it manually
hi there,
Please help it doesnt work to my spreadsheet, i did follow the right step.
Hello, did you SAVE the script after pasting it in the script editor? Check once and let me know if it still doesn't work
@@SuryanshuBakshi already saved but still blank on spreadsheet
@@herwinjuniorsitumorang5785 I won't be able to help you here, can you drop me a text on Instagram if it's Okay with you? Link - instagram.com/suryanshubakshi/
great!
Getting a 500 Internal server error
why date and time is not accurate? can you help me?
Try fixing the Date and Time in WP settings
Thank you so much.
you're welcome mate
Its not working for me.
Создается новый лист каждый раз вместо заполнения
A new sheet is created every time instead of filling
how can I fix it?
What issue are you facing?
tnk u bro
You're welcome bro
@@SuryanshuBakshi is it possible to control the number of culom to be shown?
code is not working
Getting Webhook Error
it's not working for me :(
Have you followed all the steps precisely?
it will bw ungrateful for me to not leave a thank you message after this worked for me..........................thank you very mucch
nice Filmora
Welcome 😀
doubt
May I know what your doubt is?
@@SuryanshuBakshi joking brotha
@@zerox4224 haha alright mate 😁