{"id":17257,"date":"2026-08-05T14:04:57","date_gmt":"2026-08-05T17:04:57","guid":{"rendered":"https:\/\/joaoernani.com\/blog\/?p=17257"},"modified":"2026-10-21T17:20:39","modified_gmt":"2026-10-21T20:20:39","slug":"planilha-controle-financeiro-app-canvas-gemini","status":"publish","type":"post","link":"https:\/\/joaoernani.com\/blog\/planilha-controle-financeiro-app-canvas-gemini\/","title":{"rendered":"Como Transformar Sua Planilha de Controle Financeiro em um App com o Canvas do Gemini"},"content":{"rendered":"<p>Sua planilha de controle financeiro \u00e9 t\u00e3o chata e confusa que voc\u00ea acaba desistindo de preencher?<\/p>\r\n<p>Agora o Gemini transforma qualquer planilha do Google Planilhas em um dashboard bonito e funcional, sem voc\u00ea saber programar ou design.<\/p>\r\n\r\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\r\n<iframe loading=\"lazy\" width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/iE6FaVlnaWg\" frameborder=\"0\" allowfullscreen><\/iframe>\r\n<\/div><\/figure>\r\n\r\n<p>Neste tutorial pr\u00e1tico, baseado no v\u00eddeo ADEUS, Controle Financeiro Confuso! Transforme sua Planilha em um App sem Precisar Programar, voc\u00ea vai aprender o jeito certo de usar essa fun\u00e7\u00e3o, com os cuidados que descobri nos testes.<\/p>\r\n<h2>Passo 1: Crie a Planilha a Partir de um Modelo<\/h2>\r\n<p>No Google Drive, clique em <strong>Novo<\/strong> &gt; <strong>Planilhas Google<\/strong> &gt; <strong>A partir de um modelo<\/strong> e escolha o modelo de or\u00e7amento mensal (<strong>Monthly budget<\/strong>).<\/p>\r\n<h2>Passo 2: Ative o Bot\u00e3o &#8220;Criar com Canvas&#8221;<\/h2>\r\n<p>O jeito certo n\u00e3o \u00e9 s\u00f3 pedir &#8220;crie um dashboard&#8221; no painel do Gemini (os resultados n\u00e3o eram bons). Use o bot\u00e3o <strong>Criar com Canvas<\/strong>, \u00e0 esquerda.<\/p>\r\n<blockquote class=\"wp-block-quote\">\r\n<p>Aten\u00e7\u00e3o: Se voc\u00ea tem o plano Pro e o bot\u00e3o n\u00e3o aparece, adicione o <strong>ingl\u00eas (Estados Unidos)<\/strong> como idioma na sua Conta Google. As novidades costumam chegar primeiro em ingl\u00eas.<\/p>\r\n<\/blockquote>\r\n<h2>Passo 3: Deixe S\u00f3 a Aba Necess\u00e1ria<\/h2>\r\n<p>Nos meus testes, funcionou melhor com apenas uma aba para transformar. Apaguei a aba de resumo e deixei s\u00f3 <strong>entradas e sa\u00eddas<\/strong> (setinha da aba &gt; <strong>Excluir<\/strong>).<\/p>\r\n<blockquote class=\"wp-block-quote\">\r\n<p>Dica de Ouro: Isso vale para qualquer planilha, n\u00e3o s\u00f3 a financeira.<\/p>\r\n<\/blockquote>\r\n<h2>Passo 4: Gere o Dashboard<\/h2>\r\n<p>Clique em <strong>Criar com Canvas<\/strong> (confirme que o Canvas est\u00e1 selecionado) e escolha o formato:<\/p>\r\n<ul>\r\n<li><strong>Dashboard:<\/strong> painel, ideal para controle financeiro.<\/li>\r\n<li><strong>Galeria:<\/strong> bom para planilhas de posts com imagens.<\/li>\r\n<li><strong>Kanban:<\/strong> ideal para controlar tarefas.<\/li>\r\n<\/ul>\r\n<p>Escolhi <strong>Dashboard<\/strong> e ele criou o app em poucos minutos.<\/p>\r\n<h2>Passo 5: Teste Tudo<\/h2>\r\n<p>O pr\u00f3prio Gemini avisa que pode cometer erros, ent\u00e3o teste. Adicionei uma entrada (pr\u00f3-labore de R$ 3.000) e uma despesa (ra\u00e7\u00e3o, R$ 500), inclusive criando uma categoria nova, &#8220;Animal de estima\u00e7\u00e3o&#8221;. Os dois apareceram no app e na planilha.<\/p>\r\n<h2>Passo 6: Compartilhe ou Use uma C\u00f3pia<\/h2>\r\n<p>Para compartilhar, use <strong>Compartilhar<\/strong> &gt; <strong>Qualquer pessoa com o link<\/strong>. Quem recebe o link precisa ir em <strong>Arquivo<\/strong> &gt; <strong>Fazer uma c\u00f3pia<\/strong> para usar no pr\u00f3prio Drive. Funciona at\u00e9 na vers\u00e3o gratuita do Google Planilhas.<\/p>\r\n<h2>Resumo do Passo a Passo<\/h2>\r\n<figure class=\"wp-block-table\"><table>\r\n<thead>\r\n<tr>\r\n<th>Etapa<\/th>\r\n<th>O que fazer<\/th>\r\n<\/tr>\r\n<\/thead>\r\n<tbody>\r\n<tr>\r\n<td>1<\/td>\r\n<td>Criar a planilha pelo modelo Monthly budget<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>2<\/td>\r\n<td>Usar o bot\u00e3o Criar com Canvas (idioma em ingl\u00eas, se n\u00e3o aparecer)<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>3<\/td>\r\n<td>Deixar apenas a aba de dados<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>4<\/td>\r\n<td>Escolher Dashboard<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>5<\/td>\r\n<td>Testar entradas, despesas e categorias<\/td>\r\n<\/tr>\r\n<tr>\r\n<td>6<\/td>\r\n<td>Compartilhar ou fazer uma c\u00f3pia<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table><\/figure>\r\n<h2>Conclus\u00e3o: Do Chato ao Bonito, Sem Programar<\/h2>\r\n<p>Com o Canvas, a mesma planilha vira um app visual e agrad\u00e1vel de usar, e o controle financeiro deixa de ser um sacrif\u00edcio.<\/p>\r\n<p>Agora, eu quero saber de voc\u00ea: deixe aqui nos coment\u00e1rios se o bot\u00e3o Criar com Canvas j\u00e1 apareceu para voc\u00ea.<\/p>\r\n<p>\ud83d\udd14 Inscreva-se no canal oficial do Prof. Jo\u00e3o Ernani, ative o sininho de notifica\u00e7\u00f5es e acompanhe todas as novidades em primeira m\u00e3o \ud83d\ude80\ud83d\udccc: <a href=\"https:\/\/www.youtube.com\/@joaoernani\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/www.youtube.com\/@joaoernani<\/a><\/p>\r\n<p>Forte abra\u00e7o,<\/p>\r\n<p>Prof. Jo\u00e3o Ernani<\/p>","protected":false},"excerpt":{"rendered":"<p>Sua planilha de controle financeiro \u00e9 t\u00e3o chata e confusa que voc\u00ea acaba desistindo de&#8230;<\/p>\n","protected":false},"author":24,"featured_media":17259,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2233],"tags":[],"class_list":["post-17257","post","type-post","status-publish","format-standard","has-post-thumbnail","category-gemini"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Planilha de Controle Financeiro Vira App com Gemini<\/title>\n<meta name=\"description\" content=\"Aprenda a transformar uma planilha de controle financeiro do Google Planilhas em um dashboard interativo com o Canvas do Gemini, sem programar. Veja como!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/joaoernani.com\/blog\/planilha-controle-financeiro-app-canvas-gemini\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Planilha de Controle Financeiro Vira App com Gemini\" \/>\n<meta property=\"og:description\" content=\"Aprenda a transformar uma planilha de controle financeiro do Google Planilhas em um dashboard interativo com o Canvas do Gemini, sem programar. Veja como!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/joaoernani.com\/blog\/planilha-controle-financeiro-app-canvas-gemini\/\" \/>\n<meta property=\"og:site_name\" content=\"Prof. Jo\u00e3o Ernani\" \/>\n<meta property=\"article:published_time\" content=\"2026-08-05T17:04:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-10-21T20:20:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/joaoernani.com\/blog\/wp-content\/uploads\/2026\/10\/thumb-42.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Assitente grock Bot\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Assitente grock Bot\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. tempo de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/joaoernani.com\\\/blog\\\/planilha-controle-financeiro-app-canvas-gemini\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/joaoernani.com\\\/blog\\\/planilha-controle-financeiro-app-canvas-gemini\\\/\"},\"author\":{\"name\":\"Assitente grock Bot\",\"@id\":\"https:\\\/\\\/joaoernani.com\\\/blog\\\/#\\\/schema\\\/person\\\/117e400a5310bf348ec6418470797930\"},\"headline\":\"Como Transformar Sua Planilha de Controle Financeiro em um App com o Canvas do Gemini\",\"datePublished\":\"2026-08-05T17:04:57+00:00\",\"dateModified\":\"2026-10-21T20:20:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/joaoernani.com\\\/blog\\\/planilha-controle-financeiro-app-canvas-gemini\\\/\"},\"wordCount\":523,\"image\":{\"@id\":\"https:\\\/\\\/joaoernani.com\\\/blog\\\/planilha-controle-financeiro-app-canvas-gemini\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/joaoernani.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/10\\\/thumb-42.jpg\",\"articleSection\":[\"Gemini\"],\"inLanguage\":\"pt-BR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/joaoernani.com\\\/blog\\\/planilha-controle-financeiro-app-canvas-gemini\\\/\",\"url\":\"https:\\\/\\\/joaoernani.com\\\/blog\\\/planilha-controle-financeiro-app-canvas-gemini\\\/\",\"name\":\"Planilha de Controle Financeiro Vira App com Gemini\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/joaoernani.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/joaoernani.com\\\/blog\\\/planilha-controle-financeiro-app-canvas-gemini\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/joaoernani.com\\\/blog\\\/planilha-controle-financeiro-app-canvas-gemini\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/joaoernani.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/10\\\/thumb-42.jpg\",\"datePublished\":\"2026-08-05T17:04:57+00:00\",\"dateModified\":\"2026-10-21T20:20:39+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/joaoernani.com\\\/blog\\\/#\\\/schema\\\/person\\\/117e400a5310bf348ec6418470797930\"},\"description\":\"Aprenda a transformar uma planilha de controle financeiro do Google Planilhas em um dashboard interativo com o Canvas do Gemini, sem programar. Veja como!\",\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/joaoernani.com\\\/blog\\\/planilha-controle-financeiro-app-canvas-gemini\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/joaoernani.com\\\/blog\\\/planilha-controle-financeiro-app-canvas-gemini\\\/#primaryimage\",\"url\":\"https:\\\/\\\/joaoernani.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/10\\\/thumb-42.jpg\",\"contentUrl\":\"https:\\\/\\\/joaoernani.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/10\\\/thumb-42.jpg\",\"width\":1280,\"height\":720,\"caption\":\"Como Transformar Sua Planilha de Controle Financeiro em um App com o Canvas do Gemini\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/joaoernani.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/joaoernani.com\\\/blog\\\/\",\"name\":\"Prof. Jo\u00e3o Ernani\",\"description\":\"Neste Blog voc\u00ea vai encontrar tutoriais gratuitos do professor Jo\u00e3o Ernani\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/joaoernani.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/joaoernani.com\\\/blog\\\/#\\\/schema\\\/person\\\/117e400a5310bf348ec6418470797930\",\"name\":\"Assitente grock Bot\",\"url\":\"https:\\\/\\\/joaoernani.com\\\/blog\\\/author\\\/assistente\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Planilha de Controle Financeiro Vira App com Gemini","description":"Aprenda a transformar uma planilha de controle financeiro do Google Planilhas em um dashboard interativo com o Canvas do Gemini, sem programar. Veja como!","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:\/\/joaoernani.com\/blog\/planilha-controle-financeiro-app-canvas-gemini\/","og_locale":"pt_BR","og_type":"article","og_title":"Planilha de Controle Financeiro Vira App com Gemini","og_description":"Aprenda a transformar uma planilha de controle financeiro do Google Planilhas em um dashboard interativo com o Canvas do Gemini, sem programar. Veja como!","og_url":"https:\/\/joaoernani.com\/blog\/planilha-controle-financeiro-app-canvas-gemini\/","og_site_name":"Prof. Jo\u00e3o Ernani","article_published_time":"2026-08-05T17:04:57+00:00","article_modified_time":"2026-10-21T20:20:39+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/joaoernani.com\/blog\/wp-content\/uploads\/2026\/10\/thumb-42.jpg","type":"image\/jpeg"}],"author":"Assitente grock Bot","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Assitente grock Bot","Est. tempo de leitura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/joaoernani.com\/blog\/planilha-controle-financeiro-app-canvas-gemini\/#article","isPartOf":{"@id":"https:\/\/joaoernani.com\/blog\/planilha-controle-financeiro-app-canvas-gemini\/"},"author":{"name":"Assitente grock Bot","@id":"https:\/\/joaoernani.com\/blog\/#\/schema\/person\/117e400a5310bf348ec6418470797930"},"headline":"Como Transformar Sua Planilha de Controle Financeiro em um App com o Canvas do Gemini","datePublished":"2026-08-05T17:04:57+00:00","dateModified":"2026-10-21T20:20:39+00:00","mainEntityOfPage":{"@id":"https:\/\/joaoernani.com\/blog\/planilha-controle-financeiro-app-canvas-gemini\/"},"wordCount":523,"image":{"@id":"https:\/\/joaoernani.com\/blog\/planilha-controle-financeiro-app-canvas-gemini\/#primaryimage"},"thumbnailUrl":"https:\/\/joaoernani.com\/blog\/wp-content\/uploads\/2026\/10\/thumb-42.jpg","articleSection":["Gemini"],"inLanguage":"pt-BR"},{"@type":"WebPage","@id":"https:\/\/joaoernani.com\/blog\/planilha-controle-financeiro-app-canvas-gemini\/","url":"https:\/\/joaoernani.com\/blog\/planilha-controle-financeiro-app-canvas-gemini\/","name":"Planilha de Controle Financeiro Vira App com Gemini","isPartOf":{"@id":"https:\/\/joaoernani.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/joaoernani.com\/blog\/planilha-controle-financeiro-app-canvas-gemini\/#primaryimage"},"image":{"@id":"https:\/\/joaoernani.com\/blog\/planilha-controle-financeiro-app-canvas-gemini\/#primaryimage"},"thumbnailUrl":"https:\/\/joaoernani.com\/blog\/wp-content\/uploads\/2026\/10\/thumb-42.jpg","datePublished":"2026-08-05T17:04:57+00:00","dateModified":"2026-10-21T20:20:39+00:00","author":{"@id":"https:\/\/joaoernani.com\/blog\/#\/schema\/person\/117e400a5310bf348ec6418470797930"},"description":"Aprenda a transformar uma planilha de controle financeiro do Google Planilhas em um dashboard interativo com o Canvas do Gemini, sem programar. Veja como!","inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/joaoernani.com\/blog\/planilha-controle-financeiro-app-canvas-gemini\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/joaoernani.com\/blog\/planilha-controle-financeiro-app-canvas-gemini\/#primaryimage","url":"https:\/\/joaoernani.com\/blog\/wp-content\/uploads\/2026\/10\/thumb-42.jpg","contentUrl":"https:\/\/joaoernani.com\/blog\/wp-content\/uploads\/2026\/10\/thumb-42.jpg","width":1280,"height":720,"caption":"Como Transformar Sua Planilha de Controle Financeiro em um App com o Canvas do Gemini"},{"@type":"WebSite","@id":"https:\/\/joaoernani.com\/blog\/#website","url":"https:\/\/joaoernani.com\/blog\/","name":"Prof. Jo\u00e3o Ernani","description":"Neste Blog voc\u00ea vai encontrar tutoriais gratuitos do professor Jo\u00e3o Ernani","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/joaoernani.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"},{"@type":"Person","@id":"https:\/\/joaoernani.com\/blog\/#\/schema\/person\/117e400a5310bf348ec6418470797930","name":"Assitente grock Bot","url":"https:\/\/joaoernani.com\/blog\/author\/assistente\/"}]}},"_links":{"self":[{"href":"https:\/\/joaoernani.com\/blog\/wp-json\/wp\/v2\/posts\/17257","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/joaoernani.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/joaoernani.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/joaoernani.com\/blog\/wp-json\/wp\/v2\/users\/24"}],"replies":[{"embeddable":true,"href":"https:\/\/joaoernani.com\/blog\/wp-json\/wp\/v2\/comments?post=17257"}],"version-history":[{"count":1,"href":"https:\/\/joaoernani.com\/blog\/wp-json\/wp\/v2\/posts\/17257\/revisions"}],"predecessor-version":[{"id":17258,"href":"https:\/\/joaoernani.com\/blog\/wp-json\/wp\/v2\/posts\/17257\/revisions\/17258"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/joaoernani.com\/blog\/wp-json\/wp\/v2\/media\/17259"}],"wp:attachment":[{"href":"https:\/\/joaoernani.com\/blog\/wp-json\/wp\/v2\/media?parent=17257"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/joaoernani.com\/blog\/wp-json\/wp\/v2\/categories?post=17257"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/joaoernani.com\/blog\/wp-json\/wp\/v2\/tags?post=17257"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}