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')];
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! 😉
Should not have glossed over the html part. The rest was easy to follow but you can not use this video without prior knowledge of how to compose html script.
It would be great to know how to add other values specific to the receiver, such as a discount codes.
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')];
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! 😉
Should not have glossed over the html part. The rest was easy to follow but you can not use this video without prior knowledge of how to compose html script.
Thanks for the feedback! Glad it was easy to follow. I'll look at going into more depth about how to generate HTML with Apps Script in a future video.