Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Reports, Analytics & Dashboards

Reports, Analytics & Dashboards

Send a weekly Sunday digest email from Notion databases via SMTP

Every Sunday at 09:00 this schedule reads four Notion databases for invoices, projects, pipeline and content, then emails a plain-text summary.

What it does

## Sunday digest from your Notion workspace Every Sunday morning this workflow reads four Notion databases and emails you one plain-text summary, so you start the week knowing what needs attention. Who it's for: freelancers, consultants and solo founders who run clients, invoices, sales and content in Notion. ### How it works 1. A schedule trigger runs every Sunday at 09:00 (cron 0 9 * * 0, workflow timezone Europe/Oslo). 2. Four Notion nodes fetch overdue invoices, active projects, your sales pipeline and your content plan. 3. A Code node keeps deals in Contacted, Proposal or Negotiation that haven't been touched for 7+ days, plus content in Draft or Scheduled, and builds the email text. 4. One email goes to the address you set. ### Setup steps 1. Connect your Notion credential in each of the four Notion nodes, and share the databases with that integration. 2. Open Set your settings and paste your four database IDs and your email address. 3. Connect an SMTP credential in Send Sunday digest email (or swap in the Gmail/Outlook node). 4. Change the schedule in Every Sunday at 09:00, and the timezone under Workflow settings. 5. Click Run manually to test, check your inbox, then activate. ### Customization - Property names used: Name, Status, Amount, Stage, Last touched, Deal name, Title. Rename them in the Notion filters and the Code node to match your databases. - Change COLD_AFTER_DAYS to decide when a deal counts as cold. - Add or remove sections in the Code node.

The steps

  1. Every Sunday at 09:00
  2. Run manually to test
  3. Set your settings
  4. Get overdue invoices from Notion
  5. Get active projects from Notion
  6. Get sales pipeline from Notion
  7. Get content plan from Notion
  8. Build Sunday digest text
  9. Send Sunday digest email

Similar automations