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 the creation of customers when adding new row in Google Sheets using Zapier

26 January 2021
Categories
AntsRoute plugin, Zapier
Tags

Support > AntsRoute Plugin > Automate the creation of customers when adding new row in Google Sheets using Zapier

  Automate the creation of customers when adding new row in Google Sheets using Zapier

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

Note : The Zap template is available here.

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 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 contain at least a “Last name” column and an “Address” column.

Here is an exemple of Google Sheets file with the required columns : 

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 a New Customer“.
3
Click on the “Continue” button.

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.
6
For “Last name”, select the “Last name” column (or the column with the customers’ name).
7
For “Address”, select the “Address” column (or the column with the customers’ address).

8
Fill in the other fields if necessary (external ID, phone, mobile phone, email, comments).
9
Click on the “Continue” button.
10
Click on the “Test & Continue” button.
11
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 file, the client will also be added in AntsRoute. You can find the added clients directly in AntsRoute > Resources > Customers. You can quickly find a client via the search bar available in the “Customers” tab.

Related articles 🔍

> Connect AntsRoute to Zapier
> Automate the creation of orders when adding new row in Google Sheets using Zapier
> Update AntsRoute customers from updated Quickbooks customers via Zapier
> Automate pickup & delivery order creation when adding new row in Google Sheets using 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