Tools - Extracting
Search, plus Your World
The Fine Art of Reverse Searching on Images - Being Social Us
Tips & Tricks
Get More Into YouTube
Google Demo Slam
Google Spreadsheets supports cell formulas typically found in most desktop spreadsheet packages. These formulas can be used to create functions that manipulate data and calculate strings and numbers. Here's a list of all the functions available in each category.
Transforming Text Into Knowledge AlchemyAPI provides advanced cloud-based and on-premise text analysis infrastructure that eliminates the expense and difficulty of integrating natural language processing systems into your application, service, or data processing pipeline. AlchemyAPI provides a scalable platform for analyzing web pages, documents and tweets along with flexible APIs for easy integration. AlchemyAPI is trusted by customers in over 36 countries to process over 3 billion documents per month.
In Using Google Reader to create a searchable archive of Twitter mentions Alan Cann commented: Subscribing to RSS feeds in Google Reader is my bog standard way of archiving Twitter feeds. Now to figure out how to get an RSS feed from a Google+ hashtag… Lets look at how it might be possible. So there’s no visible RSS feed from the Google+ Search page. Turning Google+ Search results into a RSS feed (for Google Reader)
I have a google spreadsheet that fetches some data via RSS. The RSS feed is updated once a day, everyday. Is it possible for me to keep archive of all the new & historic data in the google spreadsheet? Google Spreadsheet: Auto-Update via RSS (and keep history)
ImportFeed in Google Docs Tutorial - Use Google Docs as an RSS Reader This tutorial shows how to use a Google Docs spreadsheet as an RSS Feed reader. You can also aggregate news feeds from different sources into one spreadsheet similar to Popurls and Alltop. This tutorial shows how to use a Google Docs spreadsheet as an RSS Feed reader (see example).
How to get RSS into Excel: Google docs for analysing online buzz
HOW TO: Search Twitter from Google Spreadsheets and Excel Twitter search is the only usable (and useful!) social media search tool I’ve been using since it was Summize. It has turned invaluable for many essential tasks: Track your brand mentions: Be sure to check out these cool ideas on various ways to search Twitter to effectively track your brand mentions.Monitor new link building opportunities (e.g. guest post invites or citation requests).Monitor any twitter hashtag (e.g. your company Twitter chat or conference): collect and visualize Tweets around a conference hashtag and easily publish it to the web! Besides using Twitter search a lot, I love using Spreadsheet-type documents to analyze it.
Add Images to your Google Docs Spreadsheet Cells You can now add images and icons to individual cells of a Google Docs spreadsheet using the IMAGE formula. While it has always been possible to add images to the canvas of your Google Docs spreadsheets, you can now insert images inside individual cells as well. To add an image to a cell, highlight the cell, click F2 to enter the formula mode and then type =image(“URL”) where URL is the public web address of that image.
Fetching tweets to Excel/Word/PPT/Google Docs | AutomateAnalytics.com Update: due to changes made by Twitter, this script does not work at the moment. We have published a new version that is now included in our Supermetrics Functions product. Our project of the day: creating a solution for fetching a list of tweets by keyword from Twitter to Excel. There are lots of Twitter statistics apps out there, but it's quite nice being able to fetch tweets to Excel, as there you can conveniently do all kinds of additional analysis like sentiment scoring, either manually or with automation, and control all the steps in the analysis process yourself.