You may know how to create a Google Alert, but did you know you can easily push those Google alerts to Google Sheets?
If you don’t already know how to create a Google Alert, we’ll show you how to set them up in this article. It’s easy!
We’ll also show you how to go one step further. We’ll show you how to exports alerts of your name, brand, or products to a Google Sheets tracking spreadsheet.
How to Create a Google Alert
Google Alerts are simple notifications you can receive by email any time a specific word or phrase appears on the internet.
For example, I have an alert set up to alert me of new mentions of “Naomi Assaraf.” As a result, I get an email any time Google finds a mention of my name on the web.
Here’s one I received a few days ago after we published a press release that included a quote from me:
Here’s how to set up a new Google Alert for yourself.
1. Visit the Google Alerts setup page
Start by visiting the Google Alerts setup page, where you can choose what alerts you want to receive.
2. Enter the word or phrase you want to monitor
In the alert box, enter the word or phrase you want to monitor using exactly the phasing you want Google to send alerts for.
For example, if you want to monitor a phrase like “Chicago real estate agent” make sure to enter that exact phrase in the alerts box.
As you can see, I have two alerts already created in this account, one for my name and the other for “cloudHQ.”
And that’s it!
After you’ve saved your Google Alert, you’ll get an email any time Google finds a new mention of that word or phrase.
How to Save Google Alerts to Google Sheets
Once you’ve created your Google Alert, you’ll start getting emails any time your word or phrase appears on the internet. That’s a great start, but those alerts will stay buried in your inbox unless you export and organize them somehow.
For example, maybe you’d like to create a weekly or monthly report that shows every new mention of your company’s name.
If you use Gmail, you can use Export Emails to Sheets, a free Chrome extension that adds an export wizard to your inbox. With a few clicks, you can create an organized spreadsheet that includes all the information from your Google Alerts.
Here’s how to use Export Emails to Sheets:
1. Install Export Email to Sheets
Start by installing the Export Email to Sheets, Excel, or CSV Chrome extension from the Chrome Web Store.
The extension installs in seconds and is free to use for anyone with a Gmail account.
2. Click the Export to Sheets icon
Once you’ve installed the Chrome extension, you’ll see a new icon at the top of your Gmail inbox.
Click the wizard icon to open a menu of exporting options.
3. Choose “Parse Google Alerts”
From the wizard menu, choose “Parse Google Alerts.”
From there, simply follow the wizard instructions to export your Google Alerts to a Google Sheet.
Try It for Yourself!
Both tools take less than a minute to set up and use, so try them out for yourself!