Make.com Airtable Data24 Data Enrichment Sales Automation

Get Phone Numbers for Airtable Contacts from Data24

Automatically enrich new Airtable records with verified phone numbers. Eliminate manual lookups and power up your sales outreach with accurate, up-to-date contact data.

Get This Workflow → Make.com · Airtable & Data24 · Free Template
Make.com workflow diagram showing Airtable triggering a Data24 phone number lookup

What This Workflow Does

Incomplete contact data is a silent revenue killer for sales and marketing teams. Manually searching for phone numbers for every new lead is tedious, error-prone, and slows down your response time dramatically. This automation solves that by creating a seamless bridge between your Airtable database and Data24's extensive contact directory.

Every time a new person is added to your specified Airtable base—whether from a web form, imported list, or sales tool—this Make.com scenario instantly triggers. It takes the available contact details (like name, company, email, or location) and queries the Data24 API to find and retrieve the associated phone number. The number is then written back into the original Airtable record, completing the contact profile automatically. This turns your Airtable from a static list into a dynamically enriched powerhouse, ready for immediate outreach.

How It Works

The workflow operates on a simple but powerful trigger-action model, ensuring your data is enriched in real-time without any manual intervention.

Step 1: Airtable Watches for New Records

The scenario starts with the Airtable module set to "Watch Records." It monitors a specific table in your base, waiting for a new row to appear. This is the trigger that kicks off the entire enrichment process.

Step 2: Data Preparation and API Call

Make takes the data from the new record, such as first name, last name, email, and company name. It structures this information into a precise query format required by the Data24 "Find Person" API module. The API call is sent to Data24's servers to search for a matching profile.

Step 3: Phone Number Extraction and Validation

Data24 returns a response containing the found person's details, including phone numbers. The Make scenario includes a router to handle the outcome: if a match is found, it proceeds to parse the response and extract the most relevant phone number (e.g., a mobile or direct line).

Step 4: Update the Original Airtable Record

Finally, the workflow uses another Airtable module to "Update a Record." It targets the original record that triggered the scenario and writes the newly acquired phone number into a designated column. Your Airtable is now updated with enriched data, ready for your team to use.

Pro tip: Use a "Last Enriched Date" column in Airtable. Update it each time this workflow runs. This creates a clear audit trail and helps you avoid wasting API credits on re-enriching the same records repeatedly.

Who This Is For

This template is a game-changer for any business that relies on accurate contact data for outbound communication. It's perfect for Sales Teams and SDRs who need direct phone numbers to hit their call quotas faster. Recruitment Agencies can use it to find candidate contact details quickly. Marketing Agencies running lead generation campaigns can instantly qualify leads with complete data. Small Business Owners managing their own CRM in Airtable will save countless hours of manual searching. Essentially, if you use Airtable as a source of truth for people and need their phone numbers, this automation is for you.

What You'll Need

  1. A Make.com Account: A free or paid plan to build and run the automation scenario.
  2. An Airtable Account & Base: With a table containing contact records. Ensure your table has columns like First Name, Last Name, Email, and Company to maximize match rates with Data24.
  3. A Data24 API Key: You'll need an active subscription with Data24 to access their "Find Person" API. Sign up on their website and obtain your authentication key.
  4. A Dedicated Phone Number Column: In your Airtable table, create a column (e.g., "Phone" or "Direct Number") where the enriched data will be written.

Quick Setup Guide

Follow these steps to get your phone number enrichment live in under 30 minutes.

  1. Clone the Template: Click "Get This Workflow" and duplicate the scenario into your own Make.com workspace.
  2. Connect Airtable: In the first module, authorize Make to access your Airtable account and select the specific base and table you want to monitor.
  3. Configure Data24: In the "Find Person" module, paste your Data24 API key. Map the incoming fields from Airtable (name, email, company) to the corresponding search parameters in Data24.
  4. Map the Output: In the final Airtable "Update Record" module, ensure the phone number extracted from Data24's response is correctly mapped to your target column in Airtable.
  5. Test and Activate: Add a test record to your Airtable table. Run the scenario once to see it in action. If successful, turn the scenario to "ON" to let it run automatically for all future records.

