Automate Your Emails with Apps Script: Send Personalised Emails from Google Sheets

[@PeterHornerGoogleTech]

Want to learn how to automate your email workflow? In this video, we're diving into the world of Apps Script and Gmail automation. You'll learn how to send personalized emails, automate newsletters, and so much more - all directly from your Google Sheets! If you've ever wanted to save time on email tasks, this tutorial is for you. 👇 Let me know in the comments what kind of email automations you're most excited to try! 😉

[@lukemenzel05]

How can I include other columns of data in my email? For example, when "Send Emails" is clicked, I want an automated email sent to each individual that includes their username and password for an app/store login.
Your help would be greatly appreciated.

[@PeterHornerGoogleTech]

Thanks for watching my video about sending emails with Apps Script from Sheets. I'm glad you found it helpful. This video explains the best way of getting data from sheets: ua-cam.com/video/W6jgy6-GtvU/v-deo.html
Here is an example of what you can do:
To add columns called "Username" and "Password" to your sheet, you can reference them this way in the code within the forEach loop:
const username = row[head.indexOf('Username')];
const password = row[head.indexOf('Password')];
You can then use those variables within the email message. For example, you could use the following code to include the username and password in the email body:
const message = `
Hello ${username},
Your password is ${password}.
Thanks,
Your Name`;
I hope this helps!

[@jackscales9026]

It would be great to know how to add other values specific to the receiver, such as a discount codes.

[@PeterHornerGoogleTech]

Hi @jackscales9026 You can add another column called "Discount Codes" to your sheet and then reference it within the forEach loop like this:
const discountCodes = row[head.indexOf('Discount Codes')];

[@DivineSam-w6m]

Is there any way to get access to this code, so its easier to modify for our usecase.

[@PeterHornerGoogleTech]

Sure! Here's a link to the code form this video: bit.ly/googlesheets-send-emails

[@tristangriffiths4083]

@@PeterHornerGoogleTech how does one access the script you wrote, or do I have to write it myself?

[@PeterHornerGoogleTech]

Hi @@tristangriffiths4083 Here's a link to the Google Sheet with Apps Script for sending emails: bit.ly/googlesheets-send-emails

[@prakashprajapati901]

@@PeterHornerGoogleTech sir we are enable to access app script using above link given by you. There are many queries regarding app script can you please help me?

[@allanodero1658]

How can you automate email once a condition is met?