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.
What you'll need
A
Dealsdatabase app with these fields:Deal, a text fieldStageandAmountOwner, a person fieldA saved view of
Deals, for exampleOpen deals, that only shows deals that aren't won or lost. The automation uses the view as its list.
Build the automation
Open the
Dealsapp and click the automations icon at the top right (Create and view automations).Select
New automation, then selectOn a scheduled time or interval.In the trigger, select
One time, chooseEvery week, then pick1 week. Monday is selected by default afteron.Select
8:00 AMif the emails should go out at a different time.Select
Add action→Get view. The action readsGet records of a view. Choose theDealsapp and theOpen dealsview.Select
Add action→Send email to collected. It readsSend an email to all collected records. Tape preselects the records fromGet view.In
To, insert theOwnerfield and choose its email. InSubject, enter "Open deal: " and insert theDealfield.Write the message with the
StageandAmountfields, and insertRecord URLso the owner can open the deal.Select
Add action→Send email. InTo, enter[email protected]. InSubject, enter "Weekly deal reminders sent". SelectShow moreif you want to add someone inCcorBcc.Select
Create automation.
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 monthto 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 monthfor a monthly report.Add
Create PDFwith an HTML table of the view and attach it to one email. Learn more aboutCreate 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?
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?
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?
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?
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 →.
