Best Monday.com Phone Validation API & Email Verification Integration 2025

// Automation trigger webhook payload
{
  "board_id": "event_registrations",
  "item_id": "{{pulse_id}}",
  "trigger": "new_registration",
  "attendee_data": {
    "name": "{{person_name}}",
    "phone": "{{phone_column}}",
    "email": "{{email_column}}",
    "event_id": "{{event_column}}"
  }
}

// Response updates multiple columns
{
  "phone_validation": {
    "status": "Valid",
    "carrier": "AT&T",
    "type": "Mobile"
  },
  "email_validation": {
    "status": "Valid", 
    "quality_score": 92
  },
  "registration_status": "Confirmed",
  "follow_up_method": "SMS + Email"
}

// Advanced conditional logic example
{
  "validation_rules": {
    "high_value_leads": {
      "condition": "lead_value > 10000",
      "validation_level": "premium",
      "include_carrier_lookup": true,
      "include_line_type": true,
      "include_spam_check": true
    },
    "international_contacts": {
      "condition": "country != 'US'",
      "validation_level": "international",
      "timezone_detection": true,
      "local_format_validation": true
    },
    "bulk_imports": {
      "condition": "source == 'csv_import'",
      "validation_level": "batch",
      "duplicate_detection": true,
      "data_enrichment": true
    }
  },
  "automation_flows": {
    "valid_premium_lead": [
      "assign_to_senior_rep",
      "schedule_immediate_followup",
      "add_to_priority_sequence"
    ],
    "invalid_contact": [
      "flag_for_cleanup",
      "remove_from_campaigns", 
      "log_data_quality_issue"
    ]
  }
}

# Query board data for validation
query GetBoardContacts($boardId: Int!) {
  boards(ids: [$boardId]) {
    id
    name
    items {
      id
      name
      column_values {
        id
        text
        type
        ... on PhoneValue {
          phone
          country_short_name
        }
        ... on EmailValue {
          email
          text
        }
      }
    }
  }
}

# Mutation to update validation results
mutation UpdateValidationResults(
  $itemId: Int!
  $boardId: Int!
  $phoneStatus: String!
  $emailStatus: String!
  $qualityScore: Int!
) {
  change_multiple_column_values(
    item_id: $itemId
    board_id: $boardId
    column_values: "{
      "phone_validation": "$phoneStatus",
      "email_validation": "$emailStatus", 
      "contact_quality": $qualityScore
    }"
  ) {
    id
  }
}

// Webhook endpoint implementation
const express = require('express');
const crypto = require('crypto');
const app = express();

// Middleware for Monday.com webhook verification
function verifyMondayWebhook(req, res, next) {
  const signature = req.headers['authorization'];
  const payload = JSON.stringify(req.body);
  
  // Verify webhook signature (recommended)
  const expectedSignature = crypto
    .createHmac('sha256', process.env.MONDAY_WEBHOOK_SECRET)
    .update(payload)
    .digest('hex');
    
  if (signature !== `sha256=${expectedSignature}`) {
    return res.status(401).json({ error: 'Invalid signature' });
  }
  
  next();
}

// Webhook endpoint for Monday.com
app.post('/webhook/monday', verifyMondayWebhook, async (req, res) => {
  try {
    const { board_id, item_id, column_values } = req.body;
    
    // Extract contact data
    const phoneValue = column_values.find(col => col.column_id === 'phone')?.value;
    const emailValue = column_values.find(col => col.column_id === 'email')?.value;
    
    if (!phoneValue && !emailValue) {
      return res.status(400).json({ error: 'No contact data to validate' });
    }
    
    // Validate with 1lookup API
    const validationResults = await Promise.all([
      phoneValue ? validatePhone(phoneValue) : null,
      emailValue ? validateEmail(emailValue) : null
    ]);
    
    // Update Monday.com board
    await updateMondayBoard(board_id, item_id, validationResults);
    
    res.status(200).json({ 
      success: true, 
      validated: { phone: !!phoneValue, email: !!emailValue }
    });
    
  } catch (error) {
    console.error('Webhook processing error:', error);
    res.status(500).json({ error: 'Processing failed' });
  }
});

// Rate limiting for API calls
const rateLimit = require('express-rate-limit');
const limiter = rateLimit({
  windowMs: 15 * 60 * 1000, // 15 minutes
  max: 100 // limit each IP to 100 requests per windowMs
});

app.use('/webhook', limiter);