Ever wanted to become an expert in Apps Script or Google Cloud? Wanted to learn more about programming in general by building software, web applications, and full-stack systems? Check out the videos on this channel for all of the above! Each season highlights an API provided by Apps Script or a service provided by Google Cloud and delves into the most common use cases pertaining to these two technologies. I have used Apps Script heavily in my own work and I want to share the most beneficial ways I've used it. Don't forget to like and subscribe to show me some love :)
Theoretically, could I set up a daily time based trigger in the Triggers UI to run between 12AM-1AM for the setUpTrigger function and use the at() method to specify a specific time by modifying new Date() when I run it at midnight? Get new Date, then modify so it happens on a specific time of that date. This would allow me to do basically the same thing as atHour().nearMinute() without the 15 minute +/-
something like this: function createTrigger() { var now = new Date(); // Convert the current time to Pacific Time var convertPacific = now.toLocaleString('en-US', { timeZone: 'America/Los_Angeles' }); // Create a new Date object with the Pacific Time var pacificNow = new Date(convertPacific); // Set the time to 4:00 PM var runtime = new Date(pacificNow.setHours(16, 0, 0, 0)); // 16:00:00.000 is 4:00 PM Logger.log(now); Logger.log(runtime); // Create the trigger to run at 4 PM Pacific Time ScriptApp.newTrigger('closeSnoozed') .timeBased() .at(runtime) .create(); }
It´s really the better tutorial about getting data on the web! Congratulations for the content and the metodology. It would be so great to view some tutorial like this getting RU-vid data (stats) for content creators grow their followers and viewers to get ideas about content, hashtags and trends. Is it possible?
Can you help me on how to fix the Google Form grid data based on the name of the list in Google Sheet even if there is a change in the number of lists. Please help, I am willing to donate for this problem
Hey is there a way to speak to you about my current script I'm pulling my hair over I need some guidance and came across your videos I think I'm getting there with it but something throwing me off or not right.
It good to see you teaching advance flutter but there is only introduction video and i can not find other topics yyou mention on the introduction video. Can you help?
I followed your video. Could you tell me how you found the SECRET API code, indicated in the "getZoomAccessToken()" function? Because I developed a procedure using GOOGLE SCRIPT API for the implementation of the electronic signature card in the GMAIL signature parameter. Here, my test launch is crashed due to the problem on the delegation domain!!... With your video, I tried to test with your example to understand how it works... I know where KEY API is located, placed in the Google cloud console, and then, in API and service. but, I do not see API SECRET whereas, for clients, ID and password have appeared!!!... So, how did you find the SECRET API code, indicated in the "getZoomAccessToken()" function? Thank you in advance for your help. sincerely
Greate video! Amazing chanel! Wish I would have find you a while ago 😂 If it is possible, would love to get your help with the extra step enfourcing http->https redirection. thank you so much 💪🏽💪🏽
hey sir can we have contact i have some question how i can contact you
5 месяцев назад
Hello, how do I redirect the lead to a website after they fill out the form? I don't want to put the link so he has to click. I would like it to be automatically redirected to the website when pressing the submission button. It's possible? How to do this? Would you help me? Tks
Thanks for sharing. It helps me a lot. I also saw your new channel for ironman Waco. It is amazing for me as a coder ^^; By the way, I have a question for Google apps script, how to see the log which is generated by console.log(). For my apps script, there is no logs in my Exections. My apps has deployed. Hope you could give me some advice or guide me how to figure out. Thanks.
Hi, if I have 100K emails totally (inbox plus outbox plus archive plus....), what if I want to get the sender addresses of all these emails? If I just use getMessages() function, it will take too much time to fetch them, probably many many hours, because it fetches the entire messages. But I want only the index, I mean, I want only the addresses of the senders of all messages. Nothing more. Is there any quicker (more optimized) way to do it using Apps Script? or maybe there is some other way to do it?
Please make a video on how to deploy a nodejs app that uses socketio to app engine flex environment. I can't get socketio to work. Works fine locally but not after deploying to app engine. Keep getting 502 bad gateway error.
hi david, i already deployed my api into the app engine. But when i test it into postman, it showed "service unavailable". Idk where is the problem. Thanks🙌
I got an error when I redeploy the app with some changes. It is showing Action not allowed error the line number with DocumentApp.openById call method. Do i need to set any permissions for when I redeploy the app script again?
Hello, my name is Maurílio and I live in Brazil. I watched this video of yours, trying to solve a problem of mine and I really liked it!! I noticed in this video that at 4 minutes and 13 seconds you managed to create a drop-down list where you filter the results as you type in the text field. Do you have a video that shows how to do this? Thank you very much!!
Is there a way to pass let say variable "name" from withing the gs so it is displayd in index file? So it is not declared as a const but it is "calulated" from the script? OK - I got it - solutions is here: developers.google.com/apps-script/guides/html/templates#code.gs_5
Hey David, great channel! Can you please make a video explaining how to get detailed info from an event? I need to get that info on a Spreadsheet whenever an event is created/modified/removed. Or can you point me where I can get this info? Thank you very much