{"id":1102,"date":"2013-08-31T13:01:07","date_gmt":"2013-08-31T13:01:07","guid":{"rendered":"http:\/\/inspiredtoeducate.net\/inspiredtoeducate\/?p=1102"},"modified":"2013-08-31T13:01:07","modified_gmt":"2013-08-31T13:01:07","slug":"connecting-your-favorite-google-services-using-google-app-script","status":"publish","type":"post","link":"http:\/\/inspiredtoeducate.net\/inspiredtoeducate\/connecting-your-favorite-google-services-using-google-app-script\/","title":{"rendered":"Connecting Your Favorite Google Services Using Google App Script"},"content":{"rendered":"\n<!-- Facebook Like Button v1.9.6 BEGIN [http:\/\/blog.bottomlessinc.com] -->\n<iframe src=\"http:\/\/www.facebook.com\/plugins\/like.php?href=http%3A%2F%2Finspiredtoeducate.net%2Finspiredtoeducate%2Fconnecting-your-favorite-google-services-using-google-app-script%2F&amp;layout=standard&amp;show_faces=false&amp;width=450&amp;action=like&amp;colorscheme=light\" scrolling=\"no\" frameborder=\"0\" allowTransparency=\"true\" style=\"border:none; overflow:hidden; width:450px; height: 30px; align: left; margin: 2px 0px 2px 0px\"><\/iframe>\n<!-- Facebook Like Button END -->\n<p><a href=\"http:\/\/inspiredtoeducate.net\/changella\/wp-content\/uploads\/2013\/08\/GoogleAppsScript.jpg\"><img loading=\"lazy\" class=\"alignnone size-medium wp-image-213\" src=\"http:\/\/inspiredtoeducate.net\/changella\/wp-content\/uploads\/2013\/08\/GoogleAppsScript-300x115.jpg\" alt=\"Google App Script\" width=\"300\" height=\"115\" \/><\/a><\/p>\n<p>Through Google Documents, Google provides amazing web based tools for students, businesses, and educators. \u00a0 During a <a href=\"https:\/\/sites.google.com\/site\/gdgmerceru\/\" target=\"_blank\">Google Developer Group meeting at Mercer University<\/a>, \u00a0I was introduced to a cool programming technology enabling developers to customize Google App experiences using JavaScript. \u00a0 Using Google App Script, you can automate tasks and connect Google products to together. \u00a0 You can also connect apps to third-party data sources and API&#8217;s.<\/p>\n<p><strong>Why Would You Use Google App Script?<\/strong><\/p>\n<p>Dr. Robert Allen from the Google Developers Group shared his experiences in building a grade book application for his classes. \u00a0 In the past, Dr. Allen would manually construct grade book spreadsheets based on a class roster. \u00a0 His clever grade book application works in the following manner:<\/p>\n<p>1) On the first day of class, students fill out a Google form with their name and gmail e-mail address.<\/p>\n<p>2) After Dr. Allen captures the class roster from the students, he presses a &#8220;generate grade book&#8221; button that constructs his grade book.<\/p>\n<p>3) Dr. Allen wanted students to be able to track their grades as he documented them in his Google Spreadsheet. \u00a0He, however, wanted to make sure students could not see the grades of another. \u00a0 His Google App Script generated &#8220;read only&#8221; data sheets so that students can only see their data. \u00a0 The data sheets were shared with the student automatically.<\/p>\n<p>4) As Dr. Allen posts grades to his master Google Spreadsheet, he can press a &#8220;publish&#8221; button to distribute the updated grade information to the &#8220;readonly&#8221; spreadsheets.<\/p>\n<p>In the example, Dr. Allen used Google spreadsheets, Google Forms, and programming functions to share data.<\/p>\n<p>Using Google App Script, you can connect all of the following Google products together to solve a broad range of use cases and business problems: \u00a0Calendar, \u00a0Contacts, \u00a0Document, \u00a0Drive, \u00a0Finance, \u00a0Forms, \u00a0Gmail, \u00a0Groups, \u00a0Language, Maps, \u00a0Sites, \u00a0and Spreadsheet.<\/p>\n<p><strong>What else can Google App Script Do?<\/strong><\/p>\n<ul>\n<li><span style=\"line-height: 13px;\">Google App Script can be used to create small web applications.<\/span><\/li>\n<li>Create custom functions in Google Spreadsheet<\/li>\n<li>Create Google Sites Gadgets<\/li>\n<li>Check out the Google Developers Blog to learn more about how people leverage \u00a0<a href=\"http:\/\/googleappsdeveloper.blogspot.com\/search\/label\/Apps%20Script\" target=\"_blank\">Google App Script<\/a>.<\/li>\n<\/ul>\n<p><strong>How do you get started with Google App Script?<\/strong><\/p>\n<p>The following video provides a nice introduction to Google App Script concepts.<\/p>\n<p><iframe loading=\"lazy\" src=\"\/\/www.youtube.com\/embed\/K2uLzJdEVCA\" frameborder=\"0\" width=\"560\" height=\"315\"><\/iframe><\/p>\n<p><em>Abstract: \u00a0\u00a0This video is a recording of our Introduction to Apps Script. \u00a0 \u00a0Eric Koleda, a Developer Programs Engineer at Google, covers what Apps Script, use cases, code examples, and hold q&amp;a. Check out\u00a0<a href=\"https:\/\/developers.google.com\/apps-script\/\" target=\"_blank\">https:\/\/developers.google.com\/apps-script\/<\/a>\u00a0to learn more or get started!<\/em><\/p>\n<p>Check out more videos from Google I\/O conference <a href=\"http:\/\/www.youtube.com\/results?search_query=google+i%2Fo+app+script+2013&amp;oq=google+i%2Fo+app+script+2013&amp;gs_l=youtube.3...39298.41070.0.41247.7.6.1.0.0.0.137.414.3j1.4.0...0.0...1ac.1.11.youtube.42dfRIj4myQ\" target=\"_blank\">here<\/a>.<\/p>\n<p>You program Google App Scripts using the popular language JavaScript. \u00a0 If you&#8217;re interested in learning this language, check out the following links:<\/p>\n<ul>\n<li><a href=\"http:\/\/codeacademy.com\/\" target=\"_blank\">CodeAcademy.com<\/a><\/li>\n<li><a href=\"http:\/\/eloquentjavascript.net\/contents.html\">http:\/\/eloquentjavascript.net\/<\/a><\/li>\n<\/ul>\n<p>Google provides nice tutorials and learning resources here:<\/p>\n<ul>\n<li><a href=\"https:\/\/developers.google.com\/apps-script\/\">https:\/\/developers.google.com\/apps-script\/<\/a><\/li>\n<li><strong>Quickstart: Macros, menus, and custom functions:\u00a0<\/strong><a href=\"https:\/\/developers.google.com\/apps-script\/quickstart\/macros\" target=\"_blank\">https:\/\/developers.google.com\/apps-script\/quickstart\/macros<\/a><\/li>\n<li><strong>Quickstart: Managing responses for Google Forms:\u00a0<\/strong><a href=\"https:\/\/developers.google.com\/apps-script\/quickstart\/forms\" target=\"_blank\">https:\/\/developers.google.com\/apps-script\/quickstart\/forms<\/a><\/li>\n<\/ul>\n<p>We love to hear from our readers. \u00a0Let&#8217;s keep the conversation going. \u00a0What types of tasks would you like to see automated? What tasks keep you away from the work that you really enjoy?<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Top Posts On Changella<\/strong><\/p>\n<ul>\n<li><a title=\"Join The Makers Revolution\" href=\"http:\/\/inspiredtoeducate.net\/changella\/join-the-makers-revolution\/\" target=\"_blank\">Join The Makers Revolution<\/a><\/li>\n<li><a title=\"Jennifer Pahika challenges us to \u201ccode a better government\u201d\" href=\"http:\/\/inspiredtoeducate.net\/changella\/jennifer-pahika-challenges-us-to-code-a-better-government\/\" target=\"_blank\">Jennifer Pahika challenges us to \u201ccode a better government\u201d<\/a><\/li>\n<li><a title=\"Join Google Developer Group at Mercer University\" href=\"http:\/\/inspiredtoeducate.net\/changella\/join-google-developer-group-at-mercer-university\/\" target=\"_blank\">Join Google Developer Group at Mercer University<\/a><\/li>\n<li><a title=\"7 Blogs To Kick Start Your Next Business Venture\" href=\"http:\/\/inspiredtoeducate.net\/changella\/7-blogs-to-kick-start-your-next-business-venture\/\" target=\"_blank\">7 Blogs To Kick Start Your Next Business Venture<\/a><\/li>\n<li><a title=\"Apps To Deal With College Stress\" href=\"http:\/\/inspiredtoeducate.net\/changella\/apps-to-deal-with-college-stress\/\" target=\"_blank\">Apps To Deal With College Stress<\/a><\/li>\n<\/ul>\n<p>Make sure to connect with us on Twitter at \u00a0<a href=\"http:\/\/www.twitter.com\/changella\" target=\"_blank\">http:\/\/www.twitter.com\/changella<\/a>.<\/p>\n\n<!-- Facebook Like Button v1.9.6 BEGIN [http:\/\/blog.bottomlessinc.com] -->\n<iframe src=\"http:\/\/www.facebook.com\/plugins\/like.php?href=http%3A%2F%2Finspiredtoeducate.net%2Finspiredtoeducate%2Fconnecting-your-favorite-google-services-using-google-app-script%2F&amp;layout=standard&amp;show_faces=false&amp;width=450&amp;action=like&amp;colorscheme=light\" scrolling=\"no\" frameborder=\"0\" allowTransparency=\"true\" style=\"border:none; overflow:hidden; width:450px; height: 30px; align: left; margin: 2px 0px 2px 0px\"><\/iframe>\n<!-- Facebook Like Button END -->\n","protected":false},"excerpt":{"rendered":"<p>Through Google Documents, Google provides amazing web based tools for students, businesses, and educators. \u00a0 During a Google Developer Group meeting at Mercer University, \u00a0I was introduced to a cool programming technology enabling developers to customize Google App experiences using JavaScript. \u00a0 Using Google App Script, you can automate tasks [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[23,8],"tags":[],"_links":{"self":[{"href":"http:\/\/inspiredtoeducate.net\/inspiredtoeducate\/wp-json\/wp\/v2\/posts\/1102"}],"collection":[{"href":"http:\/\/inspiredtoeducate.net\/inspiredtoeducate\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/inspiredtoeducate.net\/inspiredtoeducate\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/inspiredtoeducate.net\/inspiredtoeducate\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/inspiredtoeducate.net\/inspiredtoeducate\/wp-json\/wp\/v2\/comments?post=1102"}],"version-history":[{"count":3,"href":"http:\/\/inspiredtoeducate.net\/inspiredtoeducate\/wp-json\/wp\/v2\/posts\/1102\/revisions"}],"predecessor-version":[{"id":1105,"href":"http:\/\/inspiredtoeducate.net\/inspiredtoeducate\/wp-json\/wp\/v2\/posts\/1102\/revisions\/1105"}],"wp:attachment":[{"href":"http:\/\/inspiredtoeducate.net\/inspiredtoeducate\/wp-json\/wp\/v2\/media?parent=1102"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/inspiredtoeducate.net\/inspiredtoeducate\/wp-json\/wp\/v2\/categories?post=1102"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/inspiredtoeducate.net\/inspiredtoeducate\/wp-json\/wp\/v2\/tags?post=1102"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}