Staying on top of brand mentions, competitor updates, and industry news is essential for growth marketers, PR professionals, and product teams. Google Alerts is a fantastic, free tool that lets you monitor the web for specific keywords and sends summary emails whenever new articles or blog posts match your search query.
However, reading through daily Google Alerts emails and copying links into your marketing tracker or PR dashboard is a tedious manual task. By choosing to export Google Alerts to Google Sheets automatically, you can build a self-updating media monitoring board. In this tutorial, we will show you how to track Google Alerts in Google Sheets using Mail Sheet.
Why Log Google Alerts into a Spreadsheet?
Having a live spreadsheet of your brand alerts unlocks several advantages:
- Consolidated Monitoring: Instead of searching your inbox, you have a clean list of all web mentions.
- Team Collaboration: Share the sheet with your PR team or social media managers so they can review and engage with articles.
- Analytics and Sentiment: You can categorize mentions, label them as positive/negative/neutral, and graph your media growth over time.
Step 1: Set Up Your Google Alerts
First, navigate to Google Alerts. Create alerts for terms you want to monitor. Some ideas include:
- Your brand name (e.g.,
"Mail Sheet") - Your competitors' names (e.g.,
"Zapier"or"Integromat") - Key industry terms (e.g.,
"email automation tutorial")
Under Show options, make sure to set Deliver to to your Gmail address, and set the frequency to "Once a day" or "As-it-happens".
Step 2: Create a Label in Gmail
To keep things organized and prevent the parser from scanning unrelated emails, set up a Gmail filter:
- Search for emails from
googlealerts-noreply@google.com. - Create a filter that matches this sender.
- Choose the option to **Apply the label** and create a new label called
Google Alerts.
Step 3: Setup Mail Sheet
Open a Google Sheet named "Media Tracker" and launch the Mail Sheet add-on from the *Extensions* menu. In the sidebar, select your new label Google Alerts in the filter options. This limits the parser to only scan Google Alerts emails.
Step 4: AI Extraction Mode
Google Alerts emails contain lists of matching articles, each with a Title, Link, and Excerpt. Since the HTML structure of these emails can vary depending on the alerts, Mail Sheet’s AI Mode is the most robust way to extract this data.
Select **AI Mode** and input the prompt:
"Extract all matching search results. For each result, log the Publication Title, the URL Link, the Source Website Name, and the Snippet Excerpt into separate columns."
Mail Sheet will parse the structured HTML lists and create a new row for each individual article mention in your alerts.
Step 5: Turn on Auto-Run
Go to the **Automation** section in the Mail Sheet sidebar and toggle *Auto-Run* to run daily. Since Google Alerts sends updates once a day, Mail Sheet will check for new emails overnight and update your spreadsheet, giving you a fresh media report every morning.
Frequently Asked Questions
How often does Google Alerts send emails, and does that affect my spreadsheet?
Google Alerts can be set to deliver as-it-happens or in a once-a-day digest. If you choose the daily digest, set Mail Sheet's Auto-Run to check your inbox overnight so your Google Sheet is refreshed with a complete media report every morning.
Why does Mail Sheet recommend AI Mode instead of Filter Mode for Google Alerts emails?
Google Alerts emails list multiple articles per message, and the underlying HTML structure can vary depending on the search term and how many results were found. AI Mode can reliably identify each article's title, link, source, and excerpt even when the layout shifts, whereas keyword-based Filter Mode is better suited to consistent, single-value formats.
Do I need a Gmail label for Google Alerts before setting up Mail Sheet?
It is strongly recommended. Creating a Gmail filter that labels emails from googlealerts-noreply@google.com keeps Mail Sheet focused only on alert emails, preventing it from scanning unrelated messages and making your media tracking sheet more accurate.
Conclusion
Automating your Google Alerts tracking is a game-changer for digital PR and marketing teams. It saves hours of tedious logging, keeps your team aligned, and provides a structured database of your online presence.
Ready to build your media dashboard? Join the Mail Sheet waitlist.