Loading

Google Sheets + ServiceM8

Add new spreadsheet rows to Google Sheets when forms are completed in ServiceM8

Use this handy automation to record all responses to a ServiceM8 Form (e.g. Contract Variations, Incident Reports, or Safety Assessments) in a spreadsheet. Having access to your form responses in a spreadsheet allows you to analyze trends, generate statistics, and take control of your business: Set up this automation, and we'll copy every new ServiceM8 form entry into Google Sheets as a new row.

Use this handy automation to record all responses to a ServiceM8 Form (e.g. Contract Variations, Incident Reports, or Safety Assessments) in a spreadsheet. Having access to your form responses in a spreadsheet allows you to analyze trends, generate statistics, and take control of your business: Set up this automation, and we'll copy every new ServiceM8 form entry into Google Sheets as a new row.

  1. When this happens...
    ServiceM8ServiceM8
    New Form Response

    Triggers when a Form is completed. Requires the Forms add-on to be enabled in your ServiceM8 account.

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

    Create a new row in a specific spreadsheet.

    ActionWrite
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
    • 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.

Related categories

Similar apps

iFormBuilder integrationsiFormBuilder integrations

iFormBuilder

Forms & Surveys
TrackVia integrationsTrackVia integrations

TrackVia

Databases
Device Magic integrationsDevice Magic integrations

Device Magic

Forms & Surveys