G
GTM Vault
Browse
  • Dashboard
    • Automations
    • Skills
    • Prompts
    • Makers
  • Sign in
All Automations

Automate B2B SaaS renewal risk management with CRM, support & usage data

Automatically identifies B2B SaaS accounts at renewal risk, enriches with CRM and usage data, and triggers appropriate retention playbooks.

workflowcrm
Yassin Zeharby Yassin Zeharon n8n
Nodes

33

Triggers

1

Platform

n8n

Tech Stack
Zendesk
Zendesk
Postgres
Postgres
HubSpot
HubSpot
Salesforce
Salesforce
Pipedrive
Pipedrive
Gmail
Gmail
Jira
Jira
Slack
Slack
How It Works

This workflow runs daily to detect accounts with renewals in 30 days, enriches each account with data from CRM, support, and usage systems, then calculates churn risk scores. Based on risk levels, it automatically triggers escalation playbooks including task creation, alerts, and personalized outreach to secure renewals.

1

Detect upcoming renewals

Queries Postgres database daily to identify all active subscriptions expiring in 30 days with account and commercial data.

2

Enrich account data

Collects engagement history from HubSpot, account profiles from Salesforce, deal activities from Pipedrive, and support tickets from Zendesk.

3

Calculate churn risk scores

Evaluates multiple signals including engagement, usage patterns, and support interactions to categorize accounts as high, medium, or low risk.

4

Route accounts by risk level

Directs each account to appropriate playbooks based on risk score using automated decision logic.

Attached Files
workflow.json
5

Execute retention playbooks

Creates Jira tickets and sends Slack alerts for high-risk accounts, schedules follow-ups for medium-risk, and light monitoring for low-risk accounts.

6

Log results and send reports

Records all processed accounts in database and sends daily summary email to Customer Success leadership with renewal status overview.

What You'll Need

ZendeskPostgreSQLHubSpot Service HubSalesforcePipedriveGmailJiraSlackTrello
  • Postgres database with subscription and renewal data
  • HubSpot account with CRM access
  • Salesforce or Pipedrive CRM integration
  • Zendesk support system access
  • Jira workspace for task management
  • Slack workspace for team notifications

This automation has 21 configurable settings you'll customize during setup.