Skip to content

Update guest and user scores from incoming webhook

Automatically monitor incoming webhook payloads across Webhooks by Zapier, Airtable, and Formatter by Zapier. Create and update guest and user scores when completion indicator arrives, guest completion submitters send signals, or user completion submitters confirm progressβ€”so you can update totals, refresh flags, and avoid manual scorekeeping.

How this automation updates customer health scores

When incoming webhook payload arrives, score totals and completion flags can fall out of sync. This automation looks up guest and user records and updates score totals with bonus pointsβ€”so your team can keep health scoring accurate without manual scorekeeping.

  1. 1.Receives incoming webhook payload

    Integrate Webhooks by Zapier and webhook payload mapping tools to capture the incoming email and completion indicator for scoring inputs.

    Webhooks by Zapieror swap with your favorite app
  2. 2.Finds guest record by email

    Integrate Airtable and contact lookup tools to search the Guest table by email and return the guest record id for mapping.

    Airtableor swap with your favorite app
  3. 3.Finds user record by email

    Integrate Airtable and contact lookup tools to search the User table by email and return the user record id when present.

    Airtableor swap with your favorite app
  4. 4.Adds bonus to existing score

    Integrate Formatter by Zapier and calculation tools to add the configured bonus to the existing score total from the Score table.

    Formatter by Zapieror swap with your favorite app
  5. 5.Updates score and completion flags

    Integrate Airtable and data validation rules to update the Score record and guest and user completion flags based on max limits.

    Airtableor 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: monday.com, Formatter by Zapier
    Swap with your favorite apps.

    Calculate and update partner journey score on board

    Your partner journey scores can become inconsistent when status columns change, leaving billing and program coordinators without reliable engagement metrics. It updates scores for same-day use.

  • Apps: Google Drive, Anthropic (Claude), Google Sheets, Slack
    Swap with your favorite apps.

    Create CSM call autograde row from uploaded transcript

    Your check-in call transcripts sit unstructured in Drive, delaying insight and triage for CSMs. Capture call scores and next steps so CSMs can act the same day.

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

    Create daily outreach messages from account health scores

    Your account health reports arrive without tailored outreach, so reps lack clear messages for upsell or recovery. It delivers prioritized, personalized drafts so your team can outreach same day.

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

    Create health monitoring rows from channel posts for PMs

    You have unstructured customer health posts in a busy channel that are hard to track for follow-up. The sheet centralizes parsed health entries so coordinators can triage issues before weekly reviews.

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

    Create lapse log for customers missing report views

    Customer report-view activity can go untracked, leaving CSMs blind to declining engagement and poor renewal signals. Capture lapses into a central tracker so CSMs can prioritize outreach same day.

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

    Create low NPS risk records for customer success team

    Your NPS survey responses arrive untriaged and at-risk customers go unflagged for follow-up. Capture and flag low scores so success teams can act same day.

  • Apps: Vitally, Zapier Tables, Slack
    Swap with your favorite apps.

    Create low-utilization customer log entries for renewal risk

    Your low-utilization indicators leave your CSMs without tracked records of at-risk accounts, slowing renewal prep. It logs each alert to a shared table so CSMs can triage and act ahead of renewal.

  • Apps: Schedule by Zapier, Google BigQuery, Looping by Zapier, Zapier Tables
    Swap with your favorite apps.

    Create nightly client health report and risk flags

    Your churn and onboarding metrics are scattered, leaving account managers without clear risk signals. Get nightly diagnostics so you can triage accounts before morning reviews.

  • Apps: Schedule by Zapier, Google Sheets, Looping by Zapier, HubSpot
    Swap with your favorite apps.

    Create weekly health score records for account profiles

    Your health sheet goes unchecked, leaving account health stale and managers without trend context. It logs health-score records and updates account profiles so managers act before weekly review.

  • Apps: Grain, ChatGPT (OpenAI), Notion, Slack
    Swap with your favorite apps.

    Generate and update client health score from meeting recording

    Your meeting recordings miss clear client health signals, leaving advisors unsure which accounts need attention. The workflow provides a concise health summary and tasks so you can act same day.

  • Apps: Webhooks by Zapier, Code by Zapier, Slack
    Swap with your favorite apps.

    Post account health check submissions to directors channel

    Your account health check submissions arrive scattered, causing client risks and upsell signals to be missed. Directors receive contextual summaries in Slack so they can act ahead of the weekly review.

  • Apps: Schedule by Zapier, Zapier Tables, Salesforce, Looping by Zapier, Code by Zapier
    Swap with your favorite apps.

    Publish weekly account health digest to support channel

    Your account records lack a concise weekly health snapshot, leaving support and CSMs without prioritized triage cues. Get a weekly digest that flags renewals, adoption, and owner context same day.

  • Explore all customer health scoring automations

    Strengthen customer retention with automated score updates, risk alerts, and account prioritization

    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.