ServiceM8 and Google Calendar Job Automation

Staff were copying customer details, addresses, phone numbers, job notes, appointment times and assigned staff from calendar bookings into ServiceM8 by hand. The automation had to cover several service categories, new bookings and changes to existing ones:

• Move bookings from four Google Calendars into ServiceM8
• Extract customer details, property addresses, instructions and appointment times from each event
• Create customer or company records, work orders and job contacts when needed
• Find existing jobs and update them when a booking changes
• Match staff names in events to ServiceM8 staff records
• Support timed appointments and date-only entries
• Handle missing or alternative phone numbers
• Add the ServiceM8 job number to the calendar event title
• Reuse existing customer records, especially for yard work bookings