Automated SurveySparrow Weekly NPS Report
Every Monday, WebRun opens SurveySparrow, pulls the past week's NPS score and response volume across your active surveys, saves a short report into Google Drive, and drafts a one-line Twilio text summary for execs who want the headline number without opening a dashboard.
How do I get a weekly SurveySparrow NPS summary without checking the dashboard?
Every Monday, WebRun pulls the past week's NPS score and response volume from SurveySparrow, saves a report into Google Drive, and drafts a one-line Twilio text summary for execs who want the number without opening a dashboard. Nothing texts anyone automatically, so leadership gets a fast weekly read on customer sentiment with a human still in control of what gets sent.
- Leadership gets the weekly NPS number without logging into a dashboard
- A dated report builds up in Drive automatically for later reference
- Response volume is included so a score isn't read in isolation
Built for Customer experience teams · executives and founders · product teams · customer success leaders
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
surveysparrow.comin a real browser with your saved login - no setup, no API keys. -
1
SurveySparrow - pull the week's NPS data
surveysparrow.com
WebRun opens SurveySparrow to pull the week's NPS data. - Open SurveySparrow and select each active survey
- Pull the NPS score and response volume for the last 7 days
- Compare the score against the week before
Done when Every active survey has a week-over-week NPS score and response count.
-
2
Google Drive - save the weekly report
drive.google.com
WebRun opens Google Drive to save the weekly report. - Open the weekly NPS reports folder
- Save a report with this week's scores and response counts
- Name the file with the week's date range
Done when This week's report is saved and named in Drive.
-
3
Twilio - draft a text summary
twilio.com
WebRun opens Twilio to draft a text summary. - Draft a one-line text with this week's NPS score and the change from last week
- Reference the report saved in Drive
- Queue the draft for the exec. WebRun never sends the text itself
Done when A drafted summary text is waiting for the exec's review.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Will the text summary send without anyone checking it?
No. WebRun only drafts the Twilio text. Someone reviews and sends it, so nothing reaches an exec's phone automatically.
Which surveys get included in the report?
Every survey currently marked active in your SurveySparrow account. Draft or closed surveys are left out of the weekly numbers.
Can the report include more than just the NPS score?
Yes. It also logs response volume for the week, so a low score with few responses can be read differently from one backed by a large sample.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.