Hey there, how to schedule for specific time? thanks
@brittanynoltimier2 ай бұрын
Great video! Did you remove the AppScript code to copy?
@gridabl2 ай бұрын
Thank you! The script should be available after copying the google sheet by navigating to Extensions >> AppScript. Alternatively you can also find the script here: github.com/thebrandonc/gs-automailer
@B_G_M64711 ай бұрын
Hi Thanks a lot ! Is there a way to activate the default signature of the gmail account in the emails sent ?🙏
@gridabl10 ай бұрын
After looking into this, there apparently doesn't seem to be an easy way to include a default signature, which is pretty strange. I was able to find some hacks people have come up with, but nothing in the official documentation mentioned signatures. Here's what I was able to find regarding the workaround: stackoverflow.com/questions/48519059/how-to-add-signature-to-email-in-google-apps-script-generated-email-with-proper
@Ben007-tx3vt10 ай бұрын
Hi, we have a trigger issue here : fonction : sendEmails // Error message : Exception: Cannot call SpreadsheetApp.getUi() from this context. // Trigger : time-based do you have any idea ? Thanks a lot
@gridabl9 ай бұрын
Hey thanks for bringing this to my attention. When I have a moment I'll update the script to address this issue and let you know once it's been fixed.
@Ben007-tx3vt9 ай бұрын
thanks a lot !@@gridabl
@Ben007-tx3vt8 ай бұрын
Hi @@gridabl , did you find a moment to update the script to adress this trigger issue ? thanks a lot ;-)
@ofrilav Жыл бұрын
Thanks for the great video! How can I send emails cyclically every 6 months for example?
@gridabl Жыл бұрын
Sure thing! Based on how the script currently works you'll need to add a line for every email you want to send, so if you want to schedule one for every six months a new line would need to be added with the send date scheduled six months apart. I'll add this feature to the list of possible improvements for the future!
@PITRE682 ай бұрын
How do I get the date in the send-date column to show as mm/dd/yyyy and be able to double click and select on the calendar drop down. I have pasted it in from other column and used calendar to select date and it will show as mm/dd/yyyy but once the emails send it reverts back to "Sent on: Tue Jun 04 2024 08:54:44 GMT-0700 (Pacific Daylight Time)" Also I need calendar date to function for GMT zone 0600. I have the calendar drop down selection working on the delivery-date column but that doesn't involve the script. I just want send-date column to show as mm/dd/yyyy and be able to select from the calendar. I know hardly anything about spread sheets. I am trying to use this to set up a simple PM work order issuing program. Should work great if i can get the date thing figured out. Thank you.
@user-mg1tz4vu1s10 ай бұрын
Thanks for this. Also may i know how to add "CC" and rename the "From" and also facing error in triggering " cannot read properties of null" it says
@Ben007-tx3vt10 ай бұрын
Same issues here
@Ben007-tx3vt10 ай бұрын
Any idea for this trigger issue : fonction : sendEmails // Error message : Exception: Cannot call SpreadsheetApp.getUi() from this context. // Trigger : time-based Thanks a lot
@user-qt6gf2wz9b Жыл бұрын
hello , how i change Time zone with GTM with mine
@gridabl9 ай бұрын
If you go into the script (Extensions >> Apps Script) you'll notice on line 16 it sets the date format and timezone. You'll be able to change the GMT value to any timezone you'd like. Hope this helps!
@fearmyclarinet9 ай бұрын
This is so helpful! Thank you! How would you remove the time stamp and time zone in the email text? I only want the day, month, year. Thanks again!
@gridabl9 ай бұрын
I'm glad you found the tool useful 😃If you're using a date as a variable in the email, one thing that may fix the issue is to format the date variable as Text, and the script should treat the variable as a normal string. Hope this helps!
@user-yz3so9hy2o5 ай бұрын
Hey there, I need help with another thing, I only want emails to be generated in draft, do you have any script for it?? Please let me know, thanks
@770shtrudel3 ай бұрын
I ran the script, but it keeps telling me "0 email(s) sent!". I don't know what the problem is. you can help me please?
@muhammadaffan1006 ай бұрын
Not working - showing an error sendEmails // Error message
@oluwayomidada3536 Жыл бұрын
It will be amazing if u could do a tutorial that can send the mail from a stmp email or a hosted mail service not Gmail. Just thinking out loud is that possible? 😌☺
@gridabl Жыл бұрын
Unfortunately, as far as I can tell it doesn't look like Google allows using non-gmail accounts. I'd be happy to be proven wrong though
@user-yz3so9hy2o5 ай бұрын
whoting this error Exception: Service invoked too many times for one day: email.
@briwesthaver Жыл бұрын
Is there a way to have more than one email template on the same spreadsheet? For example maybe a trigger for 2 weeks after the order is delivered for another follow up,?
@gridabl Жыл бұрын
At the moment, the best way to do this would be to duplicate the Google Sheet and schedule the second email in the new document. If this feature gets requested enough I may consider creating a new doc/video :)
@BuddyRathmell10 ай бұрын
@@gridabl I would love a way to schedule as well.
@kadenhusney6151 Жыл бұрын
Having issues when running the system. It sends multiple emails to one address instead of sending the block text to each individual recipient. anyway to fix?
@kadenhusney6151 Жыл бұрын
It sends multiple blocks to one email address.
@gridabl Жыл бұрын
Hi Kaden, thank you for bringing this to my attention. I'll look into it and push a fix
@theupdater7673 Жыл бұрын
I tested it in a normal Gmail account and it works but it doesn't work in a google workspace account, any idea how can I fix this issue?
@gridabl Жыл бұрын
Hmm, it appears this is no longer working for our workspace account either. I'll fix the script and get back to you once it's available 🙂
@vishakhsandwar1964 Жыл бұрын
Is there a way to add new lines like "/n", I've tried messing with the source code but so far I can't get anything to work?
@gridabl Жыл бұрын
Hey Vishakh, the script should parse the contents of the template cell and include any new lines entered directly into the message. You can add new lines to your message with Alt + Enter (PC), or Option + Enter (Mac). Hope this helps!
@NyRenalMD2 жыл бұрын
is there a way to change the default email sending from?
@gridabl2 жыл бұрын
The only way to change the send from address is by logging in from a different account. You could then copy the Google Sheet over to the new account and send it from there. Another option would be adding a "Reply To" email address to the script. This would allow you to send emails (from the same account), but when a user responds, it goes to the email address you specify. I could update the script to allow this if it would be helpful.
@oluwayomidada3536 Жыл бұрын
@@gridabl Absolutely Marvelous. I will be helpful.
@ahmadsukron2519 Жыл бұрын
I'm really frustrated. It worked well when I tried on the first time. But when I tried for the next one, it didn't work anymore. I always received an email with the subject "summary of failures for google apps script: untitled project" when I tried it again. The email said that there was an error "exception: cannot call spreadsheetapp.getui() from this context". Help me please...
@gridabl9 ай бұрын
Hello, thank you for the comment. I have this issue issue noted and I'll have to fix it once I have some free time. I'll let you know once the script has been updated, which I hope to do soon