How to create Login and Register Form using Google spreadsheet data?

If this video useful to you, Don't forget to subscribe, like and comment.

Source code:
Subscribe to my channel and I will post useful videos for you. so don't forget to subscribe.

How do link to your website after the user logged in?

How to submit a HTML form to Google Sheets (with full source code):
Type (1)
Type (2)

How to send HTML form to Gmail?

__________
1) Learn Google Apps Script

2) How to host your HTML code for free on google drive?

3)Learn HTML,CSS,JS

[gauritanwar]

Thank you sooo much for this video I was looking for it its been 3 days since I was struggling to make the login page. Thank you so much. Subscribed

[elishaa]

Thanks for this video... will definitely need it at the end of my google sheet / appsheet project. Subscribed!

[coolvibesreloaded]

done, done, done.... now i need this to redirect back to my site once people logged in

[hackerspro]

your videos are the best here on youtube

[dimitrisvoudouris]

thank you, there will be videos with user login and then we can edit, delete items on a sheet as a database

[KeviPegoraro]

For who is not getting succes in realize the login two things that will solve for you:
1) Remove the touppercase from the checkLogin function, that don't work anymore in app script:
function checkLogin(username, password) {
var url = 'YOUR SHEET LINK HERE';
var ss=
var webAppSheet = ss.getSheetByName("DATA");
var getLastRow = webAppSheet.getLastRow();
var found_record = '';
for(var i = 1; i <= getLastRow; i++)
{
if(webAppSheet.getRange(i, 1).getValue() == username &&
webAppSheet.getRange(i, 2).getValue() == password)
{
found_record = 'TRUE';
}
}
if(found_record == '')
{
found_record = 'FALSE';
}

return found_record;

}

2) remember of put the link of you sheet in the url variable in the same function.

That solved it for me.

[bonzpon]

this is grape thank you so much for the idea and sharing also the source code.. grape grape!!! :D

[MaliturStudio]

Can you make a tutorial about how people can change their password or mail?

[gruvitec]

excelent video, and thanks for source code. and make more video like this... 👍

[babosammo]

This is so great!
Please how do you add WARNING username, email, or phone has already been used?
And is it possible to point each user to different URL when they login?

I really appreciate your work.

[obolaji]

Thanks for sharing this 🙏🏾🥰❤️.

I've tested it, and it worked just exactly...

[michaelmemphistransportser]

Thanks for the videos bro really helped..just wanna ask is after login how to go to specific page ? is it possible ?

[mrmf]

A good example how not to do authentication. 1) No one, including site owner should be able to see passwords of "registered" users. In the demo they are visible in plain text in the spreadsheet. 2) This "login" is useless until security token is given back to the web browser, which is not shown and not explain. How do you protect subsequent pages which meant to be shown to "signed in" users? Its better if you picked up another example, instead of "security". Btw did you kn ow that instead of ... = 'FALSE' you should be writing ... = false. There are such things as types in JS code....

[majhawk]

can we create multiple sheets for a single user registered in another sheet and getting the name of new sheet from the register sheet

[jedidiahthenewhomemarketin]

After you copied the web app URL what system is that that you’re using to create that script 8:10 in the video I can’t go any further without that

[wekhgzr]

Thanks for the awesome tutorial video. After login how to go to specific url?😀

[LOTTOLAKAYBOULCHO]

Need theme plate for blogger with login and sign up

[pedroguerreiro]

amazing! thank you. How can I stop the log in being successful when username and password fields are blank? cheers

[MaliturStudio]

How do I ban people or how do I delete accounts?

[talkwithtech]

How can I add delay of some seconds on page 4th and then after redirect on my website.