antsrouteantsrouteantsrouteantsroute
  • Solutions
      • DELIVERIES

          • parcel-delivery-antsroute-softwareParcel Delivery
            Make last mile deliveries management easier and enhance customer relations.

          • meal-delivery-antsroute-softwareFood and Fresh Produce Delivery
            Smartly manage meal, fresh and frozen produce deliveries.

          • merchandise-delivery-antsroute-softwareMerchandise Pick-up and Delivery
            Build optimized merchandise delivery routes and track your drivers in real-time.

          • fuel-delivery-antsroute-softwareFuel and Gas Delivery
            Build the best fuel and gas delivery routes increasing cubic meters delivered per km.

      • OPERATIONS

          • equipment-delivery-antsroute-softwareEquipment Installation
            Ensure the most efficient equipment installations and boost the productivity.

          • maintenance-antsroute-softwareRepair and Maintenance
            Track your field technicians and improve the quality of service provided.

          • cleaning-service-antsroute-softwareCleaning Service
            Build the most efficient cleaning services routes and boost the productivity of cleaners.

          • healthcare-antsroute-softwareHome Healthcare
            Create the best daily schedules for your healthcare workers to ensure quality home care.

    • Working in other industries? Contact us ➝
  • Features
      • FEATURES

          • smart-scheduling-antsroute-softwareSchedule appointments
            Efficient scheduling of deliveries and operations integrating logistics constraints.

          • live-tracking-antsroute-softwareTrack drivers
            Real-time updates sent to drivers and field workers via the mobile application.

          • analyse-route-data-antsroute-softwareAnalyze performance
            Data of routes and performance indicators analysis.
          • determine-route-antsroute-softwareOptimize routes
            Automated routes optimization cutting down travel time and costs.

          • update-customer-delivery-antsroute-softwareUpdate Customers
            Sending of SMS and email push notifications to customers.

          • digitize-route-antsroute-softwareDigitize processes
            Generate work and delivery orders and service reports.

      • PROCESS

          • Scheduling of deliveries and operations on date defined
            Import or schedule appointments on defined date.

          • Scheduling of deliveries and operations on incoming calls
            Guide customers to the best date and time slot in a few seconds.

          • Scheduling of deliveries and operations with customer confirmation
            Receive confirmation from customers or let them reschedule orders.
  • Resources
      • LEARN

        • Support
          Learn to use the software with our online guides and videos.

        • Integrations
          Connect AntsRoute with your favorite apps to boost productivity.

        • API
          The API allows you to synchronize your data with AntsRoute.

        • Customer testimonials
          Find out why companies have chosen the AntsRoute software to grow.

      • ABOUT

        • Blog
          All the solutions, tips and news about the AntsRoute software.

        • Contact us
          AntsRoute team is here to help with any questions.


    • Book a demo ➝
  • Pricing
  • Log in
  • Free trial
  • English
    • Français
    • Español
    • Deutsch
    •       

    • Enterprise

      • Privacy Policy
      • Terms of service
    • Product

      • Appointment scheduling
      • Route optimization
      • Field workers tracking
      • Push notifications
      • Service reports
      • Route reporting
      • Online booking site New

      • Pricing
    • Integrations
      • WooCommerce

      • Prestashop

      • Zapier New

      • Google Calendar

    • Solutions

      • Parcel delivery
      • Fresh produce delivery
      • Merchandise delivery
      • Fuel and gas delivery
      • Equipment installation
      • Repair and maintenance
      • Cleaning service
      • Home healthcare
    • Definitions

      • Route optimisation
      • Route optimisation software
      • Route optimization benefits
      • Route planner
      • Transport software
      • Field service management
    • Resources

      • Blog
      • Testimonials
      • Help center
      • API Rest
      • Contact us

> Automate pickup & delivery order creation when adding new row in Google Sheets using Zapier

1 February 2021
Categories
AntsRoute plugin, Pickup and delivery, Zapier
Tags

Support > AntsRoute Plugin > Automate the creation of pickup & delivery orders when adding new row in Google Sheets using Zapier

  Automate the creation of new pickup & delivery order when adding new row in Google Sheets using Zapier

Using Zapier, you can automate the creation of new pickup & delivery orders in AntsRoute when adding new rows in a Google Sheets file. Just follow the steps below:

Note: The connection with Zapier is now a Public Beta version.

Have not connected your AntsRoute account to Zapier yet? Read the article here.

Go to your Zapier account and click on the “Make a Zap” button.

Note : An example of Google spreadsheet (add pickup&delivery orders in planning) is available here. 💡

Note : An example of Google spreadsheet (add pickup&delivery orders in bucket) is available here. 💡

Step 1: Setup the “trigger” 

1
Search Google Sheets via the search bar.

2
In the “Trigger Event” drop-down list, select “New Spreadsheet Row“.
3
Click on the “Continue” button.

