Automate Lead Ranking & Task Creation with Google Sheets + ClickUp

About

Description Stop losing warm leads in the noise. This automation analyzes your lead engagement data, calculates priority scores based on activity and last contact date, and automatically queues your top 10 leads for follow-up in ClickUp — complete with suggested send times based on timezone. ⚡ What This Template Does Pulls lead data from Google Sheets (e.g., name, engagement, last contact date, timezone). 📄 Calculates days since last contact to measure lead freshness. ⏰ Combines engagement sco