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

[@incrediblelearned4981]

good video, funny part was 'html dada'

[@MumbaiKaCoder]

ASMR Coding - Creating Real Switch Button Animation using HTML and CSS kzbin.info/www/bejne/m2bUZJuwe6-gnbc

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

[@firstclass2222]

How is it going 😊?

[@abhijithjinnu603]

Thank You! This works.

[@learning-axis]

thank yoy

[@imsankarb]

Awsome. Thanks!

[@learning-axis]

you welcome

[@prof.alexsouza20]

Amazing! Congratulations! Thanks

[@MirkoTorrisi92]

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

[@TechnoStatistics]

Same

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

[@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]"

[@yalebass]

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

[@VideoSharingg]

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

[@learning-axis]

thank you

[@user-jxnc]

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

[@learning-axis]

thank you

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

[@FikirCompany]

Thank you very much 👍❤

[@elcomentarista3477]

Elegante y muy intuitivo el video felicidades... 🎊🎉

[@owallace190]

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

[@eyasarqam3854]

Thank you, Great JOB♥

[@learning-axis]

🥰

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

[@zidanefirdaus5701]

if you want it to work, you should have better understanding of javascript. it'll require something like this: const data = document.querySelector('span #id'); unless you have learn JS it will be more difficult

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

[@Norway3.0]

Good 🙂

[@learning-axis]

thsnk you

[@ganesht7148]

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

[@Ana-tg2kc]

Amazing tutorial! Thank you very much!

[@duhabejo8370]

Amazing! Thanks,sir..

[@AlvaroGarciaMS]

Funciona correctamente.. Muy Bueno. Works Fine!

[@learning-axis]

Glad to hear that! Happy coding!

[@cashflowai506]

good job brother

[@ngorecruitment-e4v]

Thank you it worked

[@learning-axis]

you welcome

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

[@NgedonTshel]

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

[@ahmadchohan1012]

This video is so useful.

[@Loselegidosdecristo1]

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

[@lounes03b99]

is your code { in google sheet } work with more input feild or just with 4 input feilds?? i used ur code but >> {"result":"error","error":{}}

[@learning-axis]

yes, It can work just create new field in google sheet and follow the same steps as given in video

[@learning-axis]

you can run this code on local server, and also create account on smtpjs

[@BinNguyenVlog]

Amazing! Thanks

[@jorgeflores762]

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

[@learning-axis]

Thank you

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

[@EternalUltimate]

you are the best

[@3PFTChannel]

Thank you, It's awesome

[@learning-axis]

thank you

[@dev.antunes]

Thanks a bunch! It worked well!

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

[@mohdrehan418]

Shukriya bhai❤

[@learning-axis]

you welcome

[@jamal.salouni]

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

[@learning-axis]

thank you

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

[@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!');

[@Instopedia_]

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

[@szyman4666]

Good video thanks a lot

[@PravinLonkar-n2x]

Hi, Thank you so much for your efforts. I am follwing same but getting CORS error. Could you please guide me how to resolve this error. from origin 'null' 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.

[@learning-axis]

Visit this link to see guide and get source code, this may help you. Thank you! learning-axis.com/projects/google-sheets/

[@hiroyukinumaguchi1984]

Great!

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

[@crinceebelempou6611]

Amazing

[@janosch_gnz]

what is the best method to secure the sheet and the webapp against attacks? For example, someone simply takes the endpoint and spams it with a script or someone simply takes the sheet ID and edits or looks at the file

[@learning-axis]

Use authentication and authorization to protect endpoints, implement rate limiting to prevent spamming, and secure your API keys and sensitive data. For sheets, restrict access permissions and use tokens for API interactions.

[@echoesandnoise]

Thank you!

[@faroukgribej5473]

thanks man

[@learning-axis]

You Welcome

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

[@phuclahoang9266]

amazing

[@ghosttech5068]

thank you :)

[@haseebtanvir3651]

what to do if we want to upload a file as well ? firstly i want to upload the file in drive and than save the file link in sheet

[@alexapfatalimachi9224]

thank you very much :)

[@SebastiánAntonioHuertaSoto]

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.

[@SebastiánAntonioHuertaSoto]

I hope you can help me

[@Pratham008]

Thank you so much

[@Sriraam_2k3]

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

[@khoatran1535]

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

[@BinNguyenVlog]

Nice video

[@yourdailyaffirmations9100]

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

[@EspenWith]

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?

[@edppdammks]

greaaattt

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

[@tinashesigauke1149]

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

[@daddoesminecraft1980]

@Learning Axis. Thank you, I followed everything and when I run it, it doesn't bring it over into my spreadsheet. I did use MY spreadsheet link and not yours. I'm not getting any errors, just not getting any results either.

[@learning-axis]

are you using local server for this?

[@daddoesminecraft1980]

@@learning-axis no, it's live on my web server hosted thru godaddy.

[@Karmaevents]

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

[@learning-axis]

yes you can do it

[@SUBASH-i3z]

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

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

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

[@harveywork-i8p]

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?

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

[@asikahmad507]

❤❤❤❤❤

[@newtonm2162]

hello my javascript code seems to not be working, but everything else is okay

[@learning-axis]

It sounds like there might be a small issue in your JavaScript code.

[@VicenteVilaplana]

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

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

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

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

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

[@ruddykielo82]

top!

[@kaleenislive1452]

html dada >>> XD

[@muzamilzaman7463]

Can we get copy of this code ???

[@DipayanBrrandom]

How I store attachment file as well?

[@SUBASH-i3z]

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

[@KanchanChouhan-u2g]

thank you so much!!

[@binhduong607]

Thanks for your sharing but I have a bug : TypeError: Cannot read properties of null (reading 'getId') when I run the source code Code.gs on Google Apps script. Every one know this bug, please tell me the solution. Thanks you so much.

[@learning-axis]

"It sounds like the code is trying to access an element that doesn’t exist. Make sure that the function `getId` is called on an object that is not `null`. Check if all necessary elements or objects are correctly defined before calling `getId`. If you’re fetching something from a Google service (e.g., Drive or Sheets), confirm that the file or sheet exists and the ID is correct. Let me know if this helps!"

[@learning-axis]

and run it on local server

[@binhduong607]

@@learning-axis Thank you so much 😻

[@learning-axis]

@@binhduong607 you welcome

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

[@mundogamer4607]

y como envio archivos se puede hacer eso?

[@coolvibesreloaded7946]

My form submissions aren't going through? Please help

[@learning-axis]

did you run it on local server?

[@coolvibesreloaded7946]

@@learning-axis oh do you have to have a server to run it

[@coolvibesreloaded7946]

@@learning-axis I've tested it on my website added the scripts to Google script put in the header the name of my sheet Music Requests still not working please help

[@learning-axis]

@@coolvibesreloaded7946 yes

[@learning-axis]

@@coolvibesreloaded7946 ok, did you create account on SMTPjs?

[@alexandremartins6130]

Thanks bro!

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

[@GeniusFranklyn]

it didn't work for me, says error instead of success

[@learning-axis]

there main be error, do you run it on local server?

[@GeniusFranklyn]

@@learning-axis yes

[@learning-axis]

@@GeniusFranklyn ok, you also need to create account on smtpjs

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

[@SIDDHARTHKALBURGI]

Can we embed this on my landing page

[@learning-axis]

yes you can

[@ラベンダー-d9b]

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

[@NICKVLOG17]

Bhai kisme coding kar rhe ho

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

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

[@oscar_mine]

thanks man