Verify email lists from Google Sheets in one click. Marketers and growth teams can push a whole sheet to an email validation service and skip slow manual uploads. Use it before campaigns to protect deliverability and keep lists clean.

A manual start kicks off the run. A Google Sheets node reads the first column named email. A code node builds a signed request with your API key, secret, user ID, and a timestamp. The HTTP Request node sends a batch job with an Authorization header and a timestamp header. The verification runs on the provider side, and you get a download link in the app and a summary by email.

Set up a sheet with a single email column and connect your Google account. Add your API details in the code node and create a header auth credential in the HTTP Request node using the given expression. Teams typically cut list prep from an hour to a few minutes and lower bounce risk on first sends. Use it for cold outreach lists, webinar sign ups, and CRM exports where email quality matters.

• On demand run using a manual trigger to control when jobs start.
• Google Sheets node reads emails from the first column named email.
• Code node creates a signed request with API key, secret, user ID, and timestamp.
• HTTP Request node posts a bulk job with Authorization and X ROCK TIMESTAMP headers.
• Body includes task, user, name, and data so the service can process the batch.
• Results delivered in the provider app and by email for easy download.

• Reduce manual upload work from 60 minutes to 5 minutes
• Streamline verification requests by up to 80 percent
• Improve list accuracy with up to 30 percent fewer bounces
• Handle thousands of emails in one run without CSV exports
• Connect Google Sheets to the verification service in a single flow

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets and Icypeas. See the Tools Required section above for links to create accounts with these services.
3. Prepare your Google Sheet: create a new sheet with the first column header set to email. Fill a few rows with test email addresses.
4. Open the Google Sheets node in n8n. In the Credential to connect with dropdown, click Create new credential and follow the prompts to sign in to your Google account and grant access. Pick the correct Spreadsheet and Sheet.
5. In your Icypeas account, go to your profile page and copy your API key, API secret, and User ID. Keep these values ready.
6. Open the Code node named for authentication. Paste your API key, API secret, and User ID into the marked lines. Save the node. On self hosted n8n, enable the crypto package in Settings if required, then restart.
7. Open the HTTP Request node. Set Authentication to Generic Credential type and choose HTTP Header Auth. Click Create new credential. For Name enter Authorization. For Value switch to expression and enter {{ $json.api.key + ':' + $json.api.signature }}. Save the credential.
8. Still in the HTTP Request node, add a header parameter named X-ROCK-TIMESTAMP with the expression {{ $json.api.timestamp }}. Confirm the URL and method match the values set by the Code node.
9. Confirm body parameters include task set to email-verification, user bound to {{ $json.api.userId }}, and data referencing the prepared dataset from the Code node.
10. Click Execute Workflow. Check for a success status. Then visit the bulk search page in your Icypeas account to see the job created. Watch for the email with results.
11. If you get unauthorized errors, verify the API key, secret, and user ID in the Code node and ensure the Authorization header expression is correct. If you see data errors, make sure the first column header is exactly email and remove blank rows.
12. Test with a small sample of 5 to 10 emails. Once confirmed, run with the full sheet. Schedule is optional, but you can add a Cron node later if you want automatic runs.