Paying the $5 & wiring Apps Script to your Sheet

Transcript preview

Okay, so I had to do some jumps to figure out my account but to submit a Chrome extension it just requires five dollar fees. I don't think it's much high, it's very low amount for you to be able to publish unlimited Chrome extension. I have created multiple accounts because I have this theory of trying to keep things separate so that if in any chance I have an option to sell I code but I haven't done that but just still prepared. So let's get back to it. We created a Google Sheet then we created App Script. We were waiting for the terminal to provide us the App Script code. It opened up that over here and we have the code over here that is very beautiful. There's a lot we can do with App Script but we're not gonna do that here. It's a very simple thing you just copy paste it and you can see how it works. Easiest, this is this, this is this, this is this, it needs this spreadsheet ID. So I'm going to copy the spreadsheet ID which is this one up after the ID and it needs the sheet name. So I'm just gonna call this members so this is the sheet name guys you just make that members and secret it's an optional set of password paste not a required skip duplicates true so this looks fine and we can do the deploy top right new deployment we'll click on new deployment then it's next to select type web app description anyone and yeah new deployment you click on this you click on web application and then you make sure execute as me and then anyone so anyone is basically that this API shall be called can be called by anyone it doesn't require like a sign in with my Google account it will not let it do its work now this actually causes a little bit issue that's why it suggested the secret part where you want to make sure not anyone randomly is able to push into that but again that's more advanced once you have few users you can definitely do…