How To Make Working Email Subscription Form With Google Sheets Using HTML CSS & JavaScript

Learn How To Make Working Email Subscription Form With Google Sheets, Coming soon page design using HTML CSS and JavaScript | Send HTML form data on Google Sheets
❤️ SUBSCRIBE: goo.gl/tTFmPb
In this video we will create a coming soon page or launching son page design using HTML and CSS, On this website we will add an Email subscription form or newsletter subscription form also. We will send this HTML form data on Google Sheets so that we can see the email subscribers list on Google Sheets.
GitHub Link: github.com/jamiewilson/form-t...
Download Image: drive.google.com/file/d/1jGew...
-----------------------------------------
Suggested Course:
❤️ Complete website Using HTML and CSS
✔️ 8 Complete website step by step
✔️ Source Code Download
✔️ 76 Lectures, 12 Hours Video
✔️ Course Completion certificate
👉 easytutorialspro.com/go/course/
-------------------------------------
Recommended Videos:
Learn Complete HTML and CSS from basics:
► • HTML And CSS Tutorial ...
Make A Complete Website for college using HTML & CSS:
► • How To Make A College ...
How to make a Business website step by step:
► • How To Make Website Us...
How to make personal resume website step by step:
► • How To Make A Website ...
How to make fitness website design using HTML CSS:
► • How To Make A Website ...
How to make an Ecommerce Website Design:
► • How To Make eCommerce ...
How to make a Job Portal website design with HTML & CSS:
► • How To Make Website Us...
How to make travel website design with HTML CSS Bootstrap:
► • How To Make A Website ...
-------------------------------------
Affordable web hosting (coupon- EASYTUTORIALS)
👉 easytutorialspro.com/hosting/
My recommended tools and tutorials
👉 easytutorialspro.com/
-------------------------------------
◼️ Source code link is shared in community post for all my coding videos exclusively for channel members (only channel members can see)
Join Channel Membership:
► / @greatstackdev
-------------------------------------
Images Credit:
www.pexels.com/
-------------------------------------
Like - Follow & Subscribe us:
◼️ KZbin: goo.gl/tTFmPb
◼️ Facebook: goo.gl/qv7tEQ
◼️ Twitter: / itsavinashkr
◼️ Instagram: / iamavinashkr

[@WilsonStSurin]

There are a lot of KZbinrs who make complicated videos that some times do not work. This video is not only simple but, everything works perfectly as his does. Continue the work!

[@Mac-JustDoIt]

Thank you so much!!! You explained it in a very simple way and it's really working! I've been searching for a tutorial on this for a couple of days but they are all complicated and sometimes don't work. This is exactly what I needed!

[@hafidyusuf81]

Just what i need, thank you so much for making this!

[@susana.esteves]

wow I don't even have words to thank you enough! what a excelent video great quality you explain it so well and with a ryhtm that I can follow! thank you so much

[@pragatijagadale134]

I finally got the right video on the internet. Thank you so much for making this. Lots of gratitude!

[@GreatStackDev]

Glad it was helpful!

[@triumphtechnologies]

the best educative video so far! thanks a million

[@GreatStackDev]

Glad you like this tutorial to send HTML form data on google sheets

[@ranjanbarik1098]

Every Time your suggestion was very very good and i am very happy

[@serbanpascovici913]

You are great! I used this video to create a charity website. thanks. butterfly effect. God bless you

[@jethrossci-fi9528]

Just love this guy

[@cliphord_kapelo]

You the man!!! Really helped me

[@digvi2550]

You do the great work

[@An-yh2bl]

You are the best! 😊

[@DspycesRecords]

Your are the best Bro🙏

[@mdms4549]

it was the Amazing Video thanks bro

[@archanacs680]

Thank you soooo much.working fine🙏

[@user-jk3zt7nk9u]

thank you bro for this vidio you are great

[@okeregodwin7479]

You are really your youtube channel name ,good Job

[@varunvishwakarma4573]

thank you soo much iam subscribing! "you

[@anythingwithgs1841]

great video helped us alot

[@pervinnahid1667]

Really just 1 click in like button and giving thanks are not enough to show gratitude to you. But even thank you so much sir...

[@ismailvedia17]

I love you Avinash❤, I love this content 🙏❤, keep going brooo 💪

[@GreatStackDev]

Thank you so much!

[@DevBigEazi]

God bless you for this great work

[@GreatStackDev]

Thank you kindly

[@king_pomisco]

Just awesome

[@rahulbankura3564]

Thanks a lot for sharing amazing content and knowledge .

[@GreatStackDev]

Welcome Rahul

[@enesaliev]

Thanks a lot! You have been helpful.

[@GreatStackDev]

Glad to hear that!

[@andrianmalic4581]

Thank you!

[@Unlock-Hub]

perfect tutorial ever

[@diegopassosdossantos5964]

Great Content! :)

[@junaidahmed5950]

