Skip to content

Set SQL status date when lead status changes

Automatically detect new lead entries in configured status across Close. Create and update when lead enters a qualifying SQL stage, status transitions to qualifying, or SQL status changesβ€”so you can write qualification timestamps, update the correct lead record, and preserve reporting dates without manual reporting.

How this automation updates your SQL status dates

When a lead enters configured status, delays can break routing decisions and skew SQL reporting. This automation detects SQL stage entry, filters qualifying transitions, and updates the lead custom date fieldβ€”so your team can rely on accurate timestamps.

  1. 1.Detect new lead enters configured status

    Integrate Close and lead status tools to detect the new lead configured status event to trigger a qualification timestamp update.

    Closeor swap with your favorite app
  2. 2.Filter qualifying status transitions

    Integrate Filter by Zapier and workflow rules to check status transition conditions to continue only for qualifying records.

    Filter by Zapieror swap with your favorite app
  3. 3.Update lead custom SQL date field

    Integrate Close and CRM record updates to write the qualification timestamp into the lead custom date field.

    Closeor swap with your favorite app

Automate your work, your way

Build custom automations across your tools in minutes. Describe what you need, connect your apps, and create workflows without the manual effort.

Trusted by 3.4 million companies

Calendly
Okta
Zendesk
Dropbox
Asana
Allstate
Airbnb
ActiveCampaign
Lyft
Webflow
Canva
Sysco
LA Clippers
Getaround
Grammarly
HelloFresh
Lululemon
Barry's
Hopper
Casper
Hudl
Miro
The New York Times
Ruggable
Calendly
Okta
Zendesk
Dropbox
Asana
Allstate
Airbnb
ActiveCampaign
Lyft
Webflow
Canva
Sysco
LA Clippers
Getaround
Grammarly
HelloFresh
Lululemon
Barry's
Hopper
Casper
Hudl
Miro
The New York Times
Ruggable

Related automations

  • Apps: OnceHub, Filter by Zapier, Formatter by Zapier, ActiveCampaign
    Swap with your favorite apps.

    Add 15-minute booking leads to prospects with snapshot

    Your 15-minute booking submissions often lack meeting context, leaving marketing ops and reps unprepared. Capture contact, tags, and a meeting snapshot so leads are ready for nurture within minutes.

  • Apps: Unbiased Pro, Formatter by Zapier, HubSpot
    Swap with your favorite apps.

    Add accepted enquiries as nurture contacts automatically today

    Your accepted enquiries arrive without full contact profiles, delaying campaign enrollment and outreach readiness. Create complete, qualified contacts for marketing ops and campaign managers the same day.

  • Apps: Webflow, Pardot, Formatter by Zapier
    Swap with your favorite apps.

    Add agency form signups to marketing prospects list

    Your agency signups land untagged in marketing, leaving campaign managers without scored contacts for outreach. Adds and scores prospects so lists are ready for segmented nurture same day.

  • Apps: Google Sheets, AI by Zapier
    Swap with your favorite apps.

    Add AI lead grades to updated sheet rows

    Your lead sheet lacks instant qualification, so reps waste outreach time on poor-fit contacts and miss ICP prospects. Scores are written back so reps prioritize outreach within minutes.

  • Apps: Notion, AI by Zapier
    Swap with your favorite apps.

    Add AI lead qualification notes and connection options

    Your research-stage leads lack concise qualification notes, leaving campaign managers unprepared for outreach. Receive AI-written fit notes and two connection message options to act same day.

  • Apps: Webhooks by Zapier, ChatGPT (OpenAI), Formatter by Zapier, LeadConnector
    Swap with your favorite apps.

    Add AI qualified prospects to nurture campaign list

    Your inbound prospects arrive unqualified, leaving outreach cold and follow-ups unprioritized for investment offers. They join a prioritized nurture campaign so managers can follow up the same day.

  • Apps: Zapier Tables, Filter by Zapier, AI by Zapier
    Swap with your favorite apps.

    Add AI suitability verdict to job lead record

    Your job listings lack clear fit signals, causing recruiters to screen ill-matched roles. AI adds a recommendation and reasoning so you can prioritize fits same day.

  • Apps: Webhooks by Zapier, AI by Zapier, Zapier Tables
    Swap with your favorite apps.

    Add and classify incoming web leads into your leads table

    Your web form leads arrive unscored and untracked, causing slow follow-up. Get scored lead records added and updated in your leads table for same-day outreach.

  • Apps: Webhooks by Zapier, AI by Zapier, Google Sheets, Gmail
    Swap with your favorite apps.

    Add and qualify incoming lead to tracking sheet

    Your inbound leads lack verification and prioritization, leaving marketing with noisy contacts and unclear next steps. Receive scored contact rows and a notification so reps can act within minutes.

  • Apps: Typeform, Discord, Facebook Conversions (for Business admins), LeadConnector, Flodesk
    Swap with your favorite apps.

    Add and qualify new form leads to marketing systems

    Your form and quiz entries arrive unqualified, leaving campaign managers unable to prioritize follow-up. You get prioritized, tagged contacts for rapid outreach within the same day.

  • Apps: Tilda Publishing, Google Sheets, Webhooks by Zapier
    Swap with your favorite apps.

    Add and qualify website leads for agent follow-up

    Your site lead forms arrive unstructured and slow outreach, leaving agents without contact context. Leads are normalized and sent to qualification so agents get prioritized contacts same day.

  • Apps: Typeform, LeadConnector, ChatGPT (OpenAI), Formatter by Zapier
    Swap with your favorite apps.

    Add and score applicant submissions in your CRM

    Your application submissions arrive without qualification scores, forcing reviewers into manual triage. It creates leads with an AI score so coordinators can review same day.

  • Explore all lead qualification automations

    Accelerate sales-ready lead flow with automated scoring updates, qualification routing, and rep notifications

    View all

Set up in minutes

Zapier connects your tools, triggers actions from real-time data, and streamlines workflows so your team can focus on what matters most.

  1. Step 1

    Connect your tools

    Bring your apps together so information can move automatically between the tools your team already uses.

  2. Step 2

    Define the trigger

    Choose the events that should start your workflow, like a new submission, updated record, completed task, or customer action.

  3. Step 3

    Automate and measure

    Let your workflow handle follow-ups, updates, notifications, and reporting so your team can track progress and act faster.

See how teams are automating with Zapier (and loving it!)

Smart Charge America

Without Zapier, we would have needed well over 100 employees today just to do what we're doing. We would have been out of business by now.

David Laderberg, VP of Sales

Remote

Without having automation, we would have to at least be double our size. Doubling is a bit of a euphemism β€” I think we would have died or fallen back into oblivion.

Marcelo Lebre, Co-Founder

SweepBright

Zapier helps us close far above 50% more deals than we would without it. It is a key element of our overall strategy and, therefore, of our sales pitch.

Raphael Bochner, Founder and CIO

Digioh

Zapier gives us unlimited flexibility and creativity. With Zapier, you're like an artist with a blank canvas. I don't know what we'd do without it.

Rishi Shah, CEO and Co-Founder

Otter.ai

We don't just want to patch holes; we want to build scalable, future-proof systems. Zapier is helping us do that.

Allen Lai, Head of Customer Experience

Superhuman

We've been able to scale our operations while staying lean. Zapier lets us do more without needing more people.

Jacob Sirrs, Marketing Operations Specialist

Ready to automate your workflow securely?

Streamline processes, uncover new opportunities, and respond faster to change. Empower your team to get more done, without the manual work.