ClickUp and HTTP Request integration

🚀 Automated Competitor Intelligence: CrunchBase to ClickUp Tracking Workflow! Workflow Overview This cutting-edge n8n automation is a sophisticated competitive intelligence tool designed to transform market research into actionable insights. By intelligently connecting CrunchBase, ClickUp, and intelligent data processing, this workflow: Discovers Competitor Insights: Automatically retrieves company data Tracks real-time business updates Eliminates manual research efforts Intelligent Data Processing: Converts company names to API-compatible formats Fetches comprehensive company information Ensures precise data retrieval Automated Task Management: Creates instant review tasks in ClickUp Distributes competitive intelligence Enables rapid team response Seamless Workflow Integration: Cross-platform data synchronization Reduces manual intervention Provides structured competitive insights Key Benefits 🤖 Full Automation: Zero-touch competitive tracking 💡 Smart Data Processing: Intelligent insight generation 📊 Comprehensive Intelligence: Detailed company information 🌐 Multi-Platform Synchronization: Seamless data flow Workflow Architecture 🔹 Stage 1: Competitor Identification Manual Trigger**: Workflow initiation Competitor Name Setting** Slug Generation**: Converts names to API-compatible formats Ensures precise data matching 🔹 Stage 2: Data Retrieval CrunchBase API Integration** Comprehensive Company Lookup** Real-Time Information Gathering** 🔹 Stage 3: Insight Distribution ClickUp Task Creation** Structured Information Sharing** Team Notification Mechanism** Potential Use Cases Strategic Planning**: Competitive landscape monitoring Sales Teams**: Market intelligence gathering Product Managers**: Tracking industry innovations Investors**: Investment opportunity research Marketing Departments**: Competitive analysis Setup Requirements CrunchBase API API credentials Configured access permissions Company tracking setup ClickUp Workspace Connected ClickUp account Task management configuration Team collaboration settings n8n Installation Cloud or self-hosted instance Workflow configuration API credential management Future Enhancement Suggestions 🤖 Multi-competitor tracking 📊 Advanced trend analysis 🔔 Customizable alert mechanisms 🌐 Expanded data source integration 🧠 Machine learning insights generation Technical Considerations Implement robust error handling Use secure API authentication Maintain flexible data processing Ensure compliance with API usage guidelines Ethical Guidelines Respect business privacy Use data for legitimate research Maintain transparent information gathering Provide proper attribution Hashtag Performance Boost 🚀 #CompetitiveIntelligence #MarketResearch #BusinessTracking #AIWorkflow #DataAutomation #TechInnovation #StrategicPlanning #BusinessIntelligence #MarketInsights #APIAutomation Workflow Visualization [Manual Trigger] ⬇️ [Set Competitor Name] ⬇️ [Generate Crunchbase Slug] ⬇️ [Fetch Crunchbase Data] ⬇️ [Create ClickUp Task] Connect With Me Ready to revolutionize your competitive intelligence? 📧 Email: [email protected] 🎥 YouTube: @YaronBeen 💼 LinkedIn: Yaron Been Transform your competitive research with intelligent, automated workflows!

How it works This workflow runs on a schedule to monitor HubSpot deals with upcoming contract expiry dates. It filters deals that are 30, 60, or 90 days away from expiration and processes each one individually. Based on the remaining days, it sends personalized email reminders to contacts via Gmail. It also notifies account managers in Slack and creates follow-up tasks in ClickUp for tracking. Step-by-step Schedule and filter expiring deals** Schedule Trigger – Runs the workflow at defined intervals. Get all deals – Fetches deals and contract expiry data from HubSpot. Filter Deals – Calculates days left and keeps only 30, 60, or 90-day expiries. Process deals and fetch contacts** Loop Over Deals – Iterates through each filtered deal. Fetch Associated Contact With Deal – Retrieves linked contact IDs via API. Get Contact Details – Pulls contact email and basic info from HubSpot. Route and send reminder emails** Switch – Routes deals based on days left (30, 60, 90). 30 day mail – Sends urgent renewal reminder via Gmail. 60 day mail – Sends friendly renewal notification email. 90 day mail – Sends early awareness email. Merge – Combines all email paths into a single output. Notify team and create follow-ups** Nofity Account Manager – Sends Slack alert with deal and contact details. Create Follow-up Task – Creates a ClickUp task for renewal tracking. Why use this? Prevent missed renewals with automated tracking and alerts Improve customer retention through timely communication Reduce manual CRM monitoring and follow-ups Keep teams aligned with Slack notifications and task creation Scale contract management without increasing workload

