Track new trips in your car with Zubie in a Google Spreadsheet
Connect popular automations
Quickly and easily enable Applets using Google Sheets and Zubie.-
119
-
-
Record trip activity in a Google spreadsheet
38
-
-
zubie tracker
16
-
-
Log My Trips to a Spreadsheet
8
-
-
Fleet Arrival Log
5
-
-
Logging with start map url and end map url
4
-
-
Custom Trip Log for Oak Tree MGMT
1
-
Build your own Google Sheets and Zubie automations
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)
-
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.
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.
How to connect Google Sheets and Zubie
Find or create an Applet
Start by discovering an automation to connect or customizing your own. It's quick and easy.Connect IFTTT to your accounts
Securely connect your Google Sheets and Zubie accounts.Finalize and customize your Applet
Review your trigger and action settings. Your Applet is ready to go!Upgrade your automations with
-
Connect to more Applets
Connect up to 20 automations with Pro, and unlimited automations with Pro+ -
Add multiple actions with exclusive services
Add real-time data and multiple actions for smarter automations -
Get access to faster speeds
Get faster updates and more actions with higher rate limits and quicker checks
More on Discord and Instagram
About Google Sheets
Google Sheets lets you create and edit spreadsheets stored on your Google Drive. Turn on Applets to monitor specific cells in your spreadsheets as well create news docs, rows, and cell updates.
About Zubie
Zubie is a connected car service that makes driving safer, easier and less expensive. It tracks your trips, alerts you to engine and battery problems, unsafe driving events, arrivals and departures, and more.