Automate Low-Score Lead Alerts with HubSpot & Google Sheets

Stop losing valuable leads due to declining engagement scores. This n8n workflow automatically monitors your HubSpot contacts hourly, instantly alerting your team when lead scores drop below critical thresholds while preventing alert fatigue through intelligent deduplication using Google Sheets.

What this workflow does

Running every hour, this automation pulls contacts from HubSpot and cross-references them against a Google Sheets "Alert Dedup Log" to avoid duplicate notifications within 24 hours. It flags contacts with HubSpot scores under 50, categorizing them by urgency: CRITICAL for scores under 20, WARNING for scores under 50. The workflow automatically looks up each contact's owner in HubSpot and creates targeted alert payloads.

When low-score contacts are identified, the system posts alerts to appropriate Slack channels based on urgency level and sends direct messages to contact owners. It then creates follow-up tasks in HubSpot for at-risk contacts and triggers re-engagement emails via Gmail. All activity is meticulously logged in Google Sheets across two tabs: "Lead Score Alerts" for comprehensive tracking and "Alert Dedup Log" for timestamp management.

Use cases

• Sales teams needing immediate alerts when hot leads start cooling down
• Marketing operations wanting to trigger re-engagement campaigns automatically
• Revenue teams tracking lead score deterioration patterns
• Customer success teams monitoring trial user engagement drops
• B2B companies with complex lead scoring models requiring proactive intervention

Technical details

This workflow integrates HubSpot OAuth2 for contact and lead score management, Slack OAuth2 for team notifications, Gmail for automated email campaigns, and Google Sheets Service Account for deduplication logging and alert tracking. Built with n8n nodes including conditional logic (if), custom code processing, and sticky notes for documentation.

Setup requires connecting your HubSpot, Slack, and Gmail credentials, configuring Google Sheets Service Account access, and creating properly formatted spreadsheet tabs. The workflow handles all data synchronization automatically once configured.