This workflow processes raw meeting recordings or handwritten notes, automatically transcribes and summarizes them, and then distributes the concise summary to all meeting participants via Microsoft Teams while also creating an action-item task in ClickUp. The goal is to save time, keep everyone aligned, and ensure follow-up tasks are tracked in your project management workspace. Pre-conditions/Requirements Prerequisites n8n instance (self-hosted or n8n.cloud) ScrapeGraphAI community node installed Microsoft Teams tenant with permissions to create Incoming Webhooks or use Bot Framework ClickUp workspace and a target List to hold meeting action items Optional: OpenAI or any LLM API account for high-quality summarization Required Credentials Microsoft Teams Webhook URL** – to post summary messages ClickUp Personal Access Token** – to create tasks OpenAI API Key** (optional but recommended) – for AI-powered summarization ScrapeGraphAI API Key** – placeholder key to satisfy the template requirement Specific Setup Requirements | Item | Description | Example | |------|-------------|---------| | Teams Channel Webhook | Create an Incoming Webhook in the desired Teams channel and copy the URL | https://outlook.office.com/webhook/... | | ClickUp List ID | The numeric ID of the list where tasks will be created | 90123456 | | Summarization Model | The LLM model or API you prefer to use | gpt-3.5-turbo | How it works This workflow transcribes or parses meeting content, leverages an LLM to generate a concise summary and action items, then distributes the results to participants in Microsoft Teams and creates a follow-up task in ClickUp. Everything runs in a single automated flow triggered manually or on a schedule. Key Steps: Manual Trigger**: Start the workflow after a meeting ends. Sticky Note**: Provides on-canvas documentation for quick reference. Set Node – Upload Metadata**: Define meeting title, date, and participants. HTTP Request – Transcription**: Send audio/video file to a transcription service (e.g., Azure Speech-to-Text). Wait**: Pause until the transcription is complete. Code – Summarize**: Use OpenAI to summarize the transcript and extract action items. IF Node – Validate Output**: Ensure the summary exists; handle errors otherwise. Merge**: Combine summary with participant list. Microsoft Teams Node**: Send the summary to each participant or channel via webhook. ClickUp Node**: Create a task containing the summary and action items. Set up steps Setup Time: 10-15 minutes Create Teams Webhook: In Microsoft Teams, navigate to the target channel → Manage channel → Connectors → Incoming Webhook → give it a name (e.g., “MeetingBot”) and copy the generated URL. Generate ClickUp Personal Access Token: ClickUp → Settings → Apps → Generate Token → copy and store it securely. Get ClickUp List ID: Open the list in ClickUp and copy the numeric ID from the URL bar. Optional – Obtain OpenAI API Key: Sign in to OpenAI → API Keys → Create new secret key. Add Credentials in n8n: In n8n, go to Credentials → New → add Microsoft Teams, ClickUp, and OpenAI (Generic HTTP). Import Workflow: Paste the JSON workflow into n8n or use “Templates → Import”. Configure Nodes: In the Set Node: update meeting_title, date, and participants array. In HTTP Request: set the transcription service endpoint and authentication. In Code – Summarize: paste your OpenAI key or select credential. In Microsoft Teams Node: select the Teams credential and webhook URL. In ClickUp Node: select ClickUp credential and enter the List ID. Test: Click “Execute Workflow” on the Manual Trigger node. Verify that a message appears in Teams and a task is created in ClickUp. Node Descriptions Core Workflow Nodes: Manual Trigger** – Initiates the workflow manually or on a schedule. Sticky Note** – Documentation block outlining purpose and credential usage. Set** – Stores meeting metadata and participants list. HTTP Request** – Sends meeting recording to a transcription service and fetches results. Wait** – Holds the workflow until transcription is ready. Code** – Summarizes transcript and extracts action items via OpenAI. IF** – Validates summarization success; branches on failure. Merge** – Combines summary text with participant emails/usernames. Microsoft Teams** – Posts summary to Teams channel or direct messages. ClickUp** – Creates a task containing summary and action items. Data Flow: Manual Trigger → Set → HTTP Request → Wait → Code → IF → Merge → Microsoft Teams Merge → ClickUp Customization Examples Change summarization prompt // Inside the Code node const prompt = ` You are an expert meeting assistant. Summarize the following transcript in under 150 words. List action items in bullet points with owners. Transcript: ${items[0].json.transcript} `; Send summary as a PDF attachment // Add Convert & Save node before Teams // Convert markdown summary to PDF and attach in Teams node Data Output Format The workflow outputs structured JSON data: { "meeting_title": "Q3 Strategy Sync", "date": "2024-05-10", "participants": ["[email protected]", "[email protected]"], "summary": "We reviewed Q3 OKRs, decided to ...", "action_items": [ { "owner": "John", "task": "Prepare budget draft", "due": "2024-05-20" }, { "owner": "Jane", "task": "Compile market research", "due": "2024-05-25" } ], "clickup_task_id": "abcd1234", "teams_message_id": "msg7890" } Troubleshooting Common Issues Teams message not sent – Verify the Incoming Webhook URL and that the Teams node uses the correct credential. ClickUp task missing – Ensure the List ID is correct and the ClickUp token has tasks:write scope. Empty summary – Check that the transcription text is populated and the OpenAI prompt is valid. Performance Tips Compress large audio/video files before sending to the transcription service. Use batching in the Teams node if participant list is >20 to avoid rate limits. Pro Tips: Schedule the workflow to auto-run 5 minutes after recurring meeting end-times. Customize the ClickUp task description template to include embedded links. Add a “Send Email” node for participants not on Teams.

