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

[@lespetitsmontagnards-outdo768]

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

[@user-ys1yl3dd9m]

Great job - easy to follow and understand Thanks

[@AutomationMadeEasy]

Glad it was helpful!

[@MrMsblackberry]

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

[@AutomationMadeEasy]

easiest way would be to use sheet formulas and populate the desired in continuous columns in a separate sheet and use the script explained in the tutorial

[@stephenlawrence9000]

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?

[@AutomationMadeEasy]

For question 1 refer below tutorial: kzbin.info/www/bejne/bJCTqmV9aduHh6s For question 2 Just add semicolon separated email addresses

[@user-to4eb3ot9e]

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?

[@abhirajkhomane4678]

in app script there is a scheduler

[@evelynwu6135]

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.

[@sachinkudhiman8704]

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

[@jayasri-ft8040]

Very good

[@AutomationMadeEasy]

Thanks

[@anmellie8992]

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

[@AutomationMadeEasy]

nopes. this will send without colors

[@user-bp9rr7sf1r]

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?

[@AutomationMadeEasy]

yes, which is the cell based on which you wish to send or not send the mail. Send me the sheet name and cell, I will help you with the syntax.

[@user-bp9rr7sf1r]

@@AutomationMadeEasy Thank you so much. Here's the link: docs.google.com/spreadsheets/d/1Tckfog0jDi6qod3Ujc1rxWFGAfGbcN3h9ZkAw6KsouE/edit?usp=sharing

[@bappukhan3883]

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

[@rahulgalsar7766]

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

[@user-ys1yl3dd9m]

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

[@AutomationMadeEasy]

i need to take a look at your spreadsheet and script. You may share on [e-mail]

[@user-mr4mw4yy8p]

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

[@AutomationMadeEasy]

add another taga and follow same approach as done for the first one

[@manojbhat6351]

its making a lot of empty rows not sure why

[@AutomationMadeEasy]

check your source sheet, may be there are hidden blank cells

[@waqasunnabi8842]

bro how to send table + Chart ?

[@AutomationMadeEasy]

script for charts can be found in below tutorial: kzbin.info/www/bejne/iWqXqJaVjdyAecU

[@Life_Misthi]

Hi can you provide this code

[@AutomationMadeEasy]

its on the blog automationandagile

[@deepakkumaryadav2477]

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

[@AutomationMadeEasy]

Semi colon seperate email id's in .to