Step 2: Connect MySQL

Prepare the database connection used to store sender and recipient details.

1. Add the Upsert Contact Record node to your canvas.
2. Credential Required: Connect your mySql credentials.
3. Set Table to contacts.

Step 3: Set Up Data Processing with Code

Parse the email headers so sender and recipient details are extracted into clean fields.

1. Add the Extract Sender Details node after Incoming Email Trigger.
2. Set Mode to runOnceForEachItem.
3. Paste the JavaScript into JavaScript Code exactly as provided in the workflow:
4. // Extract Sender Info let sender_email = $json.From.trim(); let sender_name = null; if (sender_email.includes('<')) { sender_name = sender_email.split('<')[0].trim(); sender_email = sender_email.split('<')[1].replace('>', '').trim(); } // Extract Recipient Info let recipient_email = $json.To.trim(); let recipient_name = null; if (recipient_email.includes('<')) { recipient_name = recipient_email.split('<')[0].trim(); recipient_email = recipient_email.split('<')[1].replace('>', '').trim(); } return { "sender_name": sender_name, "sender_email": sender_email, "recipient_name": recipient_name, "recipient_email": recipient_email }

Step 4: Configure the Upsert Action

Map the extracted values into your database and upsert on message ID to avoid duplicates.

1. Open Upsert Contact Record and set Operation to upsert.
2. Set Column To Match On to messageId.
3. Set Value To Match On to {{ $('Incoming Email Trigger').item.json.id }}.
4. In Values To Send, add these mappings:
   • threadId → {{ $('Incoming Email Trigger').item.json.threadId }}
   • sender_name → {{ $json.sender_name }}
   • sender_email → {{ $json.sender_email }}
   • recipient_name → {{ $json.recipient_name }}
   • recipient_email → {{ $json.recipient_email }}
   • subject → {{ $('Incoming Email Trigger').item.json.Subject }}
   • snippet → {{ $('Incoming Email Trigger').item.json.snippet }}

Step 5: Test and Activate Your Workflow

Run a manual test to confirm data flows from Gmail into your database before turning it on.

1. Click Execute Workflow and send a test email to your connected Gmail account.
2. Verify Extract Sender Details outputs sender_name, sender_email, recipient_name, and recipient_email.
3. Confirm a new row is created or updated in the contacts table by Upsert Contact Record.
4. Toggle the workflow to Active to enable continuous monitoring.