Description Automatically analyze incoming lead replies from Google Sheets using Azure OpenAI GPT-4, classify their intent (Demo Request, Pricing, Objection, etc.), and create actionable follow-up tasks in ClickUp — all without manual intervention. Streamline your sales response workflow and never miss a lead again. 🤖📩📈 What This Template Does Triggers every 15 minutes to check for new lead replies in Google Sheets. ⏰ Prepares lead data for AI analysis by standardizing input fields. 🧩 Uses Azure OpenAI GPT-4 to classify lead intent (Demo Request, Pricing Inquiry, Objection, etc.). 🧠 Routes leads based on intent to the corresponding follow-up handler. 🔀 Creates new ClickUp tasks with calculated due dates, descriptions, and pipeline stages. 🗂️ Adds structured checklists to each task for consistent sales follow-ups. ✅ Loops through multiple tasks while respecting ClickUp API rate limits. 🔁 Key Benefits ✅ Saves hours of manual lead qualification and task creation. ✅ Ensures no lead reply is ignored or delayed. ✅ Standardizes intent-based follow-ups for sales teams. ✅ Enhances productivity with AI-driven decision logic. ✅ Maintains clear visibility across CRM and task systems. Features 15-minute recurring trigger to monitor new replies. AI-powered intent classification using Azure OpenAI GPT-4. Multi-category routing logic for personalized next steps. Seamless ClickUp integration for automated task generation. Smart checklist creation for follow-up management. Batch loop processing to avoid rate-limit errors. Requirements n8n instance (cloud or self-hosted). Google Sheets OAuth2 credentials with read access. Azure OpenAI GPT-4 API credentials. ClickUp API token with workspace permissions. Target Audience Sales and marketing teams managing inbound leads. 💼 Agencies automating client qualification workflows. 🏢 Startups improving lead follow-up efficiency. 🚀 Teams integrating AI-driven insights into CRM processes. 🌐 Step-by-Step Setup Instructions Connect Google Sheets with your lead replies document. 📊 Add Azure OpenAI GPT-4 API credentials for intent analysis. 🧠 Configure ClickUp workspace details — team, space, folder, and list IDs. ⚙️ Set your preferred trigger interval (default: every 15 minutes). ⏰ Run a test with sample data to confirm intent mapping and task creation. ✅ Activate the workflow to automatically classify leads and create ClickUp tasks. 🚀

