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:
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.
Step 1: Setup the “trigger”
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 :
Step 2: Setup the “action”
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“.
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 🔍