{"product_id":"n8n-airtable-gdpr-research-contact-enrichment-workflow","title":"n8n Airtable GDPR Research Contact Enrichment Workflow","description":"\u003ch3\u003eEnrich GDPR-focused research contacts in Airtable—automatically, twice daily\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow reads pending “Research Requests” from \u003cb\u003eAirtable\u003c\/b\u003e, searches for relevant people using \u003cb\u003eTavily Search\u003c\/b\u003e, extracts structured contact details with \u003cb\u003eOpenAI\u003c\/b\u003e, enriches them with \u003cb\u003eDropcontact\u003c\/b\u003e, and then \u003cb\u003eupserts enriched contacts back into Airtable\u003c\/b\u003e—updating each request to \u003cb\u003eCompleted\u003c\/b\u003e or \u003cb\u003eFailed - Low Confidence\u003c\/b\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eRuns on a schedule\u003c\/b\u003e at \u003cb\u003e09:00\u003c\/b\u003e and \u003cb\u003e14:00\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003ePulls pending records\u003c\/b\u003e from the Airtable “Research Requests” table where \u003cb\u003eStatus = Pending\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSearches with Tavily Search API\u003c\/b\u003e and filters results to keep only \u003cb\u003ehigh-confidence matches\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003eIf no usable results are found, it updates the Airtable request status to \u003cb\u003eFailed - Low Confidence\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003eIf usable results exist, it sends Tavily output to \u003cb\u003eOpenAI (GPT)\u003c\/b\u003e to extract a \u003cb\u003estructured JSON list\u003c\/b\u003e of contacts (names, organizations, roles, and interests).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eEnriches contacts with Dropcontact\u003c\/b\u003e, waits for the asynchronous callback, then fetches the enriched results.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eUpserts into Airtable\u003c\/b\u003e “Contact List” for each enriched contact and marks the original request as \u003cb\u003eCompleted\u003c\/b\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTurn research prompts into a continuously updated \u003cb\u003eAirtable contact database\u003c\/b\u003e for sales, recruiting, or partnerships.\u003c\/li\u003e\n  \u003cli\u003eAutomate research intake: analysts submit requests in Airtable; the workflow handles search, extraction, enrichment, and status tracking.\u003c\/li\u003e\n  \u003cli\u003eKeep quality high by failing fast when Tavily confidence is low (\u003cb\u003eFailed - Low Confidence\u003c\/b\u003e).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eIntegrations\/steps include: \u003cb\u003eAirtable\u003c\/b\u003e, \u003cb\u003eTavily Search\u003c\/b\u003e, \u003cb\u003eOpenAI\u003c\/b\u003e, and \u003cb\u003eDropcontact\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003en8n node types referenced: \u003cb\u003eif\u003c\/b\u003e, \u003cb\u003eset\u003c\/b\u003e, \u003cb\u003ecode\u003c\/b\u003e, \u003cb\u003ewait\u003c\/b\u003e, \u003cb\u003emerge\u003c\/b\u003e, \u003cb\u003eairtable\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003eSetup requirements: Airtable credentials + table IDs, OpenAI API credential (e.g., \u003cb\u003egpt-5-mini\u003c\/b\u003e), and \u003cb\u003eTAVILY_API_KEY\u003c\/b\u003e as an environment variable.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46123247567027,"sku":"N8N-20084","price":6.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/ZV7S4R_IA0mBpHbo_siPe_FRTYSLpk.png?v=1790673870","url":"https:\/\/buyflowscripts.com\/products\/n8n-airtable-gdpr-research-contact-enrichment-workflow","provider":"N8N Commerce","version":"1.0","type":"link"}