Automated Email Tracking and Client Database Update

This n8n workflow automates the process of handling incoming emails from Gmail, extracting key contact information, and updating a MySQL database with the details. It begins with a Gmail trigger that listens for new emails every minute. When a new email arrives, a code node extracts the sender’s and recipient’s names and emails by parsing the email addresses. The processed data is then inserted or updated in a MySQL database, ensuring contact records are kept current. The workflow includes sticky notes with setup instructions for users, emphasizing the importance of having appropriate Gmail and MySQL credentials, as well as a properly structured database table to store email metadata. This automation is particularly useful for customer relationship management, lead tracking, and maintaining a centralized contact repository without manual data entry.