Google Sheets + ServiceM8

Create multiple spreadsheet rows in Google Sheets when jobs are completed in ServiceM8

With this workflow, once a job is finished in your ServiceM8 app, new rows are created in your designated Google Sheets document, keeping record-keeping simple and accurate. This streamlines your post-job process, making it easy to track completion details and freeing up time for more hands-on tasks. Efficiently manage your ServiceM8 work records with the added benefit of organized data in Google Sheets.

With this workflow, once a job is finished in your ServiceM8 app, new rows are created in your designated Google Sheets document, keeping record-keeping simple and accurate. This streamlines your post-job process, making it easy to track completion details and freeing up time for more hands-on tasks. Efficiently manage your ServiceM8 work records with the added benefit of organized data in Google Sheets.

  1. When this happens...
    ServiceM8ServiceM8
    Job Completed

    Triggers when a Job's status changes to Completed.

    TriggerInstant
  2. automatically do this!
    Google SheetsGoogle Sheets
    Create Multiple Spreadsheet Rows

    Create one or more new rows in a specific spreadsheet (with line item support).

    ActionWrite
Start free with email
Start free with email
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

What does this mean?
    • Job Category

    Trigger
    Instant
    Try It
  • ServiceM8 triggers, actions, and search

    New Client

    Triggers when a new Client is created.

    Trigger
    Instant
    Try It
    • Job Category

    Trigger
    Instant
    Try It
    • Customer Name

    • Job StatusRequired

    • Job Address

    • Billing Address

    • Job Description

    • Purchase Order Number

    • Work Completed

    • Job Contact First Name

    • Job Contact Last Name

    • Job Contact Phone

    • Job Contact Mobile

    • Job Contact E-Mail Address

    • Billing Contact First Name

    • Billing Contact Last Name

    • Billing Contact Phone

    • Billing Contact Mobile

    • Billing Contact E-Mail

    Action
    Write
    • QueueRequired

    • Job Category

    Trigger
    Instant
    Try It
    • Completed By

    • Form TypeRequired

    Trigger
    Instant
    Try It
    • NameRequired

    • Address

    • Billing Address

    • Fax Number

    • Website

    • First Name

    • Last Name

    • Phone Number

    • Mobile Number

    • E-Mail Address

    Action
    Write
    • Drive

    • SpreadsheetRequired

    • WorksheetRequired

    Trigger
    Scheduled
    Try It
google-sheets logo
google-sheets logo

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Learn moreHelp

Related categories

  • Google
  • Spreadsheets

Similar apps

Zapier Tables integrationsZapier Tables integrations

Zapier Tables

Databases, Spreadsheets, Zapier
Zoho Creator integrationsZoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrationsSmartsheet integrations

Smartsheet

Spreadsheets
servicem8 logo
servicem8 logo

About ServiceM8

ServiceM8 is a field service app and small business management platform for your computer, iPhone and iPad. Track staff locations, navigate to jobs, and control your estimates, invoicing, scheduling, safety reports, clients & more.
Learn moreHelp

Related categories

  • CRM (Customer Relationship Management)

Similar apps

iFormBuilder integrationsiFormBuilder integrations

iFormBuilder

Forms & Surveys
TrackVia integrationsTrackVia integrations

TrackVia

Databases
Device Magic integrationsDevice Magic integrations

Device Magic

Forms & Surveys