HEC Paris logoDropcontact logo green and white
Tutorial to create a Zapier Dropcontact workflow for email address enrichment

✍🏻 Sales

You have a base of qualified prospect, prepare your cold emails and you are in the starting blocks to launch your marketing and sales offensive?

✋🏻 Hop hop hop! Are you sure you haven't forgotten anything?

Dropcontact Facebook
Is your prospect data enriched?

When you have targeted your market but your prospect datas are incompleted ...

Thanks to Zapier and Dropcontact, it is possible to automate your workflows to complete your prospect information (enriched, cleaned and validated contacts)!

(For those who use Integromat, 👉 [TUTO] Find B2B emails with Integromat and Dropcontact)

LinkedIn Dropcontact

🆙 Updated : Dropcontact is now directly integrated to Zapier.

For an even simpler and faster workflow, you can use the zap: "Enrich B2B contact data in new Google Sheets rows with Dropcontact".

(For those who use Integromat, 👉 [TUTO] Find B2B emails with Integromat and Dropcontact)

Workflow Zapier: Enrich your B2B contacts from a Google Sheet thanks to Dropcontact

Otherwise... you can always follow the tutorial below

Zapier: Automate your Growth Marketing processes without development

La French Tech Logo
Zapier is one of the best known automation platforms on the market: plugging web applications or SaaS services together requires no technical skills!

No dev: It's magic!

The online tool offers more than 2,000 integrations including Google Apps, numerous CRM, forms and landing page tools... in order to automate time-consuming tasks for Growth Marketing teams.

Today, prospecting should no longer be reduced to spending hours manually enriching, completing and filing contacts and prospects.

Dropcontact: the essential Growth Marketing tool

Dropcontact is a unique solution on the market! The SaaS solution makes it possible to enrich, standardize and clean each line of contacts in your file... All this in a 100% GDPR compliant way.

The use of Dropcontact does not require specific development 🤗 and is available from beginner to expert.

🤝 Let's see together, step by step, how to enrich the emails of its prospects directly from Google Sheet thanks to a workflow in a few simple steps.

Tuto : Integrate Dropcontact in Zapier and automate your Growth Hacking tools

Proof by example: How to enrich your contacts directly in Google Sheet.

  • Before starting, a few pre-requisites are necessary :
  1. Create a Google Sheet document :
  2. with a header line
  3. with at least one line with surname, first name, website, and company name
  • shared to "all persons with the link" with modification accesses
  • Have an account Dropcontact if you don't already have one. Registration is free (we don't even ask for your bank details) and it is possible to test the solution free of charge and without obligation.

Create a Zapier account. Registration is also free.

🔐 Here we go, you have all the keys in hand to automate the cleaning of your contact databases.

1. Create a Zap

Logo Station F
This Zap, or worflow, will allow Dropcontact to be connected to a Google Sheet to regularly update the latter with enriched, clean, standardized and above all guaranteed valid data.

Zap Google Sheet / Dropcontact to automatically enrich its prospect database, without any dev

2. Add a Google Sheet trigger

  • Set up :
  • App: Google Sheet
  • Trigger Event: "New Spreadsheet Row" or "New or updated Spreadsheet Row"
  • Account and Spreadsheet Row: Choose the file containing your contact database

Find data: Choose the better sample to test your future zap

💡 Share your Google Sheet with "the people who have the link" and allow editing if you haven't already done so.

3. Add Webhook POST Dropcontact

  • Configure the Dropcontact POST with :
  • App : Webhooks by Zapier
  • Action event : Custom request
  • Method : Post
  • URL: https://api.dropcontact.io/batch
  • Data Pass-Through: No
Data: Copy and paste the code below ✂️ and replace each "data-type" by the variables proposed by Zapier

"data": [
"first_name": "John",
"last_name": "Smith",
"company": "corporation",

  • 💡 If your file contains French companies, add the "siren" information: true.
  • Unflatten: Yes


- Content-type: application/json

- X-Access-Token: Find the API key in the tab "My account", top

4. Delay treatment

Then, be patient. 🎶

Finally, above all, give time for the Dropcontact algorithm to operate.

It is therefore absolutely necessary to add a "Delay for" of 1 minute between the POST and the GET of Dropcontact.

⚠️ One minute?! And yes, because Dropcontact will not retrieve its contact data from existing databases (more or less legal by the way) but launches its proprietary algorithm to find, test and verify all the data.

This is what makes the solution 100% GDPR compliant and each provided data is legal.

5. Add the Dropcontact GET

  • Configure the Dropcontact POST with :
  • Configure the Webhook as follows:
  • Event: GET

URL : https://api.dropcontact.io/batch/{{your_request_id}}

- replace {{your-resques-id}} with "2.Custom request > Request ID".

  • 💡 Remember to display all options if all variables do not appear.
  • Send as JSON Yes
  • 💡 If your file contains French companies, add the "siren" information: true.
  • JSON Key : Yes



- X-Access-Token: The Dropcontact API key, to be found in the "My Account"

💡 Test and verify your zap step by step

6. Retrieve your file of processed and validated prospects

Last step: Make the data returned by Dropcontact usable, in its Google Sheet.

  • Set up :
  • Finalize your zap by configuring :
  • Action Event: Create Spreadsheet Row
  • Account: Choose account, folder, file and sheet where your clean data will be sent by Dropcontact

- replace {{your-resques-id}} with "2.Custom request > Request ID".

Customize Spreadsheet row : For each item, add the variable

💡 For easy integration, you can download the Dropcontact template here (just copy and paste the headers into your own file)

One last data test, and bang!

You have just created your automation workflow to update the emails of your new prospects.

Picto Dropcontact - Blue leaf
Growth Hacker's Nirvana 🤩

When you optimize your canvassing without too much effort

To learn more, or to use by yourself all the features of Dropcontact, all the API documentation is available.

(For those who use Integromat, 👉 [TUTO] Find B2B emails with Integromat and Dropcontact)

🎁 The first 100 treatment lines on Dropcontact are free.

Enrich your B2B contacts directly in Google Sheet with Dropcontact and ZapierDropcontact green and black logo

How to convert each contact into an opportunity

When you want to develop your activity, the first reflex is to try to find new prospects. However, there is a recurring problem in companies: that of files...