Google Sheets | How To Send HTML Form Data To Google Sheets

#html #css #javascript #tutorials #trending #new #google #googlesheets #integration
Source code (HTML Form): shorturl.at/frDFY
App Scripts: shorturl.at/cklT2
Sound effects from Pixabay.

[@incrediblelearned4981]

good video, funny part was 'html dada'

[@PakistanZindabad-vi6xd]

🫡🫡🫡🫡 This channel is so amazing. God bless all of U. M just started learning HTML as my first language to learn. And these easy tutorials are blessings for me. Boss don't know how to express my gratitude.... Thanks very much!! 🥲🥲🥲 Love and respect from Multan Pakistan 🇵🇰

[@learning-axis]

Thank you bro.

[@kaleenislive1452]

INDIA jindabaaadd

[@CanaldoGui]

Thank you so much for everything! God bless you and give back double for your contribution and sharing this solution with us! Grateful 🤝🏼

[@learning-axis]

thank you

[@TuấnNghĩaNguyễn-j3t]

This video is so helpful. How to make it works with instead of ?

[@learning-axis]

it will not work with

[@studysangam0.194]

Sir ka video bahut achha hai mai bahut paresan tha javascript code ke lekar magar aapki sahayta aur chatgpt ke maddt se clear ho gya Thanks sir❤❤

[@learning-axis]

Thank you

[@MirkoTorrisi92]

Am I the only one who found IMPOSSIBLE to debug this stuff?? Really crazy.

[@yalebass]

this actually worked great! was a bit sus of the permissions shenanigans, but it's probably fine. thanks so much!

[@owallace190]

I don't know how it works, but it's what I was looking for so much

[@asikahmad507]

❤❤❤❤❤

[@abraham_o]

If I have 3 wishes from a genie, one of them will be to be able to write code like this without writing bugs or the need to press backspace... 🤤 I mean this is amazing.

[@danieladestefano3880]

Great video, and very well explained. Is there a way after having written the data to display only a correct sending message without displaying the address of the reference page in the pop up? Thank you for your response and your help.

[@learning-axis]

Thank you for your feedback! Yes, you can modify the pop-up to display only a success message without showing the reference page address. You can achieve this by setting the pop-up content to your desired message. Here’s a quick example: alert('Data sent successfully!');

[@user-jxnc]

Thank you so much! with the source code, it's so easy and that works!

[@learning-axis]

thank you

[@prof.alexsouza20]

Amazing! Congratulations! Thanks

[@Sloppynuts]

Thank you, bro. Your tutorial is very useful. keep it up!

[@learning-axis]

thank you

[@Pratham008]

Thank you so much

[@ganesht7148]

Thankyou very much! i was struggling with the CORS error. This helped a lot.

[@TestVideo2share]

That's great, thank You very much!!👍

[@learning-axis]

thank you

[@FikirCompany]

Thank you very much 👍❤

[@ak_yt86]

I really find this video bro, you made my day 😍, thanks a lot for you make this video for me 🙂

[@learning-axis]

thank you

[@edppdammks]

greaaattt

[@abhijithjinnu603]

Thank You! This works.

[@learning-axis]

thank yoy

[@duhabejo8370]

Amazing! Thanks,sir..

[@suketudeliwala7673]

Thanks.. I could make small application of change of address for a small NGO without domain and storage.. thank you so much.. god bless you...👃👃

[@learning-axis]

thank you

[@ahmadchohan1012]

This video is so useful.

[@cashflowai506]

good job brother

[@oscar_mine]

thanks man

[@BinNguyenVlog]

Amazing! Thanks

[@hiroyukinumaguchi1984]

Great!

[@dev.antunes]

Thanks a bunch! It worked well!

[@jorgeflores762]

Gracias, nos salvaste la vida a mi grupo y a mi, eres el mejor.

[@learning-axis]

Thank you

[@jamal.salouni]

thank you so much you give me exactly what i want you are amazing

[@learning-axis]

thank you

[@crinceebelempou6611]

Amazing

[@kaleenislive1452]

html dada >>> XD

[@capurim]

Thank you, it's a very nice tutorial but I have got an error in console : Access to fetch at 'my script URL' from origin 'my local URL' has been blocked by CORS policy: Response to preflight request doesn't pass access control check: No 'Access-Control-Allow-Origin' header is present on the requested resource. If an opaque response serves your needs, set the request's mode to 'no-cors' to fetch the resource with CORS disabled. Do you have a tip to resolve this bug? Thanks !!

[@beinfomaniac7182]

Same problem

[@phuclahoang9266]

amazing

[@Loselegidosdecristo1]

Este vídeo vale oro, estuve buscando vídeo pero esta es la mejor,

[@szyman4666]

Good video thanks a lot

[@BinNguyenVlog]

Nice video

[@3PFTChannel]

Thank you, It's awesome

[@learning-axis]

thank you

[@user-se4pf6vu5r]

how would be the app script if i add another sheet within the same google sheet

[@frankbonan7273]

Thanks beautiful project, how can I do to add a column with date and time added automatically to each submit?

