Gmail to Google Sheets
Google Apps Script
Key highlights
- Google Apps Script that works like a Contact Management System
- The script watches a Gmail inbox
- New email messages are captured in a Google Sheet
- Sender information is saved in a different Google Sheet
- Users can easily pull all messages by a sender's email address
Summary
This project required watching a specific Gmail inbox and capturing new email messages into a Google Sheet. The Google Apps Script also pulls out sender information into a contacts sheet. Spreadsheet owners can easily view all messages by sender.
Watching Gmail inbox
The script periodically watches a pre-specified Gmail inbox for new incoming messages.
When new messages arrive, the script process them and parses their information into a Google Sheet
Sender CRM
The script pulls out the sender information from each messages, separting out the sender's name and their email address.
The script checks whether the email address is already captured in the sheet. If it's not then the script adds the new user to the sheet.
Message storage
The script pulls information about each message onto a separate sheet. The script checks whether the message ID is already captured in the sheet, and if it's not then the script adds in the new message.
The script pulls the sender's email address together with the message information. This enables grouping and viewing all messages by a given sender.