Google App Script Made Easy - Automating Google Sheets
Vložit
- čas přidán 13. 09. 2024
- Hi everyone! In this video I introduce you to Google Apps Script by showing you a simple script that copies data from one column, inserts a new column, inserts the data into the new column, and gives the new column a different header.
Love your radio announcer voice! Very clear presentation.
Ha, thanks @tombrazee
I just happened across this video in my recommended. EXACTLY what I need to automate reporting on my website. Thank you!!
Glad it helped, Sam. Let me know if there’s anything else you want to know.
@@jsphpalumbo The only thing I can't figure out is how to connect a Wix database to a Google sheet so I can get the data over there automatically. Do you know how to do that? I've tried Integromat(make), but I keep getting errors.
Absolutely perfect presentation with exactly the right amount of information to get started. Thank you!
Great introduction to using App Scripts in Google Sheets. Thank you for putting this up! :)
Fantastic - thank you very much for putting these together and your depth and stle of teaching/explaining takes the value to another level
Save my life bro, really helpful for my work
😀
Happy to help
hi Joseph, your videos are great but too much for me to process. I am looking for a script that will email my teachers based on selection from a google form. For example, if user selects course 1, then teacher 1 should receive the email, "hi this person sent a request" if user selects course 2 then email should be sent to teacher2. on activesheet sheet2 I have list of teachers and their email address. Can you post what it would look like? the trigger is based on "form submit"
Excellent presentation.
thank you!! really helful. can you make another vid about insert checkbox within submit button.
Thanks!
So helpfull... sir, I have some query can you help me to resolving that. that is similiar to this.
Im struggling to find it. I can automate in excel but im wanting to share it in Google drive and excel sheets doesnt have it and i suspect thats why it doesnt work from there
around the middle, you run the logger and return the data - but you are still using current sheet, not raw_data. I accidentally changed sheets and it didnt work, thats how i noticed. I changed it to let dataRange = raw_data.getRange(1,1,10); and it worked (you have let DataRange = cs.getRange)
hi Joseph, your videos are great but too much for me to process. I am looking for a script that will email my teachers based on selection from a google form. For example, if user selects course 1, then teacher 1 should receive the email, "hi this person sent a request" if user selects course 2 then email should be sent to teacher2. on activesheet sheet2 I have list of teachers and their email address. Can you post what it would look like? the trigger is based on "form submit".