Thanks so much, very helpful. But what if the google form has different steps? How do you access and fill the variables created in different substeps of the forms? Thanks!
Great tutorial, it works perfect in 2022! I have a very little question ... I added a for loop to execute "n" times the automated data entry function. What could be the number of times allowed to avoid blocking of sending answers from Google Forms?
Thank you, nice tutorial. Do you know how to do that with radio button or checkbox ? They have also entry. but how to get the value of the options. Thanks (previous comment in the wrong video my bad)
So meaning if I open the Google Form and type information this will automatically the output to my Google Spreadsheet and fo every Data Entry i make to my Google form it will add to my Google spreadsheet.....is that correct?
@@AutomationMadeEasy I realized that I don't have the name attribute anymore in the input. Do you know why? I'm not the owner of the forms. I have to fill some inputs to the HR.
And I can't acess my own test form that I've created using var form = FormApp.openByUrl('docs.google.com/forms/d/e/asdasdasdasdasdasdadasdasdasdasd/viewform'); Exception: No item with the given ID could be found, or you do not have permission to access it. (line 2, file "Code") Dismiss Do you know why?
Really informative video! But can I get the action url from app script function without using the page source from inspect element? the formURL variable value!
@@AutomationMadeEasy I found it and follow the instructions in the video but when I run script, it says request failed return code 400, truncated server response
Thanks for the video. one question if in google sheet textbox doesn't have unique attribute then how to proceed for the mapping of field to value. Thanks in advance
Thank you for the help to solve the Problem within very short period of time. Kudos ! @Automation Made Easy All the videos are very helpful and I would highly recommend everyone to follow the videos
Great video. What if I need responders to fill out one of the fields (ex. an ID Number) then the rest of the fields in the form will be completed automatically by looking up corresponding details on a pre-created database in Sheets?
So basically in the step where we map data with HTML element I am not able to find the “entry.something “ then what to do as I checked properties it’s not there…
It would have been nice if you could have just gave us your loop code because I am trying to do exactly what you did but with 66 lines of data to be entered into 66 codes. Now I am spending too much time trying to figure out how to loop after already following your tutorial which lead to a dead end. Very useful tutorial, just please finish your actual full tutorial and do not leave us hanging! What is the point of creating the script to just fill out one form?
Automation Made Easy Thank you VERY much!! This will be useful for the future because now I just manually completed all the forms lol. I appreciate you making these great videos because there is nothing else out there with how to complete several forms. Have a great day!
hello there! thank you for the info!! it is gold powder :). i have a question, this macro will autorun with every new row un the spreadsheet? if not, can we have some help? thank you again!!!
not for every new row but if you have multiple rows and want to execute for all those rowsyou can refer below tutorial: ruclips.net/video/DVRM7VLKUFU/видео.html
How to populate same data in Dropdown list( Change in event). If I select option in Dropdown corresponding other Coloum values are automatically filled another Textboxes of Google form. Please Make video regarding this
Suppose there is a Google form for take students feedback.And there are fields like Roll no., name, class etc. Now I want that if someone fill Roll No. Other details like name, class etc is filled automatically. How can I achieve this functionality
@@AutomationMadeEasy no there isn't. What I want to say is that, I create the questions and multiple choices in Sheets, hundreds of them, and then import them to Forms as quiz, something like that.
Great video and content! But i do have a question, how would you do the reverse? Like how do I fill in a Google Sheet from Google Forms input? How do i do it with webhooks? Can you explain?
for that you must be owner of the form and there is a facility in the form itself to link response to google sheet. As soon form response is received, sheet will get populated. Some what similar example you can find in below tutorial: ruclips.net/video/Qu0pD7Tq4P4/видео.html
this technique only works for text boxes. You can try below tutorial which demonstrates ui based automated data. entry . ruclips.net/video/-GUw22ecRwI/видео.html
There are 3 question in goole form like this Q.1 Sum of male and female =10 Q. 2 male is =6 Q.3 female is =4 (how is this one automatically fil in google form as it it equal to Q1-Q2)
I believe I have followed all your step correctly and have checked for typos and can not figure out why I am getting the following error: Exception: Request failed for docs.google.com returned code 401. Truncated server response: Message details Exception: Request failed for docs.google.com returned code 401. Truncated server response:
you have to get the individual name properties of each part of the date. You need to get the (name) of the month day and year section of the data entry.
Really impressive solution !!! One Question ? Do you have an idea if its possible to enter a value in the first field of a form and then re-display the form with autopopulated fields before sending the form. Reason: The user may check, if he has entered the right Information in the first field ? Thanks a lot for your work , Sincerely Klaus
Well thats not possibe through google scripts but you could refer to below alternate tutorial to achieve the same: ruclips.net/video/-GUw22ecRwI/видео.html
I have this working except for date field which in my form is calendar picker. It won't populate in form from sheet. Is there a trick for this? Thanks.
What is the use of this Automate data entry in Google sheets , please give examples If any one submit response using Google forms with one or two wrong data , when we ask them to resend response , because of so many entry , they feel difficult , as per your video , can to send prefilled form (application) , but when I made hyperlink it is not successful If you understand my question please help me make a video (I am not a computer person) Thank you
Hello sir, I have to enter a large amount of data in the google forms. Is there a possible way to do that. And i also do not have access to google forms settings it is protected. Waiting for your reply, sir.
@@AutomationMadeEasy unable to write the exact code for for loop, could you please write the code for me. as am beginner, i will appreciate if you do so. sorry for troubling you.
it keeps throwing me an error when i get to the URLFetchapp part, saying that there is a 400 error. Is there a certain link format i need? Or is it because some how all the "entry" ids are "hidden"?
Select all the data in your sheet On Google sheet menu there is an option 'Format' Click on Format (Sub menu will open) Hover on second option (Number) Now you will see Plain text. Click on it
@@AutomationMadeEasy its still showing this error - Exception: Request failed for docs.google.com returned code 400. Truncated server response: . Is it an issue with the link i used?
Hi can someone help me here....when I inspect the Google form element I am unable to find entry.number, is this changes for different sheet? Plz help By the a good video..I have learned a lot
Hi... Thank you for such helpful videos... However, I am facing a small problem while populating data from spreadsheet to google forms. The date format and mobile number format are being reflected in a different format after submitting the form. Please help me with this.
Just one question. In the first seconds in the video you had shown to submit multiple responses at once (all 5 columns of data), can you tell me the codes i can use to get that multiple data to be entered at once?
Excellent tutorial sir.. But I have one question. Can we manipulate timestamp as per our requirement? Can we modify timestamp of responses ..? If I download these responses, it will show entry time and dates... i want to change that current timestamp. How its possible..? Thank you
okay so I want my data to be submitted in google form only ones/per day but I automated the process by setting a trigger after every 5 mins so how to do these?
Hi thx a lot, i did it, but i got new problem, the script can only process the data only six minute after that it said "exceeded maximum execution time" and then i got new problem again and it said "service invoked too many times for one day" plsss answer mee sirr i nedd your helppp pleaseee
currently this technique supports only text fields. For complex forms you may use alternate approach described in below tutorial: ruclips.net/video/Qknt8qFR7kY/видео.html
I got the answer. I wanted to create a drop down in google form and get the answer. For example if I click 1 in drop down ,I should get automatically filled name and location from sheets to form and then submit that form
It sounds like your riding a motorcycle on a highway. Great video!
thnx
No. ..It sounds more like a SERVER ROOM :)
Thanks so much, very helpful. But what if the google form has different steps? How do you access and fill the variables created in different substeps of the forms? Thanks!
Great tutorial, it works perfect in 2022!
I have a very little question ... I added a for loop to execute "n" times the automated data entry function. What could be the number of times allowed to avoid blocking of sending answers from Google Forms?
Hi bro please help
Getting error below. Any suggestion
"Exception: Request failed for docs.google.com returned code 400. Truncated server response:
share form url, sheet and script
@@AutomationMadeEasy facing same problem, may i share form url sheet and script too? thank you
Thank u so much sir nowadays everything is expensive and u sharing a very good service free for us thank u so so so so much.
Your welcome
Automation Made Easy the only thing i needed is adding submit : submit to the mapping without it nothing works with the link i use
Thank you, nice tutorial. Do you know how to do that with radio button or checkbox ? They have also entry. but how to get the value of the options. Thanks (previous comment in the wrong video my bad)
tutorial coming soon
here you go:
ruclips.net/video/DVRM7VLKUFU/видео.html
Thanks ;)
sir please complete the script with for loop
So meaning if I open the Google Form and type information this will automatically the output to my Google Spreadsheet and fo every Data Entry i make to my Google form it will add to my Google spreadsheet.....is that correct?
Exactly what I needed.Thanks!
Glad it helped!
@@AutomationMadeEasy I realized that I don't have the name attribute anymore in the input. Do you know why?
I'm not the owner of the forms. I have to fill some inputs to the HR.
And I can't acess my own test form that I've created using
var form = FormApp.openByUrl('docs.google.com/forms/d/e/asdasdasdasdasdasdadasdasdasdasd/viewform');
Exception: No item with the given ID could be found, or you do not have permission to access it. (line 2, file "Code") Dismiss
Do you know why?
last part of the url must be 'formResponse' not 'viewform'
Refer below tutorial:
ruclips.net/video/DVRM7VLKUFU/видео.html
Really informative video!
But can I get the action url from app script function without using the page source from inspect element? the formURL variable value!
Sir plz make a video on auto loop on this continue video...
refer below tutorial:
ruclips.net/video/DVRM7VLKUFU/видео.html
thank you for showing the code in the macro. explanation is clear. 🙏
Glad you liked it
@@AutomationMadeEasy There is no entry name, I tried typing inside the text box but there is no name
Type some text in any field and search the text in developer window. You will find the name property.
@@AutomationMadeEasy I found it and follow the instructions in the video but when I run script, it says request failed return code 400, truncated server response
Thanks a lot, it is really useful
Glad to hear that
Very helpful, thanks you very much, love this tutorial!
Happy to hear that!
Thanks for the video.
one question if in google sheet textbox doesn't have unique attribute then how to proceed for the mapping of field to value.
Thanks in advance
Thank you for the help to solve the Problem within very short period of time.
Kudos ! @Automation Made Easy
All the videos are very helpful and I would highly recommend everyone to follow the videos
THANK YOU VERY MUCH IT WAS VERY VERY HELPFUL
Great video.
What if I need responders to fill out one of the fields (ex. an ID Number) then the rest of the fields in the form will be completed automatically by looking up corresponding details on a pre-created database in Sheets?
Thanks. For this we may need a customized solution involving multiple forms and automating the entire process.
Could you get an answer for your question? I am also looking for the same. edutech.goa@gmail.com
Hi Maylin, Even I'm looking for this solution. Pls share it on rifathirfan@gmail.com if you have got anything
Hi ,
Perfect tutorial.
I have a query.
If i want to autofill the on a particular time from mon -fri . What should i do.?
Latter part of below tutorial explains triggers and schedulling:
ruclips.net/video/6_0y2G4vTQI/видео.html
Can U Provide The Source Code ?
Thank you, Its awsome and if we need to upload picture, pdf etc. how we can do it?
thats not feasible
So basically in the step where we map data with HTML element I am not able to find the “entry.something “ then what to do as I checked properties it’s not there…
i cant find it too
Thanks a lot! Very Helpful!!!
your welcome
Great Video! When I try to map the form to the google sheet, I cannot find anything about a name or entity.
Any ideas?
refer below tutorial:
ruclips.net/video/DVRM7VLKUFU/видео.html
It's great job... Thanks a lots.
Thank. Below is link for google forms with multiple pages. It may interest you:
ruclips.net/video/DVRM7VLKUFU/видео.html
How can we automatically fill the form whenever there is a new entry in the sheet? Please reply it's urgent
A life saving video, thanks bandu🙏🏻
Welcome 😊
It would have been nice if you could have just gave us your loop code because I am trying to do exactly what you did but with 66 lines of data to be entered into 66 codes. Now I am spending too much time trying to figure out how to loop after already following your tutorial which lead to a dead end. Very useful tutorial, just please finish your actual full tutorial and do not leave us hanging! What is the point of creating the script to just fill out one form?
Hello,
I already have a tutorial explaining what you need. Please refer below tutorial:
ruclips.net/video/DVRM7VLKUFU/видео.html
Automation Made Easy Thank you VERY much!! This will be useful for the future because now I just manually completed all the forms lol. I appreciate you making these great videos because there is nothing else out there with how to complete several forms. Have a great day!
Awesome video! How do I map a dropdown against a row value? For example, against some value in the Excel Doc or some string literal.
Refer below tutorial:
ruclips.net/video/DVRM7VLKUFU/видео.html
hello there! thank you for the info!! it is gold powder :). i have a question, this macro will autorun with every new row un the spreadsheet? if not, can we have some help? thank you again!!!
not for every new row but if you have multiple rows and want to execute for all those rowsyou can refer below tutorial:
ruclips.net/video/DVRM7VLKUFU/видео.html
this is helpful ! thank you.
Glad it was helpful!
Great video! Any tutorial for Google forms that requires a captcha?
Not that I know of
Can you please tell how to map radio button response and check box response in the google form?
Very good video. How do you auto-populate 0 to the rest of the responses when a question is answered "No"?
TypeError: Cannot read property 'getRange' of null
I'm getting the above error. Please help me solve this.
How to populate same data in Dropdown list( Change in event). If I select option in Dropdown corresponding other Coloum values are automatically filled another Textboxes of Google form. Please Make video regarding this
Nice
What is a use case for this?
Suppose there is a Google form for take students feedback.And there are fields like Roll no., name, class etc. Now I want that if someone fill Roll No. Other details like name, class etc is filled automatically. How can I achieve this functionality
Can you help me to write a code for a Google form which have drop down menu ect..
wow man you are a genuis!!!
thank you
Thanks. I learned a lot. Do you have a tutorial to automate how to create Google Forms from Google Sheets? Thanks
there is an option on google sheet itself to create a form out of the google sheet
@@AutomationMadeEasy no there isn't. What I want to say is that, I create the questions and multiple choices in Sheets, hundreds of them, and then import them to Forms as quiz, something like that.
ok got it. I do not have tutorial but it can be achieved.
Have you got answer to this ?
hi! what if the name of the text box what not indicated on the html, will it still work?
Thank you sir for this information. Its very helpful.
Most welcome
Great video and content! But i do have a question, how would you do the reverse? Like how do I fill in a Google Sheet from Google Forms input? How do i do it with webhooks? Can you explain?
for that you must be owner of the form and there is a facility in the form itself to link response to google sheet. As soon form response is received, sheet will get populated. Some what similar example you can find in below tutorial:
ruclips.net/video/Qu0pD7Tq4P4/видео.html
can this method be used on mobile phones?
refer below tutorial:
ruclips.net/video/nfZLXF5uHF0/видео.html
Automation Made Easy great, tqs, done like. So can i use this function on google form frm someone else?
can you show how to autofill a google form based on drop down menu?
this technique only works for text boxes. You can try below tutorial which demonstrates ui based automated data.
entry .
ruclips.net/video/-GUw22ecRwI/видео.html
Does it work for another website forms? Like in that video you use excel macros.
yes absolutely
Great
You have my respects!
thank u
Should we use nested for loop?
There are 3 question in goole form like this
Q.1 Sum of male and female =10
Q. 2 male is =6
Q.3 female is =4 (how is this one automatically fil in google form as it it equal to Q1-Q2)
i did not undersatnd your question. How its related to Math?
Hello I got an error code Exception: Request failed for docs.google.com returned code 405. Truncated server response:
Try formatting all the data in the sheet as plain text.
I believe I have followed all your step correctly and have checked for typos and can not figure out why I am getting the following error:
Exception: Request failed for docs.google.com returned code 401. Truncated server response:
Message details
Exception: Request failed for docs.google.com returned code 401. Truncated server response:
the form must be restricted to a domain
what will be the code if google form have "file upload" option???????
Please Make Video About change in event in Dropdown list aumatically other textboxes to be filled in Google forms like Vlookup
How can I get name of "date" label from inspect feature? because the date doesn't have name property :(
you have to get the individual name properties of each part of the date. You need to get the (name) of the month day and year section of the data entry.
Really impressive solution !!! One Question ? Do you have an idea if its possible to enter a value in the first field of a form and then re-display the form with autopopulated fields before sending the form. Reason: The user may check, if he has entered the right Information in the first field ? Thanks a lot for your work , Sincerely Klaus
Well thats not possibe through google scripts but you could refer to below alternate tutorial to achieve the same:
ruclips.net/video/-GUw22ecRwI/видео.html
This produces only one row data into the form, what to do if it is an entire sheet
refer below tutorial:
ruclips.net/video/DVRM7VLKUFU/видео.html
I have this working except for date field which in my form is calendar picker. It won't populate in form from sheet. Is there a trick for this? Thanks.
What is the use of this Automate data entry in Google sheets , please give examples
If any one submit response using Google forms with one or two wrong data , when we ask them to resend response , because of so many entry , they feel difficult , as per your video , can to send prefilled form (application) , but when I made hyperlink it is not successful
If you understand my question please help me make a video
(I am not a computer person)
Thank you
Hello sir, I have to enter a large amount of data in the google forms. Is there a possible way to do that. And i also do not have access to google forms settings it is protected. Waiting for your reply, sir.
There's also no script editor option available in the google sheets
My form does not have Unique names for each of the Fields. How do I deal with this?
refer below tutorial . You can skip first 8 minutes
ruclips.net/video/DVRM7VLKUFU/видео.html
Good work and good illustration.
Thanks
Please help, how to apply for loop to get each row data as described in last
thank you for the tutorials.
Could you please give me to for loop code for number of iterations?
code for loop can be found in below tutorial:
ruclips.net/video/6_0y2G4vTQI/видео.html
@@AutomationMadeEasy
unable to write the exact code for for loop, could you please write the code for me.
as am beginner, i will appreciate if you do so. sorry for troubling you.
Now i got it.... thanks for quick response to query.
Your welcome
how to do it for multiple records? please give me the for loop code
Brilliant video, is there a way to do this with checkboxes? Thanks
This technique works for textboxes. Refer below tutorial for alternate method.
ruclips.net/video/docnLSdj8rI/видео.html
Yes I found a way:
ruclips.net/video/DVRM7VLKUFU/видео.html
it keeps throwing me an error when i get to the URLFetchapp part, saying that there is a 400 error. Is there a certain link format i need? Or is it because some how all the "entry" ids are "hidden"?
Format all data as plain text and try.
@@AutomationMadeEasy How do we go about doing that?
Select all the data in your sheet
On Google sheet menu there is an option 'Format'
Click on Format (Sub menu will open)
Hover on second option (Number)
Now you will see Plain text. Click on it
@@AutomationMadeEasy
its still showing this error - Exception: Request failed for docs.google.com returned code 400. Truncated server response: . Is it an issue with the link i used?
Share your form url, sheet and code
Thanks so much! How do i display multiple say 100 records in each page and do pagenation like this comments or any e-commerce site.
Hi can someone help me here....when I inspect the Google form element I am unable to find entry.number, is this changes for different sheet? Plz help
By the a good video..I have learned a lot
enter some textin the text field and try to find the text in the developer window. You will find the id
@@AutomationMadeEasy Cant find it ...Is there some other tag in it's place?
Hi... Thank you for such helpful videos... However, I am facing a small problem while populating data from spreadsheet to google forms. The date format and mobile number format are being reflected in a different format after submitting the form. Please help me with this.
refer below tutorial:
ruclips.net/video/DVRM7VLKUFU/видео.html
Nice
What if I want to auto fill but instead of a name or address I just want a box to be checked or the for the answer of a question to be yes or no?
refer below tutorial:
ruclips.net/video/DVRM7VLKUFU/видео.html
sir how to add data validation in in the cell of country .
Hey, wen i click on inspect i cant see the entry and the number. Instead its labelled by i5,i6 wats this, pls help me wit it.
type something in the text field and search the same in the developer window. You will find the entry id
Thanks a lot its very helpful, but i don't understand how to looping, can I get the codes?
Refer below tutorial:
ruclips.net/video/DVRM7VLKUFU/видео.html
are u filming in airport?
what will be the syntax in case of multiple choice check box question?
Refer below tutorial:
ruclips.net/video/DVRM7VLKUFU/видео.html
Also is there a way to get the entry.XXXXXX for a dropdown
For dropdowns and other controls refer below tutorial:
ruclips.net/video/DVRM7VLKUFU/видео.html
Is it possible to fill the google questionnaire automatically + randomly?
not uploading the data from a script I mean? Like auto bot or so ?
not that I am aware of
Just one question. In the first seconds in the video you had shown to submit multiple responses at once (all 5 columns of data), can you tell me the codes i can use to get that multiple data to be entered at once?
refer below tutorial:
ruclips.net/video/DVRM7VLKUFU/видео.html
Excellent tutorial sir.. But I have one question. Can we manipulate timestamp as per our requirement? Can we modify timestamp of responses ..? If I download these responses, it will show entry time and dates... i want to change that current timestamp. How its possible..?
Thank you
Not possible
Hello sir
App script execution completed without any error code, but data doesn't tranfer or show in form responses options.
Need your expertise .
check if the spellings of values are correct also make sure any mandatory field is not missed
I have some problem my form get other option fill then it is not work
Can you make a unique username & password for each person than needs to fill in the form?
okay so I want my data to be submitted in google form only ones/per day but I automated the process by setting a trigger after every 5 mins so how to do these?
triggers are explained in below tutorial:
ruclips.net/video/6_0y2G4vTQI/видео.html
I want to automatically fill a google form which also has one question to upload a pic. How to automate that? Very informative video!!
Will be creating a new tutorial soon.
refer below tutorial for file uploads:ruclips.net/video/7a8IofqBNo4/видео.html
What if there was a radio button, or a square box option with multi choice, how will you automate that?
There is a second video for those complex Google forms
@@navedaasim5048 Can you send the video to the second link on how to register for these forms?
How to use when signin authentication is enabled?
Hi thx a lot, i did it, but i got new problem, the script can only process the data only six minute after that it said "exceeded maximum execution time" and then i got new problem again and it said "service invoked too many times for one day" plsss answer mee sirr i nedd your helppp pleaseee
yes there the execution limits. Single execution 5 minutes and 60 mins over a period of 24 hrs
I need in google forms , options shud dynamically displayed from a google sheet colmun,, is it possible???
Yes that is possible but would need custom coded Google Form
I'm not getting name =entry.xyz nos while inspecting the form
What should i do?
is it possible to make it really automated to submit at a specific time and also choose 1 random data for a particular field?
Triggers can created for scheduled execution. Refer below tutorial
ruclips.net/video/6_0y2G4vTQI/видео.html
Can I get a link to documentation you followed
Getting error
Exception: Request failed for docs.google.com returned code 401. Truncated server response:
Format all data as Plain Text and try
Dears, how I can manage "Collect email addresses" field? Field is "emailAddress" but script returns "code 400" error. If you can support me into
share url of ur form wil try to look into it
@@AutomationMadeEasy Thank you, I sent you an email, otherwise the link is deleted here. Thanks!
sir how i know my response recorded if i am not owner of google form
I can't but thank you
i have solved the problem, now one more problem left and that is how to loop
refer below tutorial:
ruclips.net/video/6_0y2G4vTQI/видео.html
Good video.
What if the form has many pages?
Refer below tutorial:
ruclips.net/video/DVRM7VLKUFU/видео.html
I want it the other way around. Fill out the google form and it creates it in excel
Try Zapier or Integromat
How can you do that for example if you want to select an option on the forms and not only with text ?
I mean like in marking the sentence
currently this technique supports only text fields. For complex forms you may use alternate approach described in below tutorial:
ruclips.net/video/Qknt8qFR7kY/видео.html
You have used name attribute. But I did the same thing.But i could not find it.
Any other way to send the data?
I got the answer.
I wanted to create a drop down in google form and get the answer.
For example if I click 1 in drop down ,I should get automatically filled name and location from sheets to form and then submit that form
Refer below tutorial:
ruclips.net/video/DVRM7VLKUFU/видео.html