All templates
For venue production managers, talent buyers & concert promoters

Chase missing show documents before the deadline

Every morning, WebRun opens Prism.fm, finds upcoming shows with missing required documents such as signed contracts, W-9s, or insurance certificates, logs the gaps in a Google Sheet, and drafts an SMS reminder via Twilio to the contact on file for each missing item, leaving every message for you to approve before it sends.

  • No credit card
  • Under $0.01 per run
  • Cancel anytime
14,115 templates Safe automation No code
Every day at 9:00 AM WebRun
1 Prism.fm find shows with missing required documents
2 Google Sheets log missing document gaps
3 Twilio draft SMS reminder for each contact
Run a sample
In short

How do I automatically chase missing show documents like contracts and W-9s before a deadline?

Every morning WebRun opens Prism.fm, scans shows in the next 30 days for missing required documents such as signed contracts, W-9s, and insurance certificates, logs each gap in Google Sheets, and drafts an SMS reminder via Twilio for each contact. All messages wait for your approval before sending, so no artist or manager is texted uninvited.

  • No show gets to within a week of the date with a missing required document
  • Contacts are never texted without your explicit approval
  • Every document gap is visible in one Google Sheet across all upcoming shows

Built for venue production managers · talent buyers · concert promoters · venue operations staff

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens prism.fm in a real browser with your saved login - no setup, no API keys.

  2. 1
    Prism.fm - find shows with missing required documents
    prism.fm How to Automate Prism.fm
    WebRun in Prism.fm: find shows with missing required documents
    WebRun opens Prism.fm to find shows with missing required documents.
    • Open Prism.fm and look at shows in the next 30 days
    • Check each show for missing documents: signed contract, W-9, certificate of insurance, and rider sign-off
    • Note the show date, artist name, and the production or management contact for each gap

    Done when Every upcoming show with at least one missing required document is listed with its contact.

  3. 2
    Google Sheets - log missing document gaps
    google.com How to Automate Google Sheets
    WebRun in Google Sheets: log missing document gaps
    WebRun opens Google Sheets to log missing document gaps.
    • Open the document-tracking sheet and log each missing-document gap with the show date and document type
    • Update the status column for any document received since the last run

    Done when The tracking sheet reflects the current document status for every show in the window.

  4. 3
    Twilio - draft SMS reminder for each contact
    twilio.com How to Automate Twilio
    WebRun in Twilio: draft SMS reminder for each contact
    WebRun opens Twilio to draft SMS reminder for each contact.
    • Draft a short SMS reminder for each contact with the missing document type and the show date
    • Queue each message for your review and do not send until you approve
    • Skip any contact already reminded in the last 48 hours

    Done when SMS reminder drafts are queued in Twilio for every outstanding document gap, all awaiting your approval.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
prism.fm
ScheduleRuns automatically on this cadence
Every day at 9:00 AM
DeliveryHow each run's result reaches you
Missing-docs log · Google Sheets
OutputWhat each run produces - A Google Sheets log of missing documents per show, plus Twilio SMS drafts ready for your approval for each contact.
Text
Setup & safety

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.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Will it text the artist or manager without my approval?

No. Every SMS reminder is queued as a draft for your review. No message is sent to any contact without your explicit approval.

Which documents does it check for?

It checks for the documents you configure: typically signed contract, W-9, certificate of insurance, and rider sign-off. You can add or remove items from the checklist.

What if the document was submitted yesterday?

It reads the current document status in Prism.fm each morning, so any document that was uploaded since the last run is removed from the chase list automatically.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.