Build ChatGPT chatbots, surprisingly fast 🚀 Use our Discord server https://discord.gg/botpress to interact!

Botpress

in this tutorial section, i will be listing videos to watch to achieve this 

watch the first part where he sets up google sheets 
https://www.youtube.com/watch?v=lgbHqyDsfwg&t=439s

and then watch this part to setup gmail. https://www.youtube.com/watch?v=ZbpXTwo1Fjc&embeds_referring_euri=https%3A%2F%2Fwww.make.com%2F&embeds_referring_origin=https%3A%2F%2Fwww.make.com&source_ve_path=MjM4NTE&feature=emb_title

image

and after all of that, set up the email sender like the following pictures:

here is a template for you guys 
https://eu2.make.com/templates/5770-send-a-gmail-email-from-a-new-google-sheets-row