How To Automatically Send HTML Table In Gmail Using Google Sheets

In this video we would learn:
1. Sending emails with HTML table using Google Sheets
2. How to embed HTML in an email using google sheets

[Anonymoustilldead]

You are awsm man keep up the great work i hope to see more of your videos in future

[Mirte]

Awesome! works smooth. How to add css styling to the email?

[ChuckFingerman]

Great job - easy to follow and understand Thanks

[MrMsblackberry]

Awesome! You are such a big help with this content. May I also asks how can we pull specific columns only?

[TauqeerAshraf-lx]

It's a great content. I would love more if you could explain how I can schedule it for a daily email at a certain time?

[stephenlawrence]

Great content! Some questions:
1. How to send to an email address from a cell on the Google Sheets?
2. How to send multiple email addresses?

[lespetitsmontagnards-outdo]

hello, many thanks for this tuto, how to do if the table is in on a specific range (e.g : O3:V8) ?

[evelynwu]

Hello, thank you for sharing the good content. May I ask a question regarding a signature? How can I add my signature in the script ? Thanks in advance.

[bprrsfr]

This works great, and is a lot simpler than setting up a html table. I am using a query to pull a table from my data sheet. Is there any way to check if the query results in the first cell of the table (under the headers) is N/A?. Or if one of the other cells is empty, dont send the email?

[anmellie]

If cells are formatted with color, doess it send that by email too? with the color i mean

[deepakkumaryadav]

can you add how to send it many people
this is absolute superb

[sachinkudhiman]

Thanks it's working but I want to pick same format with colour from sheet to Gmail please help

[ChuckFingerman]

Question: shouldn't the htmlbody string end in ' table = table + "</table>/body></html>" ' ? I followed your easy-to-understand tutorial but my output is '[object Object]'
I do need help.

[bappukhan]

Hlw sir
Can i automated login multiple id & passdword From Excel sheet
Like - gmail acc/ fb acc.

[rahulgalsar]

Hello Sir, How can we send Multiple HTML tables on a mail body with background color, Please guide us on this thru your video & provide Google script

[leelou]

Hello how can i add a signature ?
When i trie the signature become part of the table

[BhavanaAddagulla]

How to add 2 tables one below the other, unable to do that using table1+table2

[manojbhat]

its making a lot of empty rows not sure why