Post HTML Form Data to Google Spreadsheet - Easiest Way

#HTMLtoGoogleSheet #GoogleSheetAPI #PostFormData
HTML to Google sheet post request to submit html form data to google spreadsheet or ms Excel is not too simple using javascript, jquery and ajax code of few lines. I've attached code reference which will help you to post custom data to google sheet directly without any API and google scripts.

Brief Explanation: Get entry. name attribute from google form using inspect form, and url of Google form, simply replace both with your's to make attached html page works for you.

[Update]
1. Go to view form,
2. open console( inspect element),
3. Click on network (at the top of console), 4. Click on All ,
5. Keep it open and go to form and write something and submit it. Go to already opened console and you will see aa list in Name column under "All" under "Network". 6. Click on formResponse and Headers will appear on the left side. Scroll down at the bottom . You will see "Form Data" heading here you can see "entry.73847" (in your case id can b different) copy it and you are done.

HTML to Google Spreadsheet using Javascript, Ajax Code Download Link, Request all to submit test data only in form, share your feedback how it helped in posting html form data into google spreadsheet:

[FrontendZilla]

[Update]
1. Go to view form,  
2. open console( inspect element),
3. Click on network (at the top of console), 4. Click on All,
5. Keep it open  and go to form and write something and submit it.  Go to already opened console and you will see aa list in Name column under "All" under "Network". 6. Click on formResponse and Headers will appear on the left side. Scroll down at the bottom . You will see "Form Data" heading here you can see "entry.73847" (in your case id can b different) copy it and you are done.

[yogeswarans.p.muniandi]

Thank you so much my brother. After bunch of hours studying and looking for the solutions, finally your video came to rescue to sleep. I think your version in YouTube platform much easy to understand compare to others. Thank you again!

[salmaan]

YOU SAVED MY JOB BRO! I DO FREELANCING AND WAS STUCK WITH THIS TASK. SO MADE MY DAY. THANK YOU SO MUCH! GOD BLESS YOU!

[selvaganeshk]

After spending oneday on youtube finally i got this tutorial its easy and work 100% fine. you are great. Thanks bro.

[LOOOSER]

Thank You so Much bro huge fan, ,,, post this types of

[MyShoppingAdda]

bro how to import google form data to html page, reverse of this video, there is other vedio on youtube but they don't explain in lucid language like you so please make a video on this topic

[toffotin]

Thanks a lot man!
Super valuable.

Now trying to have the data sent to a specific tab.
First of my fields is a dropdown menu called "cars", and I have "car1, car2, car3..." there.
Would love for it to send the data to a tab called "car1" if car1 was selected and so forth.

[TomTom-tyej]

Hello mate! Can you tell me please why did you built the logic within the ajax to the error property? After running the function it will definitely run on error which triggers the error property but I would like to know why not triggering the success property? Is there any solution which ends with success not with error? Thanks!

[pintuchoyan]

Can I push English and Bengali letter same time?

[karlocamusgutierrez]

Hi friend, i have some problems, well i added new fields, 3 select and 2 textform, i upgrade the code but the data isnt copied to my Google SpreadSheet, is it possible share my code with you to see the error?

[adiviharshitha]

Hello, thank you for this very useful video. When I close the google form, it is not taking any responses from the html file. Is it possible to just open the HTML file and send request, which will be stored in spreadsheet?

[Mafia_]

Great tutorial! thanks, where should i add the call to the google ads gtag_report_conversion function to track the click on the button?

[ravindersuppahiya]

You are awesome dude
Thanks for how to find entry field values

[theayaanesmail]

You are the best I love this video & it helped me so much. Please continue for otherrs

[jimshere]

How about other types? like radio, Checkbox etc.. is it the same? or there's other way?

[reallyefficient]

This is great! Thank you!! I'm wondering if there's an easy way to build out if/then questions (similar to how Google Forms allows you to choose "go to section" based on answer). Any tips?

[zuhaatta]

Can you help me with making an approval workflow using the same.
As in when details are submitted can we send email to approver where approver gets an HTML form to approve or Reject the same and that decision is populated to the same spreadsheet?

[PWalko]

nice vid, but is it only works with short answer questions, or can we make like the multiple choice grid work?

[MrBulcina]

Hi, thank you so much for the tutorial, everything is working perfectly, except I can’t figure out how to use Radio Buttons.

Can you tell me what should I write there?
For this example my radio button input name=“MyRadioButton”

var field1 = $(what should go here?)

also is the result value (.val) or a text (.txt)

Thank you!

[СергейЮртаев-ып]

Hello everybody!
If you did everything on video but nothing works, check access to the form. It is important to allow access for everyone.
Even with a CORS error, this will work!