Today's top 10 hot leads — with tasks

The scenario scores each lead's priority from таблица, picks the ten hottest and creates outreach tasks for them in yandexTracker.

  • Lead priority scored automatically
  • Top 10 for outreach — every day
  • Tasks are created for you
  • Hot leads never get lost
Google Sheets

How it works

To pass leads from yandexTracker to Google Sheets automatically, use a ready-made scenario — no manual copying, no lost leads.

  1. Starts when: Manual Trigger
  2. Then: Read Leads from Sheet
  3. Then: Calculate Days Since Contact1
  4. Then: Calculate Priority Score1
  5. Then: Sort by Priority Score
  6. Then: Select Top 10 Leads
  7. Then: Suggest Optimal Send Time
  8. Then: Create ClickUp Task
  9. Then: Update Sheet - Mark as Queued

You can launch this yandexTracker + Google Sheets integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.