All workflows
Google Sheets logoGmail logo

Email last week's sales per rep from a sheet

Every Monday, emails the sales manager each rep's sales total for the past week, from a Google Sheet.

Every Monday at 08:002 apps2 steps

Apps it connects

Authenticate each one once and the workflow is ready to run.

What it does

Each integration step this workflow runs, in order, what it is for, and the conditions and loops that decide when it runs.

  1. 1Google SheetsRead rowsReads last week's rows and totals them for each rep.
  2. If last_week_sales.count is more than 0

    1. 2GmailSendEmails the table to the sales manager.

How it works

What happens on each run, in plain English.

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.

google sheetsgmailweeklyreporting

Start from a workflow that already works.

Add "Email last week's sales per rep from a sheet" to your workspace, connect its apps, and make it yours.

Free plan, no credit card