Google Sheets + MailOdds
Validate email lists directly in your spreadsheets. Clean columns, verify form responses, and maintain list hygiene without leaving Google Sheets.
Prerequisites
- MailOdds account with API key
- Google Sheets with email column
- Zapier, Make, or n8n account
How to Connect
Connect Google Sheets to MailOdds through any of these automation platforms:
Recommended: n8n Templates
We have ready-to-use n8n workflows specifically for Google Sheets. Import a template and start validating in under 2 minutes.
View Google Sheets TemplatesExample Workflow
Trigger: New Row Added
When a new email is added to your Google Sheet (or a new form response arrives).
Action: Validate Email
MailOdds API validates the email address and returns status, action, and risk score.
Action: Update Sheet
Write validation results back to adjacent columns (Status, Action, Sub-Status).
Optional: Filter & Notify
Flag invalid emails, send Slack alerts, or route to different sheets based on results.
Zapier: Validate Row Email
JAVASCRIPT// Zapier Code Step - Validate Email from Google Sheets Row
const response = await fetch('https://api.mailodds.com/v1/validate', {
method: 'POST',
headers: {
'Authorization': 'Bearer YOUR_API_KEY',
'Content-Type': 'application/json'
},
body: JSON.stringify({
email: inputData.email // Mapped from Google Sheets column
})
});
const result = await response.json();
return {
email: result.result.email,
status: result.result.status,
action: result.result.action,
is_valid: result.result.action === 'accept',
reason: result.result.sub_status || null
};Make: HTTP Module Setup
JAVASCRIPT// Make HTTP Module - Validate and Update Sheet
// 1. Google Sheets: Watch Rows trigger
// 2. HTTP Module: POST to https://api.mailodds.com/v1/validate
// Headers: Authorization: Bearer YOUR_API_KEY
// Body: { "email": "{{1.email}}" }
// 3. Google Sheets: Update Row
// Column "Status" = {{2.result.status}}
// Column "Action" = {{2.result.action}}Frequently Asked Questions
Troubleshooting
Need more help?
Can't find what you're looking for? We're here to help you get Google Sheets working.
Start Validating Your Spreadsheet Emails
Sign up free and get 1,000 validations to clean your Google Sheets data.