{"__v":1,"_id":"55c385e357f7f32d0016ed2a","category":{"__v":7,"_id":"55a7fefa3efe0c2f0074cbdf","pages":["55a7ff621fa1a53b006915e6","55a8086a8b9fdf0d00117087","55c3409857f7f32d0016ebf4","55c37a438713ec1900d17467","55c385e357f7f32d0016ed2a","55c386b0b6e05719008a0544","55c38a07b6e05719008a0554"],"project":"55a7aee84a33f92b00b7a150","version":"55a7aee84a33f92b00b7a153","sync":{"url":"","isSync":false},"reference":false,"createdAt":"2015-07-16T18:59:06.950Z","from_sync":false,"order":4,"slug":"google-sheets-add-on","title":"Google Sheets Add-on"},"parentDoc":null,"project":"55a7aee84a33f92b00b7a150","user":"55a7ae50bf1be93100d89df1","version":{"__v":6,"_id":"55a7aee84a33f92b00b7a153","project":"55a7aee84a33f92b00b7a150","createdAt":"2015-07-16T13:17:28.411Z","releaseDate":"2015-07-16T13:17:28.411Z","categories":["55a7aee94a33f92b00b7a154","55a7fefa3efe0c2f0074cbdf","55a8fb10c8bd450d000dd130","55a936b1cf45e1390093f362","55abddeaa36ccd0d00fdebe1","5624db675a86b423009462e1"],"is_deprecated":false,"is_hidden":false,"is_beta":false,"is_stable":true,"codename":"","version_clean":"1.0.0","version":"1.0"},"updates":[],"next":{"pages":[],"description":""},"createdAt":"2015-08-06T16:05:55.679Z","link_external":false,"link_url":"","githubsync":"","sync_unique":"","hidden":false,"api":{"results":{"codes":[]},"settings":"","auth":"required","params":[],"url":""},"isReference":false,"order":4,"body":"You can use the Text Analysis add-on to easily collect and analyze blog posts and news articles from within your Google Spreadsheets:\n[block:embed]\n{\n  \"html\": \"<iframe class=\\\"embedly-embed\\\" src=\\\"//cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2Fv_ceVH8732Q%3Ffeature%3Doembed&url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Dv_ceVH8732Q&image=https%3A%2F%2Fi.ytimg.com%2Fvi%2Fv_ceVH8732Q%2Fhqdefault.jpg&key=02466f963b9b4bb8845a05b53d3235d7&type=text%2Fhtml&schema=youtube\\\" width=\\\"854\\\" height=\\\"480\\\" scrolling=\\\"no\\\" frameborder=\\\"0\\\" allowfullscreen></iframe>\",\n  \"url\": \"https://www.youtube.com/watch?v=v_ceVH8732Q\",\n  \"title\": \"How to analyze URL's in Google Sheets\",\n  \"favicon\": \"https://s.ytimg.com/yts/img/favicon-vflz7uhzw.ico\",\n  \"image\": \"https://i.ytimg.com/vi/v_ceVH8732Q/hqdefault.jpg\"\n}\n[/block]\nSee also:\n\n- [Build an Automated Content Curation Tool in Google Sheets](http://blog.aylien.com/post/123123618058/build-an-automated-content-curation-tool-in-google) - AYLIEN Blog\n- [How to Analyze your Competitors Content With This Simple Google Sheets Hack](http://blog.aylien.com/post/114499910028/how-to-analyze-your-competitors-content-with-this) - AYLIEN Blog","excerpt":"","slug":"blog-news-analysis","type":"basic","title":"Blog & News Analysis"}

Blog & News Analysis


You can use the Text Analysis add-on to easily collect and analyze blog posts and news articles from within your Google Spreadsheets: [block:embed] { "html": "<iframe class=\"embedly-embed\" src=\"//cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2Fv_ceVH8732Q%3Ffeature%3Doembed&url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Dv_ceVH8732Q&image=https%3A%2F%2Fi.ytimg.com%2Fvi%2Fv_ceVH8732Q%2Fhqdefault.jpg&key=02466f963b9b4bb8845a05b53d3235d7&type=text%2Fhtml&schema=youtube\" width=\"854\" height=\"480\" scrolling=\"no\" frameborder=\"0\" allowfullscreen></iframe>", "url": "https://www.youtube.com/watch?v=v_ceVH8732Q", "title": "How to analyze URL's in Google Sheets", "favicon": "https://s.ytimg.com/yts/img/favicon-vflz7uhzw.ico", "image": "https://i.ytimg.com/vi/v_ceVH8732Q/hqdefault.jpg" } [/block] See also: - [Build an Automated Content Curation Tool in Google Sheets](http://blog.aylien.com/post/123123618058/build-an-automated-content-curation-tool-in-google) - AYLIEN Blog - [How to Analyze your Competitors Content With This Simple Google Sheets Hack](http://blog.aylien.com/post/114499910028/how-to-analyze-your-competitors-content-with-this) - AYLIEN Blog