Skip to main content

Send a weekly summary email

Every Monday, Tape emails each deal owner about their open deals and sends the sales lead a short summary note, with no report to build by hand.

Written by Leo

This recipe runs on a schedule. It reads the records of a saved view, sends one email for each record, and then sends one more email to the person in charge. It's meant to keep open deals from going quiet without anyone building a report by hand.

Scrolling through the automation Weekly deal reminders: Every week on Mon at 8:00 AM in Deals, Get records of a view in Deals from Open deals, Send an email to all collected records with To set to the deal owner's email, the subject Open deal: and the deal name, and the stage, amount, and Record URL in the message, then Send an email to <a href="mailto:sales-lead@acme.com" rel="nofollow noopener noreferrer" target="_blank">sales-lead@acme.com</a> with the subject Weekly deal reminders sent

What you'll need

  • A Deals database app with these fields:

  • Deal, a text field

  • Stage and Amount

  • Owner, a person field

  • A saved view of Deals, for example Open deals, that only shows deals that aren't won or lost. The automation uses the view as its list.

Build the automation

  1. Open the Deals app and click the automations icon at the top right (Create and view automations).

  2. Select New automation, then select On a scheduled time or interval.

  3. In the trigger, select One time, choose Every week, then pick 1 week. Monday is selected by default after on.

  4. Select 8:00 AM if the emails should go out at a different time.

  5. Select Add action → Get view. The action reads Get records of a view. Choose the Deals app and the Open deals view.

  6. Select Add action → Send email to collected. It reads Send an email to all collected records. Tape preselects the records from Get view.

  7. In To, insert the Owner field and choose its email. In Subject, enter "Open deal: " and insert the Deal field.

  8. Write the message with the Stage and Amount fields, and insert Record URL so the owner can open the deal.

  9. Select Add action → Send email. In To, enter [email protected]. In Subject, enter "Weekly deal reminders sent". Select Show more if you want to add someone in Cc or Bcc.

  10. Select Create automation.

Below Get records of a view in Deals from Open deals, selecting Add action and Send email to collected, then typing @Owner in To and choosing Owner / Email, so To reads @Collected / Deal / Owner / Email

Note:

  • One email per record. If a view holds 40 deals, 40 emails go out. They count toward your organization's 24-hour email quota.

  • A view returns at most 1,000 records. Anything above that is cut off without a warning.

The result

Every Monday at 8:00 AM, each owner receives one email per open deal they own, with the stage, the amount, and a link. The sales lead gets one note that the reminders went out.

Variations

  • Change the view to Deals without activity this month to only remind owners about stale deals.

  • Replace the last step with a single email that holds a table of all deals. Learn how to build an HTML table from records →

  • Choose Every month for a monthly report.

  • Add Create PDF with an HTML table of the view and attach it to one email. Learn more about Create PDF →

  • Run the automation every day to remind about overdue follow-ups.

Learn more

FAQs

Can I send one email with all deals in it?

Yes, but not with Send email to collected, which sends one email per record. Build an HTML table from the records of Get view, and send that table with one Send email step. Learn how to build an HTML table from records →

Why did some owners get no email?

If an owner didn't get an email, it could be because:

  • The deal isn't in the view. Open the view and check its filters.

  • The person field is empty. The email has no recipient without it.

  • Your organization's 24-hour email quota was used up.

Can I test it without waiting for Monday?

Yes! Select Manual run. Emails go to the real recipients, so use a view with a few test deals that have your own address.

Are you a developer using the Tape API for automations?

The automation API has its own documentation for developers. Full reference: collected_records_send_email in the developer docs →

Still have more questions? Find answers and get help from community experts in the Tape community →.

Did this answer your question?