Verify email contacts in Google Sheets with EmailAwesome

Quick overview

This manual workflow verifies a single email address stored in Google Sheets using EmailAwesome, saving a provider validation ID and later retrieving the verification status back into the same row with state, result, timestamp, and notes.

How it works

1. Starts manually and reads the target spreadsheet ID, tab name, row ID, and run mode (preview or live).
2. Looks up the selected contact row in Google Sheets by its row_id and validates that required columns and a plausible email address are present.
3. If running in preview mode or the row is not in an actionable state, stops and returns a message without calling EmailAwesome or writing to Google Sheets.
4. When the row is READY, reserves the row in Google Sheets to prevent accidental retries, then submits the email address to EmailAwesome to start a validation.
5. Confirms the EmailAwesome response matches the selected email, then writes the returned validation_id to Google Sheets and sets the row state to PENDING.
6. When the row is PENDING with an existing validation_id, fetches the validation from EmailAwesome, maps the provider status to DONE, PENDING, or REVIEW, and writes the result, checked timestamp, and note back to Google Sheets.

Setup

1. Create a Google Sheets spreadsheet with a Contacts tab (or update the tab name) that includes the columns row_id, email, state, validation_id, result, checked_at, and note.
2. Add a Google Sheets credential in n8n and attach it to all Google Sheets steps, then paste your spreadsheet ID and choose a row_id in the Setup step.
3. Add your EmailAwesome API key as Header Auth for both EmailAwesome MCP steps using header name x-api-key.
4. Start with mode set to preview to validate the row selection, then switch to live only when you are ready to submit an authorized email for verification.