[@learning-axis]

You can fetch time in JavaScript, forward it into the new input tag's value, and then to google sheets.

[@SUBASH-i3z]

It only works on copy path website only but it doesn't work after hosting how can i solve it

[@alexapfatalimachi9224]

thank you very much :)

[@SUBASH-i3z]

Bro it does not conduct user input after hosting how can i get user input after host public pls give me answer

[@Instopedia_]

Sir same method aan njn cheythr, but enik submit akumbo something error enna aa msg varunnu Enthaa cheyya

[@eldonmati]

This is genius work, thank you for sharing! Question, is there a way to make it send an email notification every time a new row is added to the spreadsheet?

[@learning-axis]

You can integrate email by using smtpjs; I have created video on that, Video link: kzbin.info/www/bejne/bnulnWWLnJyDlacsi=gkVXSV5JJ11ANUn-

[@alexandremartins6130]

Thanks bro!

[@ruddykielo82]

top!

[@yourdailyaffirmations9100]

How can we make the process faster.. it takes 5 secs.. Can we reduce it

[@k.harsha8792]

{"result":"error","error":{}} Iam getting this error after submitting the form can you please tell me where to correct

[@learning-axis]

create account on smtpjs and add two step verification to you Gmail account

[@user-ws6uw9rs9l]

I've copied your codes and done everything in your video. I get this error: "Script function not found: doGet"

[@learning-axis]

do you add script in google sheets?

[@khoatran1535]

If I click submit multiple times, many records with the same content will be created in the Google sheet. How to prevent that. Thank you

[@learning-axis]

you should also add "reload page function" on submit button

[@khoatran1535]

thank you so much.i have resolved@@learning-axis

[@echoesandnoise]

Thank you!

[@user-il9lc4wm4c]

thank you so much!!

[@beinfomaniac7182]

I am having cors error Does anyone know how to fix it

[@DougsTea]

You can just copypaste the code directly from his file. Mine isn't submitting any data to the google sheet (there is no error though).

[@CamiloR1997]

11:30 I have a problem with this part of the code, I'll explain. I completely created the code and the js file, and also the html linked that file, copied the link from Google Sheet and also pasted it into the js code. but when I refresh the page and enter their information and hit send, nothing happens. Neither the data is added to the sheet nor does the message appear.

[@learning-axis]

did you create account on smtpjs.

[@learning-axis]

and also add two step verification to your gmail

[@CamiloR1997]

@@learning-axis The code works for me, the form data is complete, everything is excellent, but when I enter the code for the thank you message and click send, nothing happens, the data does not arrive and the message does not appear either.

[@CamiloR1997]

@@learning-axis I already have my Hosting and I am doing it directly and my Gmail also has two-step verification. Do you have an email address where I can send you a short video so that you can help me?

[@learning-axis]

@@CamiloR1997 yeah "[e-mail]"

[@harithdevinda]

thank you ... !!!

[@tinashesigauke1149]

i have 3 diffrent form on my html code how do i go about it

[@khoatran1535]

Hi, i have a list input (checkbox) and i want to multi choice values. How to do it

[@user-wq2yo4ok5h]

I implemented this in nextjs and in a separate project only from html and js and for some reason that I don't know it did not recognize the spreadsheet at any time, it does not allow me to record data. I'm sure I created the script on the same sheet and compared each line. I don't know what it was due to.

[@user-wq2yo4ok5h]

I hope you can help me

[@zanport]

It don't work! Don't waste your time!!!

[@Mickiewicz114]

I did everything listed in this video but it didn't work. Why does it keep showing me error with empty {}

[@learning-axis]

I also provided the code link in description please use that code

[@user-hm8mt3yf4u]

sir I am getting this : {"result":"error","error":{"name":"Exception"}} help me!!

[@KoartePlays]

thanks

[@BasilIkpe]

Thank yoooooooooou

[@CT_Crock]

I have question why i do the same step with yours but i my contact data won't add into google sheet but it show sucess in row 2

[@mundogamer4607]

y como envio archivos se puede hacer eso?

[@rysh62]

It gives me the "Result": "Success" "row 2" message but doesn't actually add onto the google sheets. What's the problem?

[@learning-axis]

check the names of inputs. check the name of the sheet you put in the app script.

[@rysh62]

@@learning-axis cool i got it working! Thanks

[@azharahmed7928]

facing same issue what was the issue?

[@learning-axis]

@@azharahmed7928 check the names of inputs. check the name of the sheet you put in the app script.

[@EternalUltimate]

you are the best

[@anhleuc1365]

Great guide. I have 2 words but want to dump data into the same sheet. from 1 dump data page1 . from 2 dump data page2 . I have tried but it's failed . help me

[@muzamilzaman7463]

Can we get copy of this code ???

[@NicholasWidmer]

what is in the java script file. Everytime i submit my page it bring me to a "pretty print" app script page. How do i stop this?

[@learning-axis]

are you using local server?

[@user-wx4rm8bt2c]

