Enrich GDPR research contacts in Airtable with Tavily, OpenAI, and Dropcontact

Description

Quick overview This workflow runs twice daily to read pending research prompts from Airtable, uses Tavily search plus OpenAI to extract relevant people, enriches them with Dropcontact, and upserts the resulting contacts back into Airtable while updating each request’s status. How it works Runs on a schedule at 09:00 and 14:00. Searches Airtable for “Research Requests” records where the Status is set to Pending. For each pending prompt, queries the Tavily Search API and filters results to only keep high-confidence matches. If no usable search results are found, updates the Airtable request status to Failed - Low Confidence. If usable results are found, sends the Tavily output to OpenAI (GPT model) to extract a structured JSON list of contacts with names, organizations, roles, and interests. Submits the extracted names and organizations to Dropcontact for enrichment, waits for the asynchronous callback, then fetches the enriched results. Upserts each enriched contact into an Airtable “Contact List” table and updates the original Airtable request record to Completed. Setup Create an Airtable personal access token credential and update the base ID and table IDs for both the Research Requests and Contact List tables. Add an OpenAI API credential and confirm the selected model (for example, gpt-5-mini) is available to your account. Set the Tavily API key as an environment variable named TAVILY_API_KEY. Add a Dropcontact API credential and ensure Dropcontact can reach your n8n instance’s public resume URL used for the wait/callback step. Ensure your Airtable schema includes a Status field (Pending, Completed, and Failed - Low Confidence) and a Prompt field used to identify and update requests. Requirements Any Database, Tavily API key, OpenAI API key, Dropcontact API key. Additional info Airtable can be swapped out for Excel or any other database, This was built so non-technical staff could easily 'send requests' and get enriched contacts back in their database. An n8n automation workflow template by Luka Margiani.

Community Metrics

Categories

• Automation
• AI

Tags

• n8n
• workflow
• airtable
• http-request
• dropcontact
• code
• openai

Capabilities

• 5 nodes

Information