Automatically Add Gmail Sender Contacts to MySQL Database

This n8n workflow triggers on new emails in Gmail every minute, extracts the sender's name (or null if unavailable) and email address using a Code node, and then uses a MySQL node to insert the contact into a specified database table. If the email already exists (enforced by UNIQUE constraint), it updates the name field, ensuring no duplicates while maintaining an up-to-date contact list.

Ideal for sales and marketing teams building lead lists from inbound emails, companies backing up Gmail contacts against data loss, or creating mailing lists for promotions to recent client contacts. It saves hours of manual data entry, reduces errors, and scales effortlessly for high email volumes.

Setup requires Gmail and MySQL credentials, a table with 'name' (nullable) and 'email' (UNIQUE) columns. Customize by adding fields like subject, message ID, or snippet to the MySQL insert for richer data storage.

Benefits include seamless integration between email and database, automatic deduplication, and extensibility for advanced automations like CRM syncing or notifications.