All templates

Automated Drone Service Recurring Client Reminders

Every Monday, WebRun checks your recurring client schedule in Google Sheets, finds clients whose next inspection, mapping, or survey service falls due within 30 days, pulls their past project details from DroneDeploy, and queues a personalised re-booking reminder in Mailchimp for your review and approval before it is sent.

Runs on WebRun · Strict Lockdown policy
Every Monday at 8:00 AM WebRunorchestrates each step
1 Google Sheets find clients with service due in 30 days
2 DroneDeploy pull last project details for personalisation
3 Mailchimp queue personalised re-booking reminder for review
In short

How do I automatically remind recurring drone clients when their next survey is due?

Every Monday, WebRun checks your Google Sheets recurring client schedule for service windows due within 30 days, pulls each client's last project details from DroneDeploy, and queues a personalised re-booking reminder in Mailchimp Drafts for your review. You approve and send, keeping your recurring revenue calendar full without manual follow-up.

  • Re-booking reminders are drafted 30 days before each client's service window
  • No recurring client slips through the gap between jobs
  • Every reminder references the client's actual last project for a personal touch

Built for drone service companies · aerial inspection operators · UAV survey providers · commercial drone pilots

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 docs.google.com/spreadsheets in a real browser with your saved login - no setup, no API keys.

  2. 1
    Google Sheets - find clients with service due in 30 days
    google.com
    WebRun in Google Sheets: find clients with service due in 30 days
    WebRun opens Google Sheets to find clients with service due in 30 days.
    • Open the recurring client schedule sheet and filter rows where the next service date falls within 30 days
    • Collect the client name, contact email, service type, and recurrence interval
    • Exclude clients who have already re-booked or whose next appointment is already confirmed

    Done when A list of clients with service due within 30 days is ready.

  3. 2
    DroneDeploy - pull last project details for personalisation
    dronedeploy.com
    WebRun in DroneDeploy: pull last project details for personalisation
    WebRun opens DroneDeploy to pull last project details for personalisation.
    • Open DroneDeploy and locate each client's most recent completed project
    • Note the project name, last flight date, deliverable type, and any seasonal notes to use in the reminder

    Done when Last-service details for each due client are collected from DroneDeploy.

  4. 3
    Mailchimp - queue personalised re-booking reminder for review
    mailchimp.com
    WebRun in Mailchimp: queue personalised re-booking reminder for review
    WebRun opens Mailchimp to queue personalised re-booking reminder for review.
    • Create a draft campaign in Mailchimp for each due client using the re-booking reminder template
    • Personalise with the client name, last service date, service type, and recommended booking window
    • Set campaign status to Draft and leave unsent for your review and approval before scheduling

    Done when A personalised re-booking reminder campaign is in Mailchimp Drafts for every due client.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
docs.google.com/spreadsheets
ScheduleRuns automatically on this cadence
Every Monday at 8:00 AM
DeliveryHow each run's result reaches you
Re-booking reminders · Mailchimp Drafts
OutputWhat each run produces - One Mailchimp draft campaign per due client, personalised with their last service date and recommended booking window.
Draft campaigns
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 send the re-booking reminder without my approval?

No. Every reminder is saved as a Mailchimp draft campaign for your review. It is only sent after you open it in Mailchimp and schedule or send it yourself.

How does it personalise each reminder?

It pulls the client's last project name, flight date, and deliverable type from DroneDeploy and uses those details to make the reminder feel specific to their site and service, not a generic blast.

What if a client has already re-booked for their next service?

Mark their next appointment as confirmed in the Google Sheets schedule and WebRun will skip them automatically on the next run.

Put this on autopilot.

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