Automate Inactive Deal Cleanup from GoHighLevel to Slack and Sheets
Description Keep your CRM pipeline clean and actionable by automatically archiving inactive deals, logging results to Google Sheets, and sending Slack summary reports. This workflow ensures your sales team focuses on active opportunities while maintaining full audit visibility. šš
What This Template Does Triggers daily at 9 AM to check all GoHighLevel CRM opportunities. ā° Filters deals that have been inactive for 10+ days using last activity or update date. š Automatically archives inactive deals to keep pipelines clutter-free. š¦ Formats and logs deal details into Google Sheets for record-keeping. š Sends a Slack summary report with total archived count, value, and deal names. š¬
Key Benefits ā Keeps pipelines organized by removing stale opportunities. ā Saves time through fully automated archiving and reporting. ā Maintains a transparent audit trail in Google Sheets. ā Improves sales visibility with automated Slack summaries. ā Easily adjustable inactivity threshold and scheduling.
Features Daily scheduled trigger (9 AM) with adjustable cron expression. GoHighLevel CRM integration for fetching and updating opportunities. Conditional logic to detect inactivity periods. Google Sheets logging with automatic updates. Slack integration for real-time reporting and team visibility.
Requirements GoHighLevel API credentials (OAuth2) with opportunity access. Google Sheets OAuth2 credentials with edit permissions. Slack Bot token with chat:write permission. A connected n8n instance (cloud or self-hosted).
Target Audience Sales and operations teams managing CRM hygiene. Business owners wanting automated inactive deal cleanup. Agencies monitoring client pipelines across teams. CRM administrators ensuring data accuracy and accountability.
Step-by-Step Setup Instructions Connect your GoHighLevel OAuth2 credentials in n8n. š Link your Google Sheets document and replace the Sheet ID. š Configure Slack credentials and specify your target channel. š¬ Adjust inactivity threshold (default: 10 days) as needed. āļø Update the cron schedule (default: 9 AM daily). ā° Test the workflow manually to verify end-to-end automation. ā
Related Templates
Track OpenAI Token Usage and AI Agent Metrics with Google Sheets Dashboard
What it does Captures token usage and cost from your AI Agent/LLM. Logs model, tokens, cost, tool use, and conversation ...
Summarize SERPBear data with AI (via Openrouter) and save it to Baserow
Who's this for? If you own a website and need to analyze your keyword rankings If you need to create a keyword report on...
Send Daily Weather Forecasts from OpenWeatherMap to Telegram with Smart Formatting
š¤ļø Daily Weather Forecast Bot A comprehensive n8n workflow that fetches detailed weather forecasts from OpenWeatherMap...
š Please log in to import templates to n8n and favorite templates
Workflow Visualization
Loading...
Preparing workflow renderer
Comments (0)
Login to post comments