Пікірлер
@juliapijls8918 8 күн бұрын
Hi! This video was very helpful, thank you!! I had a question though, I believe my script is fine as it is, since there I get the message that the run has been completed. But I don't actually receive any emails.. When I checked the trigger it said that there is a very high error percentage, do you (or anyone else?) maybe know what I did wrong or how I can fix this? Thank you in advance!!
@avotutorials 4 күн бұрын
Hey there, would you be able to copy and paste the error shown from the trigger? Maybe do a hygiene check to make sure you've updated to the correct email address and the sheet name is aligned in both the code and the sheet.
@Mill3r3f 17 күн бұрын
Exactly what I was looking for, thanks!
@uzairfly 17 күн бұрын
Very helpful, thanks heaps!
@afiakissi3756 19 күн бұрын
So helpful 👏
@RahulMishraD Ай бұрын
great 3 🔥 🔥 thanxxx for sharing
@gusdriproject Ай бұрын
You have a nice voice :-)
@naivvaghela8553 Ай бұрын
Great, very usefull to me.
@solagratiasarontandiapa2631 Ай бұрын
hello this is a cool project can i get the tutorial or source code?😄
@АндасКерімбай 2 ай бұрын
thanks
@stevendesigner 2 ай бұрын
Tanks!
@hisknown-fact 3 ай бұрын
❤
@thecat293 3 ай бұрын
a question, how do you change the email account that is used to send emails?
@avotutorials 2 ай бұрын
Hey great question! You have to sign in using a different google account if you want to send from another email.
@melvinestrella735 3 ай бұрын
How to send emails in google sheets with multiple recipients?
@umeshdube1861 3 ай бұрын
Getting source error
@avotutorials 3 ай бұрын
Hey your sheet should still work as per normal even with the source error
@thecat293 3 ай бұрын
im subscribed, very nice videos
@yudimarris3119 4 ай бұрын
Thankyou so much.. auto subscribed
@KacperGonera 4 ай бұрын
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 4 ай бұрын
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: kzbin.info/www/bejne/fIfQeWdnarufeKM Hope this helps!
@scubacentresodwanabay1531 4 ай бұрын
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?
@habibfaith.official 4 ай бұрын
Very very helpful and thank you so much for this type of interesting tutorials.
@bellarivera7250 5 ай бұрын
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 5 ай бұрын
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.
@bellarivera7250 5 ай бұрын
This video is so so helpful I love how you explain everything as you go I really learned a lot !
@lucio3203 5 ай бұрын
o mano parece br... nice video boy!
@chabelyescalona9017 6 ай бұрын
Muchas gracias!!! 💟
@mxelhua 6 ай бұрын
This is so incredible. I am so happy i came across your channel. I have been looking on google for over an hour and i did find a solution but i had to pay, and i was about to. Thank you very much! I am definitely subscribing and turning on notification bell ! thank you!
@avotutorials 6 ай бұрын
your comment made my day! Thank you so much <3
@TryingCodeEng-58208 6 ай бұрын
nice video
@AndreaSkweres 6 ай бұрын
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 6 ай бұрын
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!
6 ай бұрын
Thanks
@Play_Streams 6 ай бұрын
Thanks for this. It's still shocking that Figma has added such a fundamental feature
@w0mblemania 5 ай бұрын
It's not a fundamental feature though. It's an advanced feature that takes a lot of engineering effort (and thus time and money) to get right.
@avotutorials 6 ай бұрын
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.
@GabrielaStephanyRomeroAnton 7 ай бұрын
really useful , love youu thank youuu
@ildunks 7 ай бұрын
Thanks for the tip but this plugin is also a trial that allows you to use it only 3 times
@avotutorials 7 ай бұрын
Hey, glad it was helpful :) You can actually get the authentication key for free and use it more than 3 times, explained more towards the end of the video. Link here: figmastic.gumroad.com/l/tracer
@mnoirx4347 7 ай бұрын
Why this video hasn't even 1k views, this is a wonderful resource, thank you so much @avotutorials for sharing this
@aartipanchal9573 7 ай бұрын
Thansksssss
@proshantokumar2742 8 ай бұрын
thanks
@platinumgallery25 8 ай бұрын
It shows error while tracing
@anuragbishtt 8 ай бұрын
amzing and info video
@cristinastanescu8469 8 ай бұрын
Thank u for the video. Super helpful. Btw, how can i change the background color of that image ? I tried to change the Fill color but it doesn't seem to help.
@WilkensSantos 9 ай бұрын
Thank you my Overseas Friend!!! Great job! Helped me a lot!
@SujitKumar-hr5qz 9 ай бұрын
Really great tip.
@nuggets5787 9 ай бұрын
They now require payment
@avotutorials 9 ай бұрын
Hey, I just checked the product on gumroad and it's still free. You may request for the authentication key through this link figmastic.gumroad.com/l/tracer?layout=profile&recommended_by=library
@Działki-p2j 10 ай бұрын
very helpful! thanks!
@dotunawojobi3150 10 ай бұрын
thank you very much.. this was really helpful.. I was stuck trying to do this😭😭
@Csilla-CristinaSpinochi-jk3ed 10 ай бұрын
Am I the only one who can't find it anymore?://
@avotutorials 10 ай бұрын
Hey they might have changed the plugin accessibility this year. I found an alternate solution! Check it out here: kzbin.info/www/bejne/lae8e5eHYr93nJY
@kamillakasymova9032 11 ай бұрын
😍😍😍
@aku7296 11 ай бұрын
Thank you🫶🏻
@aku7296 11 ай бұрын
I clicked on my saved file but its a black screen.
@avotutorials 11 ай бұрын
Hey! It might be because you're extracting part of a vector instead of the whole thing. Check out this video to see if it helps solves your problem: kzbin.info/www/bejne/eV65maOegMygfck
@matthewAfamefula 11 ай бұрын
How to make the vector go below
@avotutorials 11 ай бұрын
Hey! You may look at 1:44 in the video above. To drag your vector layer to the bottom, you can click on it on the left and drag it down.
@jaimeortiz2158 Жыл бұрын
This video and the previous video helped a ton. Thank you!
@נטעבוקובזה-פ6ל Жыл бұрын
Excellent explanation, thank you very much
@nevescode Жыл бұрын
Thanks!!! ❤🩹