Email daily ClickUp digests to stakeholders
HELP! Task: HELP! I work for a construction company with multiple projects that have their own corresponding stakeholders. My boss, a general contractor, wants me to create an automation flow that sends all incomplete action items to the corresponding stakeholders every morning at 6AM, all of which are grouped by project. So I prepped with the following: I created a master action item list, a project list, and a contact list with each stakeholders' corresponding email address. The project list and contact list were included as relationships into the master action item list. The email addresses were added as a rollup to the contacts. I created an automation where if a project is selected for a specific action item, then a list of contacts will be added into their respective field, and with it, their email addresses. I'm a total beginner for the website, and my job is evidently on the line. I told my boss this workflow would be better (and by default, automated in ClickUp) if they just had their own accounts, and he said it wasn't an option. I can start from scratch if need be. I asked AI to help me, and as a preview, their suggestion looked like this: [Mod 1: List Tasks] ➔ [Mod 2: Array Aggregator] ➔ [Mod 3: Iterator] ➔ [Mod 4: Get Project Details] ➔ [Mod 4b: Get Project Custom Fields] ➔ [Mod 5: Text Aggregator] ➔ [Mod 6: Send Email] But when I followed their instructions, this became the result: "Good day everyone, Here's everything that happened today (June 12, 2026): {"text":"\n▸ OWNER: \n • — Priority: \n\n▸ OWNER: \n • — Priority: \n\n▸ OWNER: \n • — Priority: \n\n▸ OWNER: \n • — Priority: \n\n▸ OWNER: \n • — Priority: ","__IMTKEY__":null} • - ({"__IMTKEY__":null,"array":[{"list":null,"name":null,"status":null,"project":null,"due_date":null,"priority":null,"custom_id":null,"dependencies":null,"custom_fields":null,"custom_item_id":null}]}) Please let me know if there's anything you'd like me to change, update, and/or coordinate with our vendors." Granted, the master action list only had about 7 tasks in it at the moment. But all my other projects and tasks have been held off for this specific project. Please help! I'm desperate and evidently do not have any other resource. I'm also willing to sit down on a call if need be.; tools: Make. Human role: The original post does not say how a person stayed involved.; limitations: Prerequisites include valid ClickUp API access and correctly configured relationships between tasks, projects, and contacts. The author noted that stakeholders do not have ClickUp accounts, requiring email-only delivery. Integration uncertainty exists regarding field mapping in Make aggregators. Human approval is required before scheduling the 6 AM automation to prevent spamming stakeholders with broken data..
Tools
Published on Agent Work Atlas:
Overview
HELP!
Workflow
HELP! I work for a construction company with multiple projects that have their own corresponding stakeholders. My boss, a general contractor, wants me to create an automation flow that sends all incomplete action items to the corresponding stakeholders every morning at 6AM, all of which are grouped by project. So I prepped with the following: I created a master action item list, a project list, and a contact list with each stakeholders' corresponding email address. The project list and contact list were included as relationships into the master action item list. The email addresses were added as a rollup to the contacts. I created an automation where if a project is selected for a specific action item, then a list of contacts will be added into their respective field, and with it, their email addresses. I'm a total beginner for the website, and my job is evidently on the line. I told my boss this workflow would be better (and by default, automated in ClickUp) if they just had their own accounts, and he said it wasn't an option. I can start from scratch if need be. I asked AI to help me, and as a preview, their suggestion looked like this: [Mod 1: List Tasks] ➔ [Mod 2: Array Aggregator] ➔ [Mod 3: Iterator] ➔ [Mod 4: Get Project Details] ➔ [Mod 4b: Get Project Custom Fields] ➔ [Mod 5: Text Aggregator] ➔ [Mod 6: Send Email] But when I followed their instructions, this became the result: "Good day everyone, Here's everything that happened today (June 12, 2026): {"text":"\n▸ OWNER: \n • — Priority: \n\n▸ OWNER: \n • — Priority: \n\n▸ OWNER: \n • — Priority: \n\n▸ OWNER: \n • — Priority: \n\n▸ OWNER: \n • — Priority: ","__IMTKEY__":null} • - ({"__IMTKEY__":null,"array":[{"list":null,"name":null,"status":null,"project":null,"due_date":null,"priority":null,"custom_id":null,"dependencies":null,"custom_fields":null,"custom_item_id":null}]}) Please let me know if there's anything you'd like me to change, update, and/or coordinate with our vendors." Granted, the master action list only had about 7 tasks in it at the moment. But all my other projects and tasks have been held off for this specific project. Please help! I'm desperate and evidently do not have any other resource. I'm also willing to sit down on a call if need be.
Reported result
The author reported that the initial automation failed, producing emails with empty JSON structures and missing task details instead of readable summaries. No successful outcomes or metrics were achieved. A measurable acceptance check is proposed: send a test email to the author only, verifying that all 7 sample tasks display correct owner, priority, and project names without raw JSON artifacts.
Human role
The original post does not say how a person stayed involved.
Limitations
Prerequisites include valid ClickUp API access and correctly configured relationships between tasks, projects, and contacts. The author noted that stakeholders do not have ClickUp accounts, requiring email-only delivery. Integration uncertainty exists regarding field mapping in Make aggregators. Human approval is required before scheduling the 6 AM automation to prevent spamming stakeholders with broken data.
Try it
Act as a Make.com automation expert. I need to fix a broken ClickUp-to-Email workflow. Context: Construction company, daily 6 AM digest of incomplete action items grouped by project. Stakeholders have no ClickUp accounts. Inputs: [ClickUp API Token], [Master Action List ID], [Project List ID], [Contact List ID]. Current failure: Emails contain raw JSON and empty fields. Task: 1. Design a Make scenario: List Tasks (filter incomplete) -> Iterator -> Get Project Details -> Text Aggregator (format: Project, Owner, Priority, Due Date) -> Send Email. 2. Ensure field mapping uses correct ClickUp IDs, not null values. 3. Create a test scenario that sends one email to [my_email] with sample data. 4. Verify the output is human-readable, not JSON. 5. Only after I confirm the test email looks correct, provide the final scenario for production. Do not invent success; if fields are missing, ask for specific ClickUp field IDs.
Source reports are not independently verified. Publication date is the catalog publication date, not the original article date.