Gmail + MotionTools + Formatter by Zapier + Looping by Zapier

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

If you can export your orders or shipments as CSV files, but don't know how to turn them into MotionTools bookings, this automation is the easiest way to do so! This automation creates 1-stop MotionTools bookings for each row in new CSV files that you send to a designated Gmail address. You don't even have to worry about the format of your CSV files; the automation takes care of mapping the columns in the CSV files to the format required by MotionTools.

When this happens...
New EmailTriggers when a new email appears in the specified mailbox.
TriggerPolling
automatically do this...
UtilitiesVarious utilities like "choose value from list" or "look up in table" (with line-item support).
ActionWrite
then do this...
Create Loop From Line ItemsCreates a new Loop from line item(s). This is an advanced action!
ActionWrite
then do this!
Create 1-Stop BookingCreates a booking that has just 1 stop.
ActionWrite

Start free with email

Start free with Google

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

More things you can do with these apps

Discover other triggers and actions you can use with Gmail, Formatter by Zapier, and more

- Label or mailbox
- Search keywords
Trigger
Polling
Try It
- Label or mailbox
  Required
Trigger
Polling
Try It
- Label or mailbox
Trigger
Polling
Try It
New Starred Email
Triggers when you receive a new email and star it within two days.
Trigger
Polling
Try It
- Label
  Required
- Message
  Required
Action
Write

- Message
  Required
Action
Write
- Trigger_instructions
- Thread
  Required
- To
- Cc
- Bcc
- From
- From_name
- Body type
- Body
  Required
- Add signature default
- Signature delimiter
- Label or mailbox
- Attachments
Action
Write

- To
- Cc
- Bcc
- From
- From_name
- Reply_to
- Subject
  Required
- Body type
- Body
  Required
- Add signature default
- Signature delimiter
- Label or mailbox
- Attachments
- Send message to Google Contacts Group/Label
Action
Write
- Thread
  Required
- Label(s) to remove
  Required
Action
Write
- Message ID
  Required
- Attachment Filename
  Required
- Attachment Size
Action
Search
- Search String
  Required
- To
- Cc
- Bcc
- From
- From_name
- Reply_to
- Subject
  Required
- Body type
- Body
  Required
- Add signature default
- Signature delimiter
- Label or mailbox
- Attachments
- Send message to Google Contacts Group/Label
Action
Search or write
- Transform
  Required
Action
Write
- Transform
  Required
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 method
  Required
- 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

New Label
Triggers when you add a new label.
Trigger
Polling
Try It
- Label or mailbox
  Required
Trigger
Polling
Try It
- Search keywords
  Required
Trigger
Polling
Try It
- Label/Mailbox
Trigger
Polling
Try It
- Message
  Required
Action
Write
- To
- Cc
- Bcc
- Subject
  Required
- From
- From_name
- Body type
- Body
  Required
- Add signature default
- Signature delimiter
- Label or mailbox
- Attachments
- Recipient_instructions
Action
Write
- Name of label
  Required
Action
Write
- Message
  Required
- Label(s) to remove
  Required
Action
Write
- Trigger_instructions
- Thread
  Required
- To
- Cc
- Bcc
- From
- From_name
- Reply_to
- Subject
- Body type
- Body
  Required
- Add signature default
- Signature delimiter
- Label or mailbox
- Attachments
Action
Write
- Search String
  Required
Action
Search
- Transform
  Required
Action
Write
- Transform
  Required
Action
Write
- Help Warning
- Values to Loop
  Required
- Trim Whitespace
- Loop iteration counter start
- Maximum number of Loop iterations
Action
Write
- Help Warning
- Values to Loop
  Required
- 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 method
  Required
- 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

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 moreLearn moreHelpHelp

Related categories

Google

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.

HelpHelp

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.

Learn moreLearn moreHelpHelp

Related categories

Documents

Zapier

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 moreLearn moreHelpHelp

Related categories

Developer Tools

Zapier

Related Zap Templates

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

Send Gmail emails when new MotionTools packages are out for delivery