Export Google Alerts to a spreadsheet

In this article we'll describe the easiest way to export Google Alerts emails to a spreadsheet or to any database or application using Parseur. It will only take you 2 minutes!

Export Google Alerts to a spreadsheet cover image

Google Alerts are awesome but export is a problem

Google Alerts is a powerful (and free) business intelligence tool for monitoring an industry, a reputation or a competitor. Its ease of use make it a must have for any company that wants to keep on top of the latest trends in its market. However, Google doesn't make it easy to export Google alerts to a spreadsheet.

In fact, Google doesn't allow you to export alerts as CSV or XLS at all. All that Google Alerts can do is sending you an email (or RSS) when a new result matches your search criteria. That makes it hard to analyze the data for tracking purposes or to check trends and volumes. Especially if you have an alert set on a high volume keyword, you need to put that data in a spreadsheet or database for deeper analysis. You may even consider doing machine learning or other Artificial Intelligence approach if your volume is very large.

Google Alerts doesn't let you download your alerts as CSV

Google Alerts doesn't let you download your alerts as CSV

Since google sends you emails, we are going to solve that problem by using a mail parser. A mail parser is a tool that can convert emails content into workable data. So what we're going to do is to use an email parser to transform Google Alert notifications into properly formatted data that we can download as CSV, Excel, or update directly into a Google Sheets or any application.

Parseur is an email parser that comes packed with a ready-made template for Google Alerts.

Let's see how it works!

Step 1: Create a Parseur account

If you don't have an account already, create a Parseur account. Parseur is totally and forever free for a limited number of emails sent per month.

Step 2: Create a mailbox

Once your account is created, enter a name for your Google Alert mailbox.

You can enter anything you'd like.

Enter a name for your Parseur mailbox

Enter a name for your Parseur mailbox

Step 3: forward your Google Alerts to your mailbox

On the next screen, Parseur will ask you to forward your first Google Alert email.

Parseur awaits you to forward your first email

Parseur awaits you to forward your first email

Click on the copy-to-clipboard button to the right of the email address to it.

Go to your Gmail inbox and forward one of your google alerts to your Parseur mailbox (paste the email address you just copied into the To field)

Forward a google alert to the email address Parseur just gave you

Forward a google alert to the email address Parseur just gave you

Go back to Parseur, and wait for the email to arrive (it usually takes less than 10 seconds).

Once the email arrived it will be processed automatically.

Your Google Alert email was processed automatically!

Your Google Alert email was processed automatically!

Click on Check result to see the extracted data.

Parseur extract the following information from each alert email:

  • Keyword term
  • Date of the alert
  • Set of results containing for each alert:
    • the name of the Website
    • the name of the Page
    • the URL
    • an Except of the page
Extracted text is on the right

Extracted text is on the right

Note: Parseur can process alerts that contain only one keyword. In case you set up Google Alerts to send a digest, you can change that setting here: click on the cog icon and uncheck the Digest box.

Step 4: automate processing of Google Alerts

Now, go ahead and forward more Google Alerts and see them all getting processed automatically.

Now you can set up an automated rule to forward all new incoming alerts to Parseur. Also, if you have a backlog of existing Google Alerts you would like to parse, you could use a chrome extension to forward them all at once to Parseur. Check out this article to learn more about how to automatically forward emails to Parseur.

All your Google Alerts data is automatically extracted!

All your Google Alerts data is automatically extracted!

Step 5: download or send your data where it belongs

Now you can use your alert data in any way you see fit.

  • Download as Excel or CSV
  • Open in Google Sheet
  • Send to hundreds of applications and databases using our integration with Zapier. Make sure to use the New Table Processed trigger for best results

To access all export options, go to the Export section on the left-hand menu.

Example of a google sheet populated by Parseur Google Alert parser

Example of a google sheet populated by Parseur Google Alert parser

That's it! You now know how to easily export Google Alerts to your spreadsheet.

Last updated:

Parseur is the most powerful and easy-to-use mail parser.
Save hours of manual work and improve your data entry speed and quality.

Sign up now