How I Automated Google Sheets with Apps Script - Automate Your Business
Vložit
- čas přidán 27. 10. 2020
- I'm a big fan of automation in my business and my most recent project was automating Google Sheets. I learned how to use Apps Script for that, which uses JavaScript. Let me walk you through how I did that! Check out my post on this subject: www.stereotypebreakers.com/po...
Learn how to use Apps Script: developers.google.com/apps-sc...
Women in Tech Weekly Newsletter: www.stereotypebreakers.com/wo...
Please let me know if you have any ideas/comments! ✨👩💻
Music:
Alumroot by Isaac Joel
Join the Stereotype Breakers Community for Women in STEM:
www.stereotypebreakers.com/co...
Follow us on Social Media:
Blog: www.stereotypebreakers.com/
Instagram: / stereotypebreakers
Facebook: / stereotypebreakers
Twitter: / stereotypebrks
LinkedIn: / stereotypebreakers
Soundstripe Content ID code:
TBHIN8EV86MKBYHD - Jak na to + styl
"Talk is cheap, show me code"
Exactly thats what I wanted to comment!!!
@@KLead963 Me too
finallly someone said it!
It was hard for her to make it in the first place. She has gone a lot of searching. As she tells the story it's clear that she just learned how to code. She's sharing her story because she knows this could help other people too. Relax your Ctrl + C fingers
Te felicito,,
Veo que tienes muy buena actitud para este tipo de desafíos.
👍🏼
This informative! I guess we can do more!
So excellent knowledge
I just gave you a thumbs up in the first 3 seconds for your accent 😂
Could you help me? I would like to input a time in minutes and seconds, and have it display in just seconds for printing. For example if I type in 0:10:06 or 10.6 (as in 10min 6seconds) I want 606 to be displayed in that cell. If yes, could you also do this with hours?
That's a easy one just change the format of text using =text
I am very impress to your content. I want to work in google. I know python. Please guide me. I am very thankful to you.
How to give Individual Worksheet View, Edit & download Access to Specific Email in one Google Sheet Workbook?
For example: Sheet1 can be viewed, edited & downloaded by Mr. A email only,
Sheet2 can be viewed, edited & downloaded by Mr. B email only, likewise
Can you help me with a project I am working on. Teach me how I should do the project?
Came here for the code...It's a very weird to present a coding tutorial ...without showing the code. Tapped out at the halfway mark.
Where is it that you show how you automated Google Sheets with Apps Script?
You are the best!!
Hey. I know this is not the domain of the video. but as you know Google Apps Script, I needed your help. Can you help me to write google apps script to directly add emails collected in google sheets to a specific google group. p.s. for a free account and not a G Suite one. Pleaseee help I really need it.
Let's try!
Wow, excellent video. This would be amazing if I could run scripts in-the-field on an iPad. I don’t think iOS Chrome can run scripts, and I know the iOS Sheets App can’t.
So this info is useless if I’m using iPad?
@@SP.Addams you can set up a trigger to run the macro if you edit a specific cell so that you can run the macro from mobile.
@@nankaigosencorp.4982 I wish I knew what any of your words meant 😫 lol. Not even joking
I liked this. No coding, just thought process and planning.
I watched this whole video to see your actual code. Ugh.
That's why I always scan the timeline and if the person shows themselves more than their work then I quit watching. I wish people would start to learn that the reason people are watching their videos is to pick up information about their project, not "your" motivations for doing "your" project...
It was so good to see your experience with this. I'm about to automate some of my daily basis as an IT Support and I think they can easily be done using Google App Script in my favor. Hope this can also give me a promotion.
Thank you Masha!
Did you create this website using google sites??? just Ask
i love your green eyes
They’re blue, but thanks!
@@StereotypeBreakers but in video it seem green
Nice video
Hey if you end up in las palmas I'll invite you for dinner!!!
Cool
Thanks!
Hai madam..
I want send automatic send Whatsapp and text messages to the customers by using google sheets. When I change the status of order.
EX: if the customer place order we need to send the message to the customer "your order is Placed".
Like wise when I change the status of order from placed to confirmed. like that I want send the Whatsapp and text messages to the customers.
"Your Order is confirmed".
Give me the google sheet with that requirements.
wtf dude, why are you giving orders to people on internet 🤣
@@fitrianhidayat I am not ordering... I am requesting... Bull shit ..😡
@@narasimhanandam7858 that's not how you made a request, that's how you give order to someone you see as below you.
your website is copyright for 2023 xD
you're in advance !! or live in the future !! awesome, thank you, you made me smile xD
ffs - dear diary...
At 1.11 stopped watching after reading the comments…
I stopped reading this comment at “At”
@@StereotypeBreakers you fit the stereotype of blondes
I can tell you're Canadian lol
Lol I’m Russian
Comments said no code, so I stopped watching. Pointless video.
Self praise video
@coding blonde ❤️
🥰
Too much talking.
the sound veerrryy weak!!
Where can I find women like this 😃
Not a single damn line of code and all this "new age" motivation... woman, show me the code, idc about your last trip to Tuscany
All talk talk..blah bah..no code..guys it waste fo time
you talk too much get to the point
1:40 filho você quer saber como comprar seguidores reais barato? AUTORIDADE SOCIAL resposta correta