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!

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!

THANK YOU VERY MUCH IT WAS VERY VERY HELPFUL

It sounds like your riding a motorcycle on a highway. Great video!

@AutomationMadeEasy

3 жыл бұрын

thnx

@callifalamien

3 жыл бұрын

No. ..It sounds more like a SERVER ROOM :)

Very helpful, thanks you very much, love this tutorial!

@AutomationMadeEasy

2 жыл бұрын

Happy to hear that!

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?

Thanks a lot! Very Helpful!!!

@AutomationMadeEasy

4 жыл бұрын

your welcome

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?

@navedaasim5048

Жыл бұрын

Hi bro please help

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.

@AutomationMadeEasy

4 жыл бұрын

Your welcome

@9ebooks

4 жыл бұрын

Automation Made Easy the only thing i needed is adding submit : submit to the mapping without it nothing works with the link i use

A life saving video, thanks bandu🙏🏻

@AutomationMadeEasy

2 жыл бұрын

Welcome 😊

Thank you sir for this information. Its very helpful.

@AutomationMadeEasy

4 жыл бұрын

Most welcome

Exactly what I needed.Thanks!

@AutomationMadeEasy

4 жыл бұрын

Glad it helped!

@douglasokubo7666

4 жыл бұрын

@@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.

@douglasokubo7666

4 жыл бұрын

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?

@AutomationMadeEasy

4 жыл бұрын

last part of the url must be 'formResponse' not 'viewform'

@AutomationMadeEasy

4 жыл бұрын

Refer below tutorial: kzread.info/dash/bejne/doqGr5mPfK67drg.html

Good work and good illustration.

@AutomationMadeEasy

5 жыл бұрын

Thanks

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.

@AutomationMadeEasy

4 жыл бұрын

Refer below tutorial: kzread.info/dash/bejne/doqGr5mPfK67drg.html

It's great job... Thanks a lots.

@AutomationMadeEasy

4 жыл бұрын

Thank. Below is link for google forms with multiple pages. It may interest you: kzread.info/dash/bejne/doqGr5mPfK67drg.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.

thank you for showing the code in the macro. explanation is clear. 🙏

@AutomationMadeEasy

3 жыл бұрын

Glad you liked it

@Azri965

3 жыл бұрын

@@AutomationMadeEasy There is no entry name, I tried typing inside the text box but there is no name

@AutomationMadeEasy

3 жыл бұрын

Type some text in any field and search the text in developer window. You will find the name property.

@Azri965

3 жыл бұрын

@@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

this is helpful ! thank you.

@AutomationMadeEasy

3 жыл бұрын

Glad it was helpful!

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?

@AutomationMadeEasy

4 жыл бұрын

refer below tutorial: kzread.info/dash/bejne/doqGr5mPfK67drg.html

Should we use nested for loop?

Thanks a lot, it is really useful

@AutomationMadeEasy

2 жыл бұрын

Glad to hear that

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

@AutomationMadeEasy

4 жыл бұрын

Well thats not possibe through google scripts but you could refer to below alternate tutorial to achieve the same: kzread.info/dash/bejne/X3uJ2ZRrlca4p6w.html

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.

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?

@AutomationMadeEasy

2 жыл бұрын

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: kzread.info/dash/bejne/g6lk0qZwhNSagJc.html

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?

@AutomationMadeEasy

4 жыл бұрын

Thanks. For this we may need a customized solution involving multiple forms and automating the entire process.

@riyana2

4 жыл бұрын

Could you get an answer for your question? I am also looking for the same. edutech.goa@gmail.com

@SRI-he4rk

4 жыл бұрын

Hi Maylin, Even I'm looking for this solution. Pls share it on rifathirfan@gmail.com if you have got anything

You have my respects!

@AutomationMadeEasy

4 жыл бұрын

thank u

hi! what if the name of the text box what not indicated on the html, will it still work?

Hi , Perfect tutorial. I have a query. If i want to autofill the on a particular time from mon -fri . What should i do.?

@AutomationMadeEasy

4 жыл бұрын

Latter part of below tutorial explains triggers and schedulling: kzread.info/dash/bejne/aJNk25SAZNm6gaw.html

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)

@AutomationMadeEasy

4 жыл бұрын

tutorial coming soon

@AutomationMadeEasy

4 жыл бұрын

here you go: kzread.info/dash/bejne/doqGr5mPfK67drg.html

@tyliamsilvini7503

4 жыл бұрын

Thanks ;)

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

