Send Emails From Google Sheets Using Check Box | Apps Script Tutorial | Automating Emails

  Рет қаралды 4,962

Avo Tutorials

Avo Tutorials

Күн бұрын

Learn how to automate sending emails from Google sheets using the check box/mark ✅
Get the sample sheet here: avotutorials.gumroad.com/l/se...
*You can name a fair price (minimum $0) to duplicate the sheet, no pressure :)
Check out more digital products here:
avotutorials.gumroad.com/
#sheet #sendemail #googlesheets #googlesheetsautomation #check #automation
_________________________________________
I've created this channel to document interesting things I've learned during my free time. We tend to forget the little things we google up to solve a problem/issue. I hope it brings value to you too! :)
Subscribe to my channel: bit.ly/3NJWGEV

Пікірлер: 14
@bellarivera7250
@bellarivera7250 3 ай бұрын
This video is so so helpful I love how you explain everything as you go I really learned a lot !
@thecat293
@thecat293 Ай бұрын
im subscribed, very nice videos
@scubacentresodwanabay1531
@scubacentresodwanabay1531 2 ай бұрын
Thank you for this!! How can i add a follow-up email, say for 3 months time, from the date stamp of the 1st email?
@avotutorials
@avotutorials 4 ай бұрын
Hello everyone! Hope you enjoyed this video. Click the link below to get access to the Google Sheet. It's minimum $0, but I do appreciate any contribution above that :) Thank you! avotutorials.gumroad.com/l/send_email_from_sheets **UPDATE 28 MAR 2024**: I have tweaked the code a little to ensure the recipient doesn't get multiple emails. The core of setting it up is very similar to what was explained in the video. The tweak made: adding a mechanism (lock) to ensure that only one action (execution of onEdit function) can happen at a time, preventing duplicates. Additionally, I removed one of the alarms (trigger setup). Previous code had 2 triggers (onOpen // createOnEditTrigger). I removed the onOpen trigger because it was redundant.
@AndreaSkweres
@AndreaSkweres 4 ай бұрын
Thank you for this video! Very helpful. I tried this with a script and spreadsheet I am currently working on, but for some reason the email is sent out any time a cell is edited. I have tried to get it linked to the checkbox specifically, but it sends the email after every cell edit. I believe it has to do with the onEdit trigger. Do you know the best way to prevent this?
@avotutorials
@avotutorials 4 ай бұрын
Hello Andrea! Thank you so much for this comment. I've looked into it and you're right about receiving multiple emails. I have tweaked the code a little, do try and let me know if it solves your issue :) If you're curious what I changed, I added a mechanism (lock) to ensure that only one action (execution of onEdit function) can happen at a time, preventing duplicates. Additionally, I removed one of the alarms (trigger setup). Previous code had 2 triggers (onOpen // createOnEditTrigger). I removed the onOpen trigger because it was redundant. Thanks again, hope this helps!
@thecat293
@thecat293 Ай бұрын
a question, how do you change the email account that is used to send emails?
@avotutorials
@avotutorials 25 күн бұрын
Hey great question! You have to sign in using a different google account if you want to send from another email.
@bellarivera7250
@bellarivera7250 3 ай бұрын
I tweaked the script to fit what I was looking for but I keep running into this error “TypeError: Cannot read properties of undefined (reading 'source') onEdit”. I have limited knowledge on code but I think it’s saying it needs to be defined ? I don’t see e.source anywhere else
@avotutorials
@avotutorials 2 ай бұрын
Hey, thank you for dropping in a comment. You don't have to worry about that error as the sheet still should work as intended. Please let me know if you still encounter issues.
@KacperGonera
@KacperGonera 2 ай бұрын
Hello, I have set up the script as you explained, however the lock does not work for me - the script sends two e-mails simultaneously. Do you maybe have a fix for that? Also I am interested in how to make it to work with two separate checkboxes within the same sheet: Checkbox A will send email to person A, and checkbox B will send different email to person B Thanks for your help!
@avotutorials
@avotutorials 2 ай бұрын
Hey thanks for dropping in a comment. 1. Regarding sending two emails simultaneously, I tried the sheet on my end again and I only get one. Maybe try creating a new sheet and copy in the app script to go through the authentication process again. 2. If you are interested in sending two different emails, you can check out my other video here: kzfaq.info/get/bejne/fLyde5dimrzQcnU.html Hope this helps!
@umeshdube1861
@umeshdube1861 Ай бұрын
Getting source error
@avotutorials
@avotutorials Ай бұрын
Hey your sheet should still work as per normal even with the source error
World’s Largest Jello Pool
01:00
Mark Rober
Рет қаралды 100 МЛН
I'm Excited To see If Kelly Can Meet This Challenge!
00:16
Mini Katana
Рет қаралды 19 МЛН
Google Sheets and Excel - A Better Dynamic Search Bar
7:01
Eamonn Cottrell
Рет қаралды 11 М.
Google Apps Script for Beginners: Start Automating Google Sheets
8:03
Analytics with Adam
Рет қаралды 12 М.
Send Personalized Emails from Excel using Power Automate
11:21
Teacher's Tech
Рет қаралды 11 М.
Google Apps Script Send Emails from List
17:23
The Excel Cave
Рет қаралды 4,2 М.
How to Use NotebookLM (Google's New AI Tool)
25:50
Tiago Forte
Рет қаралды 584 М.
Google Apps Script Tutorial for Beginners
23:54
saperis
Рет қаралды 371 М.
Send Personalized BULK Emails in Gmail (for FREE)!
6:50
Jeff Su
Рет қаралды 540 М.
4 Признака того, что Жена Злится
0:30
Petya English
Рет қаралды 6 МЛН
Забота Казахов🇰🇿
0:45
QAZAQ PEOPLE
Рет қаралды 276 М.
ДОМАШНЕЕ ЭСКИМО//ПРОВЕРКА РЕЦЕПТА ТИК ТОК
0:22
ОЛЯ ПЕРЧИК
Рет қаралды 1,2 МЛН
Será Que a FITA vai Grudar ela na PAREDE😱 #shorts
0:44
Lucan Pevidor
Рет қаралды 61 МЛН
王子居然在家这样 #艾莎
0:38
落魄的王子
Рет қаралды 10 МЛН
WOW! SMART idea and very USEFUL 👓 👁 p5 #camping #survival #bushcraft #outdoors
0:17
Ăn Vặt Tuổi Thơ 2024
Рет қаралды 87 МЛН
Gym lover..#trollface #short #shortsfeed
0:21
DS SIPUN OFFICIAL
Рет қаралды 6 МЛН