Email last week's sales per rep from a sheet

A weekly look at who sold what, without anyone building the report. Each Monday this reads the previous seven days from your sales sheet, adds up each rep's amounts and emails the manager a clean table.

If nobody sold anything that week, no email goes out.

Run every Monday at 08:00.Run every Monday at 08:00.

Sales sheetSet sales_sheet_url to blank.

Sales manager's emailSet manager_email to blank.

Last week's salesRead the rows of sales_sheet_url. Save it as last_week_sales.Google Sheets

Only when there were salesIf last_week_sales.count is greater than 0

Yes

Table of sales by repMake a table of last_week_sales.groups Save it as sales_table.

Email the sales managerSend an email to manager_email. Save it as summary. Subject: Last week's sales by repsales_table.htmlGmail

No

No steps