4
Click the “Sign in to Google Sheets” button to connect your Google Sheets account to Zapier.

5
From the “Choose an account” drop-down list, select the Google Sheets account you have just connected.
6
Click on the “Continue” button.

7
In the “Spreadsheet” drop-down list, select the desired Google Sheets file.

Note: Remember that your Google Sheets file must include some columns which are required to create pickup & delivery order in AntsRoute.

Here is the list of columns to include in your Google Sheets spreadsheet:

  • Schedule Date ;
  • Type ;
  • Last name ;
  • Name Of The Loading Location ;
  • Address Of The Loading Location ;
  • Duration of the loading ;
  • Time Slot (start) Of The Loading ;
  • Time Slot (end) Of The Loading ;
  • Name Of The Unloading Location ;
  • Address Of The Unloading Location ;
  • Duration of the Unloading ;
  • Time Slot (start) Of The Unloading ;
  • Time Slot (end) Of The Unloading ;
  • Capacity_Number ;
  • Capacity_Weight ;
  • Capacity_Volume.

Note: The “Schedule Date” column must be replaced by “Due date” (or equivalent) for those using the orders bucket. 

Here is an example for Loading-Delivery operation:

Here is an example for Collect-Unloading operation:

8
In the “Worksheet” drop-down list, select the desired worksheet.
9
Click on the “Continue” button.
10
Click on the “Test trigger” button.
11
Click on the “Continue” button.

Step 2: Setup the “action”

1
Search AntsRoute via the search bar.

2
In the “Action Event” drop-down list, select “Create an Order“.
3
Click on the “Continue” button.

Note: Are you using the bucket of orders in AntsRoute for your appointments which do not have a scheduled date? We invite you to select the “Create an Order in Basket” event.

Note: Have not connected your AntsRoute account to Zapier yet? Go to your AntsRoute account in order to retrieve the API key that you will be asked for on Zapier. To do this, just go to AntsRoute > click on the “API Key” tab > click on “Add” > Select the site > Click on “Create” > Click on “Copy” > Click on “Continue”. You can now go back to Zapier and click on “Sign in to AntsRoute” and enter the API key you just retrieved and click on “Yes, Continue“.

4
In the “Choose an account” drop-down list, select “AntsRoute”.
5
Click on the “Continue” button.

1st OPTION: Add a Loading-Delivery operation 

1
Select the type “DELIVERY“.

Note: By selecting the DELIVERY type, you add a delivery that will be preceded by a loading (associated with this delivery).

2
For “Scheduled date“, select the column “Scheduled date“» (or the column with the dates of operations).

Note: If you have selected “Create an Order in Basket“, you must select “Due-date” (or equivalent) instead of “Scheduled Date”. 

3
For “Duration“, select the column “Duration of the Unloading” (or the column with the duration of delivery).

4
For “Time Slot Start“, select the column “Time Slot (start) Of The Unloading” (or the column with the starting time slot of delivery).
5
For “Time Slot End“, select the column “Time Slot (End) Of The Unloading” (or the column with the end time slot of delivery).
6
For “Last name“, select the column “Last name” (or the column with the name of the customer to deliver).
7
For “Address“, select the column “Address Of The Unloading Location” (or the column with the address of the customer to deliver).

Information about the Loading

8
For “Name of The Loading Location“, select the column “Name of The Loading Location” (or the column with the name of the loading place).
9
For “Address of The Loading Location“, select the column “Address of The Loading Location” (or the column with the address of the loading place).
10
For “Loading Duration“, select the column “Duration of The Loading” (or the column with the duration of loading).
11
For “Time Slot (Start) of the Loading“, select the column “Time Slot (start) Of The Loading” (or the column with the start time slot of loading).
12
For “Time Slot (End) of the Loading“, select the column “Time Slot (End) Of The Loading” (or the column with the end time slot of loading).

Other information about the Delivery (or Unloading)

13
For “Name of The Unloading Location“, select the column “Name of The Unloading Location” (or the column with the name of unloading place).

Note: When adding AntsRoute orders from Google Sheets, it is not possible to fill in the extra fields about the customers.

14
Fill in the other fields if necessary (phone, mobile phone, email, comments about delivery, comments about the loading, etc.).

Note: IMPORTANT ! Don’t forget to add beforehand the three following capacities from your AntsRoute account (AntsRoute > Settings > Capacities > Add) :

  • Number (name = Number ; unit = unit and validation mode = optional) ;
  • Weight (name = Weight ; unit = kg and validation mode = optional) ;
  •  Volume (name = Volume ; unit = m3 and validation mode = optional).