Create Airtable records from new ClickUp Doc pages This workflow automates the process of turning content from ClickUp Docs into structured data in Airtable. When a new task is created in ClickUp with a link to a ClickUp Doc in its name, this workflow triggers, fetches the entire content of that Doc, parses it into individual records, and then creates a new record for each item in a specified Airtable base and table. Who's it for This template is perfect for content creators, project managers, and operations teams who use ClickUp Docs for drafting or knowledge management and Airtable for tracking and organizing data. It helps bridge the gap between unstructured text and a structured database. How it works Trigger: The workflow starts when a new task is created in a specific ClickUp Team. Fetch & Parse URL: It gets the new task's details and extracts the ClickUp Doc URL from the task name. Get Doc Content: It uses the URL to fetch the main Doc and all its sub-pages from the ClickUp API. Process Content: A Code node parses the text from each page. It's designed to split content by * * * and separate notes by looking for the "notes:" keyword. Find Airtable Destination: The workflow finds the correct Airtable Base and Table IDs by matching the names you provide. Create Records: It loops through each parsed content piece and creates a new record in your specified Airtable table. How to set up Configure the Set Node: Open the "Configure Variables" node and set the following values: clickupTeamId: Your ClickUp Team ID. Find it in your ClickUp URL (e.g., app.clickup.com/9014329600/...). airtableBaseName: The exact name of your target Airtable Base. airtableTableName: The exact name of your target Airtable Table. airtableVerticalsTableName: The name of the table in your base that holds "Vertical" records, which are linked in the main table. Set Up Credentials: Add your ClickUp (OAuth2) and Airtable (Personal Access Token) credentials to the respective nodes. Airtable Fields: Ensure your Airtable table has fields corresponding to the ones in the Create New Record in Airtable node (e.g., Text, Status, Vertical, Notes). You can customize the mapping in this node. Activate Workflow: Save and activate the workflow. Test: Create a new task in your designated ClickUp team. In the task name, include the full URL of the ClickUp Doc you want to process. How to customize the workflow Parsing Logic:* You can change how the content is parsed by modifying the JavaScript in the Parse Content from Doc Pages Code node. For example, you could change the delimiter from * * to something else. Field Mapping:** Adjust the Create New Record in Airtable node to map data to different fields or add more fields from the source data. Trigger Events:** Modify the Trigger on New ClickUp Task node to respond to different events, such as taskUpdated or taskCommentPosted.

Description: Stay ahead of payment disputes with this automated n8n workflow that integrates Stripe, Slack, and ClickUp. Perfect for finance teams, payment ops specialists, and SaaS businesses, this template fetches disputes directly from Stripe, analyzes urgency, and instantly notifies your team with rich, formatted alerts. High-priority disputes are flagged, pushed into Slack for immediate visibility, and tracked in ClickUp with due dates aligned to Stripe evidence deadlines—ensuring no dispute ever slips through the cracks. For lower-priority or resolved cases, the workflow provides concise updates and maintains an audit trail. No more manual Stripe checks, late responses, or missed deadlines—this workflow turns dispute management into a proactive, structured process. What This Template Does (Step-by-Step): 🟢 Trigger: Manual or Scheduled Execution Run the workflow on demand or schedule it (e.g., every 4 hours). 📥 Fetch Stripe Disputes Calls the Stripe API to retrieve all active disputes in your account. 📊 Validate & Format Data Ensures disputes exist, then enriches data with formatted amounts, deadlines, and customer info. ⚖️ Priority Logic Determines urgency based on dispute status, evidence deadlines, and transaction amount. 🚨 High Priority Path • Sends urgent Slack alert with full dispute details • Creates a high-priority ClickUp task with due dates • Flags immediate action required 📋 Standard Path • Sends standard Slack alert for non-urgent cases • Creates a ClickUp task with appropriate priority levels ℹ️ No Disputes Path Sends a Slack summary confirming no new disputes, maintaining a clear audit trail. ✅ Workflow Completion Confirms all disputes are processed, logged, and assigned—ready for your team to take action. Required Integrations: ✅ Stripe API (for dispute data) ✅ Slack API (for team alerts) ✅ ClickUp API (for task management) Perfect For: 💳 FinOps and payment operations teams monitoring transactions 🏢 SaaS platforms or e-commerce handling large payment volumes 🛡️ Risk and compliance teams tracking disputes and deadlines 📈 Businesses scaling customer payment handling and case management Why Use This Template? ✔️ Never miss a dispute deadline ✔️ Automated priority assessment saves hours of manual checks ✔️ Seamlessly integrates alerts + task tracking ✔️ Provides full visibility and accountability for dispute resolution