@SumitMishra-fp8hk

2 жыл бұрын

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

wow man you are a genuis!!!

@AutomationMadeEasy

4 жыл бұрын

thank you

how to do it for multiple records? please give me the for loop code

Does it work for another website forms? Like in that video you use excel macros.

@AutomationMadeEasy

4 жыл бұрын

yes absolutely

Great video! Any tutorial for Google forms that requires a captcha?

@AutomationMadeEasy

3 жыл бұрын

Not that I know of

How to use when signin authentication is enabled?

is it possible to make it really automated to submit at a specific time and also choose 1 random data for a particular field?

@AutomationMadeEasy

4 жыл бұрын

Triggers can created for scheduled execution. Refer below tutorial kzread.info/dash/bejne/aJNk25SAZNm6gaw.html

Please help, how to apply for loop to get each row data as described in last

sir please complete the script with for loop

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!!!

@AutomationMadeEasy

2 жыл бұрын

not for every new row but if you have multiple rows and want to execute for all those rowsyou can refer below tutorial: kzread.info/dash/bejne/doqGr5mPfK67drg.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

@AutomationMadeEasy

2 жыл бұрын

Not possible

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.

@AutomationMadeEasy

4 жыл бұрын

refer below tutorial: kzread.info/dash/bejne/doqGr5mPfK67drg.html

Can you please tell how to map radio button response and check box response in the google form?

Thanks. I learned a lot. Do you have a tutorial to automate how to create Google Forms from Google Sheets? Thanks

@AutomationMadeEasy

4 жыл бұрын

there is an option on google sheet itself to create a form out of the google sheet

@PardzAndDel

4 жыл бұрын

@@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.

@AutomationMadeEasy

4 жыл бұрын

ok got it. I do not have tutorial but it can be achieved.

@vishwadeepsardar1008

2 жыл бұрын

Have you got answer to this ?

sir how to add data validation in in the cell of country .

what will be the syntax in case of multiple choice check box question?

@AutomationMadeEasy

3 жыл бұрын

Refer below tutorial: kzread.info/dash/bejne/doqGr5mPfK67drg.html

you are awesome

@AutomationMadeEasy

5 жыл бұрын

Than You

what will be the code if google form have "file upload" option???????

Very good video. How do you auto-populate 0 to the rest of the responses when a question is answered "No"?

@vivekn9856

3 жыл бұрын

TypeError: Cannot read property 'getRange' of null I'm getting the above error. Please help me solve this.

Great Video! When I try to map the form to the google sheet, I cannot find anything about a name or entity. Any ideas?

@AutomationMadeEasy

3 жыл бұрын

refer below tutorial: kzread.info/dash/bejne/doqGr5mPfK67drg.html

Thank you, Its awsome and if we need to upload picture, pdf etc. how we can do it?

@AutomationMadeEasy

Жыл бұрын

thats not feasible

Is it possible to fill the google questionnaire automatically + randomly? not uploading the data from a script I mean? Like auto bot or so ?

@AutomationMadeEasy

2 жыл бұрын

not that I am aware of

Can you make a unique username & password for each person than needs to fill in the form?

Brilliant video, is there a way to do this with checkboxes? Thanks

@AutomationMadeEasy

4 жыл бұрын

This technique works for textboxes. Refer below tutorial for alternate method. kzread.info/dash/bejne/lqOX0K6MlM2eoqw.html

@AutomationMadeEasy

4 жыл бұрын

Yes I found a way: kzread.info/dash/bejne/doqGr5mPfK67drg.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

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?

@AutomationMadeEasy

3 жыл бұрын

triggers are explained in below tutorial: kzread.info/dash/bejne/aJNk25SAZNm6gaw.html

Great

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…

@opeciskandar

9 ай бұрын

i cant find it too

First, Thank you very much. I have no experience in coding and have spent a considerable amount of time looking for a solution such as this. That I have been successful is a testament to your teaching abilities. My question, please, is - My form has two sections. Initially, the script ran but did not complete the fields in the second section. When I merged the 2nd section with the first, so that the form had no separate sections (i.e, was one, single form.), the script worked. Can the script be modified to work with forms with multiple sections? And if so, would there be limitations on the transitions from one section to another --as in "go to the next section"....gotot section #X.....or submit? Thank you very much.

@AutomationMadeEasy

5 жыл бұрын

Thank you for the encouraging words. Regarding your question, the task which you have mentioned can be automated with an alternate approach. Below tutorial link will guide you to achieve the same. If you any questions you can let me know: kzread.info/dash/bejne/X3uJ2ZRrlca4p6w.html

