{"id":23785,"date":"2024-04-15T16:51:41","date_gmt":"2024-04-15T14:51:41","guid":{"rendered":"https:\/\/www.solypse.com\/?p=23785"},"modified":"2024-04-15T17:06:06","modified_gmt":"2024-04-15T15:06:06","slug":"integration-google-sheet-chatgpt","status":"publish","type":"post","link":"https:\/\/www.solypse.com\/en\/integration-google-sheet-chatgpt\/","title":{"rendered":"Int\u00e9grez google sheet et chatgpt en 10 minutes"},"content":{"rendered":"<div data-elementor-type=\"wp-post\" data-elementor-id=\"23785\" class=\"elementor elementor-23785\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1d1ff9b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1d1ff9b\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-2abbdbd\" data-id=\"2abbdbd\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c294d5e elementor-widget elementor-widget-text-editor\" data-id=\"c294d5e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>On vous montre dans cet article comment<strong> Chatgpt peut enrichir facilement nos outils du quotidien<\/strong> (ici Google Sheets) et nous faire gagner en productivit\u00e9.<\/p><p>Dans notre exemple, on cherche \u00e0 classifier des extraits de compte bancaire \u00e0 l\u2019aide de l\u2019IA d&rsquo;OpenAI (ChatGPT). On dispose d\u2019un fichier issu d\u2019un relev\u00e9 bancaire avec pour chaque ligne le libell\u00e9 de la transaction financi\u00e8re. On a par ailleurs un fichier historique des paiements que l\u2019on a d\u00e9j\u00e0 classifi\u00e9 manuellement, avec 2 attributs &#8211; un compte et une cat\u00e9gorie -.<\/p><p>Le but est d\u2019utiliser ChatGPT pour d\u00e9terminer automatiquement \u00e0 quel compte on peut rattacher une ligne bancaire.<\/p><div class=\"pixiebrix-tooltips-container\"><div style=\"z-index: 2147483645; position: fixed; width: max-content; height: max-content; top: -29.0156px; left: 98px; margin: 0px; padding: 0px; background-color: #ffffff; border-radius: 4px; border: 1px solid #dedbe3; box-shadow: rgba(56, 51, 66, 0.16) 0px 4px 8px -4px; display: none;\" data-testid=\"pixiebrix-selection-menu\" aria-hidden=\"true\"><div style=\"all: initial;\">\u00a0<\/div><\/div><div style=\"z-index: 2147483645; position: fixed; width: max-content; height: max-content; top: 142.984px; left: 0px; margin: 0px; padding: 0px; background-color: #ffffff; border-radius: 4px; border: 1px solid #dedbe3; box-shadow: rgba(56, 51, 66, 0.16) 0px 4px 8px -4px; display: block;\" data-testid=\"pixiebrix-selection-menu\" aria-hidden=\"false\"><div style=\"all: initial;\">\u00a0<\/div><\/div><div style=\"z-index: 2147483645; position: fixed; width: max-content; height: max-content; top: 166.984px; left: 91.1797px; margin: 0px; padding: 0px; background-color: #ffffff; border-radius: 4px; border: 1px solid #dedbe3; box-shadow: rgba(56, 51, 66, 0.16) 0px 4px 8px -4px; display: none;\" data-testid=\"pixiebrix-selection-menu\" aria-hidden=\"true\"><div style=\"all: initial;\">\u00a0<\/div><\/div><div style=\"z-index: 2147483645; position: fixed; width: max-content; height: max-content; top: 214.984px; left: 89.8906px; margin: 0px; padding: 0px; background-color: #ffffff; border-radius: 4px; border: 1px solid #dedbe3; box-shadow: rgba(56, 51, 66, 0.16) 0px 4px 8px -4px; display: none;\" data-testid=\"pixiebrix-selection-menu\" aria-hidden=\"true\"><div style=\"all: initial;\">\u00a0<\/div><\/div><div style=\"z-index: 2147483645; position: fixed; width: max-content; height: max-content; top: 190.984px; left: 47.5977px; margin: 0px; padding: 0px; background-color: #ffffff; border-radius: 4px; border: 1px solid #dedbe3; box-shadow: rgba(56, 51, 66, 0.16) 0px 4px 8px -4px; display: none;\" data-testid=\"pixiebrix-selection-menu\" aria-hidden=\"true\"><div style=\"all: initial;\">\u00a0<\/div><\/div><\/div><div class=\"pixiebrix-notifier-container\" style=\"all: initial;\"><div style=\"position: fixed; z-index: 2147483647; inset: 16px; pointer-events: none; font-family: sans-serif;\">\u00a0<\/div><\/div><div class=\"pixiebrix-notifier-container\" style=\"all: initial;\"><div style=\"position: fixed; z-index: 2147483647; inset: 16px; pointer-events: none; font-family: sans-serif;\">\u00a0<\/div><\/div><div class=\"pixiebrix-notifier-container\" style=\"all: initial;\"><div style=\"position: fixed; z-index: 2147483647; inset: 16px; pointer-events: none; font-family: sans-serif;\">\u00a0<\/div><\/div><div class=\"pixiebrix-notifier-container\" style=\"all: initial;\"><div style=\"position: fixed; z-index: 2147483647; inset: 16px; pointer-events: none; font-family: sans-serif;\">\u00a0<\/div><\/div><div class=\"pixiebrix-notifier-container\" style=\"all: initial;\"><div style=\"position: fixed; z-index: 2147483647; inset: 16px; pointer-events: none; font-family: sans-serif;\">\u00a0<\/div><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-dfe6f6e\" data-id=\"dfe6f6e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1ce1d97 elementor-widget elementor-widget-image\" data-id=\"1ce1d97\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"768\" height=\"768\" src=\"https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/Pub-Solypse-V6-Rose-7-768x768.png\" class=\"attachment-medium_large size-medium_large wp-image-23790\" alt=\"google sheet chatgpt boost\" srcset=\"https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/Pub-Solypse-V6-Rose-7-768x768.png 768w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/Pub-Solypse-V6-Rose-7-300x300.png 300w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/Pub-Solypse-V6-Rose-7-1024x1024.png 1024w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/Pub-Solypse-V6-Rose-7-150x150.png 150w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/Pub-Solypse-V6-Rose-7-12x12.png 12w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/Pub-Solypse-V6-Rose-7-570x570.png 570w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/Pub-Solypse-V6-Rose-7-500x500.png 500w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/Pub-Solypse-V6-Rose-7-1000x1000.png 1000w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/Pub-Solypse-V6-Rose-7-700x700.png 700w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/Pub-Solypse-V6-Rose-7.png 1200w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-024631c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"024631c\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5af6cdb\" data-id=\"5af6cdb\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-53b9b57 elementor-widget elementor-widget-spacer\" data-id=\"53b9b57\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e65ace3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e65ace3\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-fd1096f\" data-id=\"fd1096f\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-864f91d elementor-widget elementor-widget-heading\" data-id=\"864f91d\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">1. Pr\u00e9requis<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c452a61 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c452a61\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b18c360\" data-id=\"b18c360\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ab84f9b elementor-widget elementor-widget-spacer\" data-id=\"ab84f9b\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3b3b465 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3b3b465\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d32b5b3\" data-id=\"d32b5b3\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-41c46fd elementor-widget elementor-widget-text-editor\" data-id=\"41c46fd\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Vous aurez besoin avant de commencer des \u00e9l\u00e9ments suivants :\u00a0<\/p><p><!-- notionvc: c5b722c0-7041-471a-ba23-f80e632cadc6 --><\/p><ul><li>un acc\u00e8s \u00e0 Google Sheets<\/li><li>l\u2019autorisation d\u2019utiliser Apps Scripts (il faut \u00eatre propri\u00e9taire de la feuille)<\/li><li>un compte OpenAI platform (<a href=\"https:\/\/platform.openai.com\/\">https:\/\/platform.openai.com\/<\/a>)<\/li><\/ul><div style=\"all: initial;\">\u00a0<\/div><div class=\"pixiebrix-notifier-container\" style=\"all: initial;\"><div style=\"position: fixed; z-index: 2147483647; inset: 16px; pointer-events: none; font-family: sans-serif;\">\u00a0<\/div><\/div><div class=\"pixiebrix-notifier-container\" style=\"all: initial;\"><div style=\"position: fixed; z-index: 2147483647; inset: 16px; pointer-events: none; font-family: sans-serif;\">\u00a0<\/div><\/div><div class=\"pixiebrix-tooltips-container\"><div style=\"z-index: 2147483645; position: fixed; width: max-content; height: max-content; top: 46.9844px; left: 75.207px; margin: 0px; padding: 0px; background-color: #ffffff; border-radius: 4px; border: 1px solid #dedbe3; box-shadow: rgba(56, 51, 66, 0.16) 0px 4px 8px -4px; display: block;\" data-testid=\"pixiebrix-selection-menu\" aria-hidden=\"false\"><div style=\"all: initial;\">\u00a0<\/div><\/div><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0c85b6a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0c85b6a\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-abcfa68\" data-id=\"abcfa68\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-cc77e2d elementor-widget elementor-widget-spacer\" data-id=\"cc77e2d\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-53991a8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"53991a8\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-dbff3b1\" data-id=\"dbff3b1\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a35fd85 elementor-widget elementor-widget-heading\" data-id=\"a35fd85\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">2. principe de fonctionnement<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5d87216 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5d87216\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-cf42978\" data-id=\"cf42978\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a3fce06 elementor-widget elementor-widget-spacer\" data-id=\"a3fce06\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-219254f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"219254f\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-188602f\" data-id=\"188602f\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-90fac35 elementor-widget elementor-widget-text-editor\" data-id=\"90fac35\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>On dispose d&rsquo;un relev\u00e9 bancaire et\u00a0 <span style=\"background-color: #ffffff;\">on souhaite que ChatGPT associe chaque ligne \u00e0 la r\u00e9f\u00e9rence la plus pertinente parmi une liste de valeurs possibles. On n&rsquo;utilise pas ici les rapprochements manuels r\u00e9alis\u00e9s par le pass\u00e9 (ce sera l&rsquo;objet d&rsquo;un prochain billet).<\/span><\/p><p><span style=\"background-color: #ffffff;\">Exemples d&rsquo;association :\u00a0<\/span><\/p><ul><li>Carte X1234 01\/01 Resto \u2192 Resto<\/li><li>Frais 1234 Banque; fin de mois \u2192 Banque<\/li><li>VIR EUROPEEN EMIS ;REF: 123456;REMISE: Salaire janvier 2024;VIR987654 \u2192 Salaire<\/li><\/ul><div style=\"all: initial;\">\u00a0<\/div><div class=\"pixiebrix-notifier-container\" style=\"all: initial;\"><div style=\"position: fixed; z-index: 2147483647; inset: 16px; pointer-events: none; font-family: sans-serif;\">\u00a0<\/div><\/div><div class=\"pixiebrix-tooltips-container\"><div style=\"z-index: 2147483645; position: fixed; width: max-content; height: max-content; top: 46.9844px; left: 3.45312px; margin: 0px; padding: 0px; background-color: #ffffff; border-radius: 4px; border: 1px solid #dedbe3; box-shadow: rgba(56, 51, 66, 0.16) 0px 4px 8px -4px; display: none;\" data-testid=\"pixiebrix-selection-menu\" aria-hidden=\"true\"><div style=\"all: initial;\">\u00a0<\/div><\/div><\/div><div class=\"pixiebrix-notifier-container\" style=\"all: initial;\"><div style=\"position: fixed; z-index: 2147483647; inset: 16px; pointer-events: none; font-family: sans-serif;\">\u00a0<\/div><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0bfbe55 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0bfbe55\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1ac166d\" data-id=\"1ac166d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e96509f elementor-widget elementor-widget-spacer\" data-id=\"e96509f\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-27b93c4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"27b93c4\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2533b02\" data-id=\"2533b02\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b4296b6 elementor-widget elementor-widget-heading\" data-id=\"b4296b6\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">3. creation d'une clef api openai<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b92b265 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b92b265\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2bf141e\" data-id=\"2bf141e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-829a5e2 elementor-widget elementor-widget-spacer\" data-id=\"829a5e2\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c7fd2f3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c7fd2f3\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-07c79b4\" data-id=\"07c79b4\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-156edda elementor-widget elementor-widget-text-editor\" data-id=\"156edda\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Avant toute chose, il faut r\u00e9cup\u00e9rer une clef API sur la page <a style=\"color: inherit; overflow-wrap: break-word; text-decoration: inherit;\" tabindex=\"0\" href=\"https:\/\/platform.openai.com\/api-keys\" rel=\"noopener noreferrer\" data-token-index=\"1\"><span style=\"border-bottom: 0.05em solid; border-color: rgba(55,53,47,.4); opacity: 0.7;\">https:\/\/platform.openai.com\/api-keys<\/span><\/a>. Cliquez sur la section \u00e9ponyme et cr\u00e9ez une nouvelle cl\u00e9. Dans notre cas, il n\u2019est pas besoin de de configurer les d\u00e9tails.<!-- notionvc: 04c22993-235e-47a3-bef0-f3a0a380737e --><\/p><p><strong><span style=\"color: #ff0000;\">ATTENTION<\/span> <\/strong><span style=\"color: #ff0000;\">Conservez la cl\u00e9 g\u00e9n\u00e9r\u00e9e de fa\u00e7on s\u00e9curis\u00e9e car si une personne malintentionn\u00e9e parvient \u00e0 s\u2019en emparer, elle pourrait utiliser ChatGPT \u00e0 votre place et g\u00e9n\u00e9rer un surco\u00fbt.<\/span><\/p><div style=\"all: initial;\"><div style=\"position: fixed; z-index: 2147483647; inset: 16px; pointer-events: none; font-family: sans-serif;\">\u00a0<\/div><\/div><div style=\"all: initial;\"><div style=\"position: fixed; z-index: 2147483647; inset: 16px; pointer-events: none; font-family: sans-serif;\">\u00a0<\/div><\/div><div class=\"pixiebrix-tooltips-container\"><div style=\"z-index: 2147483645; position: fixed; width: max-content; height: max-content; top: 128.969px; left: 46.3086px; margin: 0px; padding: 0px; background-color: #ffffff; border-radius: 4px; border: 1px solid #dedbe3; box-shadow: rgba(56, 51, 66, 0.16) 0px 4px 8px -4px; display: block;\" data-testid=\"pixiebrix-selection-menu\" aria-hidden=\"false\"><div style=\"all: initial;\">\u00a0<\/div><\/div><div style=\"z-index: 2147483645; position: fixed; width: max-content; height: max-content; top: 24.4688px; left: 144.523px; margin: 0px; padding: 0px; background-color: #ffffff; border-radius: 4px; border: 1px solid #dedbe3; box-shadow: rgba(56, 51, 66, 0.16) 0px 4px 8px -4px; display: block;\" data-testid=\"pixiebrix-selection-menu\" aria-hidden=\"false\"><div style=\"all: initial;\">\u00a0<\/div><\/div><\/div><div class=\"pixiebrix-notifier-container\" style=\"all: initial;\"><div style=\"position: fixed; z-index: 2147483647; inset: 16px; pointer-events: none; font-family: sans-serif;\">\u00a0<\/div><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d0d290f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d0d290f\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-66 elementor-top-column elementor-element elementor-element-3caf784\" data-id=\"3caf784\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c7439ff elementor-widget elementor-widget-image\" data-id=\"c7439ff\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"151\" src=\"https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/API-Key-CHatGPT-Platform-1024x193.png\" class=\"attachment-large size-large wp-image-23791\" alt=\"chatgpt platform\" srcset=\"https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/API-Key-CHatGPT-Platform-1024x193.png 1024w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/API-Key-CHatGPT-Platform-300x57.png 300w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/API-Key-CHatGPT-Platform-768x145.png 768w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/API-Key-CHatGPT-Platform-1536x290.png 1536w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/API-Key-CHatGPT-Platform-18x3.png 18w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/API-Key-CHatGPT-Platform-700x132.png 700w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/API-Key-CHatGPT-Platform.png 2000w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-04f2cdd\" data-id=\"04f2cdd\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a34120a elementor-widget elementor-widget-image\" data-id=\"a34120a\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"425\" src=\"https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/APIKeyConf-1024x544.png\" class=\"attachment-large size-large wp-image-23792\" alt=\"\" srcset=\"https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/APIKeyConf-1024x544.png 1024w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/APIKeyConf-300x159.png 300w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/APIKeyConf-768x408.png 768w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/APIKeyConf-1536x816.png 1536w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/APIKeyConf-18x10.png 18w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/APIKeyConf-700x372.png 700w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/APIKeyConf.png 2000w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-658d6f8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"658d6f8\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-24acd31\" data-id=\"24acd31\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7a4400c elementor-widget elementor-widget-spacer\" data-id=\"7a4400c\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-39bd138 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"39bd138\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0a61a8a\" data-id=\"0a61a8a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f609098 elementor-widget elementor-widget-heading\" data-id=\"f609098\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">4. definition du script d'appel de google sheet<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ad9970e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ad9970e\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e2672d4\" data-id=\"e2672d4\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-239940d elementor-widget elementor-widget-spacer\" data-id=\"239940d\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-fb5ebfb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fb5ebfb\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d498d71\" data-id=\"d498d71\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f0b6b3b elementor-widget elementor-widget-text-editor\" data-id=\"f0b6b3b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Un script d&rsquo;appel &#8211; \u00e9crit dans le langage Google Apps Script &#8211; est n\u00e9cessaire pour appeler ChatGPT directement depuis Google Sheets et lui fournir en entr\u00e9e des donn\u00e9es issues d\u2019autres cellules des feuilles Google Sheet. Dans ce script il est possible de configurer \u00e0 travers un prompt la fonction \u00e0 r\u00e9aliser et le format du  r\u00e9sultat attendu par ChatGPT.&nbsp;<\/p><p>Il n\u2019est pas n\u00e9cessaire d\u2019avoir une grande connaissance du d\u00e9veloppement pour utiliser le script et nous vous fournissons un exemple simple \u00e0 configurer.<\/p>\n<div style=\"all: initial;\">\n<\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-874f39d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"874f39d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1250cc6\" data-id=\"1250cc6\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f9c7627 elementor-widget elementor-widget-text-editor\" data-id=\"f9c7627\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>function fetchData(<span style=\"color: #ff0000;\">systemContent<\/span>) {<br \/>try {<br \/>const headers = {<br \/>\u00ab\u00a0Content-Type\u00a0\u00bb: \u00ab\u00a0application\/json\u00a0\u00bb,<br \/>\u00ab\u00a0Authorization\u00a0\u00bb: `Bearer ${<span style=\"color: #ff0000;\">CHAT_GPT_API_KEY<\/span>}`<br \/>};<\/p><p><span style=\"color: #0000ff;\">var feuille = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(\u00ab\u00a0CompteCategorie\u00a0\u00bb);<\/span><br \/><span style=\"color: #0000ff;\">var donneesColonne = feuille.getRange(\u00ab\u00a0A1:A250\u00a0\u00bb).getValues(); \/\/ Lire les x premi\u00e8res cellules de la colonne C<\/span><br \/><span style=\"color: #0000ff;\">var texteColonne = donneesColonne.map(function(row) { return row[0]; }).join(\u00ab\u00a0; \u00ab\u00a0);<\/span><\/p><p>const options = {<br \/>headers,<br \/>method: \u00ab\u00a0GET\u00a0\u00bb,<br \/>muteHttpExceptions: true,<br \/>payload: JSON.stringify({<br \/>\u00ab\u00a0model\u00a0\u00bb: \u00ab\u00a0gpt-4\u00a0\u00bb,<br \/>\u00ab\u00a0messages\u00a0\u00bb: [{<br \/>\u00ab\u00a0role\u00a0\u00bb: \u00ab\u00a0system\u00a0\u00bb,<br \/>\u00ab\u00a0content\u00a0\u00bb: \u00ab\u00a0Voici une valeur : \u00a0\u00bb + <span style=\"color: #ff0000;\">systemContent<\/span> + \u00ab\u00a0. Trouve le compte correspondant parmi les comptes de r\u00e9f\u00e9rence et renvoie isreference \u00e0 1. Si tu ne trouves pas de correspondance, cr\u00e9e un nouveau compte et mets un isreference \u00e0 0. Renvoie un json avec les clefs compte et isreference. Voici les comptes de r\u00e9f\u00e9rence : \u00a0\u00bb + <span style=\"color: #0000ff;\">texteColonne<\/span>,<br \/>},<br \/>{<br \/>\u00ab\u00a0role\u00a0\u00bb: \u00ab\u00a0user\u00a0\u00bb,<br \/>\u00ab\u00a0content\u00a0\u00bb: \u00ab\u00a0user\u00a0\u00bb<br \/>},<br \/>],<br \/><span style=\"color: #008000;\">\u00ab\u00a0temperature\u00a0\u00bb: 0.3<\/span><br \/>})<br \/>};<\/p><p>const response = JSON.parse(UrlFetchApp.fetch(BASE_URL, options));<br \/>\/\/console.log(response);<br \/>\/\/console.log(response.choices[0].message.content)<br \/>return response.choices[0].message.content;<br \/>} catch (e) {<br \/>console.log(e)<br \/>SpreadsheetApp.getActiveSpreadsheet().toast(\u00ab\u00a0Some Error Occured Please check your formula or try again later.\u00a0\u00bb);<br \/>return \u00ab\u00a0Some Error Occured Please check your formula or try again later.\u00a0\u00bb;<br \/>}<br \/>}<\/p><div class=\"pixiebrix-tooltips-container\"><div style=\"z-index: 2147483645; position: fixed; width: max-content; height: max-content; top: -29.0156px; left: 98px; margin: 0px; padding: 0px; background-color: #ffffff; border-radius: 4px; border: 1px solid #dedbe3; box-shadow: rgba(56, 51, 66, 0.16) 0px 4px 8px -4px; display: none;\" data-testid=\"pixiebrix-selection-menu\" aria-hidden=\"true\"><div style=\"all: initial;\">\u00a0<\/div><\/div><div style=\"z-index: 2147483645; position: fixed; width: max-content; height: max-content; top: 214.984px; left: 91.1797px; margin: 0px; padding: 0px; background-color: #ffffff; border-radius: 4px; border: 1px solid #dedbe3; box-shadow: rgba(56, 51, 66, 0.16) 0px 4px 8px -4px; display: block;\" data-testid=\"pixiebrix-selection-menu\" aria-hidden=\"false\"><div style=\"all: initial;\">\u00a0<\/div><\/div><div style=\"z-index: 2147483645; position: fixed; width: max-content; height: max-content; top: 149.953px; left: 71.7969px; margin: 0px; padding: 0px; background-color: #ffffff; border-radius: 4px; border: 1px solid #dedbe3; box-shadow: rgba(56, 51, 66, 0.16) 0px 4px 8px -4px; display: block;\" data-testid=\"pixiebrix-selection-menu\" aria-hidden=\"false\"><div style=\"all: initial;\">\u00a0<\/div><\/div><div style=\"z-index: 2147483645; position: fixed; width: max-content; height: max-content; top: 210.953px; left: 39.125px; margin: 0px; padding: 0px; background-color: #ffffff; border-radius: 4px; border: 1px solid #dedbe3; box-shadow: rgba(56, 51, 66, 0.16) 0px 4px 8px -4px; display: block;\" data-testid=\"pixiebrix-selection-menu\" aria-hidden=\"false\"><div style=\"all: initial;\">\u00a0<\/div><\/div><div style=\"z-index: 2147483645; position: fixed; width: max-content; height: max-content; top: 116.969px; left: 34.2969px; margin: 0px; padding: 0px; background-color: #ffffff; border-radius: 4px; border: 1px solid #dedbe3; box-shadow: rgba(56, 51, 66, 0.16) 0px 4px 8px -4px; display: block;\" data-testid=\"pixiebrix-selection-menu\" aria-hidden=\"false\"><div style=\"all: initial;\">\u00a0<\/div><\/div><div style=\"z-index: 2147483645; position: fixed; width: max-content; height: max-content; top: 210.953px; left: 39.125px; margin: 0px; padding: 0px; background-color: #ffffff; border-radius: 4px; border: 1px solid #dedbe3; box-shadow: rgba(56, 51, 66, 0.16) 0px 4px 8px -4px; display: block;\" data-testid=\"pixiebrix-selection-menu\" aria-hidden=\"false\"><div style=\"all: initial;\">\u00a0<\/div><\/div><div style=\"z-index: 2147483645; position: fixed; width: max-content; height: max-content; top: 210.953px; left: 39.125px; margin: 0px; padding: 0px; background-color: #ffffff; border-radius: 4px; border: 1px solid #dedbe3; box-shadow: rgba(56, 51, 66, 0.16) 0px 4px 8px -4px; display: block;\" data-testid=\"pixiebrix-selection-menu\" aria-hidden=\"false\"><div style=\"all: initial;\">\u00a0<\/div><\/div><div style=\"z-index: 2147483645; position: fixed; width: max-content; height: max-content; top: 87.9531px; left: 58.8711px; margin: 0px; padding: 0px; background-color: #ffffff; border-radius: 4px; border: 1px solid #dedbe3; box-shadow: rgba(56, 51, 66, 0.16) 0px 4px 8px -4px; display: block;\" data-testid=\"pixiebrix-selection-menu\" aria-hidden=\"false\"><div style=\"all: initial;\">\u00a0<\/div><\/div><\/div><div class=\"pixiebrix-notifier-container\" style=\"all: initial;\"><div style=\"position: fixed; z-index: 2147483647; inset: 16px; pointer-events: none; font-family: sans-serif;\">\u00a0<\/div><\/div><div class=\"pixiebrix-notifier-container\" style=\"all: initial;\"><div style=\"position: fixed; z-index: 2147483647; inset: 16px; pointer-events: none; font-family: sans-serif;\">\u00a0<\/div><\/div><div class=\"pixiebrix-notifier-container\" style=\"all: initial;\"><div style=\"position: fixed; z-index: 2147483647; inset: 16px; pointer-events: none; font-family: sans-serif;\">\u00a0<\/div><\/div><div class=\"pixiebrix-notifier-container\" style=\"all: initial;\"><div style=\"position: fixed; z-index: 2147483647; inset: 16px; pointer-events: none; font-family: sans-serif;\">\u00a0<\/div><\/div><div class=\"pixiebrix-notifier-container\" style=\"all: initial;\"><div style=\"position: fixed; z-index: 2147483647; inset: 16px; pointer-events: none; font-family: sans-serif;\">\u00a0<\/div><\/div><div class=\"pixiebrix-notifier-container\" style=\"all: initial;\"><div style=\"position: fixed; z-index: 2147483647; inset: 16px; pointer-events: none; font-family: sans-serif;\">\u00a0<\/div><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-01cd9a1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"01cd9a1\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2e9f2c9\" data-id=\"2e9f2c9\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-69e6b08 elementor-widget elementor-widget-text-editor\" data-id=\"69e6b08\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Dans le d\u00e9tail, la fonction va envoyer une requ\u00eate au format JSON \u00e0 ChatGPT et renvoyer le r\u00e9sultat. Le code comporte plusieurs param\u00e8tres qui peuvent \u00eatre modifi\u00e9s :<\/p><p><!-- notionvc: 1e18bf63-45a5-4777-9f04-d66162479bc3 --><\/p><ul><li>La cl\u00e9 d\u2019API dans le param\u00e9trage. Elle est indispensable pour l\u2019authentification. Vous pouvez la stocker dans un autre fichier de Apps Script si vous pr\u00e9f\u00e9rez. Pensez \u00e0 bien remplacer la valeur de la cl\u00e9 utilis\u00e9e dans le script qui va sinon \u00e9chouer.<\/li><li>Le mod\u00e8le de ChatGPT : gpt-3.5-turbo est celui par d\u00e9faut, mais d\u2019autres sont possibles, comme gpt-4.<\/li><li>Le param\u00e8tre temp\u00e9rature dans le script varie entre 0 et 1 et permet de configurer le type de r\u00e9ponse attendu : une valeur plus proche de 0 sera plus d\u00e9terministe, une valeur plus proche de 1 sera plus cr\u00e9ative.<\/li><li>Les valeurs donneesColonne et texteColonne : il s\u2019agit des colonnes utilis\u00e9es pour nos valeurs de r\u00e9f\u00e9rence. Pensez \u00e0 bien remplacer par les valeurs qui correspondent \u00e0 votre cas. Pour trois colonnes qui vont jusqu\u2019\u00e0 la ligne 123, ce sera getRange(\u00ab\u00a0A1:C123\u00a0\u00bb).<\/li><\/ul><div style=\"all: initial;\">\u00a0<\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-fa1ccb3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fa1ccb3\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7c2a185\" data-id=\"7c2a185\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a5714a4 elementor-widget elementor-widget-spacer\" data-id=\"a5714a4\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c398c93 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c398c93\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0400943\" data-id=\"0400943\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7e4e197 elementor-widget elementor-widget-heading\" data-id=\"7e4e197\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">5. enregistrement du script dans google sheet<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-eed3fd0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"eed3fd0\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9202578\" data-id=\"9202578\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1fc2cac elementor-widget elementor-widget-spacer\" data-id=\"1fc2cac\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-87852f2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"87852f2\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3785a8a\" data-id=\"3785a8a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6b68b7b elementor-widget elementor-widget-text-editor\" data-id=\"6b68b7b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Une fois le script configur\u00e9, il faut l&rsquo;enregistrer dans Google Sheets. Pour cela, allez dans Extensions &gt; Apps Script.<\/p><p><!-- -->Note : <span class=\"discussion-id-197f090d-f69d-43db-b69b-607e8f0d33d5 notion-enable-hover\" data-token-index=\"1\">il faut pour que cela soit possible<\/span>, \u00eatre le propri\u00e9taire de la feuille ou avoir l\u2019autorisation de l\u2019administrateur. Quelle que soit la version du script utilis\u00e9e, la fa\u00e7on de le saisir est la m\u00eame.<\/p><p>\u00a0<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e6d1f41 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e6d1f41\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6ee3777\" data-id=\"6ee3777\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-016b251 elementor-widget elementor-widget-image\" data-id=\"016b251\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"219\" src=\"https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/AppScriptInsert-1024x280.png\" class=\"attachment-large size-large wp-image-23799\" alt=\"\" srcset=\"https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/AppScriptInsert-1024x280.png 1024w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/AppScriptInsert-300x82.png 300w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/AppScriptInsert-768x210.png 768w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/AppScriptInsert-1536x420.png 1536w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/AppScriptInsert-18x5.png 18w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/AppScriptInsert-700x191.png 700w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/AppScriptInsert.png 2000w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c8e32b7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c8e32b7\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9a9126a\" data-id=\"9a9126a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6fd4d67 elementor-widget elementor-widget-spacer\" data-id=\"6fd4d67\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c4007e7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c4007e7\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5e8f854\" data-id=\"5e8f854\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-38b3db4 elementor-widget elementor-widget-text-editor\" data-id=\"38b3db4\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Une fois l&rsquo;onglet AppScripts ouvert, copiez la fonction de la section pr\u00e9c\u00e9dente, enregistrez la et revenez \u00e0\u00a0 l&rsquo;onglet pr\u00e9c\u00e9dent de votre feuille Google Sheet.<!-- notionvc: 7672270c-2de0-4bb0-81bf-8359d450a497 --><\/p><p>\u00a0<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-fd95e39 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fd95e39\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ed7f990\" data-id=\"ed7f990\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c645c1a elementor-widget elementor-widget-image\" data-id=\"c645c1a\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"190\" src=\"https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/AppScriptPanel-1024x243.png\" class=\"attachment-large size-large wp-image-23800\" alt=\"\" srcset=\"https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/AppScriptPanel-1024x243.png 1024w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/AppScriptPanel-300x71.png 300w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/AppScriptPanel-768x182.png 768w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/AppScriptPanel-1536x364.png 1536w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/AppScriptPanel-18x4.png 18w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/AppScriptPanel-700x166.png 700w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/AppScriptPanel.png 2000w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f6cde51 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f6cde51\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2c3fed7\" data-id=\"2c3fed7\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8054f0b elementor-widget elementor-widget-spacer\" data-id=\"8054f0b\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5857545 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5857545\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3caeddb\" data-id=\"3caeddb\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-928e51e elementor-widget elementor-widget-heading\" data-id=\"928e51e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">6. UTILISATION DE LA NOUVELLE FONCTION DANS GOOGLE SHEETS<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b41e855 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b41e855\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7de856e\" data-id=\"7de856e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-096f598 elementor-widget elementor-widget-spacer\" data-id=\"096f598\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8c64662 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8c64662\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4ae3628\" data-id=\"4ae3628\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-67c0dd4 elementor-widget elementor-widget-text-editor\" data-id=\"67c0dd4\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Pour appeler le script on vient appeler la fonction comme n&rsquo;importe quelle autre formule Google Sheet. On voit sur cette capture que nous avons un r\u00e9sultat et que celui-ci est format\u00e9 en JSON\u00a0<span style=\"background-color: #ffffff;\">comme demand\u00e9<\/span><span style=\"background-color: #ffffff;\">\u00a0<\/span>. Il suffit d&rsquo;extraire ensuite les donn\u00e9es de r\u00e9sultat qui nous int\u00e9ressent avec REGEXEXTRACT par exemple.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b134dff elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b134dff\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-bda07eb\" data-id=\"bda07eb\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-969326a elementor-widget elementor-widget-image\" data-id=\"969326a\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"297\" src=\"https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/AppelChatGPT-1024x380.png\" class=\"attachment-large size-large wp-image-23801\" alt=\"\" srcset=\"https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/AppelChatGPT-1024x380.png 1024w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/AppelChatGPT-300x111.png 300w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/AppelChatGPT-768x285.png 768w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/AppelChatGPT-1536x571.png 1536w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/AppelChatGPT-18x7.png 18w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/AppelChatGPT-700x260.png 700w, https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/AppelChatGPT.png 2000w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-894c0b8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"894c0b8\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3886823\" data-id=\"3886823\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-fbe61e9 elementor-widget elementor-widget-spacer\" data-id=\"fbe61e9\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c62bede elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c62bede\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-35f2f1e\" data-id=\"35f2f1e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-14ed6fc elementor-widget elementor-widget-heading\" data-id=\"14ed6fc\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">7. quelques mots sur les resultats <\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b10cbf5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b10cbf5\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a522965\" data-id=\"a522965\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-bc93ab5 elementor-widget elementor-widget-spacer\" data-id=\"bc93ab5\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-31fb62b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"31fb62b\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-31f4d3b\" data-id=\"31f4d3b\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-79f33cf elementor-widget elementor-widget-text-editor\" data-id=\"79f33cf\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Sur notre exemple, on obtient 40 matching trouv\u00e9s sur 55 r\u00e9f\u00e9rences soit 73 % de propositions. Sur les 40 r\u00e9sultats propos\u00e9s,\u00a0 6 sont faux soit 85% de bonnes propositions.\u00a0<\/p><p><strong>Un tr\u00e8s bon r\u00e9sultat avec <span style=\"color: #ff0000;\">62% d&rsquo;automatisation globale<\/span>, d&rsquo;autant qu&rsquo;on peut optimiser ce r\u00e9sultat en utilisant les donn\u00e9es historiques en notre possession.\u00a0 Ce sera l&rsquo;objet d&rsquo;un prochain post.\u00a0<\/strong><\/p><p><strong><span class=\"notion-enable-hover\" style=\"color: rgba(212, 76, 71, 1); fill: rgba(212, 76, 71, 1);\" data-token-index=\"0\">LIMITE IMPORTANTE :<\/span><\/strong> Google Sheets actualise les donn\u00e9es \u00e0 des fr\u00e9quences per\u00e7ues comme al\u00e9atoires \u2192 1-cela co\u00fbte de l\u2019argent et 2- les r\u00e9sultats peuvent changer d\u2019une fois \u00e0 l\u2019autre.<!-- notionvc: 1c04955e-f70d-4fbb-83aa-4db474b21a62 --><\/p><div class=\"pixiebrix-notifier-container\" style=\"all: initial;\"><div style=\"position: fixed; z-index: 2147483647; inset: 16px; pointer-events: none; font-family: sans-serif;\">\u00a0<\/div><\/div><div class=\"pixiebrix-notifier-container\" style=\"all: initial;\"><div style=\"position: fixed; z-index: 2147483647; inset: 16px; pointer-events: none; font-family: sans-serif;\">\u00a0<\/div><\/div><div class=\"pixiebrix-tooltips-container\"><div style=\"z-index: 2147483645; position: fixed; width: max-content; height: max-content; top: 97.4688px; left: 91.2734px; margin: 0px; padding: 0px; background-color: #ffffff; border-radius: 4px; border: 1px solid #dedbe3; box-shadow: rgba(56, 51, 66, 0.16) 0px 4px 8px -4px; display: block;\" data-testid=\"pixiebrix-selection-menu\" aria-hidden=\"false\"><div style=\"all: initial;\">\u00a0<\/div><\/div><div style=\"z-index: 2147483645; position: fixed; width: max-content; height: max-content; top: 95.9531px; left: 98.1992px; margin: 0px; padding: 0px; background-color: #ffffff; border-radius: 4px; border: 1px solid #dedbe3; box-shadow: rgba(56, 51, 66, 0.16) 0px 4px 8px -4px; display: block;\" data-testid=\"pixiebrix-selection-menu\" aria-hidden=\"false\"><div style=\"all: initial;\">\u00a0<\/div><\/div><div style=\"z-index: 2147483645; position: fixed; width: max-content; height: max-content; top: 128.969px; left: 22.1797px; margin: 0px; padding: 0px; background-color: #ffffff; border-radius: 4px; border: 1px solid #dedbe3; box-shadow: rgba(56, 51, 66, 0.16) 0px 4px 8px -4px; display: block;\" data-testid=\"pixiebrix-selection-menu\" aria-hidden=\"false\"><div style=\"all: initial;\">\u00a0<\/div><\/div><\/div><div class=\"pixiebrix-notifier-container\" style=\"all: initial;\"><div style=\"position: fixed; z-index: 2147483647; inset: 16px; pointer-events: none; font-family: sans-serif;\">\u00a0<\/div><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>","protected":false},"excerpt":{"rendered":"<p>On vous montre dans cet article comment Chatgpt peut enrichir facilement nos outils du quotidien (ici Google Sheets) et nous faire gagner en productivit\u00e9. Dans notre exemple, on cherche \u00e0 classifier des extraits de compte bancaire \u00e0 l\u2019aide de l\u2019IA d&rsquo;OpenAI (ChatGPT). On dispose d\u2019un fichier issu d\u2019un relev\u00e9 bancaire avec pour chaque ligne le [&hellip;]<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[214],"class_list":["post-23785","post","type-post","status-publish","format-standard","hentry","category-non-classe","tag-ia-generative"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Int\u00e9grez google sheet et chatgpt en 10 minutes - Solypse<\/title>\n<meta name=\"description\" content=\"&quot;How to&quot; rapide permettant de montrer comment int\u00e9grer rapidement google sheet et chatgpt pour gagner en productivit\u00e9 dans son quotidien professionnel.\" \/>\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.solypse.com\/en\/integration-google-sheet-chatgpt\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Int\u00e9grez google sheet et chatgpt en 10 minutes - Solypse\" \/>\n<meta property=\"og:description\" content=\"&quot;How to&quot; rapide permettant de montrer comment int\u00e9grer rapidement google sheet et chatgpt pour gagner en productivit\u00e9 dans son quotidien professionnel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.solypse.com\/en\/integration-google-sheet-chatgpt\/\" \/>\n<meta property=\"og:site_name\" content=\"Solypse\" \/>\n<meta property=\"article:published_time\" content=\"2024-04-15T14:51:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-15T15:06:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/Pub-Solypse-V6-Rose-7.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"1200\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Athi\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Athi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.solypse.com\/integration-google-sheet-chatgpt\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.solypse.com\/integration-google-sheet-chatgpt\/\"},\"author\":{\"name\":\"Athi\",\"@id\":\"https:\/\/www.solypse.com\/#\/schema\/person\/ad5690a668df908894015a56065489b0\"},\"headline\":\"Int\u00e9grez google sheet et chatgpt en 10 minutes\",\"datePublished\":\"2024-04-15T14:51:41+00:00\",\"dateModified\":\"2024-04-15T15:06:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.solypse.com\/integration-google-sheet-chatgpt\/\"},\"wordCount\":1028,\"publisher\":{\"@id\":\"https:\/\/www.solypse.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.solypse.com\/integration-google-sheet-chatgpt\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/Pub-Solypse-V6-Rose-7-768x768.png\",\"keywords\":[\"ia generative\"],\"articleSection\":[\"Non class\u00e9\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.solypse.com\/integration-google-sheet-chatgpt\/\",\"url\":\"https:\/\/www.solypse.com\/integration-google-sheet-chatgpt\/\",\"name\":\"Int\u00e9grez google sheet et chatgpt en 10 minutes - Solypse\",\"isPartOf\":{\"@id\":\"https:\/\/www.solypse.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.solypse.com\/integration-google-sheet-chatgpt\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.solypse.com\/integration-google-sheet-chatgpt\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/Pub-Solypse-V6-Rose-7-768x768.png\",\"datePublished\":\"2024-04-15T14:51:41+00:00\",\"dateModified\":\"2024-04-15T15:06:06+00:00\",\"description\":\"\\\"How to\\\" rapide permettant de montrer comment int\u00e9grer rapidement google sheet et chatgpt pour gagner en productivit\u00e9 dans son quotidien professionnel.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.solypse.com\/integration-google-sheet-chatgpt\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.solypse.com\/integration-google-sheet-chatgpt\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.solypse.com\/integration-google-sheet-chatgpt\/#primaryimage\",\"url\":\"https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/Pub-Solypse-V6-Rose-7-768x768.png\",\"contentUrl\":\"https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/Pub-Solypse-V6-Rose-7-768x768.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.solypse.com\/integration-google-sheet-chatgpt\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.solypse.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Int\u00e9grez google sheet et chatgpt en 10 minutes\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.solypse.com\/#website\",\"url\":\"https:\/\/www.solypse.com\/\",\"name\":\"Solypse\",\"description\":\"Architecting growth through technology\",\"publisher\":{\"@id\":\"https:\/\/www.solypse.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.solypse.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.solypse.com\/#organization\",\"name\":\"Solypse\",\"url\":\"https:\/\/www.solypse.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.solypse.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.solypse.com\/wp-content\/uploads\/2015\/06\/LOGO_SOLYPSE_BLANC.png\",\"contentUrl\":\"https:\/\/www.solypse.com\/wp-content\/uploads\/2015\/06\/LOGO_SOLYPSE_BLANC.png\",\"width\":319,\"height\":136,\"caption\":\"Solypse\"},\"image\":{\"@id\":\"https:\/\/www.solypse.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.solypse.com\/#\/schema\/person\/ad5690a668df908894015a56065489b0\",\"name\":\"Athi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.solypse.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8cb9d3a7e661f26506eefea7c01d8a62b33dda09e2251a5b29b5fa7016272374?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8cb9d3a7e661f26506eefea7c01d8a62b33dda09e2251a5b29b5fa7016272374?s=96&d=mm&r=g\",\"caption\":\"Athi\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Int\u00e9grez google sheet et chatgpt en 10 minutes - Solypse","description":"\"How to\" rapide permettant de montrer comment int\u00e9grer rapidement google sheet et chatgpt pour gagner en productivit\u00e9 dans son quotidien professionnel.","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.solypse.com\/en\/integration-google-sheet-chatgpt\/","og_locale":"en_US","og_type":"article","og_title":"Int\u00e9grez google sheet et chatgpt en 10 minutes - Solypse","og_description":"\"How to\" rapide permettant de montrer comment int\u00e9grer rapidement google sheet et chatgpt pour gagner en productivit\u00e9 dans son quotidien professionnel.","og_url":"https:\/\/www.solypse.com\/en\/integration-google-sheet-chatgpt\/","og_site_name":"Solypse","article_published_time":"2024-04-15T14:51:41+00:00","article_modified_time":"2024-04-15T15:06:06+00:00","og_image":[{"width":1200,"height":1200,"url":"https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/Pub-Solypse-V6-Rose-7.png","type":"image\/png"}],"author":"Athi","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Athi","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.solypse.com\/integration-google-sheet-chatgpt\/#article","isPartOf":{"@id":"https:\/\/www.solypse.com\/integration-google-sheet-chatgpt\/"},"author":{"name":"Athi","@id":"https:\/\/www.solypse.com\/#\/schema\/person\/ad5690a668df908894015a56065489b0"},"headline":"Int\u00e9grez google sheet et chatgpt en 10 minutes","datePublished":"2024-04-15T14:51:41+00:00","dateModified":"2024-04-15T15:06:06+00:00","mainEntityOfPage":{"@id":"https:\/\/www.solypse.com\/integration-google-sheet-chatgpt\/"},"wordCount":1028,"publisher":{"@id":"https:\/\/www.solypse.com\/#organization"},"image":{"@id":"https:\/\/www.solypse.com\/integration-google-sheet-chatgpt\/#primaryimage"},"thumbnailUrl":"https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/Pub-Solypse-V6-Rose-7-768x768.png","keywords":["ia generative"],"articleSection":["Non class\u00e9"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.solypse.com\/integration-google-sheet-chatgpt\/","url":"https:\/\/www.solypse.com\/integration-google-sheet-chatgpt\/","name":"Int\u00e9grez google sheet et chatgpt en 10 minutes - Solypse","isPartOf":{"@id":"https:\/\/www.solypse.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.solypse.com\/integration-google-sheet-chatgpt\/#primaryimage"},"image":{"@id":"https:\/\/www.solypse.com\/integration-google-sheet-chatgpt\/#primaryimage"},"thumbnailUrl":"https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/Pub-Solypse-V6-Rose-7-768x768.png","datePublished":"2024-04-15T14:51:41+00:00","dateModified":"2024-04-15T15:06:06+00:00","description":"\"How to\" rapide permettant de montrer comment int\u00e9grer rapidement google sheet et chatgpt pour gagner en productivit\u00e9 dans son quotidien professionnel.","breadcrumb":{"@id":"https:\/\/www.solypse.com\/integration-google-sheet-chatgpt\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.solypse.com\/integration-google-sheet-chatgpt\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.solypse.com\/integration-google-sheet-chatgpt\/#primaryimage","url":"https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/Pub-Solypse-V6-Rose-7-768x768.png","contentUrl":"https:\/\/www.solypse.com\/wp-content\/uploads\/2024\/04\/Pub-Solypse-V6-Rose-7-768x768.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.solypse.com\/integration-google-sheet-chatgpt\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.solypse.com\/"},{"@type":"ListItem","position":2,"name":"Int\u00e9grez google sheet et chatgpt en 10 minutes"}]},{"@type":"WebSite","@id":"https:\/\/www.solypse.com\/#website","url":"https:\/\/www.solypse.com\/","name":"Solypse","description":"Architecting growth through technology","publisher":{"@id":"https:\/\/www.solypse.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.solypse.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.solypse.com\/#organization","name":"Solypse","url":"https:\/\/www.solypse.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.solypse.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.solypse.com\/wp-content\/uploads\/2015\/06\/LOGO_SOLYPSE_BLANC.png","contentUrl":"https:\/\/www.solypse.com\/wp-content\/uploads\/2015\/06\/LOGO_SOLYPSE_BLANC.png","width":319,"height":136,"caption":"Solypse"},"image":{"@id":"https:\/\/www.solypse.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.solypse.com\/#\/schema\/person\/ad5690a668df908894015a56065489b0","name":"Athi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.solypse.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8cb9d3a7e661f26506eefea7c01d8a62b33dda09e2251a5b29b5fa7016272374?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8cb9d3a7e661f26506eefea7c01d8a62b33dda09e2251a5b29b5fa7016272374?s=96&d=mm&r=g","caption":"Athi"}}]}},"_links":{"self":[{"href":"https:\/\/www.solypse.com\/en\/wp-json\/wp\/v2\/posts\/23785","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.solypse.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.solypse.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.solypse.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.solypse.com\/en\/wp-json\/wp\/v2\/comments?post=23785"}],"version-history":[{"count":29,"href":"https:\/\/www.solypse.com\/en\/wp-json\/wp\/v2\/posts\/23785\/revisions"}],"predecessor-version":[{"id":23820,"href":"https:\/\/www.solypse.com\/en\/wp-json\/wp\/v2\/posts\/23785\/revisions\/23820"}],"wp:attachment":[{"href":"https:\/\/www.solypse.com\/en\/wp-json\/wp\/v2\/media?parent=23785"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.solypse.com\/en\/wp-json\/wp\/v2\/categories?post=23785"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.solypse.com\/en\/wp-json\/wp\/v2\/tags?post=23785"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}