1.Monitor updated scoring row
Integrate Google Sheets and reporting worksheets to detect updated row data and trigger last activity backfills.
Update last contact activity date in reporting sheet
Automatically monitor updated lead-scoring rows across Google Sheets and keep Salesforce contact matches aligned. Create last activity lookups and update the reporting worksheet when contact rows update, batch dates change, or cutoff comparisons runβso you can compute priorities, persist reporting dates, and avoid manual data rework.
How this automation preserves lead activity reporting
When lead-scoring dates stay stale, prioritization can miss the real recency signal and follow-up timing slips. This automation watches updated worksheet rows, finds the matching contact, calculates the most recent prior activity date, and updates your Google Sheets reporting columnβso your team can score leads accurately.
Google Sheetsor swap with your favorite app
2.Find contact by email
Integrate Salesforce and CRM lookup tools to search for the contact by email and return the matching record.
Salesforceor swap with your favorite app
3.Format batch date
Integrate Formatter by Zapier and date normalization tools to convert the batch date into a YYYY-MM-DD string.
Formatter by Zapieror swap with your favorite app
4.Find tasks for contact
Integrate Salesforce and task retrieval tools to query tasks by contact ID and pull activity dates.
5.Determine last activity before cutoff
Integrate Code by Zapier and date filtering logic to normalize dates, filter tasks before the cutoff, and pick the latest date.
Code by Zapieror swap with your favorite app
6.Update reporting row with last activity
Integrate Google Sheets and spreadsheet reporting to update the reporting date column with the computed last activity date.
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
Related automations
- Apps: Zapier Tables, AI by ZapierSwap with your favorite apps.
Add account score and tier to target records
Your target account records lack a standardized fit score, causing reps to mis-prioritize outreach and spend extra time assessing fit. This provides tiers and rationale same day.
- Apps: Marketo, Salesforce, ChatGPT (OpenAI), Filter by ZapierSwap with your favorite apps.
Add AI lead score to MQLs for routing
Your MQL list entries lack quick validation and matched account context, leaving SDRs chasing low-fit prospects. Gain an AI confidence score and account insight so SDRs get prioritized leads same day.
- Apps: Pipedrive, ChatGPT (OpenAI), Formatter by ZapierSwap with your favorite apps.
Add a lead score to deals for prioritization
Your deals lack standardized merchant fit and monthly revenue, leaving reps unsure which prospects deserve priority. Score deals 0β100 and write to the record so reps can act on top leads same day.
- Apps: SurveyMonkey, Formatter by Zapier, HubSpotSwap with your favorite apps.
Add assessment respondents to CRM contact records with score
Your assessment survey responses arrive outside CRM, leaving marketing unable to segment prospects by readiness. They become enriched contacts with scores, ready for nurture within minutes.
- Apps: Webhooks by Zapier, Delay by Zapier, Zapier TablesSwap with your favorite apps.
Add bot risk score to lead records automatically
Your inbound lead records lack bot-risk context, causing wasted outreach to low-quality signups. The workflow adds risk scores to records so marketing can triage leads same day.
- Apps: Call Tools PCC, Formatter by Zapier, Filter by Zapier, Google SheetsSwap with your favorite apps.
Add call notes to prospect scorecards in real time
Your inbound call notes and dispositions aren't captured on prospect scorecards, so campaign managers and reps lack the context to prioritize leads. Keep scorecards current so marketing managers can prioritize hot prospects same day.
- Apps: HubSpot, Zapier Tables, Delay by Zapier, ChatGPT (OpenAI), Google SheetsSwap with your favorite apps.
Add clicked email contacts to ICP lead table
Your campaign link-click contacts arrive without qualification, delaying follow-up and wasting outreach. Capture and ICP-score them so RevOps prioritizes outreach same day.
- Apps: HubSpot, Zapier Tables, Delay by Zapier, ChatGPT (OpenAI), Google SheetsSwap with your favorite apps.
Add event registrants to CRM and score ICP
Your event registrants remain in marketing lists unqualified, so sales reps lack ICP context and delays slow follow-up. Capture and score each registrant so reps can prioritize outreach same day.
- Apps: Webflow, Google Sheets, ChatGPT (OpenAI), GmailSwap with your favorite apps.
Add form submissions to screening sheet with AI score
Your application submissions arrive unstructured, stalling deal-flow and leaving founders waiting. You get structured spreadsheet rows and an AI fit score so associates prioritize outreach same day.
- Apps: ActiveCampaign, Filter by Zapier, Google SheetsSwap with your favorite apps.
Add highly engaged contacts to your lead tracker
Your highly engaged webhook contacts aren't in a central list, leaving campaign managers unsure which prospects to call. This creates a prioritized lead tracker so outreach starts same day.
- Apps: Sub-Zap by Zapier, Formatter by ZapierSwap with your favorite apps.
Add ICP scoring and segments to company records
When company leads lack ICP tags and size data, your growth team misprioritizes outreach and campaign segments. Get consistent company scoring and segments for faster targeting within minutes.
- Apps: Schedule by Zapier, Zapier Tables, Filter by Zapier, Looping by Zapier, Code by ZapierSwap with your favorite apps.
Add missing first contact dates to lead records
Your leads table has contacted entries missing first-contact timestamps, which skews segmentation. Populate timestamps and elapsed buckets so campaign managers can act on fresh leads within an hour.
- View all
Explore all lead scoring automations
Prioritize high-intent leads with automated score updates, qualification rules, and rep alerts
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.
Step 1
Connect your tools
Bring your apps together so information can move automatically between the tools your team already uses.
Step 2
Define the trigger
Choose the events that should start your workflow, like a new submission, updated record, completed task, or customer action.
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!)
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
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
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
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
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
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.