{"id":12674,"date":"2023-07-12T09:52:58","date_gmt":"2023-07-12T12:52:58","guid":{"rendered":"https:\/\/herospark.com\/blog\/?p=12674"},"modified":"2025-04-22T16:16:39","modified_gmt":"2025-04-22T19:16:39","slug":"inteligencia-artificial-para-planilhas","status":"publish","type":"post","link":"https:\/\/herospark.com\/blog\/inteligencia-artificial-para-planilhas\/","title":{"rendered":"Intelig\u00eancia artificial para planilhas: 5 op\u00e7\u00f5es + como usar"},"content":{"rendered":"\n<p>Voc\u00ea sabia que j\u00e1 existe intelig\u00eancia artificial para planilhas? Sim, em meio a tantas IAs dispon\u00edveis para facilitar a vida dos neg\u00f3cios, saiba que j\u00e1 existem tamb\u00e9m ferramentas para tornar o processo de constru\u00e7\u00e3o de planilhas mais simples.<\/p>\n\n\n\n<p>Essa \u00e9 uma boa not\u00edcia para quem \u00e9 empreendedor e precisa utilizar o Excel ou Google Sheets para controlar o fluxo de caixa ou para quem deseja<a href=\"https:\/\/herospark.com\/blog\/vender-planilha-no-excel\/\"> vender planilhas no Excel<\/a> como um infoproduto. Afinal, \u00e9 poss\u00edvel gastar menos tempo na sua produ\u00e7\u00e3o.&nbsp;&nbsp;<\/p>\n\n\n\n<p>Por isso, preparamos este post sobre intelig\u00eancia artificial para planilhas para que voc\u00ea conhe\u00e7a algumas boas op\u00e7\u00f5es no mercado. Confira!<\/p>\n\n\n\n<p><strong>Aprenda como usar o ChatGPT para automatizar o marketing digital do seu lan\u00e7amento e dos seus infoprodutos.<\/strong>\u00a0<strong>Baixe agora gr\u00e1tis!<\/strong><\/p>\n\n\n\n<div class=\"wp-block-leadin-hubspot-form-block\">\n\t\t\t\t\t<script>\n\t\t\t\t\t\twindow.hsFormsOnReady = window.hsFormsOnReady || [];\n\t\t\t\t\t\twindow.hsFormsOnReady.push(()=>{\n\t\t\t\t\t\t\thbspt.forms.create({\n\t\t\t\t\t\t\t\tportalId: 734319,\n\t\t\t\t\t\t\t\tformId: \"b2466da9-d3f1-410c-a3ad-8e6edbbd6440\",\n\t\t\t\t\t\t\t\ttarget: \"#hbspt-form-1779643614000-2823259812\",\n\t\t\t\t\t\t\t\tregion: \"na1\",\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t})});\n\t\t\t\t\t<\/script>\n\t\t\t\t\t<div class=\"hbspt-form\" id=\"hbspt-form-1779643614000-2823259812\"><\/div><\/div>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_45_2 counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\">O que voc&ecirc; ver&aacute;:<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"ez-toc-toggle-icon-1\"><label for=\"item-6a1334de9c957\" aria-label=\"Table of Content\"><span style=\"display: flex;align-items: center;width: 35px;height: 30px;justify-content: center;direction:ltr;\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/label><input style='display:none' type=\"checkbox\" id=\"item-6a1334de9c957\"><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/herospark.com\/blog\/inteligencia-artificial-para-planilhas\/#5_opcoes_de_inteligencia_artificial_para_planilhas\" title=\"5 op\u00e7\u00f5es de intelig\u00eancia artificial para planilhas\">5 op\u00e7\u00f5es de intelig\u00eancia artificial para planilhas<\/a><ul class='ez-toc-list-level-3'><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/herospark.com\/blog\/inteligencia-artificial-para-planilhas\/#1_Excelformulabot\" title=\"1. Excelformulabot\">1. Excelformulabot<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/herospark.com\/blog\/inteligencia-artificial-para-planilhas\/#2_Supermetrics\" title=\"2. Supermetrics\">2. Supermetrics<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/herospark.com\/blog\/inteligencia-artificial-para-planilhas\/#3_MonkeyLearn\" title=\"3. MonkeyLearn\">3. MonkeyLearn<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/herospark.com\/blog\/inteligencia-artificial-para-planilhas\/#4_DocParser\" title=\"4. DocParser\">4. DocParser<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/herospark.com\/blog\/inteligencia-artificial-para-planilhas\/#5_AppSheet\" title=\"5. AppSheet\">5. AppSheet<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/herospark.com\/blog\/inteligencia-artificial-para-planilhas\/#Como_usar_o_ChatGPT_no_Google_Sheets\" title=\"Como usar o ChatGPT no Google Sheets?\">Como usar o ChatGPT no Google Sheets?<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5_opcoes_de_inteligencia_artificial_para_planilhas\"><\/span>5 op\u00e7\u00f5es de intelig\u00eancia artificial para planilhas<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>A seguir, listamos 5 op\u00e7\u00f5es de intelig\u00eancia artificial para planilhas para que voc\u00ea possa otimizar o seu tempo e aumentar a efici\u00eancia da sua planilha no Excel ou Google Sheets.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_Excelformulabot\"><\/span>1. Excelformulabot<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Gratuito e f\u00e1cil de usar, o Excelformulabot \u00e9 uma IA que auxilia na gera\u00e7\u00e3o de f\u00f3rmulas do Excel de forma mais r\u00e1pida e f\u00e1cil. Basta o usu\u00e1rio enviar comandos em texto.<\/p>\n\n\n\n<p>Mas, al\u00e9m de gerar as f\u00f3rmulas, a ferramenta tamb\u00e9m fornece uma explica\u00e7\u00e3o sobre cada uma, o que pode ajudar as pessoas a entenderem o funcionamento da planilha.<\/p>\n\n\n\n<p>Conv\u00e9m destacar que essa ferramenta pode ser utilizada tanto no Excel quanto no Google Planilhas.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_Supermetrics\"><\/span>2. Supermetrics<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Essa \u00e9 uma intelig\u00eancia artificial voltada para a integra\u00e7\u00e3o. Isso porque, por meio dela, \u00e9 poss\u00edvel vincular as planilhas do Google a diversas fontes de dados. Dessa forma, \u00e9 poss\u00edvel importar informa\u00e7\u00f5es sem qualquer dificuldade.<\/p>\n\n\n\n<p>A vantagem de utilizar o Supermetrics \u00e9 conseguir realizar an\u00e1lises de dados e de relat\u00f3rios de forma consistente, uma vez que os dados importados s\u00e3o cruzados na planilha.&nbsp;&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3_MonkeyLearn\"><\/span>3. MonkeyLearn<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>J\u00e1 a MonkeyLearn \u00e9 uma IA voltada para a an\u00e1lise e marca\u00e7\u00e3o de textos. Ou seja, ela permite que o usu\u00e1rio automatize as tarefas de analisar, destacar e revisar os conte\u00fados escritos em uma planilha.<\/p>\n\n\n\n<p>Dessa forma, \u00e9 poss\u00edvel obter relat\u00f3rios mais assertivos e personalizados sem precisar gastar muito tempo.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4_DocParser\"><\/span>4. DocParser<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Essa \u00e9 mais uma ferramenta de IA que simplifica a extra\u00e7\u00e3o de dados. Sim, ela permite que o Google Sheets seja alimentado com dados de diferentes formatos de arquivo, como documentos digitalizados e PDF.<\/p>\n\n\n\n<p>Assim, ao realizar a exporta\u00e7\u00e3o das informa\u00e7\u00f5es desses arquivos, o DocParser os envia diretamente para a planilha, o que te ajuda a economizar tempo na etapa de coleta e exporta\u00e7\u00e3o de dados, que n\u00e3o precisa mais ser manual.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5_AppSheet\"><\/span>5. AppSheet<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Por fim, temos o AppSheet, uma <a href=\"https:\/\/herospark.com\/blog\/app-de-inteligencia-artificial\/\">intelig\u00eancia artificial<\/a> ideal para o <a href=\"https:\/\/herospark.com\/blog\/infoprodutor\/\">infoprodutor<\/a> que deseja criar aplicativos sem a necessidade de programar.<\/p>\n\n\n\n<p>\u00c9 isso mesmo! Essa ferramenta permite a detec\u00e7\u00e3o autom\u00e1tica de rela\u00e7\u00f5es de dados, al\u00e9m de criar formul\u00e1rios interativos e interfaces intuitivas.<\/p>\n\n\n\n<p>Portanto, quem deseja criar um app para dispositivo m\u00f3vel ou computador, mas n\u00e3o sabe criar c\u00f3digos, pode aproveitar a funcionalidade dessa IA para lan\u00e7ar um novo infoproduto no mercado.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Como_usar_o_ChatGPT_no_Google_Sheets\"><\/span>Como usar o ChatGPT no Google Sheets?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Atualmente, o Google Sheets \u2013 ou simplesmente Google Planilhas \u2013 tem sido preferido por muitas pessoas por permitir a cria\u00e7\u00e3o de planilhas de forma online e colaborativa.<\/p>\n\n\n\n<p>Mas o que pouca gente sabe \u00e9 que uma das <a href=\"https:\/\/herospark.com\/blog\/tipos-de-inteligencia-artificial\/\">intelig\u00eancias artificiais<\/a> mais famosas do momento pode ser usada no Google Sheets: o<a href=\"https:\/\/herospark.com\/blog\/chat-gpt\/\"> ChatGPT<\/a>!<\/p>\n\n\n\n<p>Sim, a integra\u00e7\u00e3o entre Google Planilhas e ChatGPT permite que voc\u00ea tenha acesso a ideias inovadoras para o seu projeto, independente de qual seja ele, al\u00e9m de melhorar a produtividade e otimizar a sua rotina. E tudo isso sem precisar ir ao navegador!<\/p>\n\n\n\n<p>Portanto, a IA de di\u00e1logos virtuais pode ser usada nas suas planilhas para que voc\u00ea crie materiais mais ricos e diferentes de tudo aquilo que existe no mercado.<\/p>\n\n\n\n<p>Para te ajudar com isso, trouxemos um passo a passo a seguir de como integrar o ChatGPT ao Google Sheets. Veja como \u00e9 simples!<\/p>\n\n\n\n<p>1. Dentro do Google Planilhas, clique em \u201c<strong>Extens\u00f5es<\/strong>\u201d. Na sequ\u00eancia, acesse \u201c<strong>Complementos<\/strong>\u201d e \u201c<strong>Instalar complementos<\/strong>\u201d.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img  fetchpriority=\"high\"  decoding=\"async\"  width=\"1024\"  height=\"485\"  src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAABAAAAAHlAQMAAABRYhxWAAAAA1BMVEUAAP+KeNJXAAAAAXRSTlMAQObYZgAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAFNJREFUeNrtwTEBAAAAwqD1T20MH6AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADgbPRlAAEL5O9zAAAAAElFTkSuQmCC\"  alt=\"\"  class=\"wp-image-12675 pk-lazyload\"  data-pk-sizes=\"auto\"  data-ls-sizes=\"(max-width: 1024px) 100vw, 1024px\"  data-pk-src=\"https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/Conectar-ChatGPT-e-Google-Sheets-1-1024x485.png\"  data-pk-srcset=\"https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/Conectar-ChatGPT-e-Google-Sheets-1-1024x485.png 1024w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/Conectar-ChatGPT-e-Google-Sheets-1-300x142.png 300w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/Conectar-ChatGPT-e-Google-Sheets-1-768x363.png 768w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/Conectar-ChatGPT-e-Google-Sheets-1-390x185.png 390w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/Conectar-ChatGPT-e-Google-Sheets-1-820x388.png 820w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/Conectar-ChatGPT-e-Google-Sheets-1-1180x558.png 1180w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/Conectar-ChatGPT-e-Google-Sheets-1-150x71.png 150w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/Conectar-ChatGPT-e-Google-Sheets-1.png 1304w\" ><\/figure>\n\n\n\n<p>2. No campo de pesquisa que aparece, digite \u201c<strong>ChatGPT for Sheets and Docs<\/strong>\u201d.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img  decoding=\"async\"  src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABAQMAAAAl21bKAAAAA1BMVEUAAP+KeNJXAAAAAXRSTlMAQObYZgAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAApJREFUCNdjYAAAAAIAAeIhvDMAAAAASUVORK5CYII=\"  alt=\"\"  class=\"wp-image-12676 pk-lazyload\"  style=\"width:670px;height:352px\"  width=\"670\"  height=\"352\"  data-pk-sizes=\"auto\"  data-ls-sizes=\"(max-width: 670px) 100vw, 670px\"  data-pk-src=\"https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/Conectar-ChatGPT-e-Google-Sheets-2.png\"  data-pk-srcset=\"https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/Conectar-ChatGPT-e-Google-Sheets-2.png 978w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/Conectar-ChatGPT-e-Google-Sheets-2-300x158.png 300w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/Conectar-ChatGPT-e-Google-Sheets-2-768x404.png 768w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/Conectar-ChatGPT-e-Google-Sheets-2-390x205.png 390w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/Conectar-ChatGPT-e-Google-Sheets-2-820x432.png 820w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/Conectar-ChatGPT-e-Google-Sheets-2-150x79.png 150w\" ><\/figure>\n\n\n\n<p>3. Clique em \u201c<strong>Instalar<\/strong>\u201d.&nbsp;<br>4. Agora, volte novamente na planilha. Selecione \u201cExtens\u00f5es\u201d e aparecer\u00e1 que o \u201c<strong>ChatGPT for Sheets and Docs<\/strong>\u201d foi instalado. Ent\u00e3o, clique nele e, ap\u00f3s, clique em \u201c<strong>Enable GPT functions<\/strong>\u201d.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img  decoding=\"async\"  width=\"1024\"  height=\"419\"  src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAABAAAAAGjAQMAAACIY\/UnAAAAA1BMVEUAAP+KeNJXAAAAAXRSTlMAQObYZgAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAEtJREFUeNrtwTEBAAAAwqD1T20MH6AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAOBvTIwABLX198AAAAABJRU5ErkJggg==\"  alt=\"\"  class=\"wp-image-12677 pk-lazyload\"  data-pk-sizes=\"auto\"  data-ls-sizes=\"(max-width: 1024px) 100vw, 1024px\"  data-pk-src=\"https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/extensao-gpt-1024x419.jpg\"  data-pk-srcset=\"https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/extensao-gpt-1024x419.jpg 1024w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/extensao-gpt-300x123.jpg 300w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/extensao-gpt-768x314.jpg 768w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/extensao-gpt-390x160.jpg 390w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/extensao-gpt-820x336.jpg 820w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/extensao-gpt-1180x483.jpg 1180w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/extensao-gpt-150x61.jpg 150w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/extensao-gpt.jpg 1302w\" ><\/figure>\n\n\n\n<p>5. Em seguida, <a href=\"https:\/\/platform.openai.com\/docs\/api-reference\">acesse esse link da OpenAI<\/a> e fa\u00e7a o seu login (ou cadastre-se).&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img  loading=\"lazy\"  decoding=\"async\"  width=\"1024\"  height=\"463\"  src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAABAAAAAHPAQMAAAD3VToGAAAAA1BMVEUAAP+KeNJXAAAAAXRSTlMAQObYZgAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAFFJREFUeNrtwTEBAAAAwqD1T20MH6AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACAswHpTwABtJPlmwAAAABJRU5ErkJggg==\"  alt=\"\"  class=\"wp-image-12678 pk-lazyload\"  data-pk-sizes=\"auto\"  data-ls-sizes=\"(max-width: 1024px) 100vw, 1024px\"  data-pk-src=\"https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/Conectar-ChatGPT-e-Google-Sheets-4-1024x463.png\"  data-pk-srcset=\"https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/Conectar-ChatGPT-e-Google-Sheets-4-1024x463.png 1024w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/Conectar-ChatGPT-e-Google-Sheets-4-300x136.png 300w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/Conectar-ChatGPT-e-Google-Sheets-4-768x347.png 768w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/Conectar-ChatGPT-e-Google-Sheets-4-390x176.png 390w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/Conectar-ChatGPT-e-Google-Sheets-4-820x370.png 820w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/Conectar-ChatGPT-e-Google-Sheets-4-1180x533.png 1180w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/Conectar-ChatGPT-e-Google-Sheets-4-150x68.png 150w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/Conectar-ChatGPT-e-Google-Sheets-4.png 1359w\" ><\/figure>\n\n\n\n<p>6. Depois de logar, clique em \u201c<strong>Personal<\/strong>\u201d, no canto superior direito da tela e, em seguida, em \u201c<strong>View API Keys<\/strong>\u201d. Depois, clique em \u201c<strong>Create new secret Key<\/strong>\u201d.<\/p>\n\n\n\n<p>7. O passo anterior vai gerar um c\u00f3digo. Copie-o.&nbsp;<\/p>\n\n\n\n<p>8. V\u00e1 novamente ao Google Planilhas, clique em \u201c<strong>Extens\u00f5es<\/strong>\u201d, em \u201c<strong>ChatGPT for Sheets and Docs<\/strong>\u201d e, por fim, em \u201c<strong>Set API Key<\/strong>\u201d. Aqui voc\u00ea vai colar o c\u00f3digo que foi copiado e clicar em \u201c<strong>Save API Key<\/strong>\u201d.&nbsp;<\/p>\n\n\n\n<p>9. Por fim, clique novamente em \u201c<strong>Extens\u00f5es<\/strong>\u201d, em \u201c<strong>ChatGPT for Sheets and Docs<\/strong>\u201d e em \u201c<strong>Enable GPT Functions<\/strong>\u201d para ativar o ChatGPT no Google Sheets. Voc\u00ea receber\u00e1 uma mensagem confirmando essa ativa\u00e7\u00e3o!<\/p>\n\n\n\n<p>Finalmente, o ChatGPT j\u00e1 est\u00e1 integrado ao seu Google Planilhas e voc\u00ea j\u00e1 pode us\u00e1-lo! Viu como \u00e9 simples?<\/p>\n\n\n\n<p>Vale dizer que sempre que voc\u00ea quiser utilizar a fun\u00e7\u00e3o do ChatGPT na sua planilha \u00e9 s\u00f3 utilizar a seguinte f\u00f3rmula:<\/p>\n\n\n\n<p><strong>=GPT()<\/strong><\/p>\n\n\n\n<p>Entre os par\u00eanteses, voc\u00ea deve inserir a sua solicita\u00e7\u00e3o, como no exemplo abaixo:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"998\" height=\"350\" src=\"https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/exemplo-gpt.jpg\" alt=\"exemplo de uso AI para planilhas\n\" class=\"wp-image-12679\" srcset=\"https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/exemplo-gpt.jpg 998w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/exemplo-gpt-300x105.jpg 300w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/exemplo-gpt-768x269.jpg 768w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/exemplo-gpt-390x137.jpg 390w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/exemplo-gpt-820x288.jpg 820w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/exemplo-gpt-150x53.jpg 150w\" sizes=\"(max-width: 998px) 100vw, 998px\" \/><\/figure>\n\n\n\n<p>Ent\u00e3o, ele responder\u00e1 com o solicitado no comando enviado. Veja:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img  loading=\"lazy\"  decoding=\"async\"  width=\"998\"  height=\"333\"  src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAA+YAAAFNAQMAAAC36udgAAAAA1BMVEUAAP+KeNJXAAAAAXRSTlMAQObYZgAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAEBJREFUeNrtwTEBAAAAwqD1T20ND6AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA4N0Ao+YAAZN347AAAAAASUVORK5CYII=\"  alt=\"\"  class=\"wp-image-12680 pk-lazyload\"  data-pk-sizes=\"auto\"  data-ls-sizes=\"(max-width: 998px) 100vw, 998px\"  data-pk-src=\"https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/ideias-gpt-ok.jpg\"  data-pk-srcset=\"https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/ideias-gpt-ok.jpg 998w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/ideias-gpt-ok-300x100.jpg 300w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/ideias-gpt-ok-768x256.jpg 768w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/ideias-gpt-ok-390x130.jpg 390w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/ideias-gpt-ok-820x274.jpg 820w, https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/ideias-gpt-ok-150x50.jpg 150w\" ><\/figure>\n\n\n\n<p>E ent\u00e3o, gostou de conhecer todas essas op\u00e7\u00f5es de intelig\u00eancia artificial para planilhas? J\u00e1 sabe qual ou quais voc\u00ea vai utilizar no seu neg\u00f3cio?<\/p>\n\n\n\n<p>Mas n\u00e3o pense que nossas dicas acabaram por aqui! Para voc\u00ea que deseja lan\u00e7ar um infoproduto de sucesso, como um curso online ou um e-book, \u00e9 imprescind\u00edvel conhecer uma outra IA que facilitar\u00e1 todo esse processo: o HeroCreator!<\/p>\n\n\n\n<p>Sim, essa ferramenta de IA da HeroSpark permite que voc\u00ea planeje e estruture em apenas 3 minutos o seu produto digital. E o melhor: de forma totalmente gratuita!<\/p>\n\n\n\n<p>Portanto, <a href=\"https:\/\/herospark.com\/academia\/herocreator\">garanta o seu acesso hoje mesmo ao HeroCreator<\/a> para faturar muito com o seu pr\u00f3ximo infoproduto!<\/p>\n","protected":false},"excerpt":{"rendered":"Voc&ecirc; sabia que j&aacute; existe intelig&ecirc;ncia artificial para planilhas? Sim, em meio a tantas IAs dispon&iacute;veis para facilitar a vida dos neg&oacute;cios, saiba que j&aacute; existem tamb&eacute;m ferramentas para tornar&hellip;\n","protected":false},"author":63,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"content-type":"","_uag_custom_page_level_css":"","footnotes":""},"categories":[4121],"tags":[4485],"yst_prominent_words":[977,1903],"class_list":{"0":"post-12674","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-inteligencia-artificial","7":"tag-ai-para-planilhas"},"acf":[],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false,"pk-small":false,"pk-thumbnail":false,"cs-small":false,"cs-intermediate":false,"cs-thumbnail":false,"cs-thumbnail-uncropped":false,"cs-medium":false,"cs-large":false,"web-stories-poster-portrait":false,"web-stories-publisher-logo":false,"web-stories-thumbnail":false},"uagb_author_info":{"display_name":"Nilson Filatieri","author_link":"https:\/\/herospark.com\/blog\/author\/nilson\/"},"uagb_comment_info":2,"uagb_excerpt":"Voc&ecirc; sabia que j&aacute; existe intelig&ecirc;ncia artificial para planilhas? Sim, em meio a tantas IAs dispon&iacute;veis para facilitar a vida dos neg&oacute;cios, saiba que j&aacute; existem tamb&eacute;m ferramentas para tornar&hellip;","yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v14.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Intelig\u00eancia artificial para planilhas: 5 op\u00e7\u00f5es + como usar<\/title>\n<meta name=\"description\" content=\"Voc\u00ea sabia que j\u00e1 existe intelig\u00eancia artificial para planilhas? Sim, em meio a tantas IAs dispon\u00edveis para facilitar a vida dos neg\u00f3cios\" \/>\n<meta name=\"robots\" content=\"index, follow\" \/>\n<meta name=\"googlebot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta name=\"bingbot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/herospark.com\/blog\/inteligencia-artificial-para-planilhas\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Intelig\u00eancia artificial para planilhas: 5 op\u00e7\u00f5es + como usar\" \/>\n<meta property=\"og:description\" content=\"Voc\u00ea sabia que j\u00e1 existe intelig\u00eancia artificial para planilhas? Sim, em meio a tantas IAs dispon\u00edveis para facilitar a vida dos neg\u00f3cios\" \/>\n<meta property=\"og:url\" content=\"https:\/\/herospark.com\/blog\/inteligencia-artificial-para-planilhas\/\" \/>\n<meta property=\"og:site_name\" content=\"HeroSpark Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-12T12:52:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-22T19:16:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/herospark.com\/blog\/wp-content\/uploads\/sites\/6\/2023\/07\/Conectar-ChatGPT-e-Google-Sheets-1-1024x485.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","amp_enabled":true,"_links":{"self":[{"href":"https:\/\/herospark.com\/blog\/wp-json\/wp\/v2\/posts\/12674","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/herospark.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/herospark.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/herospark.com\/blog\/wp-json\/wp\/v2\/users\/63"}],"replies":[{"embeddable":true,"href":"https:\/\/herospark.com\/blog\/wp-json\/wp\/v2\/comments?post=12674"}],"version-history":[{"count":0,"href":"https:\/\/herospark.com\/blog\/wp-json\/wp\/v2\/posts\/12674\/revisions"}],"wp:attachment":[{"href":"https:\/\/herospark.com\/blog\/wp-json\/wp\/v2\/media?parent=12674"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/herospark.com\/blog\/wp-json\/wp\/v2\/categories?post=12674"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/herospark.com\/blog\/wp-json\/wp\/v2\/tags?post=12674"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/herospark.com\/blog\/wp-json\/wp\/v2\/yst_prominent_words?post=12674"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}