Un descubrimiento, gracias. Intento modificarlo para poder subir una imagen pero no logro hacerlo. Me sale el formulario bien, no me da errores pero ni me sube la imagen ni me registra la URL

[@payunghujan1758]

HOW to With Upload file/image?

[@skillzorskillsson8228]

You do know that font-family and font-size is inherited properties right? So why use it on the universal selector?

[@learning-axis]

Some properties like font-size, and font-family are inherited from the parent when the element has no value specified in itself

[@mk.bigboss122]

​@@learning-axis Hlo bro, I need a website, I will give money when the website complete. How to contact you 🤔 plz replay me

[@learning-axis]

contact me on: [e-mail]

[@learning-axis]

@@mk.bigboss122 sure

[@clevermissfox]

They aren’t inherited by default on inputs. You have to set input {font: inherit}

[@SIDDHARTHKALBURGI]

Can we embed this on my landing page

[@learning-axis]

yes you can

[@Sriraam_2k3]

Anybody can explain why he code in that another page of Excel site program 7:14

[@DipayanBrrandom]

How I store attachment file as well?

[@vincentsominski9124]

Hey. Really nice guide. I was wondering if it is possible to set each sheet to be for a single form and has like for ex. 3 forms and for each one will be one sheet. Do you have any idea if it is accessible?

[@learning-axis]

you can do these things using node js

[@hirenprajapati1]

cors error occur in console log

[@learning-axis]

can you explain more?

[@hirenprajapati1]

@@learning-axis cross origin restriction policy error . proxy server needed

[@learning-axis]

@@hirenprajapati1 you need to add two step verification to your email

[@user-rw4xm6qn5w]

{"result":"success","row":5} - this error i can see after submit with js, and with js, form is not coming after refresh

[@learning-axis]

add 2 factor authentication in you Gmail

[@user-cz7gz1cy1n]

how do you add a 'upload file', add an image from files and then receive and open it on google sheets?

[@learning-axis]

we can't receive image file in google sheets

[@v2al389]

So where can I send the file to open it?

[@gabrielkaqinari8299]

Why submit button is not working to send data materials to google sheets ? @Learning Axis

[@learning-axis]

see code link in description, that may help you

[@user-lb4rx2tg1y]

Bro why the php file is downloading when i click on submit

[@learning-axis]

I provided the code link in description copy the it may resolve your issue

[@harsharavi2683]

Hi, everything works perfectly. I want to know how do I redirect to another link once the form is submitted? Thanks in advance

[@learning-axis]

Replace (window. location.reload.) with (window. location.href="link";)

[@antoniosh8130]

@@learning-axis Hi! When I'm trying to fetch it shows an error saying I'm missing some headers? And keeps saying failed to fetch

[@learning-axis]

@@antoniosh8130 add twostep verification to you Gmail and create account on smtpjs

[@shahjahanali5189]

How to add pictures in your form and upload my google drive

[@Karmaevents]

hey good job, can we do it for a multiple step form ?

[@learning-axis]

yes you can do it

[@Lumina__]

Hi sir can you help me because im having a problem where it shows this error: Thank you in advance {"result":"error","error":{}}

[@adityasrivastava6701]

how to take file as input

[@learning-axis]

you can do it by using

[@polliosantrophilloes]

how to upload this?

[@Asd_Marriage_Beauro]

sir ham na form ma photo be lagai ha photo ko google sheet ma kase save kare ga ya bata da thank you!

[@user-ul8ro6po4c]

i want it to send it in exel app is it possible?

[@rishamdeiv8252]

not working, after i submitted the form its appears {"result":"error","error":{}}

[@akarshgururaju5073]

Yes i am facing the same problem

[@akarshgururaju5073]

Is there any soln to it

[@user-ls7zg7kg1b]

please do same in google site

[@Gamernick1404]

Bhai kisme coding kar rhe ho

[@tony4512]

Great video and thank you for sharing. First time playing with Google sites and I have everything up and running as in your video, I just can't figure out where I build and save the "Google Sheet.js" file and how it links to everything. Would you be able to elaborate a little more on this part (video marker 11:09)?

[@learning-axis]

just create a file named as sheet.js in any folder

[@user-ko3rb4sl4z]

sir mere me to submit btn pr click kar ke redirect ho raha hai muje vo disable karna kese karu

[@learning-axis]

redirection wala function hata doo

[@user-go5wv9mg5j]

sir please share the script for delete record from google sheet.

[@jademarkfernandez1890]

What app did you use to code? Im not very familiar sorry

[@learning-axis]

sublime text

[@jademarkfernandez1890]

How about adding new column in google sheet,?

[@jademarkfernandez1890]

What is the code?

[@ferigalung]

I follow along your video and facing an error 302 while sending my formData to app script, with response like this: {"result":"error","error":{}} could you help me? i'll send you more detail if you wish (maybe trough discord or something) thank you

[@ferigalung]

nvm i figured it out

[@TipsportRalphLauren]

how did you fixed it? @@ferigalung

[@zeyadbelal9901]

@@ferigalung e in dopost is undfiened so i get that error {"result":"error","error":{}} can u help plz ?