How to Automate Data Entry in Google Forms with multiple pages

In this tutorial we would learn:
1. Google script code to automate google forms
2. Google form submission via url parameters

[@Jyotiskaborah]

Thanks for this video, my job requires me to submit a google form 50-60 times per day. Which have 14 entries in total. I have been doing this filling manually for the last 2 years. I am going to create this script today and I will come back to give feedback.

[@techera3563]

does it work bro

[@zeeiftikhar5284]

Thank you. Very helpful tutorial, it works perfectly well. For anyone who wants the script, here you go: function autoEntry() { var wrkBk = SpreadsheetApp.getActiveSpreadsheet(); var wrkSht= wrkBk.getSheetByName("SheetName"); var formURL = ""; var formData = ""; var question1 = ""; var question2 = ""; var question3 = ""; var question4 = ""; var question5 = ""; var question6 = ""; var question7 = ""; var question8 = ""; let noOfRows = 50; for(let i=2; i

[@AutomationMadeEasy]

thnx

[@zeeiftikhar5284]

@@AutomationMadeEasy please pin the comment so that people can find the script easily and copy it.. 😊

[@NewVistaPhoto]

Fabulous! You anticipated my questions before I could ask them. Very well done. Thank you!

[@AutomationMadeEasy]

Happy to help!

[@ajaynagarajan1934]

Excellent Hacks to get the requried ids, saved me time and effort :) appreciate the video!

[@YUSIN117]

Thank you, you inspired me to learn programming.

[@AutomationMadeEasy]

That's great!

[@raktimasensarma82]

VERY VERY THANKS TO YOU MAN! I HAVE DONE THIS CODE FOR GIVING MY ATTENDENCE IN GOOGLE FORM FOR SCHOOL. ALL THE TIME THE FORM IS CLOSED BY OUR TEACHER AND A PERTICULAR TIME OUR TEACHER OPENS IT AND TOLD US TO GIVE ATTENDENCE. I WANT TO EXCECUTE THE PROCESS ALWAYS 24/7 BUT IT DONT NEED MY COMPUTER TO BE TURNED ON AND THE PROCESS WILL STOP FOR SOME HOURS AFTER IT GOT A SUCCESSFUL SUBMITION AS MY TEACHER WILL CLOSE THE FORM AFTER SOME TIME, SO AFTERFEW HOURS IT SHOULD START AGAIN. SO, HOW TO DO THESE PLZ CAN YOU MAKE A VIDEO OR EXPLAIN?

[@lalitseemasoni]

thanks a lot @Automation Made Easy this is the only video tutorial that i found which works on multiple form section keep teaching us thank you once agin

[@AutomationMadeEasy]

Glad it helped!

[@roadrangermy4354]

Fantastic video, I love this tutorial. You saved me so much time from manually filling in Google forms. Thank you!

[@AutomationMadeEasy]

Glad it helped!

[@fisher30011987]

Hi Thanx for this video, its very helpful, if possible please post a video on conditional branching google forms too...im not able to automate a google form having conditional branching on it

[@palanatikarthik2669]

How to write code for checkbox questions?? Like you did it for hobbies... what if someone has 2 hobbies?

[@PURIANS3]

After column g your formula is not working so how we work upto O column

[@jaysonmanadong1421]

It's not working with me every time I tried to rerun the script this message pops up Exception: Request failed for docs.google.com returned code 404. Truncated server response:

[@AutomationMadeEasy]

Format all data as plain text and try

[@emanueke29]

Same problem

[@A7XGaming]

@@AutomationMadeEasy same problems

[@AutomationMadeEasy]

@@A7XGaming share your form url, script and google sheet

[@AutomationMadeEasy]

@@A7XGaming + is missing before tempatL Format all the data as plain text and re try

[@dishatomar4707]

Hellow sir, thankyou so much for the great video but I am facing an error.... The options that you showed in radio button were single word options. My options have space inbetween, how to deal with it please reply!!!! Options which have space are not accepting replies and rest are accepting... What to do sir??

[@liorpr]

Great video, can you add the code to description to avoid typo..

[@taarala8136]

Hello sir, I've watched your videos on KZbin. This is in regard to google forms. I have to enter a large amount of data in the google forms. Is there a possible way to do that. I do not have access to google forms settings it is protected. Waiting for your reply, sir.

[@AutomationMadeEasy]

i need to see the form to suggest a solution

[@taarala8136]

@@AutomationMadeEasy how do I send you all the details, sir ?

[@PrasanKus]

very helpful video sir keep posting such amazing stuff Excellent and well done What if we have dynamic UI elements which means is time field values shuffle and after every refresh name value is also change. Please help me with this problem.

[@narutouzumaki-lt3uv]

If anyone got "Invalid Arguments" try to check which line that contain the invalid arguments. If its pointing to the UrlFetch, put this in your script: var finalURL = formURL + formData var urlEncoded = encodeURI(finalURL) var options = { "method" : "post" }; UrlFetchApp.fetch(urlEncoded, options);

[@subhankhan9563]

I'm getting ReferenceError: encodeURL is not defined What can be done?

[@javiera.palaciosc1515]

Thanks broth for your answer, I did that but now I have this error exception: request failed return code 401. Truncated server response. Do you have any Suggestion?

[@javiera.palaciosc1515]

@@subhankhan9563 Thanks broth for your answer, I did that but now I have this error exception: request failed return code 401. Truncated server response. Do you have any Suggestion?

[@jedzkisiel]

bro u are god of google forms. no other way was that easy as this one. chapeau bas!

[@AutomationMadeEasy]

thnk u

[@yashmayekar_MIS]

Awesome tutorial bro, I have good experience in Excel macros, but really never before imagined this will happen in Google sheet too. this video and obviously gonna grow very fast. And Bro your teaching skills are awesome. thank you for this video. best of luck!

[@AutomationMadeEasy]

Glad you liked it

[@parabbmishraa]

very helpful video sir keep posting such amazing stuff Exellent and well done

[@AutomationMadeEasy]

So nice of you

[@marstar5993]

it helps at minute 8:10, when I put inspect I don't get "name =" entry "

[@avdheshjoshi4977]

same

[@ajithvictor7154]

i faced problem Error Exception: Limit Exceeded: URLFetch URL Length. how to solve this error 100 entries i have .

[@dinomug8469]

Any way you can put the code in the description of the video

[@4funrc11]

👍 Awesome! The only thing that would be better is you having all the code downloadable. (hint, hint)

[@hrispar4874]

Hi i try this at another site and doesnt work. Is it only for Google forms? can i use it at any site with froms with a submit button?

[@nayanjyotirabidas622]

Thank you very much for creating this wonderful video 🙏

[@AutomationMadeEasy]

Glad you liked it!

[@shree12333]

I have one scenario where in sheet i have two columns - one is containing Id and other is containing Name . So I select ID in one field then wanted name in next field automatically and in disabled mode

[@gabrwy1990]

First of all I would like to thank you for that magnificent tutorial. It is a piece of Art. Secondly, I have a question and I hope you answer me "What should be written to select multiple values in the questions with check boxes answers ?"

[@AutomationMadeEasy]

Thanks, you have to just keep appending the name property with the value: name.654646=Reading&name.654646=Writing

[@gabrwy1990]

@@AutomationMadeEasy Thank you. It works well but I faced another issue. In order to be 100% sure of the output, I created an identical copy of the google form that I am submitting the data on and tested the method on the version I created. It was found that "Response receipts" option is enabled and I get error "There was a problem submitting your response" when using the link although that error solved when "Response receipts" option disabled. Pleas help how can I solve this issue

[@yashmayekar_MIS]

@@gabrwy1990 show your code here, I also faced same problem, try to correct where is "pageHistory"

[@migsnaval]

@@yashmayekar_MIS same happening with me - response receipts enabled so method doesn't work. Any solutions?

[@migsnaval]

did you figure it out? same thing happening with me

[@MZgamingYT]

how to find the entry number of multiple choice, like Facebook, KZbin, TikTok and you should choice only one

[@javierdelcarpio8976]

nice tutorial however I have an error in UrlFetchApp.fetch(finalURL, options);

[@AutomationMadeEasy]

whats the error description? Is it an open form or you need to login to access it?

[@marwandarwish6513]

When I paste URL i get this error: "Sorry, unable to open the file at this time." Anyone knows why or how to fix? Thank you for the video

[@epoldgr8920]

I need help with this also

[@TechnoEveryday]

Will it work for forms which requires email authentication?

[@AutomationMadeEasy]

no. only open forms

[@ericdahlgren3588]

I was wondering if you had any advice on finding the name property for a time entry?

[@AutomationMadeEasy]

Enter the time in the field (example 10:19) and serach for 19 in the developer window you will find the name property.

[@robloxianfilipinocsgcars]

I can't find that "name=" part in the code. 8:35

[@swarnasurya3853]

Same here

[@pizzagarden1025]

i tried an alternative way, instead of finding for name manually , press control+f, a very small search box will open at the bottom or right (depending on where your inspect console is) and search for "entry." dont miss the . at the end, you will get a list of all questions together, its in the order of questions u have in the sheet. also if u input any data in the form, the result will come in front of these numbers, im sure this will resolve any issue

[@pizzagarden1025]

@@swarnasurya3853 refer to my reply below

[@divyarajchauhan9876]

@@pizzagarden1025 don't find it

[@divyarajchauhan9876]

Same

[@shawstack]

when the forms generates random questions or random slots??? please?

[@AutomationMadeEasy]

Rabdom questions are genrally based on answers to previous questions so it needs to be programmed based on the different scenarios with advanced programming logic

[@ahmedhakeem8476]

Hi sir Can you help me pleae? I work this code but shows this error Exception: Request failed for returned code 404. Truncated server response:

[@AutomationMadeEasy]

there could be multiple reasons behind the error. Incorrect data format could be one of the reasons. Format all data as plain text and try

[@ahmedhakeem8476]

@@AutomationMadeEasy i did all this can i send urls google form and sheet for you and solve it please

[@ahmedhakeem8476]

@@AutomationMadeEasy 👏

[@AutomationMadeEasy]

ok share

[@yohanesphilis5958]

nice video, but what if you dont want to submit it, like what would you do if you just wanted to fill out one form, and then you can manually check it and then submit it on your own, how would you do that?

[@AutomationMadeEasy]

not sure about that, but we could implement a number of checks before the form is submitted to ensure correct submission

[@justaditya678]

thank you brother, i have question. How about if that input type is a file ? how to do auto entry file ?

[@laluhabibsasiwimba8610]

Sorry, I can't find the name="entry.xxxxxxxxx" in the inspect when i inspect the text box.. maybe google form was hidden that thing?

[@AutomationMadeEasy]

refer to the section where dropdown is explained. Apply same logic for text boxes. You will find name property

[@sarveshpoddar5360]

@@AutomationMadeEasy not able to find name property even after using the trick from dropdown section. I tried searching for the word "entry" also, and there is just one search which has "_sentinel". Can you please guide?

[@adminasjb2815]

Hi, Nice tutorial but I cant find my each data entry my element is

[@AutomationMadeEasy]

manually input some data in the text field and search the same data in the developer window, you will find the element id

[@kevinnichols9836]

How can I split a column with text separated by commas and automatically have it duplicate into rows. For instance: Lot #1,Lot#2, Lot#3 (I want to make each Lot into its own row while keeping or copying data in all other columns).??

[@a2zhotelsolutions207]

hello there is a google form that opens for a limited time. is there any way to prefill that thru excel so that I can fill that form.

[@SapnaSud]

How do you upload the multiple choices into the form, if the answers are of more than 3 words?

[@badaYang]

Thank you for the great video. At 12:39, you have multiple options, but later in the video, all the values from the spreadsheet are shown as a single choice at 19:43. How do you upload the multiple choices into the form?

[@AutomationMadeEasy]

you have just keep appending with the value which needs to be selected: name6464612=Sports&Name98879=Reading

[@sivabalanshanmugam7387]

Really Really fantastic

[@AutomationMadeEasy]

thnx

[@m.aryankurniawan9353]

Hello, the codes can't recognize ">" and " 40 years" text. Can you help me explain please? Thx

[@xiaowang9255]

How to input # in form?for example abcd#1234. It only shows abcd, value disappear after #

[@sanbidrc]

For large forms, the method of embedding values In URL isn't working. Can you help me?

[@Worth_wattching]

i prepared all script bt when i am trying to run that script its giving me error saying ""Exception: Request failed for docs.google.com returned code 400. Truncated server response:

[@AutomationMadeEasy]

Format all the data in the sheet as Plain text and try

[@Worth_wattching]

@@AutomationMadeEasy Thank you for ur reply nd i am sorry to bother u again now my script is running and form also receiving responses but no data is filling in form.. blank form is submitting

[@AutomationMadeEasy]

Need to see ur form and code.

[@Worth_wattching]

@@AutomationMadeEasy plz share me your email id i ll share you form and sheet .. you can charge me whatever your fee is

[@mantivi4087]

I fixed it, you add formurl="[your link google form]/formResponse?pageHistory=0" and done

[@girishchincholikar]

Good one. Everything is clear. Just one quick question. How will the code look if select 02 options of checkbox ?

[@AutomationMadeEasy]

You have to just keep appending entry.895674=Sports&entry.895674=Music

[@sanketghoman8102]

Bro but my Google forms are not in one ascending order they are changing after one submission will it work on that also pls reply?

[@gopinathkaki5982]

i don't know why all the responses are null (no response with empty) tried the same as per the video please help me it helps me lot since i have to enter the question wise marks of each and every student in the google form (i have to fill the same form for 60 times)

[@gopinathkaki5982]

got it error in last line... UrlFetchApp.fetch(finalURL,options);

[@AutomationMadeEasy]

great.. hope it saves your time :)