@stuartmeyers9032

5 жыл бұрын

Thank you for your prompt reply. I really appreciate it. Unfortunately, I am not so technically oriented, and the tutorial was beyond my ability. I will try a workaround, in which I run the script from your previous tutorial on a Google form without multiple sections, and then add the sections. I am doing volunteer work for a small group and seem to be getting over my head. If you or someone you know may be available to assist with projects, from time-to-time, please let me know. Thanks again.

@AutomationMadeEasy

5 жыл бұрын

how should I get in touch with you?

@stuartmeyers9032

5 жыл бұрын

Thank you for replying. Please use info@soundsleepsolutions.com. I look forward to hearing from you. By the way, the workaround was successful (at least I think so). - I first merged the sections of a form. I then ran the script, and then added the sections again. I do have an additional question, below, but I do not want you to feel obligated to answer it. You have provided great value to me and so many others for free, and I am uncomfortable taking up more of your time with additional questions at no charge. Re the mapping of data fields in Google forms to data fields in Google Sheets: Though I can easily find the unique identifiers for text-field answers in Google Forms (e.g."entry.12324"), I could not figure out how to map to a specific "check-box" that has a pre-filled value associate with it. Is that a straightforward "copy-paste," as well? Thank you again

@AutomationMadeEasy

5 жыл бұрын

I sent you an email on the mentioned id.

thank you for the tutorials. Could you please give me to for loop code for number of iterations?

@AutomationMadeEasy

5 жыл бұрын

code for loop can be found in below tutorial: kzread.info/dash/bejne/aJNk25SAZNm6gaw.html

@sachinpatil4647

5 жыл бұрын

@@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.

@sachinpatil4647

5 жыл бұрын

Now i got it.... thanks for quick response to query.

@AutomationMadeEasy

5 жыл бұрын

Your welcome

How to update two pages of Google forms. Code for moving to 2 page.

I can't but thank you

@mstsoniakhatun2140

4 жыл бұрын

i have solved the problem, now one more problem left and that is how to loop

@AutomationMadeEasy

4 жыл бұрын

refer below tutorial: kzread.info/dash/bejne/aJNk25SAZNm6gaw.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!!

@AutomationMadeEasy

5 жыл бұрын

Will be creating a new tutorial soon.

@AutomationMadeEasy

5 жыл бұрын

refer below tutorial for file uploads:kzread.info/dash/bejne/aZVsq9GfoaW0n5c.html

Can you help me to write a code for a Google form which have drop down menu ect..

Nice What is a use case for this?

Missing before function parameters line 1 file code

can you show how to autofill a google form based on drop down menu?

@AutomationMadeEasy

4 жыл бұрын

this technique only works for text boxes. You can try below tutorial which demonstrates ui based automated data. entry . kzread.info/dash/bejne/X3uJ2ZRrlca4p6w.html

What if the form has multiple choices? Say "I am here" or "I am not here." How can I specify which one I want clicked?

@AutomationMadeEasy

3 жыл бұрын

Refer below tutorial: kzread.info/dash/bejne/doqGr5mPfK67drg.html

How can I get name of "date" label from inspect feature? because the date doesn't have name property :(

@techuila

4 жыл бұрын

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.

Also is there a way to get the entry.XXXXXX for a dropdown

@AutomationMadeEasy

3 жыл бұрын

For dropdowns and other controls refer below tutorial: kzread.info/dash/bejne/doqGr5mPfK67drg.html

Hello I got an error code Exception: Request failed for docs.google.com returned code 405. Truncated server response:

@AutomationMadeEasy

3 жыл бұрын

Try formatting all the data in the sheet as plain text.

LOB U BRO

Hello sir. Thank you for your great tutorial. How do you send information into a multiple choice, checkbox or drop down question?

@AutomationMadeEasy

4 жыл бұрын

as of now this technique works only with text boxes

@utkarshsaraogi

4 жыл бұрын

did you find any solution regarding this?

@Axayubale

4 жыл бұрын

@@utkarshsaraogi bro did you get any solution

@Axayubale

4 жыл бұрын

please provide me if u get i need it urgently

@ekahariyantadaily6410

4 жыл бұрын

pliss bro

Thanks a lot its very helpful, but i don't understand how to looping, can I get the codes?

@AutomationMadeEasy

3 жыл бұрын

