Quick overview
Quick overview This workflow runs weekly to scan customer job postings via RapidAPI JSearch for competitor tool keywords, calculates renewal proximity from Google Sheets, and alerts the assigned CSM by Gmail while logging high-risk accounts back to Google Sheets. How it works Runs every Monday at 8 AM on a schedule. Reads the customer list from a Google Sheets tab, including company name, renewal date, and CSM email. Searches recent job postings for each customer using the RapidAPI JSearch API with a query that includes competitor tool terms. Scans the returned postings for competitor keyword matches (excluding postings from competitor employers) and calculates days remaining until renewal. Filters to accounts marked high risk when a competitor is detected and the renewal date is within the next 90 days. Appends the high-risk match details to a Google Sheets log tab and sends a formatted Gmail alert to the customer’s CSM. Setup Create a Google Sheet with a customers tab and a churn-alerts-log tab (with the required column headers) and set the Sheet ID in both Google Sheets nodes. Add Google Sheets OAuth2 credentials in n8n. Sign up for RapidAPI JSearch, add your API key in the HTTP request headers, and adjust the search query/competitor terms if needed. Add Gmail OAuth2 credentials and ensure each customer row includes a valid csm_email value for routing alerts. An n8n automation workflow template by Incrementors.
Incrementors
web
free
Others in the same category, ranked by how often they are opened.