[@santhivenkatraman3355]

here if any mobile number got auto submission (eg:9923882843) but in form it showing as (9.13E+09), inspiteof declaring that variable as (var)key word,what keyword should i use for mobile number ??

[@sezzor]

How to set time through this sir..i can set AM and PM please help

[@amamrbc527]

Thanks a lot 🙏 for such a awesome video. I have one another request that is How to write script for uploading photo. Because sometimes we have to upload photos.

[@AutomationMadeEasy]

not feasible using this technique but you can use alternate approach explained in below tutorial: kzbin.info/www/bejne/nWjbgKqrocuqgZI

[@ictdirector7892]

It seems Google have hide the "name" tag from the form. How can I get it back or what's the next method?. Good job

[@AutomationMadeEasy]

in the same tutorial refer the section where dates,dropdowns and radiobuttons are handled you will get the field id

[@mdhare1515]

hello, need your help to create a dependent dropdown in *google form* in 1 single section,using data or dependent dropdown menus from a google sheet. please guide me or if possible make a video on it. P.S : Don't want to use logic based section shuffle or *form ranger* or *cascade formatting*. thanks in advance

[@klakshmireddy4]

I am a teacher. In a question paper,there are 2 sections partA & partB. In partA,35 questions given & all questions attempted. In partB, 15 questions given only 10 questions must be answered. Therefore overall 45 questions need to be attempted. Each questions carries 4 marks hence total marks 180. Which add on should I use. Please suggest

