n8n Email Open Tracking Pixel: Airtable Webhook & Proxy Detection

Detect real email opens—and sort out privacy proxies, scanners, and “fake” traffic

This 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.

What this workflow does

• Receives tracking requests via an n8n webhook using query parameters such as the Airtable lead record ID and the email send timestamp.
• Returns a 1x1 transparent GIF immediately using no-cache headers, so email clients don’t wait for any downstream processing.
• Classifies the request by analyzing the user agent, IP-related headers, and time since send to label the source (e.g., Gmail/Yahoo image proxies, native clients, Apple MPP/privacy proxies, or security scanners) and assign a confidence level.
• Updates Airtable for real opens: if it’s a real open and a lead ID is present, it fetches the lead and finds an existing row in the “Email Opens” table.
  • If found, it increments the open count and refreshes last-opened and classification fields.
  • If not found, it creates a new “Email Opens” record for a first-time open.
• Handles noise traffic intelligently: obvious scanners/bots are dropped, while privacy-proxy “blind” hits are logged in Airtable with Count = 0 only when no existing open record exists for that lead.

Use cases

• Measure engagement from email campaigns while reducing false “open” metrics caused by proxies and security scanners.
• Maintain an Airtable “Email Opens” history that includes classification source and confidence for each lead.
• Integrate tracking into SaaS workflows where email timing and lead-level attribution matter.

Technical details (n8n + Airtable)

• n8n nodes: webhook, respond to webhook, airtable, code, if, plus sticky note for documentation.
• Airtable setup: create an Airtable personal access token with read/write permissions and select it in all Airtable steps; configure the base and the Email Opens table.