{"product_id":"n8n-email-open-tracking-pixel-airtable-webhook-proxy-detection","title":"n8n Email Open Tracking Pixel: Airtable Webhook \u0026 Proxy Detection","description":"\u003ch3\u003eDetect real email opens—and sort out privacy proxies, scanners, and “fake” traffic\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow delivers a 1x1 tracking pixel via an n8n webhook, classifies each request to determine whether it’s a genuine email open or a proxy\/scanner hit, and records results in Airtable with confidence and source metadata.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives tracking requests\u003c\/strong\u003e via an n8n \u003cem\u003ewebhook\u003c\/em\u003e using query parameters such as the \u003cstrong\u003eAirtable lead record ID\u003c\/strong\u003e and the \u003cstrong\u003eemail send timestamp\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReturns a 1x1 transparent GIF\u003c\/strong\u003e immediately using \u003cem\u003eno-cache headers\u003c\/em\u003e, so email clients don’t wait for any downstream processing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClassifies the request\u003c\/strong\u003e by analyzing the \u003cstrong\u003euser agent\u003c\/strong\u003e, \u003cstrong\u003eIP-related headers\u003c\/strong\u003e, and \u003cstrong\u003etime since send\u003c\/strong\u003e to label the source (e.g., Gmail\/Yahoo image proxies, native clients, Apple MPP\/privacy proxies, or security scanners) and assign a \u003cstrong\u003econfidence level\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates Airtable for real opens\u003c\/strong\u003e: if it’s a real open and a lead ID is present, it fetches the lead and finds an existing row in the \u003cstrong\u003e“Email Opens”\u003c\/strong\u003e table.\n    \u003cul\u003e\n      \u003cli\u003eIf found, it increments the \u003cstrong\u003eopen count\u003c\/strong\u003e and refreshes last-opened and classification fields.\u003c\/li\u003e\n      \u003cli\u003eIf not found, it creates a new “Email Opens” record for a first-time open.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles noise traffic intelligently\u003c\/strong\u003e: obvious scanners\/bots are dropped, while privacy-proxy “blind” hits are logged in Airtable with \u003cstrong\u003eCount = 0\u003c\/strong\u003e only when no existing open record exists for that lead.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMeasure engagement from email campaigns while reducing false “open” metrics caused by proxies and security scanners.\u003c\/li\u003e\n  \u003cli\u003eMaintain an \u003cstrong\u003eAirtable “Email Opens”\u003c\/strong\u003e history that includes classification source and confidence for each lead.\u003c\/li\u003e\n  \u003cli\u003eIntegrate tracking into SaaS workflows where email timing and lead-level attribution matter.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details (n8n + Airtable)\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes:\u003c\/strong\u003e \u003cem\u003ewebhook\u003c\/em\u003e, \u003cem\u003erespond to webhook\u003c\/em\u003e, \u003cem\u003eairtable\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003eif\u003c\/em\u003e, plus \u003cem\u003esticky note\u003c\/em\u003e for documentation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAirtable setup:\u003c\/strong\u003e create an \u003cstrong\u003eAirtable personal access token\u003c\/strong\u003e with read\/write permissions and select it in all Airtable steps; configure the base and the \u003cstrong\u003eEmail Opens\u003c\/strong\u003e table.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45862252216499,"sku":"N8N-18104","price":52.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/qydN2VZ900w9rtT-HFfw8_1wlKXMzv.png?v=1786958030","url":"https:\/\/buyflowscripts.com\/products\/n8n-email-open-tracking-pixel-airtable-webhook-proxy-detection","provider":"N8N Commerce","version":"1.0","type":"link"}