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

แชร์
ฝัง
  • เผยแพร่เมื่อ 24 พ.ย. 2024

ความคิดเห็น • 158

  • @WilsonStSurin
    @WilsonStSurin ปีที่แล้ว +11

    There are a lot of TH-camrs 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!

  • @anabelamarquesdasilva
    @anabelamarquesdasilva 15 วันที่ผ่านมา

    What an excellent video class! Simple and clear! Five stars!!!! 🤩

  • @adrien3777
    @adrien3777 ปีที่แล้ว +19

    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_
      @SonnyWhite_ ปีที่แล้ว +4

      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
      @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
      @konstantinreut2577 ปีที่แล้ว +1

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

    • @grayson7650
      @grayson7650 11 หลายเดือนก่อน

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

    • @Hussam2024
      @Hussam2024 10 หลายเดือนก่อน

      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_

  • @pragatijagadale134
    @pragatijagadale134 ปีที่แล้ว +2

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

  • @triumphtechnologies
    @triumphtechnologies 2 ปีที่แล้ว +3

    the best educative video so far! thanks a million

    • @GreatStackDev
      @GreatStackDev  2 ปีที่แล้ว

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

  • @christophermawela3318
    @christophermawela3318 หลายเดือนก่อน

    Success, followed all steps and the program completed successfully without facing any difficulty, Thanks Avinash...

    • @ScriptingWithSaad
      @ScriptingWithSaad หลายเดือนก่อน

      mera tu nhi hoa

    • @ScriptingWithSaad
      @ScriptingWithSaad หลายเดือนก่อน

      console pr success msg appear ho raha ha magar google sheet pr nhi araha ha

  • @Mac-JustDoIt
    @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!

  • @Indonesia1persen
    @Indonesia1persen 2 ปีที่แล้ว +2

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

  • @pervinnahid1667
    @pervinnahid1667 7 หลายเดือนก่อน

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

  • @serbanpascovici913
    @serbanpascovici913 8 หลายเดือนก่อน

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

  • @susana.esteves
    @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

  • @digvi2550
    @digvi2550 2 ปีที่แล้ว +3

    You do the great work

  • @hafidyusuf81
    @hafidyusuf81 ปีที่แล้ว

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

  • @MaskedJet_Rush
    @MaskedJet_Rush 2 ปีที่แล้ว +1

    Just love this guy

  • @ranjanbarik1098
    @ranjanbarik1098 2 ปีที่แล้ว

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

  • @SlinkyCollins
    @SlinkyCollins 5 หลายเดือนก่อน +1

    Very helpful video...thanks GreatStack😃

    • @GreatStackDev
      @GreatStackDev  5 หลายเดือนก่อน

      Glad you enjoyed it! Thanks for your comment. 😊

  • @ismailvedia17
    @ismailvedia17 2 ปีที่แล้ว +3

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

  • @DevBigEazi
    @DevBigEazi 2 ปีที่แล้ว +1

    God bless you for this great work

  • @okeregodwin7479
    @okeregodwin7479 2 ปีที่แล้ว

    You are really your youtube channel name ,good Job

  • @Muscle_Mindset_Daily
    @Muscle_Mindset_Daily ปีที่แล้ว +1

    thank you bro for this vidio
    you are great

  • @danishbukhari6693
    @danishbukhari6693 6 หลายเดือนก่อน

    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.

  • @mdms4549
    @mdms4549 2 ปีที่แล้ว +1

    it was the Amazing Video
    thanks bro

  • @abdelmajidagreenois4893
    @abdelmajidagreenois4893 หลายเดือนก่อน

    Thank You that is woooooork 10000%

  • @WhiteDoberman
    @WhiteDoberman 10 หลายเดือนก่อน

    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?

  • @cliphord_kapelo
    @cliphord_kapelo 8 หลายเดือนก่อน

    You the man!!! Really helped me

  • @junaidahmed5950
    @junaidahmed5950 2 ปีที่แล้ว +1

  • @rahulbankura3564
    @rahulbankura3564 2 ปีที่แล้ว +2

    Thanks a lot for sharing amazing content and knowledge .

  • @FactsDude01
    @FactsDude01 5 หลายเดือนก่อน +1

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

    • @GreatStackDev
      @GreatStackDev  5 หลายเดือนก่อน +1

      Glad you liked it. Thank You. 😊

    • @FactsDude01
      @FactsDude01 5 หลายเดือนก่อน

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

    • @FactsDude01
      @FactsDude01 5 หลายเดือนก่อน

      @@GreatStackDev and also appreciate your efforts

  • @greentube2024
    @greentube2024 2 ปีที่แล้ว +4

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

  • @PositiveVibesCoach
    @PositiveVibesCoach 2 ปีที่แล้ว +1

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

  • @Chaotic360Remastered
    @Chaotic360Remastered ปีที่แล้ว +6

    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
      @WimmelJimmel ปีที่แล้ว +3

      same here

    • @MADKingR
      @MADKingR ปีที่แล้ว +2

      Same here.

    • @WimmelJimmel
      @WimmelJimmel ปีที่แล้ว +3

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

  • @Unlock-Hub
    @Unlock-Hub ปีที่แล้ว

    perfect tutorial ever

  • @HetShah08
    @HetShah08 3 หลายเดือนก่อน

    HI, I really liked your video and how you taught, i only have a question at 13:32 that instead of anyone if i select only me then what will happen ??

  • @anythingwithgs1841
    @anythingwithgs1841 ปีที่แล้ว

    great video helped us alot

  • @An-yh2bl
    @An-yh2bl ปีที่แล้ว

    You are the best! 😊

  • @DspycesRecords
    @DspycesRecords 2 ปีที่แล้ว

    Your are the best Bro🙏

  • @Nickforu
    @Nickforu 2 ปีที่แล้ว +1

    Thank you bro❤️‍🔥💝💥

  • @pedromello6488
    @pedromello6488 9 หลายเดือนก่อน

    You re the best

  • @archanacs680
    @archanacs680 ปีที่แล้ว

    Thank you soooo much.working fine🙏

  • @huyho9229
    @huyho9229 2 ปีที่แล้ว +1

    Very nice guy

  • @atifahmad19
    @atifahmad19 2 ปีที่แล้ว +1

    Great bro

  • @marwantarifit4114
    @marwantarifit4114 9 หลายเดือนก่อน

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

  • @enesaliev
    @enesaliev ปีที่แล้ว

    Thanks a lot! You have been helpful.

  • @varunvishwakarma4573
    @varunvishwakarma4573 9 หลายเดือนก่อน

    thank you soo much
    iam subscribing! "you

  • @peaceout9805
    @peaceout9805 2 ปีที่แล้ว +1

    Can you do after submitting redirect to the home page

  • @goodlaugh1094
    @goodlaugh1094 ปีที่แล้ว +4

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

  • @sewalimech6830
    @sewalimech6830 2 ปีที่แล้ว

    Please make a video on Student results displaying using Filter system

  • @kindred9768
    @kindred9768 2 ปีที่แล้ว +1

    Sir Please make a Video on Foodpanda with html css

  • @king_pomisco
    @king_pomisco 2 ปีที่แล้ว

    Just awesome

  •  ปีที่แล้ว +3

    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

  • @Autopsiah
    @Autopsiah 2 ปีที่แล้ว +1

    Thank you

  • @telugucareerguide
    @telugucareerguide 2 ปีที่แล้ว +1

    Please start online classes I will join

  • @OgyXD
    @OgyXD 2 ปีที่แล้ว

    You're making awesome videos thank you

    • @GreatStackDev
      @GreatStackDev  2 ปีที่แล้ว

      Glad you like this coming soon website with email subscription form

  • @abdulahadgazi3460
    @abdulahadgazi3460 2 ปีที่แล้ว +1

    Beautiful

  • @andrianmalic4581
    @andrianmalic4581 6 หลายเดือนก่อน

    Thank you!

  • @KrishnamoorthyIlakkanan
    @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?

  • @johnlarch3779
    @johnlarch3779 ปีที่แล้ว +1

    Thank you so much!

    • @GreatStackDev
      @GreatStackDev  ปีที่แล้ว +1

      You're welcome!

    • @johnlarch3779
      @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
      @GreatStackDev  ปีที่แล้ว +1

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

    • @johnlarch3779
      @johnlarch3779 ปีที่แล้ว

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

    • @GreatStackDev
      @GreatStackDev  ปีที่แล้ว +1

      you can send me your code on email, will check what's the issue. Email [avinashdm@outlook.com]

  • @nehakaur9607
    @nehakaur9607 ปีที่แล้ว

    superb 😍

  • @diegopassosdossantos5964
    @diegopassosdossantos5964 2 ปีที่แล้ว

    Great Content!
    :)

  • @ElkeT-jb8qn
    @ElkeT-jb8qn ปีที่แล้ว

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

  • @tieflabs
    @tieflabs 2 ปีที่แล้ว

    thank you brother

  • @quickgamingnerd
    @quickgamingnerd 10 หลายเดือนก่อน

    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?

  • @DanteMishima
    @DanteMishima 2 ปีที่แล้ว

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

  • @jonathanmaynard2551
    @jonathanmaynard2551 ปีที่แล้ว

    Fye

  • @abdulwassayansari9989
    @abdulwassayansari9989 2 ปีที่แล้ว

    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.

  • @deckmanbestie9772
    @deckmanbestie9772 8 วันที่ผ่านมา

    Im getting a Cannot read properties of undefined (reading 'addEventListener') error, any help?

  • @varadgholap1767
    @varadgholap1767 4 หลายเดือนก่อน

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

  • @jaypanchal1771
    @jaypanchal1771 2 ปีที่แล้ว

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

    • @shivanirao9607
      @shivanirao9607 2 ปีที่แล้ว

      yes it will

    • @devshimul7277
      @devshimul7277 2 ปีที่แล้ว

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

  • @mahdiasgari9358
    @mahdiasgari9358 2 ปีที่แล้ว

    thanks but you missed one step according to project GitHub

  • @الظلامدانتي
    @الظلامدانتي 2 ปีที่แล้ว +1

    I love you 😍 💗

  • @maheenanwar6351
    @maheenanwar6351 2 ปีที่แล้ว +1

    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
    🤔

  • @onlysports8101
    @onlysports8101 2 ปีที่แล้ว

    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
      @GreatStackDev  2 ปีที่แล้ว

      please check this video to make news website or blog: th-cam.com/video/7VsFNtdgxjs/w-d-xo.html

  • @An-yh2bl
    @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.

  • @DanielRamirez-ys8tx
    @DanielRamirez-ys8tx ปีที่แล้ว

    working!

  • @abdullahmirza5551
    @abdullahmirza5551 ปีที่แล้ว

    Bro please make all in one video downloader without code

  • @gangadhars4355
    @gangadhars4355 2 ปีที่แล้ว +1

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

    • @GreatStackDev
      @GreatStackDev  2 ปีที่แล้ว

      check the error message in browser console

  • @chadytamdy1902
    @chadytamdy1902 2 ปีที่แล้ว

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

    • @GreatStackDev
      @GreatStackDev  2 ปีที่แล้ว

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

  • @DeepakLalchandaniProfile
    @DeepakLalchandaniProfile 2 ปีที่แล้ว +2

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

    • @GreatStackDev
      @GreatStackDev  2 ปีที่แล้ว

      just posted, please check. Thanks for supporting my channel

    • @DeepakLalchandaniProfile
      @DeepakLalchandaniProfile 2 ปีที่แล้ว

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

  • @shivvugamer8196
    @shivvugamer8196 2 ปีที่แล้ว

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

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

  • @anupamdandriyal4192
    @anupamdandriyal4192 3 หลายเดือนก่อน

    everything is fine but data isn't visible on the spreadsheet

  • @badkapitals
    @badkapitals 2 ปีที่แล้ว

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

  • @musarapio_hha
    @musarapio_hha 2 ปีที่แล้ว

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

    • @GreatStackDev
      @GreatStackDev  2 ปีที่แล้ว

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

  • @its_vikas_saxena
    @its_vikas_saxena 10 หลายเดือนก่อน

    I did'nt understand that JavaScript part?

  • @Alex_Felix_life
    @Alex_Felix_life ปีที่แล้ว

    How can i buy course for Russian ?

  • @naaziz-ytyt
    @naaziz-ytyt 2 หลายเดือนก่อน

    i want ask, something. when i open live serve. nothing happen just blank page (color blank).
    Somebody help me ;)

  • @MADKingR
    @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
      @estersouza8380 ปีที่แล้ว

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

  • @MaskedJet_Rush
    @MaskedJet_Rush 2 ปีที่แล้ว

    Please do a php tutorial

  • @dracula387
    @dracula387 11 หลายเดือนก่อน +1

    10:10 what you came for

  • @devshimul7277
    @devshimul7277 2 ปีที่แล้ว

    why not storing data to google sheet

  • @tommytanti1776
    @tommytanti1776 ปีที่แล้ว

    Is it secured? Anyone can assess the google sheet

  • @saurabhmishra8470
    @saurabhmishra8470 2 ปีที่แล้ว

    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
      @metadsexpert ปีที่แล้ว

      pls share your email id

  • @pravakarbasnet2547
    @pravakarbasnet2547 2 ปีที่แล้ว

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

  • @BeneeshS
    @BeneeshS 11 หลายเดือนก่อน

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

  • @nevinsronald8728
    @nevinsronald8728 2 ปีที่แล้ว

    😃😍

  • @munde95
    @munde95 ปีที่แล้ว

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

    • @GreatStackDev
      @GreatStackDev  ปีที่แล้ว

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

  • @TechSmith-h9f
    @TechSmith-h9f 11 หลายเดือนก่อน

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

  • @khadijah22
    @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"

  • @yavalio7500
    @yavalio7500 2 ปีที่แล้ว

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

  • @enesaliev3518
    @enesaliev3518 ปีที่แล้ว

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