Hey! I am trying to create a notion to slack automation that sends a summary into a slack channel each week.
The summary I want to contain a list of what is due that week, and who it’s assigned to.
We use notion as our project manager. So I want the automation to pull that database data and summarize it into due dates for the week and assignee and then input that into the slack channel.
I started this, but not sure what else I need to do (especially with the “formats section”)
I’d recommend a workflow like this:
Use a logic like Due Date is in or between [Start of Week] and [End of Week] to isolate tasks due within the week.
Use Zapier's "Formatter" and choose "Text" or "Utilities > Line Item"
Map fields from your Notion database, such as "Task Name," "Due Date," and "Assignee."
Repeat this for each task due this week
Use the "Utilities > Line Item to Text" formatter to combine all tasks into a single summary message.
Choose "Send Channel Message." in slack.
You’ll have to do trial and error, depending on the database values you might have to map the fields accordingly and change the logic.
+6Hi
We just wanted to see how everything is going with your Zap. Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
We're looking forward to your response.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
