{"id":2192,"date":"2018-12-01T01:20:58","date_gmt":"2018-12-01T01:20:58","guid":{"rendered":"http:\/\/www.fditf.com\/bi\/?p=2192"},"modified":"2020-12-04T02:11:38","modified_gmt":"2020-12-04T02:11:38","slug":"la-barra-lateral-sidebar-en-google-sheets-i","status":"publish","type":"post","link":"https:\/\/www.fditf.com\/bi\/google-apps-script\/la-barra-lateral-sidebar-en-google-sheets-i\/","title":{"rendered":"La barra lateral Google Sheets"},"content":{"rendered":"<h2>La barra lateral en google sheets<\/h2>\n<p>La barra lateral en google sheets (google sidebar) es uno de los &#8220;features&#8221; menos conocidos, pero tambi\u00e9n es de los que lucen mucho, ya que es muy atractivo visualmente, y es muy \u00fatil si intentas construir un tablero de control (dashboard) en Google Sheets (donde puedes acceder a google sheets con un html). Para llamar la barra lateral no hay de otra: necesitamos macros en Google Sheets. Como lo he publicado en otro momento (<a href=\"https:\/\/www.fditf.com\/bi\/category\/google-apps-script\/\" target=\"_blank\" rel=\"noopener noreferrer\">ver posts relacionados<\/a>), las macros en Google Sheets operan con Google Apps Script (Javascript). En esta serie crearemos un dashboard con esta herramienta (y un par de complementos m\u00e1s), explic\u00e1ndote c\u00f3mo poner la barra lateral de google sheets.<br \/>\n<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=\"4298448911\"><\/ins><br \/>\n<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script><\/p>\n<h2>Un ejemplo b\u00e1sico<\/h2>\n<p>Esto es lo que ocurrir\u00e1 para desplegar esta barra lateral:<\/p>\n<ul>\n<li>Abrir libro de Google Sheets;<\/li>\n<li>Al abrirse el libro, se crear\u00e1 un men\u00fa personalizado, mostrando la opci\u00f3n para desplegar la barra lateral.<\/li>\n<\/ul>\n<p>Ingredientes:<\/p>\n<ul>\n<li>Barra lateral en html;<\/li>\n<li>C\u00f3digo de una macro que se ejecute al abrir el libro de trabajo. La tarea de esta macro ser\u00e1 ejecutar otra macro que desplegar\u00e1 la barra lateral.<\/li>\n<\/ul>\n<p>Para insertar los c\u00f3digos, crea un archivo en Google Sheets, luego ve a &#8220;<strong>Tools<\/strong>&#8221; y despu\u00e9s a &#8220;<strong>Script editor<\/strong>&#8220;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2195 size-full\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/12\/sidebar0.png\" alt=\"La barra lateral en google sheets\" width=\"677\" height=\"442\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/12\/sidebar0.png 677w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/12\/sidebar0-300x196.png 300w\" sizes=\"auto, (max-width: 677px) 100vw, 677px\" \/><\/p>\n<p>Con esto, se crear\u00e1 un contenedor de scripts para el libro de trabajo.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2196 size-full\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/12\/sidebar1.png\" alt=\"La barra lateral en google sheets\" width=\"499\" height=\"290\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/12\/sidebar1.png 499w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/12\/sidebar1-300x174.png 300w\" sizes=\"auto, (max-width: 499px) 100vw, 499px\" \/><\/p>\n<p>Ahora crea un archivo HTML dentro de este proyecto. El archivo se llamar\u00e1 &#8220;mySideBar&#8221;. Sigue estos pasos:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2198 size-full\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/12\/sidebar2.png\" alt=\"La barra lateral en google sheets\" width=\"519\" height=\"460\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/12\/sidebar2.png 519w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/12\/sidebar2-300x266.png 300w\" sizes=\"auto, (max-width: 519px) 100vw, 519px\" \/><\/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=\"5242072910\"><\/ins><br \/>\n<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2199 size-full\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/12\/sidebar3.png\" alt=\"La barra lateral en google sheets\" width=\"479\" height=\"201\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/12\/sidebar3.png 479w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/12\/sidebar3-300x126.png 300w\" sizes=\"auto, (max-width: 479px) 100vw, 479px\" \/><\/p>\n<p>Si todo sali\u00f3 bien, debes ver algo as\u00ed:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2200 size-full\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/12\/sidebar4.png\" alt=\"La barra lateral en google sheets\" width=\"492\" height=\"383\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/12\/sidebar4.png 492w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/12\/sidebar4-300x234.png 300w\" sizes=\"auto, (max-width: 492px) 100vw, 492px\" \/><\/p>\n<p>Inserta este c\u00f3digo en Code.gs<\/p>\n<p><script src=\"https:\/\/gist.github.com\/vmburbinamx\/bd91f577e1dce587ea6d772d81ee512d.js\"><\/script><\/p>\n<p>Y este c\u00f3digo en el archivo mySideBar.html<\/p>\n<p><script src=\"https:\/\/gist.github.com\/vmburbinamx\/fd87c6e0f1b525c8a455c737ecdb9aa9.js\"><\/script><\/p>\n<p>Guarda los cambios. Es momento de ejecutar. Cierra el libro de trabajo y vu\u00e9lvelo a abrir. El c\u00f3digo est\u00e1 listo para crear un men\u00fa en la parte superior, justo despu\u00e9s de abrir el archivo.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2206 size-full\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/12\/sidebar6.png\" alt=\"La barra lateral en google sheets\" width=\"1007\" height=\"241\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/12\/sidebar6.png 1007w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/12\/sidebar6-300x72.png 300w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/12\/sidebar6-768x184.png 768w\" sizes=\"auto, (max-width: 1007px) 100vw, 1007px\" \/><\/p>\n<p>Cuando des clic en el bot\u00f3n &#8220;Mostrar barra lateral&#8221;, la ver\u00e1s desplegada del lado derecho. Considera que en la primera ejecuci\u00f3n Google te pedir\u00e1 autorizaci\u00f3n para ejecutar este script. Pero es s\u00f3lamente una vez (aplica para cada usuario que use el archivo).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2207 size-full\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/12\/sidebar7.png\" alt=\"La barra lateral en google sheets\" width=\"804\" height=\"480\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/12\/sidebar7.png 804w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/12\/sidebar7-300x179.png 300w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/12\/sidebar7-768x459.png 768w\" sizes=\"auto, (max-width: 804px) 100vw, 804px\" \/><\/p>\n<p>Si editas el c\u00f3digo HTML, la barra mostrar\u00e1 el contenido. Prueba con este c\u00f3digo:<\/p>\n<p><script src=\"https:\/\/gist.github.com\/vmburbinamx\/f5d7a65a9d883b8c42b3c924d290525f.js\"><\/script><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2209 size-full\" src=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/12\/sidebar8.png\" alt=\"La barra lateral en google sheets\" width=\"661\" height=\"669\" srcset=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/12\/sidebar8.png 661w, https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/12\/sidebar8-296x300.png 296w\" sizes=\"auto, (max-width: 661px) 100vw, 661px\" \/><\/p>\n<p>Puedes hacer una copia de este libro con este link: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1B11YSorIEYf-aPDIRdrGg4HiLIhVSUf8f5dJO9zrGbE\/edit?usp=sharing\" target=\"_blank\" rel=\"noopener noreferrer\">ver libro<\/a>.<\/p>\n<p><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<!-- bottomHugeAd --><br \/>\n<ins class=\"adsbygoogle\" style=\"display: inline-block; width: 970px; height: 250px;\" data-ad-client=\"ca-pub-9033709093144000\" data-ad-slot=\"8179725853\"><\/ins><br \/>\n<script>\n(adsbygoogle = window.adsbygoogle || []).push({});\n<\/script><\/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<div class=\"fb-share-button\" data-href=\"https:\/\/www.fditf.com\/bi\/google-sheets\/la-formula-query-en-google-sheets\/\" data-layout=\"box_count\" data-size=\"large\" data-mobile-iframe=\"true\"><a class=\"fb-xfbml-parse-ignore\" href=\"https:\/\/www.facebook.com\/sharer\/sharer.php?u=http%3A%2F%2Fwww.fditf.com%2Fbi%2Fgoogle-sheets%2Fla-formula-query-en-google-sheets%2F&amp;src=sdkpreparse\" target=\"_blank\" rel=\"noopener noreferrer\">Compartir<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>La barra lateral en google sheets La barra lateral en google sheets (google sidebar) es uno de los &#8220;features&#8221; menos conocidos, pero tambi\u00e9n es de los que lucen mucho, ya que es muy atractivo visualmente, y es muy \u00fatil si <a href=\"https:\/\/www.fditf.com\/bi\/google-apps-script\/la-barra-lateral-sidebar-en-google-sheets-i\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":2278,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23,10],"tags":[],"class_list":["post-2192","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-apps-script","category-google-sheets"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>La barra lateral Google Sheets - Business Intelligence MX<\/title>\n<meta name=\"description\" content=\"C\u00f3mo desplegar la barra lateral en Google Sheets. Copia la hoja de c\u00e1lculo e implem\u00e9ntalo en tus proyectos.\" \/>\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-apps-script\/la-barra-lateral-sidebar-en-google-sheets-i\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"La barra lateral Google Sheets - Business Intelligence MX\" \/>\n<meta property=\"og:description\" content=\"C\u00f3mo desplegar la barra lateral en Google Sheets. Copia la hoja de c\u00e1lculo e implem\u00e9ntalo en tus proyectos.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fditf.com\/bi\/google-apps-script\/la-barra-lateral-sidebar-en-google-sheets-i\/\" \/>\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-12-01T01:20:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-12-04T02:11:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/12\/barra.png\" \/>\n\t<meta property=\"og:image:width\" content=\"960\" \/>\n\t<meta property=\"og:image:height\" content=\"385\" \/>\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-apps-script\\\/la-barra-lateral-sidebar-en-google-sheets-i\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-apps-script\\\/la-barra-lateral-sidebar-en-google-sheets-i\\\/\"},\"author\":{\"name\":\"V\u00edctor Urbina\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#\\\/schema\\\/person\\\/ff30cbd17d9f746cacb687d5332924c5\"},\"headline\":\"La barra lateral Google Sheets\",\"datePublished\":\"2018-12-01T01:20:58+00:00\",\"dateModified\":\"2020-12-04T02:11:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-apps-script\\\/la-barra-lateral-sidebar-en-google-sheets-i\\\/\"},\"wordCount\":415,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-apps-script\\\/la-barra-lateral-sidebar-en-google-sheets-i\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/12\\\/barra.png\",\"articleSection\":[\"Google Apps Script\",\"Google Sheets\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-apps-script\\\/la-barra-lateral-sidebar-en-google-sheets-i\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-apps-script\\\/la-barra-lateral-sidebar-en-google-sheets-i\\\/\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-apps-script\\\/la-barra-lateral-sidebar-en-google-sheets-i\\\/\",\"name\":\"La barra lateral Google Sheets - Business Intelligence MX\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-apps-script\\\/la-barra-lateral-sidebar-en-google-sheets-i\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-apps-script\\\/la-barra-lateral-sidebar-en-google-sheets-i\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/12\\\/barra.png\",\"datePublished\":\"2018-12-01T01:20:58+00:00\",\"dateModified\":\"2020-12-04T02:11:38+00:00\",\"description\":\"C\u00f3mo desplegar la barra lateral en Google Sheets. Copia la hoja de c\u00e1lculo e implem\u00e9ntalo en tus proyectos.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-apps-script\\\/la-barra-lateral-sidebar-en-google-sheets-i\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-apps-script\\\/la-barra-lateral-sidebar-en-google-sheets-i\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-apps-script\\\/la-barra-lateral-sidebar-en-google-sheets-i\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/12\\\/barra.png\",\"contentUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/12\\\/barra.png\",\"width\":960,\"height\":385,\"caption\":\"barra lateral google sheets\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-apps-script\\\/la-barra-lateral-sidebar-en-google-sheets-i\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"La barra lateral 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:\\\/\\\/secure.gravatar.com\\\/avatar\\\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g\",\"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":"La barra lateral Google Sheets - Business Intelligence MX","description":"C\u00f3mo desplegar la barra lateral en Google Sheets. Copia la hoja de c\u00e1lculo e implem\u00e9ntalo en tus proyectos.","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-apps-script\/la-barra-lateral-sidebar-en-google-sheets-i\/","og_locale":"en_US","og_type":"article","og_title":"La barra lateral Google Sheets - Business Intelligence MX","og_description":"C\u00f3mo desplegar la barra lateral en Google Sheets. Copia la hoja de c\u00e1lculo e implem\u00e9ntalo en tus proyectos.","og_url":"https:\/\/www.fditf.com\/bi\/google-apps-script\/la-barra-lateral-sidebar-en-google-sheets-i\/","og_site_name":"Business Intelligence MX","article_publisher":"https:\/\/www.facebook.com\/excelyfinanzasmx\/","article_published_time":"2018-12-01T01:20:58+00:00","article_modified_time":"2020-12-04T02:11:38+00:00","og_image":[{"width":960,"height":385,"url":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/12\/barra.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-apps-script\/la-barra-lateral-sidebar-en-google-sheets-i\/#article","isPartOf":{"@id":"https:\/\/www.fditf.com\/bi\/google-apps-script\/la-barra-lateral-sidebar-en-google-sheets-i\/"},"author":{"name":"V\u00edctor Urbina","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/person\/ff30cbd17d9f746cacb687d5332924c5"},"headline":"La barra lateral Google Sheets","datePublished":"2018-12-01T01:20:58+00:00","dateModified":"2020-12-04T02:11:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fditf.com\/bi\/google-apps-script\/la-barra-lateral-sidebar-en-google-sheets-i\/"},"wordCount":415,"commentCount":2,"publisher":{"@id":"https:\/\/www.fditf.com\/bi\/#organization"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/google-apps-script\/la-barra-lateral-sidebar-en-google-sheets-i\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/12\/barra.png","articleSection":["Google Apps Script","Google Sheets"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fditf.com\/bi\/google-apps-script\/la-barra-lateral-sidebar-en-google-sheets-i\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fditf.com\/bi\/google-apps-script\/la-barra-lateral-sidebar-en-google-sheets-i\/","url":"https:\/\/www.fditf.com\/bi\/google-apps-script\/la-barra-lateral-sidebar-en-google-sheets-i\/","name":"La barra lateral Google Sheets - Business Intelligence MX","isPartOf":{"@id":"https:\/\/www.fditf.com\/bi\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fditf.com\/bi\/google-apps-script\/la-barra-lateral-sidebar-en-google-sheets-i\/#primaryimage"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/google-apps-script\/la-barra-lateral-sidebar-en-google-sheets-i\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/12\/barra.png","datePublished":"2018-12-01T01:20:58+00:00","dateModified":"2020-12-04T02:11:38+00:00","description":"C\u00f3mo desplegar la barra lateral en Google Sheets. Copia la hoja de c\u00e1lculo e implem\u00e9ntalo en tus proyectos.","breadcrumb":{"@id":"https:\/\/www.fditf.com\/bi\/google-apps-script\/la-barra-lateral-sidebar-en-google-sheets-i\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fditf.com\/bi\/google-apps-script\/la-barra-lateral-sidebar-en-google-sheets-i\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fditf.com\/bi\/google-apps-script\/la-barra-lateral-sidebar-en-google-sheets-i\/#primaryimage","url":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/12\/barra.png","contentUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/12\/barra.png","width":960,"height":385,"caption":"barra lateral google sheets"},{"@type":"BreadcrumbList","@id":"https:\/\/www.fditf.com\/bi\/google-apps-script\/la-barra-lateral-sidebar-en-google-sheets-i\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fditf.com\/bi\/"},{"@type":"ListItem","position":2,"name":"La barra lateral 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:\/\/secure.gravatar.com\/avatar\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g","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\/2192","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=2192"}],"version-history":[{"count":15,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/2192\/revisions"}],"predecessor-version":[{"id":4869,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/2192\/revisions\/4869"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/media\/2278"}],"wp:attachment":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/media?parent=2192"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/categories?post=2192"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/tags?post=2192"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}