Skip to main content
TradeAI Hub

Tutorial 13 · 12 min read · Uses Google Sheets + Zapier or Make, or recurring jobs in your job app

Never forget a repeat job: automatic servicing reminders

Backflow tests, cylinder servicing, periodic inspections, heat pump services, seasonal garden rounds — repeat work is the easiest work to win, if you remember to ask. Set this up once and the reminders go out on their own.

What you'll need

  • A list of past customers and what they had done
  • Google Sheets (free) or your job app
  • A free Zapier or Make account
  • A free AI app for writing the messages

Step 1: Build your 'due list'

In Google Sheets, make columns: Customer, Email or mobile, Service type, Last done, Next due. Start with last year's jobs — even 20 customers is worth it.

Step 2: Write three reminder messages with AI

One for 4 weeks out, one for 1 week out, one for overdue.

Copy this prompt and fill in the [square brackets]:

Write a friendly reminder email for a customer whose annual [backflow test / heat pump service] is due next month. Include a booking link placeholder, keep it under 90 words, no pushy sales language.

Step 3: Connect the sheet to email or SMS

In Zapier or Make, start with ONE automation: when 'Next due' is 4 weeks away, send reminder 1. Add the others once it's working.

Step 4: Or use recurring jobs in your job app

If you use a job app, it may be simpler to set up recurring jobs there (Fergus advertises recurring jobs; check Tradify or ServiceM8 for your plan).

Step 5: Seasonal rounds (landscapers and gardeners)

Copy this prompt and fill in the [square brackets]:

Suggest a seasonal maintenance calendar for residential lawn and hedge clients in [region, NZ/AU], month by month. Mark anything that depends on local climate as 'check locally'.

Step 6: Test it on yourself first

Add yourself as a customer with a due date next week and check the message arrives looking right.

Checklist

  • ☐ Due list built with next-due dates
  • ☐ Three messages written and checked
  • ☐ One automation working before adding more
  • ☐ Tested on yourself
  • ☐ Customers can easily opt out

Common mistakes to avoid

  • Building five automations at once
  • Messaging people who asked not to be contacted
  • Forgetting to update 'Last done' after the job

Next steps

Rather not fiddle with it?

Take the free 2-minute quiz for a short list of tools, or ask a local helper to set it all up for you.

We may earn a referral fee if you use a setup helper we introduce you to. How we're funded.

Prefer to email? [email protected]