Refer below tutorial: kzread.info/dash/bejne/doqGr5mPfK67drg.html

good tutorial. just one thing is to keep the indent consistent. It give me ocd when i look at the code >

@AutomationMadeEasy

4 жыл бұрын

thanks. noted.

Nice

How can we automatically fill the form whenever there is a new entry in the sheet? Please reply it's urgent

are u filming in airport?

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

How do you do this for a form that has multiple pages? Like 14 of them?

@AutomationMadeEasy

4 жыл бұрын

this technique works for simple forms. You can refer below tutorial for complex forms. kzread.info/dash/bejne/lqOX0K6MlM2eoqw.html

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

I need in google forms , options shud dynamically displayed from a google sheet colmun,, is it possible???

@AutomationMadeEasy

3 жыл бұрын

Yes that is possible but would need custom coded Google Form

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?

@AutomationMadeEasy

3 жыл бұрын

refer below tutorial: kzread.info/dash/bejne/doqGr5mPfK67drg.html

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

@AutomationMadeEasy

2 жыл бұрын

enter some textin the text field and try to find the text in the developer window. You will find the id

@kunalbhatt4333

2 жыл бұрын

@@AutomationMadeEasy Cant find it ...Is there some other tag in it's place?

Getting error Exception: Request failed for docs.google.com returned code 401. Truncated server response:

@AutomationMadeEasy

4 жыл бұрын

Format all data as Plain Text and try

How can you do that for example if you want to select an option on the forms and not only with text ?

@pronone3

4 жыл бұрын

I mean like in marking the sentence

@AutomationMadeEasy

4 жыл бұрын

currently this technique supports only text fields. For complex forms you may use alternate approach described in below tutorial: kzread.info/dash/bejne/g5-i1pqqdrWdm7w.html

Sir plz make a video on auto loop on this continue video...

@AutomationMadeEasy

2 жыл бұрын

refer below tutorial: kzread.info/dash/bejne/doqGr5mPfK67drg.html

Can you send us your code in a typed out form ?

sir how i know my response recorded if i am not owner of google form

Good video. What if the form has many pages?

@AutomationMadeEasy

4 жыл бұрын

Refer below tutorial: kzread.info/dash/bejne/doqGr5mPfK67drg.html

What if there was a radio button, or a square box option with multi choice, how will you automate that?

@navedaasim5048

Жыл бұрын

There is a second video for those complex Google forms

@chaitanyasrinevas8764

Жыл бұрын

@@navedaasim5048 Can you send the video to the second link on how to register for these forms?

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

@AutomationMadeEasy

10 ай бұрын

yes there the execution limits. Single execution 5 minutes and 60 mins over a period of 24 hrs

hi, there is no name attribute in my inputs. so how can we reference them to data?

@AutomationMadeEasy

3 жыл бұрын

refer below tutorial. you wil be able to find the name attribute: kzread.info/dash/bejne/doqGr5mPfK67drg.html

I want it the other way around. Fill out the google form and it creates it in excel

@kunal_chand

4 жыл бұрын

Try Zapier or Integromat

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.

@AutomationMadeEasy

2 жыл бұрын

type something in the text field and search the same in the developer window. You will find the entry id

Hi bro pls help me how to autofill google account enabled forms? I have 30+ gmails but how can we autofill forms? how to manage to fill google enabled form multiple times? pls reply if you know

@AutomationMadeEasy

4 жыл бұрын

refer below tutorial: kzread.info/dash/bejne/hmp8tMyicce9Y5s.html

Can I get a link to documentation you followed

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?

@AutomationMadeEasy

4 жыл бұрын

Hello, I already have a tutorial explaining what you need. Please refer below tutorial: kzread.info/dash/bejne/doqGr5mPfK67drg.html

@TeriCZimmerman

4 жыл бұрын

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!

How can atu feel data 1 sheet data to another data seet,ek google form ka data dusre form pr kese atu feel hoga

is there a way to make this work with drop down menus?

@AutomationMadeEasy

4 жыл бұрын

As of now this technique only works for textboxes.

@AutomationMadeEasy

4 жыл бұрын

Here it is: kzread.info/dash/bejne/doqGr5mPfK67drg.html

can this method be used on mobile phones?

@AutomationMadeEasy

4 жыл бұрын

refer below tutorial: kzread.info/dash/bejne/oJqOrrp_ZdiudpM.html

@SirJazz1000

4 жыл бұрын

Automation Made Easy great, tqs, done like. So can i use this function on google form frm someone else?