Gmail + MotionTools + Formatter by Zapier + Looping by Zapier

Import 2-stop MotionTools bookings from new CSV files received as email attachments in Gmail

If you can export your data to CSV but don't know how to create 2-stop MotionTools bookings from it, then this Zapier automation is the easiest way to do so! This integration creates 2-stop MotionTools bookings for each row in new CSV files received via email on a designated Gmail address. You also don't have to worry about the format of your CSV files—the automation takes care of mapping from your proprietary format to the format MotionTools expects.

When this happens...
New Email
Triggers when a new e-mail appears in the specified mailbox.
TriggerScheduled
automatically do this...
Utilities
Various utilities like "choose value from list" or "look up in table" (with line-item support).
ActionWrite
then do this...
Create Loop From Line Items
Creates a new Loop from line item(s). This is an advanced action!
ActionWrite
then do this!
Create 2-Stop Booking
Creates a booking that has just 2 stops.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

What does this mean?

- Label/Mailbox
- Search String
Trigger
Scheduled
Try It
- Label/MailboxRequired
Trigger
Scheduled
Try It
- Search StringRequired
Trigger
Scheduled
Try It
- Label/Mailbox
Trigger
Scheduled
Try It
- SubjectRequired
- To
- Cc
- Bcc
- From
- From Name
- Body Type
- BodyRequired
- Signature
- Label/Mailbox
- Attachments
Action
Write

- NameRequired
Action
Write
- Message to Remove Label(s) FromRequired
- Label(s) to RemoveRequired
Action
Write

- Search StringRequired
Action
Search
- TransformRequired
Action
Write
- TransformRequired
Action
Write
- Help Warning
- Values to LoopRequired
- Trim Whitespace
- Loop iteration counter start
- Maximum number of Loop iterations
Action
Write
- Help Warning
- Values to LoopRequired
- Text Delimiter
- Trim Whitespace
- Loop iteration counter start
- Maximum number of Loop iterations
Action
Write
Booking Status Update
Triggers when the status of an existing booking updates. Only available if you have a MotionToolsadmin account
Trigger
Instant
Try It
Package Created
Triggers when a package gets created. Only available if you have a MotionToolsadmin account
Trigger
Instant
Try It
- Scheduled at
- Payment methodRequired
- Additional information
- Metadata
- Stop type
- Metadata
- Coordinates (optional)
- Street
- Street number
- City
- Country
- Postal code
- Address additional line
- Location name
- Stop contact first name
- Stop contact last name
- Stop contact phone nr
- Stop contact email
Action
Write

New Label
Triggers when you add a new label.
Trigger
Scheduled
Try It
- Label/Mailbox
Trigger
Scheduled
Try It
New Starred Email
Triggers when you receive a new email and star it within two days.
Trigger
Scheduled
Try It
- Label(s) to Add
- Message to be LabeledRequired
Action
Write
- Trigger Instructions
- ThreadRequired
- To
- Cc
- Bcc
- From
- From Name
- Body Type
- BodyRequired
- Signature
- Label/Mailbox
- Attachments
Action
Write
- To
- Cc
- Bcc
- From
- From Name
- Reply To
- SubjectRequired
- Body Type
- BodyRequired
- Signature
- Label/Mailbox
- Attachments
Action
Write
- Trigger Instructions
- ThreadRequired
- To
- Cc
- Bcc
- From
- From Name
- Reply To
- Body Type
- BodyRequired
- Label/Mailbox
- Attachments
Action
Write
- Search StringRequired
- To
- Cc
- Bcc
- From
- From Name
- Reply To
- SubjectRequired
- Body Type
- BodyRequired
- Signature
- Label/Mailbox
- Attachments
Action
Search or write
- TransformRequired
Action
Write
- TransformRequired
Action
Write
- Help Warning
- Loop iteration counter start
- Loop iteration counter end
- Loop iteration counter increment amount
- Maximum number of Loop iterations
Action
Write
Booking Created
Triggers when a booking gets created. Only available if you have a MotionToolsadmin account
Trigger
Instant
Try It
Booking Stop Status Update
Triggers when the status of the stop of an existing booking updates. Only available if you have a MotionToolsadmin account
Trigger
Instant
Try It
Package Status Update
Triggers when the status of an existing package updates. Only available if you have a MotionToolsadmin account
Trigger
Instant
Try It
- Scheduled at
- Payment methodRequired
- Additional information
- Metadata
- Stop type
- Metadata
- Coordinates (optional)
- Street
- Street number
- City
- Country
- Postal code
- Address additional line
- Location name
- Stop contact first name
- Stop contact last name
- Stop contact phone nr
- Stop contact email
- Stop type
- Metadata
- Coordinates (optional)
- Street
- Street number
- City
- Country
- Postal code
- Address additional line
- Location name
- Stop contact first name
- Stop contact last name
- Stop contact phone nr
- Stop contact email
Action
Write

About Gmail

One of the most popular email services, Gmail keeps track of all your emails with threaded conversations, tags, and Google-powered search to find any message you need.

Learn more Help

Related categories

Similar apps

IMAP by Zapier

Email, Zapier

SMTP by Zapier

Email, Zapier

Microsoft Office 365

Email, Microsoft

About MotionTools

Manage your workforce & deliveries with MotionTools.

Help

Related categories

Dashboards

About Formatter by Zapier

Data isn't always in the format you need. Perhaps a date is in International format, but your app needs it in American format. Or maybe you need to Title Case a subject, truncate text for a Tweet, or turn Markdown text into HTML for your blog. Zapier's Formatter tool can help.

Help

Related categories

About Looping by Zapier

Looping by Zapier is a helper app to repeat Action(s) in you Zaps a variable number of times for sets of values.

Learn more Help

PRODUCTS

CAPABILITIES

By team

Gmail + MotionTools + Formatter by Zapier + Looping by Zapier

Import 2-stop MotionTools bookings from new CSV files received as email attachments in Gmail

New Attachment

Label/Mailbox

Search String

New Labeled Email

New Email Matching Search

Search StringRequired

New Thread

Label/Mailbox

Create Draft

SubjectRequired

To

Cc

Bcc

From

From Name

Body Type

BodyRequired

Signature

Label/Mailbox

Attachments

Create Label

NameRequired

Remove Label from Email

Message to Remove Label(s) FromRequired

Label(s) to RemoveRequired

Find Email

Search StringRequired

Date / Time

TransformRequired

Text

TransformRequired

Create Loop From Line Items

Help Warning

Values to LoopRequired

Trim Whitespace

Loop iteration counter start

Maximum number of Loop iterations

Create Loop From Text

Help Warning

Values to LoopRequired

Text Delimiter

Trim Whitespace

Loop iteration counter start

Maximum number of Loop iterations

Booking Status Update

Package Created

Create 1-Stop Booking

Scheduled at

Payment methodRequired

Additional information

Metadata

Stop type

Metadata

Coordinates (optional)

Street

Street number

City

Country

Postal code

Address additional line

Location name

Stop contact first name

Stop contact last name

Stop contact phone nr

Stop contact email

New Label

New Email

Label/Mailbox

New Starred Email

Add Label to Email

Label(s) to Add

Message to be LabeledRequired

Create Draft Reply

Trigger Instructions

ThreadRequired