[@aidsreeharsha]

Thank you for video and also support for creating my sheet.

[@AutomationMadeEasy]

No problem

[@LearnersClasses]

thank you so much . EXCELLENT TUTORIAL .

[@AutomationMadeEasy]

Glad you enjoyed it!

[@umeshbasnet7598]

Hi, I am not able to see the entry number as it is showing "Required dir="auto" in place of "name""entry.142" in your example?

[@AutomationMadeEasy]

type some text in any field and search for the same in the developer window you will find the id

[@vb6328]

Good day, it is very helpful however I can't find the name then entry when I click the inspect. Hope you will respond to my question sir.

[@AutomationMadeEasy]

populate any text field in the form and search the text you populated in developer window you will find the field id

[@mohamedhanysalaheldeenzahe1814]

the resulting URL is too long for URLfetch to use, and i don't know how to fix it, can you help?

[@ayushsarawgi7794]

Thank you very helpful! how do we also automate file upload in the same form ?

[@AutomationMadeEasy]

Not possible

[@tamerruhioglu9710]

Thanks for the amazing video, is it possible to edit or update any field as well? example update a person's age How can I reach you urgently?

[@AutomationMadeEasy]

write into [e-mail]

[@abhishekmishra9201]

Sir Any video tutorials for autofilling a webform by uploading data in excel..?

