Daily Email Validation for Airtable Records with Mailcheck

This workflow automates email validation for Airtable records using the Mailcheck API, running daily. Key nodes include Daily Email Validation Schedule (cron trigger), Initialize Process (sets process metadata), Get Pending Email Records (fetches Airtable records), Prepare Email Records (sanitizes data), Check Email Format Valid (validates format), Validate Email via API (Mailcheck API call), Format Success/Error Result (processes API response), Update Airtable Record (updates records), Log Record Result (logs outcomes), and Generate Process Summary (summarizes process).\n\nSetup Requirements and Configuration: Install n8n from n8n.io for self-hosting or sign up at cloud.n8n.io. Follow prompts or create a cloud account. Obtain an Airtable Personal Access Token from airtable.com: log in, go to 'Account' > 'API Access,' generate a token with data read/write permissions. Get a Mailcheck API key from mailcheck.ai: sign up, access the dashboard, and copy the API key. In n8n, import the JSON workflow. Configure Get Pending Email Records and Update Airtable Record with Airtable token and base/table IDs under ‘Credentials’ > ‘Airtable API.’ Set Validate Email via API with Mailcheck API key under ‘Credentials’ > ‘Mailcheck API.’ Ensure server supports API calls and cron scheduling.\n\nTesting and Deployment Steps: Test manually in n8n by executing the workflow. Ensure Airtable table ‘Contacts’ has an ‘Email’ column and an optional ‘Valid’ column. Success output includes process_id, records_processed, and valid_emails_found in the Generate Process Summary. Errors include invalid Airtable token (check credentials), API key issues (verify Mailcheck key), or no records found (ensure Airtable filter matches records). Validate output: check process_id is unique, records_updated matches processed count, and validation_status is ‘Valid’/’Invalid’/’API Error.’ Debug using n8n logs for errors like ‘Rate limit exceeded’ or ‘Invalid email format.’ Adjust cron schedule (e.g., ‘0 2 * * *’ for 2 AM) if needed. Activate workflow in n8n for daily runs.