Send a weekly update to your Slack channel with a clean count of new UX ideas saved in Notion. This is great for product and design teams that want a quick snapshot of progress without building reports by hand. Everyone sees the same number at the same time.

A schedule starts the run once a week. The workflow pulls recent pages from a Notion database using a created time filter for the last seven days. It keeps only items where the idea type includes UX, then summarizes the data with a unique count of idea IDs. Finally, it posts a simple message in Slack that shows the total. A mock data node is included for safe testing before you connect your live Notion data.

Setup is simple. You need a Notion database and a Slack channel the bot can post to. Adjust the filter if your property name is different from property_type or if you want to track other categories. Expect to replace a 30 minute manual report with a message that sends itself on time every week. Use it for weekly standups, roadmap reviews, or leadership updates.

• Weekly schedule trigger that you can change to any day and time
• Notion query that only pulls pages created in the last seven days
• Filter node that keeps entries where the type includes UX
• Item Lists summarize step that counts unique idea IDs
• Slack message that posts the total using a dynamic field
• Optional mock data node for safe testing before going live

• Reduce manual reporting from 30 minutes to 2 minutes
• Automate 100 percent of weekly idea summary posts
• Improve data accuracy by removing copy and paste errors
• Connect Notion and Slack so updates reach the right team
• Scale to handle more ideas without extra effort

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Notion and Slack. See the Tools Required section above for links to create accounts with these services.
3. Open the Notion node in n8n. In the Credential to connect with dropdown, click Create new credential, then follow the on screen steps to connect your Notion account. Name the credential clearly, such as Notion Main.
4. In Notion, share your target database with the integration so n8n can read it. Copy the database ID and paste it into the Notion node database field.
5. Check the Notion filter for Created time on or after last seven days. Keep it if you want a weekly window, or adjust as needed.
6. Open the Filter node and confirm the condition uses your category field. If your Notion property is not property_type or uses a different label than UX, update the expression to match your data.
7. Open the Item Lists node and confirm it summarizes by counting unique values in the id field. If your dataset uses another stable key, switch the field to that key.
8. Open the Slack node. In the Credential to connect with dropdown, click Create new credential and authorize your Slack workspace. Pick the channel where you want to post the update.
9. Review the Slack message text. It uses the unique_count_id field from the summarize step. Adjust wording to match your team style if needed.
10. Open the Schedule Trigger node and set your preferred day and time. Set the timezone in n8n so the run happens when you expect.
11. If you are using live Notion data, disable the Mock Data Code node to avoid mixing test items with real items.
12. Click Execute Workflow to test. Check the Notion, Filter, and Item Lists outputs to confirm the count. If no message appears in Slack, verify the bot has permission to post in that channel and that your filters return at least one item.