{"id":1,"date":"2024-06-11T21:15:37","date_gmt":"2024-06-11T21:15:37","guid":{"rendered":"http:\/\/www.guiagas.cat\/?p=1"},"modified":"2026-06-15T21:36:01","modified_gmt":"2026-06-15T21:36:01","slug":"comencem_apps_script","status":"publish","type":"post","link":"https:\/\/www.guiagas.cat\/index.php\/2024\/06\/11\/comencem_apps_script\/","title":{"rendered":"Comencem amb Apps Script"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"1\" class=\"elementor elementor-1\">\n\t\t\t\t<div class=\"elementor-element elementor-element-52c883e7 e-flex e-con-boxed e-con e-parent\" data-id=\"52c883e7\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-7cb4298d elementor-widget elementor-widget-text-editor\" data-id=\"7cb4298d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Arribats aqu\u00ed, ens podem preguntar, i amb aix\u00f2 d&#8217;Apps Script com es comen\u00e7a? He vist molts de v\u00eddeos curts i llargs fent coses molt xules, per\u00f2 des d&#8217;on es comen\u00e7a si ho vull fer des de zero? Permeten que us doni l&#8217;enhorabona ja que has arribat al lloc idoni.<\/p>\n<p>Hem preparat una s\u00e8rie de v\u00eddeos introductoris&nbsp; que responen a totes els preguntes que ens poden sorgir al comen\u00e7ar.&nbsp;<\/p>\n<p>Despr\u00e9s del salt podreu veure el primer en el que explico com accedir a l&#8217;entorn de programaci\u00f3. Pot semblar obvi per\u00f2 ho necessitarem per poder comen\u00e7ar.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-017cb0d elementor-widget elementor-widget-video\" data-id=\"017cb0d\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;youtube_url&quot;:&quot;https:\\\/\\\/youtu.be\\\/e_ugKY33EEQ&quot;,&quot;start&quot;:1,&quot;end&quot;:153,&quot;video_type&quot;:&quot;youtube&quot;,&quot;controls&quot;:&quot;yes&quot;}\" data-widget_type=\"video.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-wrapper elementor-open-inline\">\n\t\t\t<div class=\"elementor-video\"><\/div>\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-cccaf16 e-flex e-con-boxed e-con e-parent\" data-id=\"cccaf16\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-7855121 elementor-widget elementor-widget-heading\" data-id=\"7855121\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Qu\u00e8 hem vist en aquest v\u00eddeo?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-08f6928 elementor-widget elementor-widget-text-editor\" data-id=\"08f6928\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Aqu\u00ed tens resumits<strong> els punts principals<\/strong> del primer v\u00eddeo:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7ea7b78 elementor-widget elementor-widget-text-editor\" data-id=\"7ea7b78\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol><li><strong><span class=\"ng-star-inserted\">Qu\u00e8 \u00e9s Google Apps Script?<\/span><\/strong><\/li><\/ol><p class=\"ng-star-inserted\"><span class=\"ng-star-inserted\">\u00c9s un llenguatge de programaci\u00f3 basat en\u00a0<\/span><strong class=\"ng-star-inserted\"><span class=\"ng-star-inserted\">JavaScript<\/span><\/strong><span class=\"ng-star-inserted\">\u00a0que s&#8217;executa totalment al n\u00favol. No cal que instal\u00b7lis res al teu ordinador; nom\u00e9s necessites el teu navegador i un compte de Google. Amb ell, pots crear funcions personalitzades, automatitzar correus, generar informes i connectar diferents aplicacions de Google entre si.<\/span><\/p><ol><li class=\"ng-star-inserted\"><span class=\"ng-star-inserted\">\u00a0<b>Com podem accedir a l&#8217;editor (IDE)?<\/b><\/span><\/li><\/ol><p class=\"ng-star-inserted\"><span class=\"ng-star-inserted\">Tal com hem vist al tutorial, hi ha tres vies principals per obrir l&#8217;entorn de desenvolupament:<\/span><\/p><ul class=\"ng-star-inserted\"><li class=\"ng-star-inserted\"><p class=\"ng-star-inserted\"><strong class=\"ng-star-inserted\"><span class=\"ng-star-inserted\">Des de Google Drive:<\/span><\/strong><span class=\"ng-star-inserted\">\u00a0Vas a\u00a0<\/span><span class=\"ng-star-inserted\">Nou &gt; M\u00e9s &gt; Scripts de Google Apps<\/span><span class=\"ng-star-inserted\">. Aix\u00f2 crea un projecte independent.<\/span><\/p><\/li><li class=\"ng-star-inserted\"><p class=\"ng-star-inserted\"><strong class=\"ng-star-inserted\"><span class=\"ng-star-inserted\">Des d&#8217;una aplicaci\u00f3 espec\u00edfica (com un Full de C\u00e0lcul):<\/span><\/strong><span class=\"ng-star-inserted\">\u00a0Dins del document, vas a\u00a0<\/span><span class=\"ng-star-inserted\">Extensions &gt; Apps Script<\/span><span class=\"ng-star-inserted\">. Aquesta \u00e9s la millor opci\u00f3 si vols que el codi actu\u00ef directament sobre les dades d&#8217;aquell fitxer.<\/span><\/p><\/li><li class=\"ng-star-inserted\"><p class=\"ng-star-inserted\"><strong class=\"ng-star-inserted\"><span class=\"ng-star-inserted\">A trav\u00e9s de la URL directa:<\/span><\/strong><span class=\"ng-star-inserted\">\u00a0Escrivint\u00a0<\/span><a class=\"ng-star-inserted\" href=\"https:\/\/www.google.com\/url?sa=E&amp;q=https%3A%2F%2Fscript.google.com\" target=\"_blank\" rel=\"noopener noreferrer\"><span class=\"ng-star-inserted\">script.google.com<\/span><\/a><span class=\"ng-star-inserted\">\u00a0al teu navegador per accedir al teu tauler de control personal on veur\u00e0s tots els teus projectes.<\/span><\/p><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-9e36e71 e-flex e-con-boxed e-con e-parent\" data-id=\"9e36e71\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-716e255 elementor-widget elementor-widget-text-editor\" data-id=\"716e255\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3 class=\"ng-star-inserted\"><strong><span class=\"ng-star-inserted\">Propers passos<\/span><\/strong><\/h3><p class=\"ng-star-inserted\"><span class=\"ng-star-inserted\">L&#8217;objectiu d&#8217;avui era perdre la por i saber on trobar l&#8217;eina. En el proper v\u00eddeo de la s\u00e8rie, entrarem de ple a analitzar la plataforma de gesti\u00f3 de projectes i com navegar per l&#8217;interf\u00edcie.<\/span><\/p><p class=\"ng-star-inserted\"><strong class=\"ng-star-inserted\"><span class=\"ng-star-inserted\">No t\u2019ho perdis!<\/span><\/strong><span class=\"ng-star-inserted\">\u00a0Visita\u00a0<\/span><strong class=\"ng-star-inserted\"><a class=\"ng-star-inserted\" href=\"https:\/\/www.google.com\/url?sa=E&amp;q=http%3A%2F%2Fguiagas.cat\" target=\"_blank\" rel=\"noopener noreferrer\"><span class=\"ng-star-inserted\">guiagas.cat<\/span><\/a><\/strong><span class=\"ng-star-inserted\">\u00a0per a m\u00e9s recursos i no oblidis subscriure&#8217;t al canal per estar al dia de totes les automatitzacions.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Arribats aqu\u00ed, ens podem preguntar, i amb aix\u00f2 d&#8217;Apps Script com es comen\u00e7a? He vist molts de v\u00eddeos curts i llargs fent coses molt xules, per\u00f2 des d&#8217;on es comen\u00e7a si ho vull fer des de zero? Permeten que us doni l&#8217;enhorabona ja que has arribat al lloc idoni. Hem preparat una s\u00e8rie de v\u00eddeos &#8230; <a title=\"Comencem amb Apps Script\" class=\"read-more\" href=\"https:\/\/www.guiagas.cat\/index.php\/2024\/06\/11\/comencem_apps_script\/\" aria-label=\"Read more about Comencem amb Apps Script\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-1","post","type-post","status-publish","format-standard","hentry","category-appscript"],"_links":{"self":[{"href":"https:\/\/www.guiagas.cat\/index.php\/wp-json\/wp\/v2\/posts\/1","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.guiagas.cat\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.guiagas.cat\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.guiagas.cat\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.guiagas.cat\/index.php\/wp-json\/wp\/v2\/comments?post=1"}],"version-history":[{"count":8,"href":"https:\/\/www.guiagas.cat\/index.php\/wp-json\/wp\/v2\/posts\/1\/revisions"}],"predecessor-version":[{"id":78,"href":"https:\/\/www.guiagas.cat\/index.php\/wp-json\/wp\/v2\/posts\/1\/revisions\/78"}],"wp:attachment":[{"href":"https:\/\/www.guiagas.cat\/index.php\/wp-json\/wp\/v2\/media?parent=1"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.guiagas.cat\/index.php\/wp-json\/wp\/v2\/categories?post=1"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.guiagas.cat\/index.php\/wp-json\/wp\/v2\/tags?post=1"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}