[@he_vyas]

How can we pass multiple value in spreadsheet column for multiselect checkbox.in ur example how can u pass both reading,singing?

[@AutomationMadeEasy]

you to jisy keep appending & entry.54646=Singing&entry54646=Sports

[@sharafmehdi8579]

I'm unable to find the entry id. When I write something in text field and then look up to inspect I only get this : here Rahul is the text I've written Please help

[@swapnilthorat6624]

Same happen with me.

[@sharafmehdi6285]

@@swapnilthorat6624 I got the solution for it.

[@swapnilthorat6624]

@@sharafmehdi6285 please share

[@sharafmehdi6285]

@@swapnilthorat6624 If you created that form, you can get a pre fill link so generate a pre fill link and the entryid is given in that generated pre fill url.

[@swapnilthorat6624]

@@sharafmehdi6285 lot of thank you bro...

[@sanjayuchgaonkar8077]

Hello sir,In my form all the entries are having same value so how to distinguish while creating code?

[@mithunpr9888]

Hey there. Thanks for the insight. What if I have a dynamic row? say for example if I add data till row 17, how to auto update? Thanks in advance

[@shashankshirke3689]

Thanks for such helpful video Sir. How do we print 6% in answer .

[@shashankarya7291]

What if we want to add a new row and not give a specific row number in var code, instead it should get updated when we add new row with new data.

