📬 Schedule & Send Emails from Google Sheets for Free

[@nevensi.yogini]

Amazing, thank you so much!

[@user-ep8xk2pn1g]

Hey there, how to schedule for specific time? thanks

[@brittanynoltimier]

Great video! Did you remove the AppScript code to copy?

[@gridabl]

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_M647]

Hi Thanks a lot ! Is there a way to activate the default signature of the gmail account in the emails sent ?🙏

[@gridabl]

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-tx3vt]

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

[@gridabl]

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-tx3vt]

thanks a lot !@@gridabl

[@Ben007-tx3vt]

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!

[@PITRE68]

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-mg1tz4vu1s]

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-tx3vt]

Same issues here

[@Ben007-tx3vt]

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

[@gridabl]

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!

[@fearmyclarinet]

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!

[@gridabl]

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-yz3so9hy2o]

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

[@770shtrudel]

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?

[@muhammadaffan100]

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-yz3so9hy2o]

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 :)

[@BuddyRathmell]

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

[@NyRenalMD]

is there a way to change the default email sending from?

[@gridabl]

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

[@gridabl]

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