[@Shameerchagani]

Very useful video. Can you also make one Video on how to retrieve the data from google sheets to the webpage?

[@SlinkyCollins]

Very helpful video...thanks GreatStack😃

[@GreatStackDev]

Glad you enjoyed it! Thanks for your comment. 😊

[@pedromello6488]

You re the best

[@OgyXD]

You're making awesome videos thank you

[@GreatStackDev]

Glad you like this coming soon website with email subscription form

[@WebDevFreelancer4]

Thank you bro❤️‍🔥💝💥

[@GreatStackDev]

Welcome 😊

[@adrien3777]

If it's not working for you (showing success in the console but not putting data in your google sheet) it must be because your Google Sheet is in a different language than english, and therefore the default name of your sheet isn't the one it should be. To fix this, either rename your sheet 'Sheet1', or change the first line of the App Scripts code to match your sheet name. Hope this helps!

[@SonnyWhite_]

Somehow it still wont work for me, i have no idea why. It says Succes in the Console, i changed the name to Sheet1 but its still not showing the Input

[@susana.esteves]

you're great for putting this out there. I had the same problem and took so long to find out the issue

[@konstantinreut2577]

Thank you, but it still doesn't work for me.

[@grayson7650]

It was related to tab name of bottom of the sheet. Let's change the name in English what you set.

[@Hussam2024]

Make sure that the input's name is the same word in the first column in your sheet​ it should be identical email=email not Email @@SonnyWhite_

[@nehakaur9607]

superb 😍

[@atifahmad19]

Great bro

[@Indonesia1persen]

I'm still learning about programmers, but still learning css3. This video is very helpful

[@GreatStackDev]

Glad it was helpful!

[@tieflabs]

thank you brother

[@Autopsiah]

Thank you

[@abdulahadgazi3460]

Beautiful

[@greentube2024]

Love your all contents. Please make a video on dashboard. You can make it part by part. Thank you.

[@FactsDude01]

thanks a lot , I really want this kind of unique and awesome project. ❤❤

[@GreatStackDev]

Glad you liked it. Thank You. 😊

[@FactsDude01]

@@GreatStackDev please can you explain the code inside of Google extension app script

[@FactsDude01]

@@GreatStackDev and also appreciate your efforts

[@huyho9229]

Very nice guy

[@danishbukhari6693]

if it's not working then just keep it in mind that the list name should be email not emails or something else, I was getting response success but wasn't getting the emails in the list. Then I just changed the list name from emails to Email and it's working. the name of the sheet can be anything mine is Email list for practicing and it's working fine.

[@jonathanmaynard2551]

Fye

[@sewalimech6830]

Please make a video on Student results displaying using Filter system

[@DanielRamirez-ys8tx]

working!

[@WhiteDoberman]

This is very, very helpful and very well outlined. Is there a way to be notified when a new email is collected/submitted via the form or via the Google Sheet?

[@johnlarch3779]

Thank you so much!

[@GreatStackDev]

You're welcome!

[@johnlarch3779]

@@GreatStackDev I'm actually having a problem now where it says success, but the data isn't transferred. Do you know why this could be?

[@GreatStackDev]

please check console of Web browser, is there any error message?

[@johnlarch3779]

@@GreatStackDev Nope, it says thank you for subscribing, but I never get the data.

[@GreatStackDev]

you can send me your code on email, will check what's the issue. Email [[e-mail]]

[@peaceout9805]

Can you do after submitting redirect to the home page

[@kindred9768]

Sir Please make a Video on Foodpanda with html css

[@goodlaugh1094]

Execution started TypeError: Cannot read properties of null (reading, 'getId') 😢

[@nevinsronald8728]

😃😍

[@user-ts6kt4qe9w]

Hi, i followed this tutorial line to line checked back a good few times but im having a issue, im getting the console saying success but it's not pulling any data to the spreadsheet, I can see a few comments with this issue but I can't see any fixes. Do you have any solutions on how we can fix this please. thanks

[@WimmelJimmel]

same here

[@MADKingR]

Same here.

[@WimmelJimmel]

I named my sheet identical to the name in the video - somehow it worked then lols 🤷‍♂

[@user-ms8zl8re2i]

I love you 😍 💗

[@abdulwassayansari9989]

Can you help me getting multiple forms on same page with the same submit function I tried but only getting response from 1 form as their is no ID calling in JavaScript Thank you.

[@DanteMishima]

Hey, I'm tying to implement this for my react project.... Could you help me please

[@telugucareerguide]

Please start online classes I will join

[@ElkeT-jb8qn]

Can I easily move the google sheet to another google account or do I have to start over?

It says success but the names never shows up in the google sheet, do you got some resolvement to this? I have tried the tutorial multiple times but I can't catch this error

[@mertbayram9781]

same here

[@KrishnamoorthyIlakkanan]

This is really helpful, but here, once we register one email address. it allow to register to same address, that is also working, how to omit this error?