Then you must add the these three columns in you Google Sheet file: “Capacity_Number” ; “Capacity_Weight” and “Capacity_Volume”. The cells of these three columns can’t remain blank. If you don’t want to display these capacities in AntsRoute, just enter the value “0” in the cells of these three columns. Finally, when creating your Zap, make sure these capacities are properly selected. (See screenshot below).

15
Click on the “Continue” button.
16
Click on the “Test & Continue” button.
17
Finally, click on the “Turn on Zap” button.

The creation of the Zap is now completed. From now, when you add a new line in your Google Sheets spreadsheet, the loading-delivery order will also be added in AntsRoute.

2nd OPTION: Add a Collect-Unloading operation

1
Select the type “COLLECT“.

Note: By selecting the COLLECT type, you add a collect that will be followed by an Unloading (associated with this collect).

2
For “Scheduled date“, select the column “Scheduled date” (or the column with the dates of collect).

Note: If you have selected “Create an Order in Basket“, you must select “Due-date” (or equivalent) instead of “Scheduled Date”. 

3
For “Duration“, select the column “Duration of the Loading” (or the column with the duration of collect).
4
For “Time Slot (Start)“, select the column “Time Slot (start) Of The Loading” (or the column with the start time slot of collect).
5
For “Time Slot (End)“, select the column “Time Slot (End) Of The Loading” (or the column with the end time slot of collect).

6
For “Last name“, select the column “Last name” (or the column with the name of customer to collect).
7
For “Address“, select the column “Address Of The Loading Location” (or the column with the address of customer to collect).

Other information about the Collect (or Loading)

8
For “Name of The Loading Location“, select the column “Name of The Loading Location” (or the column with the name of the collect location).

Information about the Unloading

9
For “Name of The Unloading Location“, select the column “Name of The Unloading Location” (or the column with the name of the unloading location).
10
For “Address of The Unloading Location“, select the column “Address of The Unloading Location” (or the column with address of the unloading location).
11
For “Unloading Duration“, select the column “Duration of The Unloading” (or the column with the duration of unloading).
12
For “Time Slot (Start) of the Unloading“, select the column “Time Slot (start) Of The Unloading” (or the column with the start time slot of unloading).
13
For “Time Slot (End) of the Unloading“, select the column “Time Slot (End) Of The Unloading” (or the column with end time slot of unloading).

Note: When adding AntsRoute orders from Google Sheets, it is not possible to fill in the extra fields about the customers.

14
Fill in the other fields if necessary (phone, mobile phone, email, comments about the collect, comments about the unloading, etc.).

Note: IMPORTANT ! Don’t forget to add beforehand the three following capacities from your AntsRoute account (AntsRoute > Settings > Capacities > Add) :

  • Number (name = Number ; unit = unit and validation mode = optional) ;
  • Weight (name = Weight ; unit = kg and validation mode = optional) ;
  •  Volume (name = Volume ; unit = m3 and validation mode = optional).

Then you must add the these three columns in you Google Sheet file: “Capacity_Number” ; “Capacity_Weight” and “Capacity_Volume”. The cells of these three columns can’t remain blank. If you don’t want to display these capacities in AntsRoute, just enter the value “0” in the cells of these three columns. Finally, when creating your Zap, make sure these capacities are properly selected. (See screenshot below).

15
Click on the “Continue” button.
16
Click on the “Test & Continue” button.
17
Finally, click on the “Turn on Zap” button.

The creation of the Zap is now completed. From now, when you add a new line in your Google Sheets spreadsheet, the collect-unloading order will also be added in AntsRoute.

Related articles 🔍

> Connect AntsRoute to Zapier
> Automate the creation of customers when adding new row in Google Sheets using Zapier
> Automate the creation of orders when adding new row in Google Sheets using Zapier
> Update AntsRoute customers from updated Quickbooks customers via Zapier
> Add AntsRoute customers from new HubSpot contacts using Zapier
> Add orders in the AntsRoute bucket from new Quickbooks invoices via Zapier
> Add AntsRoute customers from new Quickbooks customers via Zapier
> Add AntsRoute customers from new Axonaut companies-contacts using Zapier
Share
    •       

    • Enterprise

      • Privacy Policy
      • Terms of service
    • Product

      • Appointment scheduling
      • Route optimization
      • Field workers tracking
      • Push notifications
      • Service reports
      • Route reporting
      • Online booking site New

      • Pricing
    • Integrations
      • WooCommerce

      • Prestashop

      • Zapier New

      • Google Calendar

    • Solutions

      • Parcel delivery
      • Fresh produce delivery
      • Merchandise delivery
      • Fuel and gas delivery
      • Equipment installation
      • Repair and maintenance
      • Cleaning service
      • Home healthcare
    • Definitions

      • Route optimisation
      • Route optimisation software
      • Route optimization benefits
      • Route planner
      • Transport software
      • Field service management
    • Resources

      • Blog
      • Testimonials
      • Help center
      • API Rest
      • Contact us