Flag bounced emails in Google Sheets from Gmail delivery error messages
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
Nodes used (6)
- Manual Trigger
n8n-nodes-base.manualTrigger - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set - Gmail
n8n-nodes-base.gmail - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets
What it does
Scanning Email Inbox for Delivery Errors Prerequisite: Automate Personalized Email Campaigns with Google Docs, Sheets, and SMTP. How It Works After running your email campaign, some messages may fail to deliver. This workflow scans your email inbox for delivery errors (e.g., bounced messages), flags problematic email addresses in the Google Sheet and ensures future campaigns skip them. How to Use 1. Ensure Prerequisite Workflow: - You should have the Email Campaign Workflow configured and running. 2. Google Sheet Setup: - Use the Google Sheet Template. - Identify your document’s ID (the string after /d/ and before /edit in the URL). 3. Configure Workflow: - Enter your Google Sheet ID in the settings node. - Connect your Google credentials to n8n. 4. Email Inbox: - Set up the readspamfolder node to search for bounce/error messages in your mail (e.g., in the Spam or Inbox folders—adjust label/folder if emails land elsewhere). 5. Google Sheet Update: - Configure the lookupemail and updateerr nodes Requirements - Google Credentials to access Gmail and sheets. - Gmail Account (bounce/error messages must be accessible here). - n8n Version: Tested with 1.105.2 (Ubuntu). Need Help? - Comment this post or contact me on LinkedIn - Ask in the n8n Community Forum!