{"id":825,"date":"2018-02-27T02:40:09","date_gmt":"2018-02-27T02:40:09","guid":{"rendered":"http:\/\/www.fditf.com\/bi\/?p=825"},"modified":"2023-08-10T15:56:13","modified_gmt":"2023-08-10T15:56:13","slug":"6-scripts-basicos-en-google-sheets-con-google-apps-script","status":"publish","type":"post","link":"https:\/\/www.fditf.com\/bi\/google-apps-script\/6-scripts-basicos-en-google-sheets-con-google-apps-script\/","title":{"rendered":"Ejemplos de Google Apps Script en Google Sheets"},"content":{"rendered":"<h2>Ejemplos de macros en Google Sheets (Google Apps Script).<\/h2>\n<p>Abre una hoja nueva de Google Sheets (la puedes crear desde este <a href=\"https:\/\/docs.google.com\/spreadsheets\/u\/0\/\" target=\"_blank\" rel=\"noopener noreferrer\">link<\/a>, considera que es necesaria una cuenta de Google). Cambia el nombre de la primera hoja, usa el nombre &#8220;<strong>ejemplo<\/strong>&#8220;. Despu\u00e9s ve al men\u00fa de herramientas, ah\u00ed est\u00e1 el editor de scripts:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-828 size-full\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/02\/img02-2.png\" alt=\"Google Apps Script\" width=\"664\" height=\"436\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/02\/img02-2.png 664w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/02\/img02-2-300x197.png 300w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/02\/img02-2-360x236.png 360w\" sizes=\"auto, (max-width: 664px) 100vw, 664px\" \/><\/p>\n<p>Copia el c\u00f3digo mostrado abajo, y p\u00e9galo en el editor; guarda el c\u00f3digo (click en el \u00edcono de guardar, usa el nombre que quieras):<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-829 size-full\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/02\/img03-1.png\" alt=\"Google Apps Script\" width=\"845\" height=\"422\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/02\/img03-1.png 845w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/02\/img03-1-300x150.png 300w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/02\/img03-1-768x384.png 768w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/02\/img03-1-360x180.png 360w\" sizes=\"auto, (max-width: 845px) 100vw, 845px\" \/><\/p>\n<p><script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<ins class=\"adsbygoogle\" style=\"display: block; text-align: center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-9033709093144000\" data-ad-slot=\"7741409798\"><\/ins><br \/>\n<script><br \/>\n     (adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n<p>C\u00f3digo:<\/p>\n<p><script src=\"https:\/\/gist.github.com\/vmburbinamx\/7a95e4865ecd5b63075e4c1e17d92ac5.js\"><\/script><br \/>\nSi ya guardaste el c\u00f3digo, ahora solo agrega un nombre al archivo. Aqu\u00ed usaremos &#8220;Simple trigger&#8221;:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-831 size-full\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/02\/img04-1.png\" alt=\"Google Apps Script\" width=\"220\" height=\"353\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/02\/img04-1.png 220w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/02\/img04-1-187x300.png 187w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/02\/img04-1-168x270.png 168w\" sizes=\"auto, (max-width: 220px) 100vw, 220px\" \/><\/p>\n<p>Cierra la ventana\/archivo, y localiza tu archivo en Google Drive. \u00c1brelo. Al abrirse se ejecutar\u00e1 la primera macro. <strong>onOpen<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-832 size-full\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/02\/img05.png\" alt=\"Google Apps Script\" width=\"521\" height=\"247\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/02\/img05.png 521w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/02\/img05-300x142.png 300w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/02\/img05-360x171.png 360w\" sizes=\"auto, (max-width: 521px) 100vw, 521px\" \/><\/p>\n<h2>Ejemplos descargables de macros en Google Sheets (Google Apps Script).<\/h2>\n<p>0. <strong>onOpen<\/strong>.<\/p>\n<p>Se trata de un trigger b\u00e1sico: una macro que se ejecuta cuando se abre un archivo. La acci\u00f3n que ejecuta es la crear un men\u00fa personalizado con algunos otros componentes.<\/p>\n<blockquote><p><span style=\"color: #0000ff;\">function onOpen&#8230;<\/span><\/p><\/blockquote>\n<p>1. Activar una hoja espec\u00edfica al inicio. Este es el tramo de c\u00f3digo que activa la hoja especificada. Puedes cambiar esta macro cambiando el valor de inicio (nombreDeHojaDeInicio).<\/p>\n<blockquote><p><span style=\"color: #0000ff;\">&#8230; var hojaQueSeActivaraAlInicio = SpreadsheetApp.getActiveSpreadsheet();<\/span><br \/>\n<span style=\"color: #0000ff;\"> SpreadsheetApp.setActiveSheet(hojaQueSeActivaraAlInicio.getSheetByName(nombreDeHojaDeInicio)); &#8230;<\/span><\/p><\/blockquote>\n<p>2. Mostrar un mensaje\/alerta en la parte inferior. Se trata de una funci\u00f3n personalizada (ve el detalle al final del c\u00f3digo).<\/p>\n<blockquote><p><span style=\"color: #0000ff;\">mostrarMensajeDeEspera(&#8220;Cargando, por favor espere&#8230;&#8221;, 60);<\/span><\/p><\/blockquote>\n<p>3. Crear un men\u00fa personalizado (incluyendo sub men\u00fa).<\/p>\n<blockquote><p><span style=\"color: #0000ff;\">SpreadsheetApp.getUi().createMenu(&#8220;MEN\u00da PERSONALIZADO&#8221;)<\/span><br \/>\n<span style=\"color: #0000ff;\"> .addItem(&#8216;OPCI\u00d3N UNO&#8217;, &#8216;macroUno&#8217;)<\/span><br \/>\n<span style=\"color: #0000ff;\">&#8230;<\/span><\/p>\n<p><span style=\"color: #0000ff;\">.addSeparator()<\/span><br \/>\n<span style=\"color: #0000ff;\"> .addSubMenu(SpreadsheetApp.getUi().createMenu(&#8216;OPCI\u00d3N CUATRO&#8217;)<\/span><br \/>\n<span style=\"color: #0000ff;\">&#8230;<\/span><br \/>\n<span style=\"color: #0000ff;\"> .addToUi();<\/span><\/p><\/blockquote>\n<p>4. Las opciones individuales muestran mensajes al usuario. Se trata de un mensaje b\u00e1sico:<\/p>\n<blockquote><p><span style=\"color: #0000ff;\">Browser.msgBox(&#8220;Esta es la macro uno&#8221;);<\/span><\/p><\/blockquote>\n<p>5. Macro que hace un conteo de celdas ocupadas. El l\u00edmite es de 2 millones de celdas por libro. Celda ocupada significa celda existente, es decir, las celdas en blanco tambi\u00e9n importan en esta cuenta.<\/p>\n<blockquote><p><span style=\"color: #0000ff;\">numeroDeCeldasOcupadas<\/span><\/p><\/blockquote>\n<p><script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<ins class=\"adsbygoogle\" style=\"display: block; text-align: center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-9033709093144000\" data-ad-slot=\"5242072910\"><\/ins><br \/>\n<script><br \/>\n     (adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n<p>Si lo necesitas, puedes hacer una copia del libro de trabajo. Debido a que tiene permisos de &#8220;visitante&#8221; (view only), no funcionar\u00e1 hasta que hagas tu copia (puedes hacerlo sin restricciones). Ver libro de trabajo: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1NInwgaNA13ORWtPdGjMdNufwV7qgSdmd6p95X7pyEYU\/edit#gid=0\" target=\"_blank\" rel=\"noopener noreferrer\">abrir<\/a>. En el blog tenemos m\u00e1s ejemplos, puedes consultarlos aqu\u00ed mismo: <a href=\"https:\/\/www.fditf.com\/bi\/category\/google-apps-script\/\">https:\/\/www.fditf.com\/bi\/category\/google-apps-script\/<\/a>.<\/p>\n<p>&nbsp;<\/p>\n<p>Conoce el potencial de toda la suite de Google, obt\u00e9n una prueba gratuita de la suite; m\u00e1s informaci\u00f3n en este enlace (Google): <a href=\"https:\/\/goo.gl\/ZPXKU2\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/goo.gl\/ZPXKU2<\/a><\/p>\n<p><a href=\"https:\/\/goo.gl\/ZPXKU2\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-267 size-medium\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/google-300x200.jpg\" alt=\"\" width=\"300\" height=\"200\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ejemplos de macros en Google Sheets (Google Apps Script). Abre una hoja nueva de Google Sheets (la puedes crear desde este link, considera que es necesaria una cuenta de Google). Cambia el nombre de la primera hoja, usa el nombre <a href=\"https:\/\/www.fditf.com\/bi\/google-apps-script\/6-scripts-basicos-en-google-sheets-con-google-apps-script\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":163,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23,10],"tags":[11,22,110,111],"class_list":["post-825","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-apps-script","category-google-sheets","tag-google-sheets","tag-googleappsscript","tag-onopen","tag-spreadsheetapp-getactivespreadsheet-toast"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Ejemplos de Google Apps Script en Google Sheets - Business Intelligence MX<\/title>\n<meta name=\"description\" content=\"Ejemplos de scripts b\u00e1sicos de Google Apps Script en Google Sheets. Consulta c\u00f3mo integrarlos a un men\u00fa personalizado.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.fditf.com\/bi\/google-sheets\/6-scripts-basicos-en-google-sheets-con-google-apps-script\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Ejemplos de Google Apps Script en Google Sheets - Business Intelligence MX\" \/>\n<meta property=\"og:description\" content=\"Ejemplos de scripts b\u00e1sicos de Google Apps Script en Google Sheets. Consulta c\u00f3mo integrarlos a un men\u00fa personalizado.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fditf.com\/bi\/google-sheets\/6-scripts-basicos-en-google-sheets-con-google-apps-script\/\" \/>\n<meta property=\"og:site_name\" content=\"Business Intelligence MX\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/excelyfinanzasmx\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-02-27T02:40:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-10T15:56:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/unnamed.png\" \/>\n\t<meta property=\"og:image:width\" content=\"440\" \/>\n\t<meta property=\"og:image:height\" content=\"280\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"V\u00edctor Urbina\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@excelfinanzasMX\" \/>\n<meta name=\"twitter:site\" content=\"@excelfinanzasMX\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"V\u00edctor Urbina\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.fditf.com\/bi\/google-sheets\/6-scripts-basicos-en-google-sheets-con-google-apps-script\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.fditf.com\/bi\/google-sheets\/6-scripts-basicos-en-google-sheets-con-google-apps-script\/\"},\"author\":{\"name\":\"V\u00edctor Urbina\",\"@id\":\"https:\/\/www.fditf.com\/bi\/#\/schema\/person\/ff30cbd17d9f746cacb687d5332924c5\"},\"headline\":\"Ejemplos de Google Apps Script en Google Sheets\",\"datePublished\":\"2018-02-27T02:40:09+00:00\",\"dateModified\":\"2023-08-10T15:56:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.fditf.com\/bi\/google-sheets\/6-scripts-basicos-en-google-sheets-con-google-apps-script\/\"},\"wordCount\":406,\"publisher\":{\"@id\":\"https:\/\/www.fditf.com\/bi\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.fditf.com\/bi\/google-sheets\/6-scripts-basicos-en-google-sheets-con-google-apps-script\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/unnamed.png\",\"keywords\":[\"Google Sheets\",\"GoogleAppsScript\",\"onOpen\",\"SpreadsheetApp.getActiveSpreadsheet().toast\"],\"articleSection\":[\"Google Apps Script\",\"Google Sheets\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.fditf.com\/bi\/google-sheets\/6-scripts-basicos-en-google-sheets-con-google-apps-script\/\",\"url\":\"https:\/\/www.fditf.com\/bi\/google-sheets\/6-scripts-basicos-en-google-sheets-con-google-apps-script\/\",\"name\":\"Ejemplos de Google Apps Script en Google Sheets - Business Intelligence MX\",\"isPartOf\":{\"@id\":\"https:\/\/www.fditf.com\/bi\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.fditf.com\/bi\/google-sheets\/6-scripts-basicos-en-google-sheets-con-google-apps-script\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.fditf.com\/bi\/google-sheets\/6-scripts-basicos-en-google-sheets-con-google-apps-script\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/unnamed.png\",\"datePublished\":\"2018-02-27T02:40:09+00:00\",\"dateModified\":\"2023-08-10T15:56:13+00:00\",\"description\":\"Ejemplos de scripts b\u00e1sicos de Google Apps Script en Google Sheets. Consulta c\u00f3mo integrarlos a un men\u00fa personalizado.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.fditf.com\/bi\/google-sheets\/6-scripts-basicos-en-google-sheets-con-google-apps-script\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.fditf.com\/bi\/google-sheets\/6-scripts-basicos-en-google-sheets-con-google-apps-script\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.fditf.com\/bi\/google-sheets\/6-scripts-basicos-en-google-sheets-con-google-apps-script\/#primaryimage\",\"url\":\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/unnamed.png\",\"contentUrl\":\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/unnamed.png\",\"width\":440,\"height\":280},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.fditf.com\/bi\/google-sheets\/6-scripts-basicos-en-google-sheets-con-google-apps-script\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.fditf.com\/bi\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Ejemplos de Google Apps Script en Google Sheets\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.fditf.com\/bi\/#website\",\"url\":\"https:\/\/www.fditf.com\/bi\/\",\"name\":\"Business Intelligence MX\",\"description\":\" \",\"publisher\":{\"@id\":\"https:\/\/www.fditf.com\/bi\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.fditf.com\/bi\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.fditf.com\/bi\/#organization\",\"name\":\"FDI Tecnolog\u00eda y Finanzas, SAS de CV\",\"url\":\"https:\/\/www.fditf.com\/bi\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.fditf.com\/bi\/#\/schema\/logo\/image\/\",\"url\":\"http:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/logo.png\",\"contentUrl\":\"http:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/logo.png\",\"width\":275,\"height\":168,\"caption\":\"FDI Tecnolog\u00eda y Finanzas, SAS de CV\"},\"image\":{\"@id\":\"https:\/\/www.fditf.com\/bi\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/excelyfinanzasmx\/\",\"https:\/\/x.com\/excelfinanzasMX\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.fditf.com\/bi\/#\/schema\/person\/ff30cbd17d9f746cacb687d5332924c5\",\"name\":\"V\u00edctor Urbina\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.fditf.com\/bi\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g\",\"caption\":\"V\u00edctor Urbina\"},\"url\":\"https:\/\/www.fditf.com\/bi\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Ejemplos de Google Apps Script en Google Sheets - Business Intelligence MX","description":"Ejemplos de scripts b\u00e1sicos de Google Apps Script en Google Sheets. Consulta c\u00f3mo integrarlos a un men\u00fa personalizado.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.fditf.com\/bi\/google-sheets\/6-scripts-basicos-en-google-sheets-con-google-apps-script\/","og_locale":"en_US","og_type":"article","og_title":"Ejemplos de Google Apps Script en Google Sheets - Business Intelligence MX","og_description":"Ejemplos de scripts b\u00e1sicos de Google Apps Script en Google Sheets. Consulta c\u00f3mo integrarlos a un men\u00fa personalizado.","og_url":"https:\/\/www.fditf.com\/bi\/google-sheets\/6-scripts-basicos-en-google-sheets-con-google-apps-script\/","og_site_name":"Business Intelligence MX","article_publisher":"https:\/\/www.facebook.com\/excelyfinanzasmx\/","article_published_time":"2018-02-27T02:40:09+00:00","article_modified_time":"2023-08-10T15:56:13+00:00","og_image":[{"width":440,"height":280,"url":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/unnamed.png","type":"image\/png"}],"author":"V\u00edctor Urbina","twitter_card":"summary_large_image","twitter_creator":"@excelfinanzasMX","twitter_site":"@excelfinanzasMX","twitter_misc":{"Written by":"V\u00edctor Urbina","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fditf.com\/bi\/google-sheets\/6-scripts-basicos-en-google-sheets-con-google-apps-script\/#article","isPartOf":{"@id":"https:\/\/www.fditf.com\/bi\/google-sheets\/6-scripts-basicos-en-google-sheets-con-google-apps-script\/"},"author":{"name":"V\u00edctor Urbina","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/person\/ff30cbd17d9f746cacb687d5332924c5"},"headline":"Ejemplos de Google Apps Script en Google Sheets","datePublished":"2018-02-27T02:40:09+00:00","dateModified":"2023-08-10T15:56:13+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fditf.com\/bi\/google-sheets\/6-scripts-basicos-en-google-sheets-con-google-apps-script\/"},"wordCount":406,"publisher":{"@id":"https:\/\/www.fditf.com\/bi\/#organization"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/google-sheets\/6-scripts-basicos-en-google-sheets-con-google-apps-script\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/unnamed.png","keywords":["Google Sheets","GoogleAppsScript","onOpen","SpreadsheetApp.getActiveSpreadsheet().toast"],"articleSection":["Google Apps Script","Google Sheets"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.fditf.com\/bi\/google-sheets\/6-scripts-basicos-en-google-sheets-con-google-apps-script\/","url":"https:\/\/www.fditf.com\/bi\/google-sheets\/6-scripts-basicos-en-google-sheets-con-google-apps-script\/","name":"Ejemplos de Google Apps Script en Google Sheets - Business Intelligence MX","isPartOf":{"@id":"https:\/\/www.fditf.com\/bi\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fditf.com\/bi\/google-sheets\/6-scripts-basicos-en-google-sheets-con-google-apps-script\/#primaryimage"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/google-sheets\/6-scripts-basicos-en-google-sheets-con-google-apps-script\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/unnamed.png","datePublished":"2018-02-27T02:40:09+00:00","dateModified":"2023-08-10T15:56:13+00:00","description":"Ejemplos de scripts b\u00e1sicos de Google Apps Script en Google Sheets. Consulta c\u00f3mo integrarlos a un men\u00fa personalizado.","breadcrumb":{"@id":"https:\/\/www.fditf.com\/bi\/google-sheets\/6-scripts-basicos-en-google-sheets-con-google-apps-script\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fditf.com\/bi\/google-sheets\/6-scripts-basicos-en-google-sheets-con-google-apps-script\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fditf.com\/bi\/google-sheets\/6-scripts-basicos-en-google-sheets-con-google-apps-script\/#primaryimage","url":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/unnamed.png","contentUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/unnamed.png","width":440,"height":280},{"@type":"BreadcrumbList","@id":"https:\/\/www.fditf.com\/bi\/google-sheets\/6-scripts-basicos-en-google-sheets-con-google-apps-script\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fditf.com\/bi\/"},{"@type":"ListItem","position":2,"name":"Ejemplos de Google Apps Script en Google Sheets"}]},{"@type":"WebSite","@id":"https:\/\/www.fditf.com\/bi\/#website","url":"https:\/\/www.fditf.com\/bi\/","name":"Business Intelligence MX","description":" ","publisher":{"@id":"https:\/\/www.fditf.com\/bi\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fditf.com\/bi\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.fditf.com\/bi\/#organization","name":"FDI Tecnolog\u00eda y Finanzas, SAS de CV","url":"https:\/\/www.fditf.com\/bi\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/logo\/image\/","url":"http:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/logo.png","contentUrl":"http:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/logo.png","width":275,"height":168,"caption":"FDI Tecnolog\u00eda y Finanzas, SAS de CV"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/excelyfinanzasmx\/","https:\/\/x.com\/excelfinanzasMX"]},{"@type":"Person","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/person\/ff30cbd17d9f746cacb687d5332924c5","name":"V\u00edctor Urbina","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g","caption":"V\u00edctor Urbina"},"url":"https:\/\/www.fditf.com\/bi\/author\/admin\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/825","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/comments?post=825"}],"version-history":[{"count":20,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/825\/revisions"}],"predecessor-version":[{"id":5350,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/825\/revisions\/5350"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/media\/163"}],"wp:attachment":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/media?parent=825"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/categories?post=825"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/tags?post=825"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}