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
Пікірлер: 32
@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-ys1yl3dd9m11 ай бұрын
Great job - easy to follow and understand Thanks
@AutomationMadeEasy11 ай бұрын
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-to4eb3ot9e9 ай бұрын
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?
@abhirajkhomane46785 ай бұрын
in app script there is a scheduler
@evelynwu61357 ай бұрын
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-ys1yl3dd9m11 ай бұрын
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.
@AutomationMadeEasy11 ай бұрын
i need to take a look at your spreadsheet and script. You may share on info@automationandagile.com
@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
@deepakkumaryadav247710 ай бұрын
can you add how to send it many people this is absolute superb