Description Give your sales team a competitive edge with this Lead Profile Enrichment automation! This workflow automatically enriches lead data by fetching company details, logos, and brand colors, then syncs everything into Notion, ClickUp, and Google Sheets—ensuring your reps walk into every call fully prepared. With domain lookups, Clearbit API integration, and seamless updates across platforms, you’ll always have a complete 360° profile of every lead—without the manual research. What This Template Does (Step-by-Step) 📋 Pulls lead details from Google Sheets 🕒 Triggers enrichment when a meeting is booked or a rep is assigned 🔗 Extracts company domain from the lead’s email 🏢 Fetches company logos & metadata via Clearbit APIs 🎨 Assigns brand colors & industries for visual consistency 📝 Creates enriched profiles in Notion & ClickUp with full lead context 📊 Appends enriched records to Google Sheets for logging & history Prerequisites Google Sheets with lead data (Name, Email, Company, Status) Clearbit Logo & Company Enrichment API access Notion API credentials ClickUp API credentials n8n instance (self-hosted or cloud) Step-by-Step Setup Prepare your Google Sheet with columns: Name, Email, Company, Status, Domain. Set a trigger for enrichment (meeting booked OR >24 hrs since reply). Extract company domain from the lead’s email. Connect to Clearbit APIs to fetch: Logo Industry Brand colors Company metadata Format the enriched data and create a new profile entry in Notion. Create/update a ClickUp task with enriched lead details. Append enriched data to Google Sheets for tracking & reporting. Customization Ideas Extend enrichment with LinkedIn or Crunchbase APIs. Add Slack/Telegram notifications when enrichment completes. Auto-assign leads to reps based on industry or geography. Sync with CRM platforms (HubSpot, Salesforce, Zoho). Key Benefits ✅ Saves time on manual research ✅ Provides sales reps with complete lead profiles instantly ✅ Ensures consistent logos, colors, and metadata ✅ Keeps data synchronized across Notion, ClickUp, and Sheets Perfect For Sales Teams preparing for discovery calls SDRs handling lead qualification Account Managers wanting full company context Businesses that value data-driven sales preparation

This workflow automatically analyses tasks to uncover why the actual time spent exceeds the original estimates. It connects with ClickUp(Can do with any PMS like JIRA, Asana, Monday and more) and other project management tools to generate clear insights on overspending trends. Save time, improve planning accuracy, and boost team productivity with automated task time analysis with two types of reports. “Why needed extra time?”** – Reasons users requested extensions or faced blockers. “Why went over estimate?”** – Reasons the actual work exceeded the original estimation. 🔧 Workflow Overview Manual Trigger Kick off execution by clicking “Test workflow”. Fetch Relevant Tasks Calls ClickUp to retrieve all tasks in specified states (“internal review” or “in progress”) that belong to designated folders and assignees. Filter by Overrun Filters tasks to include only those where time_spent > time_estimate. Gather Details For each overrun task: Fetch time entries via ClickUp API. Fetch all comments, including threaded replies. Retain only essential task fields and reformat timestamps. Normalize and Merge Extracts and sorts comment threads into clean arrays. Sorts time entry intervals chronologically. Merges task metadata, comments, and time entries into a single payload. Pass to AI Agent Sends consolidated task data to a ChatGPT-powered node using a custom prompt that: Extracts all “extra time requests” from comments and time entries. Identifies debugging, research, clarification, or rework intervals exceeding estimates. Combines findings into two distinct checklists. Format JSON Output A final Code node parses AI output into a clean JSON array ready for conversion. Convert to File JSON result for each task is prepared for file attachment or external storage. 🧩 Key Nodes & Functions |Node Name|Responsibility| |-|-| |Get ClickUp Tasks|Retrieves tasks by filter criteria| |If task has crossed estimation|Ensures only tasks with overruns continue| |Fetch Time entries via task IDs|Retrieves detailed time intervals| |Fetch Master comments|Retrieves all comments and threads| |Split → Merge scripting nodes|Clean and normalize comments structure| |Modify Time/Task data|Trims and prepares JSON for AI processing| |OpenAI Chat Model + AI Agent|Applies a GPT-based prompt to generate two reasoned checklists in JSON format| |Convert to File|Prepares final output as a JSON file or store on Sreadsheet or Email or Excel| 🛠 Customization Tips Trigger Automation:** Integrate a scheduled node for periodic runs (e.g., daily). Filter Scope:** Adjust ClickUp filters for different task types, spaces, or statuses. AI Prompt Tuning:** Refine prompt to include severity, link references, or categorize reasons. Output Handling:* Use the JSON file in subsequent n8n nodes for notifications *(Slack, Email, Spreadsheet, Airtable, ExcelSheet, etc.) or analytics. ✅ Benefits at a Glance Automates time-overrun analysis, eliminating manual review. Extracts insights directly from tasks description, comments, and timesheets. Produces structured outputs ideal for management dashboards or retrospectives. Customizable for team-specific workflows or reporting needs. 🔐 API Credentials Needed You will required to create API key of your ClickUp Account. Follow the n8n instruction document here ++https://docs.n8n.io/integrations/builtin/credentials/clickup/++ this will guide you how you can connect your ClickUp acount with n8n workflow. 👨🏻‍💻 Need Help? Contact www.KrupalPatel.com for support and custom workflow development. Find more n8n workflow for real world use cases from here: ++https://n8n.io/creators/krupalpatel/++

