n8n Workflow: Generate ClickUp Weekly Assignment & Performance Reports with Gmail

This n8n workflow automates the process of generating and sending weekly assignment and performance reports from ClickUp via Gmail. It's designed to streamline communication and ensure stakeholders receive timely updates on team progress and individual contributions.

What it does

This workflow, when manually triggered, performs the following actions:

1. Initiates Manually: The workflow starts when explicitly executed.
2. Executes Custom Code: It runs a custom JavaScript function, likely to prepare data or define variables needed for subsequent steps. (The specific logic is within the Function node's code, not visible in the provided JSON, but it's a critical step for data manipulation).
3. Interacts with ClickUp: It connects to ClickUp, presumably to retrieve assignment and performance data. This could involve fetching tasks, lists, or other relevant metrics.
4. Sends Email via Gmail: Finally, it uses Gmail to compose and send an email. Based on the workflow's purpose, this email would contain the generated ClickUp reports.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running instance of n8n.
• ClickUp Account: With appropriate API access to retrieve task and performance data.
• Gmail Account: Configured as a credential in n8n for sending emails.
• n8n Credentials: Configured credentials for both ClickUp and Gmail within your n8n instance.

Setup/Usage

1. Import the Workflow: Import the provided JSON into your n8n instance.
2. Configure Credentials:
   • Set up your ClickUp API credential in n8n.
   • Set up your Gmail OAuth2 credential in n8n.
3. Customize the Function Node: Review and modify the JavaScript code within the "Function" node (ID: 14) to tailor data extraction and manipulation as per your specific reporting needs from ClickUp.
4. Configure ClickUp Node: Adjust the "ClickUp" node (ID: 129) to specify which ClickUp data (e.g., Space, Folder, List, Task details) it should retrieve.
5. Configure Gmail Node: Customize the "Gmail" node (ID: 356) to define the recipient(s), subject, and body of the email, incorporating the ClickUp data processed by the "Function" node.
6. Execute the Workflow: Click the "Execute Workflow" button in the n8n editor to run the workflow manually. You can then activate it for ongoing use if desired (though the current trigger is manual).