Automatic Email Report from Google Sheets
Learn how to automate weekly email reports from Google Sheets, summarizing key data like tasks completed and hours worked by department. This tutorial covers setting up a single tab for data entry and using Google Apps Script to send automated emails every Friday.
So we're gonna send an email summary every Friday from our Google sheet, and it's going to include a few pieces of data . Now I wanna share with you a little trick right away that's gonna make your life a way better in Google Sheets.
Put everything into one tab, put the date here, put the employees, the departments, the tasks, everything in one tab. Why is that? Because then we can create views of this data and we don't have to figure out what is the name of the tab that we're looking for.
Some range is gonna be task completed criteria range is gonna be this date.
Get all the dates there and actually it's going to get zero. I noticed there's no dates here, so we're gonna add a little bit more data .
So this is tasks. And hours can actually just write tasks and hours. And for the hours we wanna get column E.
We need some variables. We need that data that we're gonna send.
Easy done. All three lines are done in one go. So there's all of our variables. How do we send an email? This is really easy.
So who is it to variable to now this could be any email address. Uh, I'm gonna send it to myself as the owner of the spreadsheet .
And then we want a date in the month, which is a lowercase D, D, d. So that'd be like seven.
Let's try to run it. So what I like to do when I'm creating these automations, this is an automatic email report.
and here's what that email looks like. Oh, I got a range , so that's good that I'm testing this out.
But you can also just edit it if you wanna do a different function .