Key Benefits

Save 5–10 hours per week per salesperson previously spent on manual data lookup. This time can be redirected towards actual selling and relationship-building activities, directly impacting revenue.

Increase call connect rates by up to 40% by using verified, direct-dial numbers instead of generic office lines. Accurate data means less time wasted on wrong numbers and gatekeepers.

Improve data hygiene automatically, ensuring your Airtable CRM remains a reliable single source of truth. Automated enrichment reduces human error and keeps contact records consistently complete.

Accelerate sales response time to minutes instead of hours or days. The moment a lead enters your system, their phone number is appended, allowing for immediate, high-conversion outreach.

Scale your outbound efforts without scaling your team. This automation handles the data grunt work, enabling your existing team to manage a larger volume of qualified leads effectively.

Frequently Asked Questions

Common questions about contact data enrichment automation and integration

Contact data enrichment is the process of adding missing or updating existing information in your contact database, like phone numbers, email addresses, or job titles. It's crucial for sales because accurate, complete data directly increases outreach success rates. Without enrichment, sales teams waste time on incorrect numbers, leading to lower connect rates and missed opportunities.

Automated enrichment ensures your CRM is always ready for effective campaigns. For example, a sales rep can call a new lead within minutes of them signing up, using a verified direct-dial number instead of a generic front desk line, dramatically improving the chance of a meaningful conversation.

Data24 is a specialized provider known for its comprehensive European and global B2B and B2C contact databases, offering high match rates for phone numbers. Compared to generalist providers, Data24 often provides more accurate direct-dial numbers and better coverage for specific regions.

When integrated via automation, it delivers real-time, verified data directly into your workflow, reducing the need for manual cross-referencing across multiple sources. The key is its focus on depth and verification, which translates to higher-quality outputs for your sales team.

Yes, but with important considerations. Using Data24 for phone number lookup must align with GDPR principles of lawful basis and transparency. You should only enrich data for contacts where you have a legitimate interest or consent, such as leads who have explicitly requested contact.

The automation itself can help maintain compliance by logging data sources and enrichment dates in Airtable, creating an audit trail. Always ensure your data provider guarantees GDPR-compliant sourcing and that your internal processes for data use are clearly documented and communicated.

Common pitfalls include hitting API rate limits, mismatched data formats causing errors, and enriching outdated or incorrect base records which wastes credits. Another issue is not having a fallback process when a phone number isn't found.

To avoid this, design your workflow to flag records for manual review, use data validation before the API call, and schedule enrichment during off-peak hours to manage costs and system load effectively. Always start with a small batch test to gauge match rates and data quality.

Enriched phone numbers unlock powerful multi-channel marketing automation. You can trigger personalized SMS campaigns immediately after a website sign-up, sync phone numbers to your dialer for timely sales calls, or create segmented outreach lists based on contact completeness.

This turns a basic email sequence into a coordinated phone-and-email strategy, significantly boosting engagement rates and shortening sales cycles by reaching prospects on their preferred channel. For instance, an automated welcome SMS after a download can have a 98% open rate.

The best approach depends on your use case. Real-time enrichment, like this Airtable-Make workflow, is ideal for immediate actions like sales calls for new leads. Batch enrichment is better for periodically updating your entire database or cleaning legacy data.

Real-time keeps data fresh but costs more per API call. Batch processing is more cost-efficient for large volumes but data may be stale between runs. Many businesses use a hybrid strategy: real-time for new leads and a weekly batch job to refresh older records.

Absolutely. GrowwStacks specializes in building tailored data enrichment automations that fit your specific CRM, data sources, and business rules. We can integrate multiple providers, add custom validation logic, connect enriched data to your sales dialer or marketing platform, and design fallback workflows.

Our consultants will assess your current process and build a system that maximizes data accuracy while minimizing cost and manual effort. Whether you need complex multi-source lookups, compliance logging, or integration with tools like Salesforce or HubSpot, we can create a solution that scales with your business.

Need a Custom Contact Enrichment Automation?

This free template is a starting point. Our team builds fully tailored automation systems for your specific business needs.