How I Automated Google Sheets with Apps Script - Automate Your Business

Подписаться 52 тыс.

Просмотров 70 тыс.

50% 1

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.stereotype...
Learn how to use Apps Script: developers.goo...
Women in Tech Weekly Newsletter: www.stereotype...
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.stereotype...
Follow us on Social Media:
Blog: www.stereotype...
Instagram: / stereotypebreakers
Facebook: / stereotypebreakers
Twitter: / stereotypebrks
LinkedIn: / stereotypebreakers
Soundstripe Content ID code:
TBHIN8EV86MKBYHD

Хобби

Опубликовано:

4 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 58

@VineetKrGupta 3 года назад

"Talk is cheap, show me code"

@KLead963 3 года назад

Exactly thats what I wanted to comment!!!

@SuperSonicBros 2 года назад

@@KLead963 Me too

@adityams1659 Год назад

finallly someone said it!

@danieldoru1825 Год назад

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

@furiousflower 3 года назад

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.

@Edison_mm 6 месяцев назад

Te felicito,, Veo que tienes muy buena actitud para este tipo de desafíos. 👍🏼

@markk364 2 года назад

Where is it that you show how you automated Google Sheets with Apps Script?

@user-fu4ui9zr1k 28 дней назад

Thanks! It was very interesting! It was even more interesting to listen to a person, who was really passionate about what she was doing)

@AnshulMarele-gbaa 5 месяцев назад

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

@jfresh2054 3 года назад

I watched this whole video to see your actual code. Ugh.

@Kennb17 3 года назад

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...

@thoyo Год назад

I liked this. No coding, just thought process and planning.

@soarhigh981 3 года назад

I just gave you a thumbs up in the first 3 seconds for your accent 😂

@cincinnatislider 2 года назад

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.

@SP.Addams 2 года назад

So this info is useless if I’m using iPad?

@nankaigosencorp.4982 Год назад

@@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.

@SP.Addams Год назад

@@nankaigosencorp.4982 I wish I knew what any of your words meant 😫 lol. Not even joking

@muctautomation 3 года назад

This informative! I guess we can do more!

@krout0 2 года назад

Can you help me with a project I am working on. Teach me how I should do the project?

@latestloveyaatri5221 2 года назад

So excellent knowledge

@beef2244 3 года назад

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?

@madhugupta2289 Год назад

That's a easy one just change the format of text using =text

@himgui 3 года назад

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!

@thesmartideas4246 3 года назад

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.

@nirmal3500 2 года назад

Did you create this website using google sites??? just Ask

@anupriyavarshney1012 2 года назад

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.

@samuelaraujo9099 2 года назад

Let's try!

@GrahamMelb 3 года назад

At 1.11 stopped watching after reading the comments…

@StereotypeBreakers 3 года назад

I stopped reading this comment at “At”

@Nonchalant2023 Год назад

@@StereotypeBreakers you fit the stereotype of blondes

@josedanielportillocarias3001 3 года назад

You are the best!!

@creativebreed 3 года назад

ffs - dear diary...

@shaitaan0666 2 года назад

i love your green eyes

@StereotypeBreakers 2 года назад

They’re blue, but thanks!

@shaitaan0666 2 года назад

@@StereotypeBreakers but in video it seem green

@Morbius2271 3 года назад

Comments said no code, so I stopped watching. Pointless video.

@Archist111 2 года назад

your website is copyright for 2023 xD you're in advance !! or live in the future !! awesome, thank you, you made me smile xD

@RenatoEsquarcit 3 года назад

Hey if you end up in las palmas I'll invite you for dinner!!!

@darkbrowniris9643 3 года назад

Cool Thanks!

@Nonchalant2023 Год назад

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

@narasimhanandam525 3 года назад

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.