Fleet Arrival Log
Start today
Popular Google Sheets and Zubie workflows and automations
Useful Google Sheets and Zubie integrations
Triggers (If this)
- Vehicle arrives at a placeThis trigger fires every time a vehicle arrives at a specific place such as Home or Work (defined within Zubie).
- New spreadsheet added to folderThis trigger fires when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.
- Vehicle leaves a placeThis Trigger fires every time a vehicle leaves a place.
- New worksheet in spreadsheetThis trigger fires when a new worksheet is added to a spreadsheet you specify.
- Trip startedThis Trigger fires every time a vehicle starts a trip, indicated by the ignition being turned on.
- New row added to spreadsheetThis trigger fires when a new row is added to a spreadsheet you specify.
- Trip endedThis Trigger fires at the end of every vehicle trip, as indicated by the Ignition being turned off.
- Cell updated in spreadsheetThis trigger fires when a particular cell is updated within the spreadsheet you specify.
- Check engine light is on for any vehicleThis Trigger fires when ANY vehicle's Check Engine light has been activated, caused by a Diagnostic Trouble Code (DTC).
- Low battery condition for any vehicleThis Trigger fires when battery levels fall below normal levels for any vehicle in your account. The vehicle ingredient specifies the name of the vehicle with the problem.
- Vehicle driven between hoursThis Trigger fires when a vehicle trip ends during a selected time frame.
- Vehicle out of rangeThis Triggers when your vehicle is further than an allowed distance from a specific location.
- Long-distance tripThis Trigger fires when a trip is completed that is longer than a specified distance.
- Hard braking detectedTriggers when a vehicle detects a hard brake event.
- Hard acceleration detectedTriggers when your vehicle has a hard-acceleration event.
- High speed driving detectedTriggers when your vehicle is driven at speeds above a safe level (configured within Zubie).
Queries (With)
- History of trip endsThis query returns a list of the end of every vehicle trip, as indicated by the Ignition being turned off.
- Current values of a rowThis query returns the current values in a given row. Values from columns A-Z are available as ingredients.
- History of when hard acceleration was detectedThis query returns a list of when your vehicle was a hard-acceleration event.
- Current value of a cellThis query returns the current value of a single cell in your spreadsheet.
- History of vehicle driven between hoursThis query returns a list of when a vehicle trip ends during a selected time frame.
- History of rows added to spreadsheetThis query returns a list of when a new row is added to a spreadsheet you specify.
- History of when Check engine light was on for any vehicleThis query returns a list of when ANY vehicle's Check Engine light was been activated, caused by a Diagnostic Trouble Code (DTC).
- History of when Cell was updated in spreadsheetThis query returns a list of when a particular cell was updated within the spreadsheet you specify.
- History of vehicle out of rangeThis query returns a list of when your vehicle was further than an allowed distance from a specified location.
- History of spreadsheets added to folderThis query returns a list of when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.
- History of instances a vehicle left a placeThis query returns a list of instances when a vehicle left a place.
- History of worksheets in spreadsheetThis query returns a list of when a new worksheet is added to a spreadsheet you specify.
- History of vehicle arriving at a placeThis query returns a list of when a vehicle arrived at a specific place such as Home or Work (defined within Zubie).
Actions (Then that)
- Add row to spreadsheetThis action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
- Update cell in spreadsheetThis action will update a single cell in the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created if the file doesn't exist.
IFTTT helps all your apps and devices work better together