Real-Time ClickUp Time Tracking to HubSpot Project Sync This workflow automates the synchronization of time tracked on ClickUp tasks directly to a custom project object in HubSpot, ensuring your project metrics are always accurate and up-to-date. Use Case & Problem This workflow is designed for teams that use a custom object in HubSpot for high-level project overviews (tracking scoped vs. actual hours per sprint) but manage daily tasks and time logging in ClickUp. The primary challenge is the constant, manual effort required to transfer tracked hours from ClickUp to HubSpot, a process that is both time-consuming and prone to errors. This automation eliminates that manual work entirely. How It Works Triggers on Time Entry:** The workflow instantly starts whenever a user updates the time tracked on any task in a specified ClickUp space. ⏱️ Fetches Task & Time Details:** It immediately retrieves all relevant data about the task (like its name and custom fields) and the specific time entry that was just updated. Identifies the Project & Sprint:** The workflow processes the task data to determine which HubSpot project it belongs to and categorizes the work into the correct sprint (e.g., Sprint 1, Sprint 2, Additional Requests). Updates HubSpot in Real-Time:** It finds the corresponding project record in HubSpot and updates the master actual_hours_tracked property. It then intelligently updates the specific field for the corresponding sprint (e.g., actual_sprint_1_hours), ensuring your reporting remains granular and accurate. Requirements ✅ ClickUp Account with the following custom fields on your tasks: A Dropdown custom field named Sprint to categorize tasks. A Short Text custom field named HubSpot Deal ID or similar to link to the HubSpot record. ✅ HubSpot Account with: A Custom Object used for project tracking. Custom Properties** on that object to store total and sprint-specific hours (e.g., actual_hours_tracked, actual_sprint_1_hours, total_time_remaining, etc.). > Note: Since this workflow interacts with a custom HubSpot object, it uses flexible HTTP Request nodes instead of the standard n8n HubSpot nodes. Setup Instructions Configure Credentials: Add your ClickUp (OAuth2) and HubSpot (Header Auth with a Private App Token) credentials to the respective nodes in the workflow. Set ClickUp Trigger: In the Time Tracked Update Trigger node, select your ClickUp team and the specific space you want to monitor for time updates. Update HubSpot Object ID: Find the ID of your custom project object in HubSpot. In the HubSpot HTTP Request nodes (e.g., OnProjectFolder), replace the placeholder ID objectTypeId in the URL with your own objectTypeId How to Customize Adjust the Code: Extract Sprint & Task Data node to change how sprint names are mapped or how time is calculated. Update the URLs in the HubSpot HTTP Request nodes if your custom object or property names differ.