{"product_id":"automate-low-score-lead-alerts-with-hubspot-google-sheets","title":"Automate Low-Score Lead Alerts with HubSpot \u0026 Google Sheets","description":"\u003cp\u003eStop 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003eRunning 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.\u003c\/p\u003e\n\n\u003cp\u003eWhen 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.\u003c\/p\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003eSales teams needing immediate alerts when hot leads start cooling down\u003c\/li\u003e\n\u003cli\u003eMarketing operations wanting to trigger re-engagement campaigns automatically\u003c\/li\u003e\n\u003cli\u003eRevenue teams tracking lead score deterioration patterns\u003c\/li\u003e\n\u003cli\u003eCustomer success teams monitoring trial user engagement drops\u003c\/li\u003e\n\u003cli\u003eB2B companies with complex lead scoring models requiring proactive intervention\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003cp\u003eSetup 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.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45544316010675,"sku":"N8N-16003","price":41.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/A1G6HZQAilRk_whBzv0gs_5346a412594e4d09bb1e90afb1d5c0c9.jpg?v=1780090015","url":"https:\/\/buyflowscripts.com\/products\/automate-low-score-lead-alerts-with-hubspot-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}