Fleet Arrival Log
Start today
Triggers (If this)
Queries (With)
Actions (Then that)
Popular Google Sheets and Zubie workflows and automations
Useful Google Sheets and Zubie integrations
Triggers (If this)
-
Vehicle arrives at a place
This trigger fires every time a vehicle arrives at a specific place such as Home or Work (defined within Zubie).
-
New spreadsheet added to folder
This 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 place
This Trigger fires every time a vehicle leaves a place.
-
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
-
Trip started
This Trigger fires every time a vehicle starts a trip, indicated by the ignition being turned on.
-
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
-
Trip ended
This Trigger fires at the end of every vehicle trip, as indicated by the Ignition being turned off.
-
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
-
Check engine light is on for any vehicle
This Trigger fires when ANY vehicle's Check Engine light has been activated, caused by a Diagnostic Trouble Code (DTC).
-
Low battery condition for any vehicle
This 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 hours
This Trigger fires when a vehicle trip ends during a selected time frame.
-
Vehicle out of range
This Triggers when your vehicle is further than an allowed distance from a specific location.
-
Long-distance trip
This Trigger fires when a trip is completed that is longer than a specified distance.
-
Hard braking detected
Triggers when a vehicle detects a hard brake event.
-
Hard acceleration detected
Triggers when your vehicle has a hard-acceleration event.
-
High speed driving detected
Triggers when your vehicle is driven at speeds above a safe level (configured within Zubie).
Vehicle arrives at a place
This trigger fires every time a vehicle arrives at a specific place such as Home or Work (defined within Zubie).
New spreadsheet added to folder
This 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 place
This Trigger fires every time a vehicle leaves a place.
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
Trip started
This Trigger fires every time a vehicle starts a trip, indicated by the ignition being turned on.
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
Trip ended
This Trigger fires at the end of every vehicle trip, as indicated by the Ignition being turned off.
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
Check engine light is on for any vehicle
This Trigger fires when ANY vehicle's Check Engine light has been activated, caused by a Diagnostic Trouble Code (DTC).
Low battery condition for any vehicle
This 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 hours
This Trigger fires when a vehicle trip ends during a selected time frame.
Vehicle out of range
This Triggers when your vehicle is further than an allowed distance from a specific location.
Long-distance trip
This Trigger fires when a trip is completed that is longer than a specified distance.
Hard braking detected
Triggers when a vehicle detects a hard brake event.
Hard acceleration detected
Triggers when your vehicle has a hard-acceleration event.
High speed driving detected
Triggers when your vehicle is driven at speeds above a safe level (configured within Zubie).
Queries (With)
-
History of trip ends
This query returns a list of the end of every vehicle trip, as indicated by the Ignition being turned off.
-
Current values of a row
This query returns the current values in a given row. Values from columns A-Z are available as ingredients.
-
History of when hard acceleration was detected
This query returns a list of when your vehicle was a hard-acceleration event.
-
Current value of a cell
This query returns the current value of a single cell in your spreadsheet.
-
History of vehicle driven between hours
This query returns a list of when a vehicle trip ends during a selected time frame.
-
History of rows added to spreadsheet
This 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 vehicle
This 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 spreadsheet
This query returns a list of when a particular cell was updated within the spreadsheet you specify.
-
History of vehicle out of range
This query returns a list of when your vehicle was further than an allowed distance from a specified location.
-
History of spreadsheets added to folder
This 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 place
This query returns a list of instances when a vehicle left a place.
-
History of worksheets in spreadsheet
This query returns a list of when a new worksheet is added to a spreadsheet you specify.
-
History of vehicle arriving at a place
This query returns a list of when a vehicle arrived at a specific place such as Home or Work (defined within Zubie).
History of trip ends
This query returns a list of the end of every vehicle trip, as indicated by the Ignition being turned off.
Current values of a row
This query returns the current values in a given row. Values from columns A-Z are available as ingredients.
History of when hard acceleration was detected
This query returns a list of when your vehicle was a hard-acceleration event.
Current value of a cell
This query returns the current value of a single cell in your spreadsheet.
History of vehicle driven between hours
This query returns a list of when a vehicle trip ends during a selected time frame.
History of rows added to spreadsheet
This 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 vehicle
This 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 spreadsheet
This query returns a list of when a particular cell was updated within the spreadsheet you specify.
History of vehicle out of range
This query returns a list of when your vehicle was further than an allowed distance from a specified location.
History of spreadsheets added to folder
This 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 place
This query returns a list of instances when a vehicle left a place.
History of worksheets in spreadsheet
This query returns a list of when a new worksheet is added to a spreadsheet you specify.
History of vehicle arriving at a place
This 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 spreadsheet
This 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 spreadsheet
This 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.
Add row to spreadsheet
This 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 spreadsheet
This 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