Send a Gmail message when you press the Button widget
About this Applet
Track your vehicle trips automatically and keep detailed records. This Applet runs whenever a Bouncie-connected vehicle completes a trip, saving the trip data to a Microsoft 365 Excel worksheet and sending an email summary via Gmail. Perfect for anyone managing vehicle fleets or keeping personal travel logs. Customize the message to fit your tone.
If
Trigger ingredients
CreatedAt
StartOfTrip
EndOfTrip
FuelConsumed
TripDistance
MaxSpeed
TripTime
IdleTime
VehicleName
HardBrakingCounts
HardAccelerationCounts
AverageDriveSpeed
TripTimeMinutes
IdleTimeMinutes
StartOfTripLocation
EndOfTripLocation
Then
Action fields
path
filename
formatted_row
worksheet_name
And
Action fields
to
cc
bcc
subject
body
attachment_url
Services used in this Applet
You might also like...
-
33.6k
-
-
Email yourself when your phone is plugged in
11.1k
-
-
Notify your neighbour when your mower needs attention
7.37k
-
Related services
-
-
App store rating
Create your own workflow
Create custom workflows effortlessly by selecting triggers, queries, and actions. With IFTTT, it's simple: “If this” trigger happens, “then that” action follows. Streamline tasks and save time with automated workflows that work for you.
52 triggers, queries, and actions
Bouncie was reconnected
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when the Bouncie adapter is plugged back into the vehicle.
Cell updated in workbook
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a particular cell is updated within the workbook you specify.
Geo-Circle was entered
Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
This trigger fires when a vehicle enters one of its geo-circles.
Geo-Circle was exited
Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
This trigger fires when a vehicle exits one of its geo-circles
Insurance expiration reminder
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a vehicle's insurance is expiring.
New attachment
Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
This trigger fires every time a new email with an attachment arrives in your inbox.
New conversation
Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
This trigger fires when a conversation starts in your Gmail inbox: a message gets its first reply and a back-and-forth begins. It fires once per conversation, not on every reply.
New email
Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
This trigger fires every time a new email arrives in your Gmail inbox.
New email matching search
Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
This trigger fires every time an email newly matches your Gmail search, whether it just arrived or just changed to match.
New label
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires once every time a new label is created in your Gmail account. New labels are typically detected within an hour.
New row added to workbook
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new row is added to a workbook you specify.
New sent email
Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
This trigger fires every time you send an email from your Gmail account, typically within a few minutes of the send. This includes emails your Applets send.
Current value of a cell
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the current value of a single cell in your workbook.
Find email
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the most recent emails matching your Gmail search, newest first.
Get attachment by filename
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns an attachment from a specific Gmail message, located by its filename, as links to a temporary copy of the file that IFTTT hosts and removes automatically, along with the attachment's details.
Get conversation
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the messages in a Gmail conversation, looked up by its thread id: one result per message, oldest first, each carrying the message's full content alongside the conversation's participants and message count.
History of Bouncie reconnections
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when the Bouncie adapter was plugged back into the vehicle.
History of trips completed
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a new trip was completed.
History of vehicle brakes hard frequently
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a vehicle brakes hard frequently.
History of vehicle drove a long distance
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a vehicle drives a long distance.
History of Vehicle idles
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a vehicle was idle for a long time during a trip.
History of vehicle renewals
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a vehicle renewal occurred.
History of vehicle's check engine light ons
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when the vehicles check engine come on.
History of when vehicle drove at unusual times
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a vehicle drove outside the time range specified. Time range can be configured on drives alert page in the Bouncie App.
Add label to email
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will add the label you choose to a specific email message in your Gmail account.
Add row to workbook
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will add a single row to the bottom of the worksheet you specify in the workbook.
Archive email
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will archive a specific email message, removing it from your inbox without deleting it. The message remains in All Mail and stays searchable.
Create a draft
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will save a new email as a draft in your Gmail account without sending it. The draft waits in your Drafts folder until you open Gmail and send it yourself.
Create a draft reply
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will save a draft reply to a specific email in your Gmail account, kept in the original conversation. The draft waits in your Drafts folder until you send it yourself.
Create label
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will create a new label in your Gmail account.
Delete email
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will move a specific email message to Trash in your Gmail account. Messages in Trash can be recovered until Gmail permanently removes them.
Forward email
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will forward an email from your Gmail account, attachments included, to the recipient you specify.
Remove label from conversation
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will remove a label from a Gmail conversation, removing it from every message in the conversation at the time the action runs. Messages added to the conversation later are not affected.
Remove label from email
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will remove the label you choose from a specific email message in your Gmail account. The message keeps its other labels and stays in your mailbox.
Reply to email
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will send a reply to a specific email in your Gmail account, kept in the original conversation. The reply goes to whoever sent the original message.
Send an email
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will send an email to up to twenty recipients from your Gmail account.
Add label to email
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will add the label you choose to a specific email message in your Gmail account.
Add row to workbook
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will add a single row to the bottom of the worksheet you specify in the workbook.
Archive email
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will archive a specific email message, removing it from your inbox without deleting it. The message remains in All Mail and stays searchable.
Bouncie was reconnected
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when the Bouncie adapter is plugged back into the vehicle.
Cell updated in workbook
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a particular cell is updated within the workbook you specify.
Create a draft
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will save a new email as a draft in your Gmail account without sending it. The draft waits in your Drafts folder until you open Gmail and send it yourself.
Create a draft reply
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will save a draft reply to a specific email in your Gmail account, kept in the original conversation. The draft waits in your Drafts folder until you send it yourself.
Create label
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will create a new label in your Gmail account.
Current value of a cell
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the current value of a single cell in your workbook.
Delete email
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will move a specific email message to Trash in your Gmail account. Messages in Trash can be recovered until Gmail permanently removes them.
Find email
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the most recent emails matching your Gmail search, newest first.
Forward email
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will forward an email from your Gmail account, attachments included, to the recipient you specify.
Build an automation in seconds!
If
Select a trigger the automation will use
Bouncie was reconnected
Cell updated in workbook
Geo-Circle was entered
Geo-Circle was exited
Insurance expiration reminder
New attachment
New conversation
New email
New email matching search
New label
New row added to workbook
New sent email
New starred email
Trip was completed
Vehicle care event
Vehicle drove a long distance
Vehicle drove at unusual time
Vehicle had frequent hard brakes
Vehicle had frequent rapid accelerations
Vehicle had unusual fuel economy
Vehicle has low fuel
Vehicle renewal
Vehicle was idle for a long time
Vehicle was over maximum speed
Vehicle's battery is low or critical
Vehicle's check engine light comes on
Then
Select an action the automation will perform
Add label to email
Add row to workbook
Archive email
Create a draft
Create a draft reply
Create label
Delete email
Forward email
Remove label from conversation
Remove label from email
Reply to email
Send an email
Send yourself an email
Update cell in workbook
You can add delays, queries, and more actions in the chat.
More on these services
About Gmail
Gmail and IFTTT connect your inbox to 1000+ other apps and devices to automate routine email management tasks. Keep your inbox organized, ensure timely follow-up with custom reminders, keep teams informed for urgent messages, or even change your lights if a specific email comes in. Spend less time managing your email with easy-to-use automations.
The use of information received from Google Workspace scopes will adhere to the Google User Data Policy, including the Limited Use requirements.
About Bouncie
Revolutionize your car ownership experience by staying connected with Bouncie.
About Microsoft 365 Excel
Microsoft 365 Excel is a powerful spreadsheet program used for organizing, analyzing, and visualizing data. Leverage its capabilities to manage finances, track projects, and perform complex calculations with ease. Connect Microsoft 365 Excel to IFTTT to automate data entry, generate reports, and trigger actions based on spreadsheet changes. Optimize your data workflows and enhance productivity across your personal and professional tasks.