Every Monday, emails the sales manager each rep's sales total for the past week, from a Google Sheet.
Uses
Gmail
Google Sheets
Email last week's sales per rep from a sheet
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 0Yes
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.htmlGmailNo
No steps