{"__v":16,"_id":"55c37a438713ec1900d17467","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-06T15:16:19.810Z","link_external":false,"link_url":"","githubsync":"","sync_unique":"","hidden":false,"api":{"results":{"codes":[]},"settings":"","auth":"required","params":[],"url":""},"isReference":false,"order":1,"body":"Getting started with Text Analysis for Google Sheets is easy and you can be up and running in a matter of minutes. Check out our walkthroughs and videos in this section.\n\n<a href=\"https://chrome.google.com/webstore/detail/text-analysis/bhgojekhekigceifapkmgbibgfmdicno?hl=en&gl=US&authuser=0\" target=\"_blank\" class=\"btn btn-lg btn-success\" style=\"margin: 0 auto; display: block; width: 30%; color: #fff;\"><i class=\"fa fa-cloud-download\"></i> Install Text Analysis</a>\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%2FUrbVpLCtJsA%3Ffeature%3Doembed&url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DUrbVpLCtJsA&image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FUrbVpLCtJsA%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=UrbVpLCtJsA\",\n  \"title\": \"Getting started with the AYLIEN Text Analysis Add-on for Google Sheets.\",\n  \"favicon\": \"https://s.ytimg.com/yts/img/favicon-vflz7uhzw.ico\",\n  \"image\": \"https://i.ytimg.com/vi/UrbVpLCtJsA/hqdefault.jpg\"\n}\n[/block]\n\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Step One\"\n}\n[/block]\nClick [here](http://g.co/newsheets) to create a new Spreadsheet, and then install the the Text Analysis Add-on by navigating to **Add-ons > Get add-ons...** and searching for \"text analysis\" or \"aylien\" in the Add-on store.\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/QlRU0D9MQ2m8RMSuMJ42_Step1.png\",\n        \"Step1.png\",\n        \"645\",\n        \"315\",\n        \"#3c866b\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\n\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/gFi5aK6QqmppJ8K5C08C_Step1_1.png\",\n        \"Step1_1.png\",\n        \"1280\",\n        \"800\",\n        \"#18423c\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\n\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Step Two\"\n}\n[/block]\nNavigate to the Add-ons section in your Sheets toolbar and under the Text Analysis drop down, click Start (this will open the Text Analysis sidebar in the right-hand side of your Google Sheet)\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/NluIF15uSmq2GXUpnLiJ_Step2.png\",\n        \"Step2.png\",\n        \"878\",\n        \"347\",\n        \"#313e80\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\n\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Step Three\"\n}\n[/block]\nAdd some Text or URLs anywhere on your Spreadsheet, and make sure you've selected the range you wish to analyze:\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/VpZQYocTAWq6DE2TyuEX_Step3.png\",\n        \"Step3.png\",\n        \"810\",\n        \"608\",\n        \"#426cd0\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\n\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Step Four\"\n}\n[/block]\nChoose the analysis tasks you wish to perform from the Add-on sidebar and hit Analyze:\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/cQReBfcvTbagTOPZPkBI_Step4.png\",\n        \"Step4.png\",\n        \"605\",\n        \"633\",\n        \"#4258a6\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\n\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Step Five\"\n}\n[/block]\nThe results of your analysis will be added to your sheet, to the right of the selected range.\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/lkkYr4tJQqtBkvbM98fA_Step5.png\",\n        \"Step5.png\",\n        \"1280\",\n        \"800\",\n        \"#2c57a6\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\nYou are now ready to create charts and reports based on these results.","excerpt":"","slug":"getting-started","type":"basic","title":"Getting Started"}
Getting started with Text Analysis for Google Sheets is easy and you can be up and running in a matter of minutes. Check out our walkthroughs and videos in this section. <a href="https://chrome.google.com/webstore/detail/text-analysis/bhgojekhekigceifapkmgbibgfmdicno?hl=en&gl=US&authuser=0" target="_blank" class="btn btn-lg btn-success" style="margin: 0 auto; display: block; width: 30%; color: #fff;"><i class="fa fa-cloud-download"></i> Install Text Analysis</a> [block:embed] { "html": "<iframe class=\"embedly-embed\" src=\"//cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FUrbVpLCtJsA%3Ffeature%3Doembed&url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DUrbVpLCtJsA&image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FUrbVpLCtJsA%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=UrbVpLCtJsA", "title": "Getting started with the AYLIEN Text Analysis Add-on for Google Sheets.", "favicon": "https://s.ytimg.com/yts/img/favicon-vflz7uhzw.ico", "image": "https://i.ytimg.com/vi/UrbVpLCtJsA/hqdefault.jpg" } [/block] [block:api-header] { "type": "basic", "title": "Step One" } [/block] Click [here](http://g.co/newsheets) to create a new Spreadsheet, and then install the the Text Analysis Add-on by navigating to **Add-ons > Get add-ons...** and searching for "text analysis" or "aylien" in the Add-on store. [block:image] { "images": [ { "image": [ "https://files.readme.io/QlRU0D9MQ2m8RMSuMJ42_Step1.png", "Step1.png", "645", "315", "#3c866b", "" ] } ] } [/block] [block:image] { "images": [ { "image": [ "https://files.readme.io/gFi5aK6QqmppJ8K5C08C_Step1_1.png", "Step1_1.png", "1280", "800", "#18423c", "" ] } ] } [/block] [block:api-header] { "type": "basic", "title": "Step Two" } [/block] Navigate to the Add-ons section in your Sheets toolbar and under the Text Analysis drop down, click Start (this will open the Text Analysis sidebar in the right-hand side of your Google Sheet) [block:image] { "images": [ { "image": [ "https://files.readme.io/NluIF15uSmq2GXUpnLiJ_Step2.png", "Step2.png", "878", "347", "#313e80", "" ] } ] } [/block] [block:api-header] { "type": "basic", "title": "Step Three" } [/block] Add some Text or URLs anywhere on your Spreadsheet, and make sure you've selected the range you wish to analyze: [block:image] { "images": [ { "image": [ "https://files.readme.io/VpZQYocTAWq6DE2TyuEX_Step3.png", "Step3.png", "810", "608", "#426cd0", "" ] } ] } [/block] [block:api-header] { "type": "basic", "title": "Step Four" } [/block] Choose the analysis tasks you wish to perform from the Add-on sidebar and hit Analyze: [block:image] { "images": [ { "image": [ "https://files.readme.io/cQReBfcvTbagTOPZPkBI_Step4.png", "Step4.png", "605", "633", "#4258a6", "" ] } ] } [/block] [block:api-header] { "type": "basic", "title": "Step Five" } [/block] The results of your analysis will be added to your sheet, to the right of the selected range. [block:image] { "images": [ { "image": [ "https://files.readme.io/lkkYr4tJQqtBkvbM98fA_Step5.png", "Step5.png", "1280", "800", "#2c57a6", "" ] } ] } [/block] You are now ready to create charts and reports based on these results.