Damien mentioned at his Online PR workshop on Saturday that there was a way to capture Google Alerts in a spreadsheet rather than into your inbox. Handy, no? So I had a look into it. Below is the how-to.
Sorry about the image quality, not sure what WordPress is doing to my images :(#
1. Set up your Google Alert and be sure to select Feed from the Deliver to: dropdown list
2. Get your feed URL
3. Create a new Google Spreadsheet in Google Docs, select a cell and select the Forumlas button. Choose Google from the category listing presented and then double-click on ImportFeed.
4. When you get the space to pop your info into, blank out what’s in between the brackets and add in your feed URL. Make sure it’s wrapped in double quotes or else it won’t work. Hit enter and away you go.
You must be logged in to post a comment.
Lovely, didn’t know about those functions in Google Docs – thanks
Thanks for going to the trouble to post that. Also saw it on Damien’s course, but hadn’t gotten around to following up on it yet. This has saved me the trouble
Hi,
Any idea why the sheet stops filling after it hits 20 lines? This renders the whole exercise sort if irrelevant, since 20 alerts is a pretty small number…
Thanks,
Rob