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 thoughts on “Google Alerts to Google Spreadsheet”
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
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…