[@AutomationMadeEasy]

use while loop. Check if the Column A data is blank or not. assume column A data is represented by variable fname while (fname != "") { //code }

[@namename5156]

Very nice tutorial

[@AutomationMadeEasy]

Thank you! Cheers!

[@peilyntan9377]

I have an error stating [Saved Progress It looks like there's a more recent draft of your response. Update to your latest draft to pick up where you left off. ] May I know how I resolve this?

[@leofrancisco9708]

- Click update - Find and click on clear form - Retry It worked for me when I was doing one.

[@rezaibrahim8285]

HELP ME Brother. my question until nine pages. why my response just one page? explain me brother

[@shivprasadkale8404]

Hi! This is nice tutorial, saved my lots of time. I have a query regarding "other:" option in multiple choice or checkbox. how to script it? we need to describe in "other" space

[@AutomationMadeEasy]

Thanks, you have to just keep appending the name property with the value: name.654646=Reading&name.654646=Other

[@shivprasadkale8404]

@@AutomationMadeEasy I Get it , thank you, you made it too easy for non coder!!

[@AutomationMadeEasy]

glad you found it helpful

[@auto-diciplime237]

Thank you very much sir

[@piponaja]

I have 1 question for the google form which has a conditional web page. For ex. if there is 2 radio button on 1st page, the 1st answer will direct to page 2 and the 2nd answer will direct you to page 3. How can I automate them? I have tried with your tutorial but after entering in chrome, the form is not submitted successfully.

[@AutomationMadeEasy]

the form response url will have different pages depending on the option to be selectd. So using 'if' statement that can be achieved.

[@piponaja]

@@AutomationMadeEasy Hi, thx for the reply. My problem is you mention the page history in html parm, but I dunno how to get the page number in code page. Please guide me.

[@AutomationMadeEasy]

I need to see the form and sample data to suggest a possible solution

[@coolsam4044]

i have last option in form option for image upload how to setup?

[@angechaplin8721]

Thank you sir !

[@AutomationMadeEasy]

Most welcome!

[@jameso.akinsiun2951]

Thanks for the amazing video, is it possible to edit or update the Timestamp as well? How can I reach you urgently?

[@AutomationMadeEasy]

i replied to ur email

[@tungmatto]

Hi, with question can have more response, so How i can code ?

[@AutomationMadeEasy]

you talking about checkboxes?

[@sriganesht4030]

Hi, this is wonderful tutorial. I have a web page that requires multiple entries. I have the requisite data in an excel sheet. However, I do not want to submit the data in one go(after submit i dont get to edit it). There is a save draft option next to the submit button which i would like to use for trying the code before submitting. Is there a similar function from MS Excel to web pages and not just google forms.

[@AutomationMadeEasy]

you can take the approach explained in below tutorial: kzbin.info/www/bejne/Y3i4qGVomsiFras

[@shivangdubey4461]

Hey, is there a way to do this by using some other attribute than name? The form 'm trying to fill doesn't have a name attribute in its fields

[@AutomationMadeEasy]

use the same technique as explained in the tutorial for dropdowns

[@guuday2all]

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.

[@gautampatel1565]

hi could you tell us how to fill in the email id in such forms...it seems to under some "auto" function and has NO entry code for it...please help..thanks

[@AutomationMadeEasy]

if the form is restriced to a specific domain, this approach wont work

[@GajendraAudichya]

Hi man how to do it when the data type is multiple choice choice grid in Google form

[@AutomationMadeEasy]

process will remain the same. identify the respective entry id and use it in the script

[@vineetsinghal7546]

Hi When I am running the code , it only stores the last row on Google form , what mistake I may be making?

[@AutomationMadeEasy]

Check if page history in the url has correct page numbers and make sure page number for 1st page is 0 in the url. Also check if the spellings and cases for the fields where options are to be selected are correct.

[@Econotrix]

Thanks . But how to autofill D.O.B. and Gender on the basis of Name of the Person, when this data is already available on another sheet. Thanks

[@AutomationMadeEasy]

its explained in the video

[@joaofreire6451]

Thank you for the video! It really helped! But I still have a doubt, I need to attach a file to each answer. It's possible? How can I automate this?

[@AutomationMadeEasy]

Have never tried file uploads with this approach but you can use an alternate UI based approach explained in below tutorial: kzbin.info/www/bejne/bZKbeqKcpqeBpZY

[@SapnaSud]

I am not able to see "name property" in my google form. I can only find the values as (aria-describedby="i2 i3"). can you please help me here.

[@AutomationMadeEasy]

enter some value in the field and search for the entered value in developer window you will find name property

[@Worth_wattching]

goog video small suggestion.. u can avoid noting all name id just by using pre filled link also can u share script

[@ho..mukattekurunoka..8301]

clear explanation, thank you so much

[@AutomationMadeEasy]

You are welcome!

[@olivertorrez5256]

will the the automate data entry work for another pages ? or just google forms?

[@AutomationMadeEasy]

The approach explained in the tutorial is applicable for google forms only. For generic auto data entry you may refer below tutorial: kzbin.info/www/bejne/d3bTYYybnthsd68

[@danielt.2474]

Hello. It's a really nice tutorial. I got error when executing the code (line 22 in your example) stating "Cannot read property 'getRange' of null". Why did this error occur? How do I fix this? Thank you in advance.

[@AutomationMadeEasy]

check if you are trying to read data from a blank cell.

[@muhammadnabeel1011]

i am unable to find name entry for linear scales

[@gustykraken]

my script is running to completion but nothings happening

[@mds1655]

Sir please help me from last 3 month i cant get form field name by inspecting that is like entry.1245564 not found

[@AutomationMadeEasy]

Enter some value in the form field and search the same value in the developer window you will find the entry name

[@mds1655]

@@AutomationMadeEasy sir i have tried like this too... Sir please check once and reply sir... You are my god... I want this project please sir... Can you please provide your mail address plz

[@AutomationMadeEasy]

[e-mail]

[@mubarismansoor566]

I am getting a page not found error .. can you please help ?

[@jedidiahjesse6903]

Fantastic Video. May I ask how do you populate 2 different checkboxes ( for Sports ) for a single response in the spreadsheet?

[@AutomationMadeEasy]

Put the booes as comm seperated in the spreadsheet for eg Sports,Reading Some prograaming would be needed to split each hobby and then must be put in the url

[@jedidiahjesse6903]

@@AutomationMadeEasy Thank you! In addition to that question, may I know how do u give a random string in the "Others" for listitems? Ive found two separate name values, one with other_option_response and the other with numbers. Tried passing in value to other option response but no luck ie A B C Others: ___