[@jethrossci-fi9528]

Please do a php tutorial

[@abdullahmirza5551]

Bro please make all in one video downloader without code

[@shivvugamer8196]

Please sir stock screener wabsite kaise banaye html and css Please a full video

[@badkapitals]

hey can you make how to validate if we already entered the email?

[@quickgamingnerd]

How would you create a way for people to unsubscribe from it? I understand how to make the main page, but is there a way to automate the removal of their email from the list?

[@marwantarifit4114]

I have a problem, I have the success message in console.log but I don't receive any email in my google sheet document

[@ajmalassouma2269]

It doesn't work with me. Emails not showing in google sheet. And the script link gives me an error Script function not found: doGet

[@mahdiasgari9358]

thanks but you missed one step according to project GitHub

[@pravakarbasnet2547]

Why my deployment is not working? Anyone knows, please help !!

[@maheenanwar6351]

bhai jab hm small screen karty han to text or pic wgera jo lgai hoti merge ho jati hn🤯 hm is ko kesy thik karyn gy 🤔

[@tommytanti1776]

Is it secured? Anyone can assess the google sheet

[@varadgholap1767]

Is it ok to copy paste saved code without understanding it?

[@PrashanthPoojari87]

I am Getting uncaught typeerror

[@An-yh2bl]

A question. Is it permitted to use this code and your method in projects which I sell for clients? I mean only the JS code and not the HTML and CSS.

[@alekseyfelk9137]

no

[@jaypanchal1771]

Great job broo! i having one doubt! If we get exit from the google sheet page will the data be remain there?

[@shivanirao9607]

yes it will

[@devshimul7277]

@@shivanirao9607 not working data is not storing google sheet why?

[@enesaliev3518]

Here when the subscribel subscribers how he/she can get automaticaly email as welcome to our email list and so on

[@alekseyfelk9137]

How can i buy course for Russian ?

[@its_vikas_saxena]

I did'nt understand that JavaScript part?

[@onlysports8101]

Bro you are doing amazong work but i want to learn how to make a news website like either "ary news " "geo news " or "BBC News"

[@GreatStackDev]

please check this video to make news website or blog: kzbin.info/www/bejne/bYfWd4GqmcyroNU

[@gangadhars4355]

hi avinash, i tried this but dont know what is the error but its not working data not reflecting in google sheet

[@GreatStackDev]

check the error message in browser console

[@musarapio_hha]

how you can sell a software, and when you buy it you can download from the page

[@GreatStackDev]

make a website with WordPress and WooCommerce. then upload a product as a digital downloadable product

[@BeneeshS]

how to create a login & signup page with googlesheet using html css js

[@devshimul7277]

why not storing data to google sheet

[@DeepakLalchandaniProfile]

please unable to get code under community posts. please reply.

[@GreatStackDev]

just posted, please check. Thanks for supporting my channel

[@DeepakLalchandaniProfile]

@@GreatStackDev awesome dude. I have a specific requirement. Where can i send it to you. Please share your email address

[@chadytamdy1902]

The video was great, I really like your videos. But the emails don't appear on my Google Sheets, any help.

[@GreatStackDev]

Thank you, there must be any minor mistake, that i can't tell you without seeing your code.

[@MADKingR]

Followed everything on your video, but it is not working. No email is submitted to the sheet despite it is showing success in the console.

[@estersouza8380]

O mesmo problema esta acontecendo comigo e não estou conseguindo resolver.

[@saurabhmishra8470]

hello sir... I implemented this code on my website & it's working fine........ but the issue is when user clicked on the send button... it takes time to show the msg [ thank you for subscribing ]... during this period user clicked 3 or 4 more times and I received same mail id for 3 or 4 time... can you pls tell the solution...

[@metadsexpert]

pls share your email id

[@daniell9384]

mine did not work and i dont know why?????

[@yavalio7500]

I dont know why my submisions doesnt apear on my spread sheet¡

[@MartinHasen]

me neither

[@shamseverything6106]

Can any one tell me should i memorize this code ??

[@User-lm4qq]

no

[@munde95]

You said I'll put the googlesheet code on comment section. But you didn't. Could you give the code?

[@GreatStackDev]

It is already given in the video description. here is the link: github.com/jamiewilson/form-to-google-sheets

[@hack7071]

Why it's not working ?

[@JanisStiprais]

Doesn't work on Google Sheets.

[@user-rt7ql9di7l]

9.Feb.24

[@dracula387]

10:10 what you came for

[@khadijah22]

TO ALL THOSE WHO DID NOT GET THE MAIL ID PUSHED TO THE SHEET, refresh the apps script page after pasting the script and then paste again. Also rename it to "Submit Form to Google Sheets"

[@JanisStiprais]

Does not work!

[@siddharthbhagat8458]

Code.gs its runs and stop every time, I hit RUN

[@anythingwithgs1841]

great video helped us alot