Modèles de la communauté AppSheet - Workflow

Name: Modèles de la communauté AppSheet - Workflow
Rating: 4.5 (10 reviews)
Author: Mohammed Rifad

Avancé

Ceci est unAIworkflow d'automatisation du domainecontenant 25 nœuds.Utilise principalement des nœuds comme Set, Limit, Aggregate, HttpRequest, Agent, combinant la technologie d'intelligence artificielle pour une automatisation intelligente. Orchestrateur de requêtes intelligent AppSheet - Interrogez n'importe quelle donnée !

Prérequis

•Peut nécessiter les informations d'identification d'authentification de l'API cible
•Informations d'identification Google Sheets API
•Clé API Anthropic
•Clé API Google Gemini

Nœuds utilisés (25)

ExecuteWorkflowTrigger

LmChatAnthropic

LmChatGoogleGemini

OutputParserStructured

Catégorie

Intelligence Artificielle

Aperçu du workflow

Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement

Analyseur de Sortie Structurée

Limite

AppSheet

Agrégation

Agrégation Classée

Sortie Finale Reclassée

Reclassement Cohere

Google Gemini Chat Model

Obtenir la Liste des Feuilles

Obtenir les En-têtes

Appeler l'API AppSheet

Analyseur de Schéma AppSheet

Anthropic Chat Model

Lors de l'Exécution par un Autre Flux

Lors de la Réception d'un Message Chat

Nettoyer et Structurer l'Entrée

React Flow

Exporter le workflow

Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow

{
  "id": "EbTFAsvfdJZBB3J5",
  "meta": {
    "instanceId": "28532c0819ec8862291e01fb286b386e2fa3156b644ba3d1efc7c46bdaf57519",
    "templateId": "VMiAxXa3lCAizGB5f7dVZQSFfg3FtHkdTKvLuupqBls=",
    "templateCredsSetupCompleted": true
  },
  "name": "Appsheet Community Template-Workflow",
  "tags": [],
  "nodes": [
    {
      "id": "b4e6fed9-f776-4075-83d8-090c5180fb5a",
      "name": "Analyseur de Sortie Structurée",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        320,
        180
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "b2fc61ac-4c7b-4a3c-abe6-37f5a3eb34eb",
      "name": "Limite",
      "type": "n8n-nodes-base.limit",
      "position": [
        860,
        -20
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "3ab3185c-d9b3-4767-8bc6-5d9d8b1966e4",
      "name": "AppSheet",
      "type": "n8n-nodes-rifad-appsheet.appSheet",
      "position": [
        920,
        320
      ],
      "parameters": {},
      "typeVersion": 1,
      "alwaysOutputData": false
    },
    {
      "id": "f58c1671-396e-49d3-beed-7884d5fa5f92",
      "name": "Agrégation",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        1020,
        -20
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "4e3d2fe0-d1b8-40e2-96c1-66891fd770b3",
      "name": "Agrégation Classée",
      "type": "n8n-nodes-base.set",
      "position": [
        1580,
        -20
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "8fef5f0b-d163-468f-8dc0-f09240f06021",
      "name": "Sortie Finale Reclassée",
      "type": "n8n-nodes-base.set",
      "position": [
        1840,
        -20
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "b6ac9a2c-dead-4bdb-8b3b-f78f2673a31d",
      "name": "Reclassement Cohere",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1340,
        -20
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "47e28822-19f5-40f2-b6ab-63223049e66f",
      "name": "Google Gemini Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        120,
        180
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "7f05514c-1499-4bc9-9d4e-2c1311a29340",
      "name": "Obtenir la Liste des Feuilles",
      "type": "n8n-nodes-base.googleSheetsTool",
      "position": [
        600,
        -740
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "349f36e5-634f-4141-a41c-23907144d39e",
      "name": "Obtenir les En-têtes",
      "type": "n8n-nodes-base.googleSheetsTool",
      "position": [
        760,
        -1060
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "e60a29e9-5c61-4d62-b666-195a2e822b14",
      "name": "Appeler l'API AppSheet",
      "type": "@n8n/n8n-nodes-langchain.toolWorkflow",
      "position": [
        1180,
        -1120
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "ef68c1bc-1fc1-4027-9dfe-0ebcad79d5be",
      "name": "Analyseur de Schéma AppSheet",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "notes": "This agent gets input and start exploring the data and its relationships throughout the app and creates a storyline",
      "onError": "continueRegularOutput",
      "position": [
        420,
        -1260
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 1.7
    },
    {
      "id": "8f1e81d0-7ace-40d6-939e-e51e9d953da3",
      "name": "Anthropic Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatAnthropic",
      "position": [
        340,
        -1060
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "75ccf02e-721c-468a-a7a4-8b8e4c7239c4",
      "name": "Note Adhésive",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1360,
        -200
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "b3debcb8-18bc-4eb5-8df1-64a5d532b8ce",
      "name": "Note Adhésive1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -40,
        -200
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "65e9ed23-f01a-4a9e-b262-328e7b97cc8d",
      "name": "Note Adhésive2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1240,
        -220
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "79919a4e-e7d4-49f4-a6b8-d4861a456925",
      "name": "Lors de l'Exécution par un Autre Flux",
      "type": "n8n-nodes-base.executeWorkflowTrigger",
      "position": [
        -240,
        -20
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "994be9b4-d4e8-4f30-a724-52d7bf9567aa",
      "name": "Note Adhésive3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1400,
        -1700
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "e0dce744-c592-45b1-a81f-5abe9f47e2bc",
      "name": "Note Adhésive4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        820,
        240
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "a6fe8fe1-459c-441e-ae65-7433da62b4a8",
      "name": "Lors de la Réception d'un Message Chat",
      "type": "@n8n/n8n-nodes-langchain.chatTrigger",
      "position": [
        -140,
        -1260
      ],
      "webhookId": "e1fa302e-3f84-46a5-b90a-cb009f33a5b7",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "03dcef04-4a4c-48ab-b6f6-03b294fd83c2",
      "name": "Note Adhésive5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        480,
        -920
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "c2b76cf2-adad-41c6-946d-9b1b1979aedc",
      "name": "Nettoyer et Structurer l'Entrée",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        60,
        -20
      ],
      "parameters": {},
      "typeVersion": 1.5
    },
    {
      "id": "eaf92dab-8aa8-431e-9662-02c03a55d796",
      "name": "Note Adhésive6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1080,
        -1240
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "61b16043-6f64-44f7-91d8-b2500ce6a1b8",
      "name": "Note Adhésive7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1360,
        160
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "7c9f2bd9-7f43-408f-95e3-0f9ab3c092ca",
      "name": "Note Adhésive8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -320,
        -1440
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "376d90d3-0560-4d3a-a1b1-0436fac53325",
  "connections": {
    "b2fc61ac-4c7b-4a3c-abe6-37f5a3eb34eb": {
      "main": [
        [
          {
            "node": "f58c1671-396e-49d3-beed-7884d5fa5f92",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3ab3185c-d9b3-4767-8bc6-5d9d8b1966e4": {
      "main": [
        [
          {
            "node": "b2fc61ac-4c7b-4a3c-abe6-37f5a3eb34eb",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f58c1671-396e-49d3-beed-7884d5fa5f92": {
      "main": [
        [
          {
            "node": "b6ac9a2c-dead-4bdb-8b3b-f78f2673a31d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "349f36e5-634f-4141-a41c-23907144d39e": {
      "ai_tool": [
        [
          {
            "node": "ef68c1bc-1fc1-4027-9dfe-0ebcad79d5be",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "b6ac9a2c-dead-4bdb-8b3b-f78f2673a31d": {
      "main": [
        [
          {
            "node": "4e3d2fe0-d1b8-40e2-96c1-66891fd770b3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4e3d2fe0-d1b8-40e2-96c1-66891fd770b3": {
      "main": [
        [
          {
            "node": "8fef5f0b-d163-468f-8dc0-f09240f06021",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "e60a29e9-5c61-4d62-b666-195a2e822b14": {
      "ai_tool": [
        [
          {
            "node": "ef68c1bc-1fc1-4027-9dfe-0ebcad79d5be",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "7f05514c-1499-4bc9-9d4e-2c1311a29340": {
      "ai_tool": [
        [
          {
            "node": "ef68c1bc-1fc1-4027-9dfe-0ebcad79d5be",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "8f1e81d0-7ace-40d6-939e-e51e9d953da3": {
      "ai_languageModel": [
        [
          {
            "node": "ef68c1bc-1fc1-4027-9dfe-0ebcad79d5be",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "8fef5f0b-d163-468f-8dc0-f09240f06021": {
      "main": [
        []
      ]
    },
    "47e28822-19f5-40f2-b6ab-63223049e66f": {
      "ai_languageModel": [
        [
          {
            "node": "c2b76cf2-adad-41c6-946d-9b1b1979aedc",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "b4e6fed9-f776-4075-83d8-090c5180fb5a": {
      "ai_outputParser": [
        [
          {
            "node": "c2b76cf2-adad-41c6-946d-9b1b1979aedc",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "a6fe8fe1-459c-441e-ae65-7433da62b4a8": {
      "main": [
        [
          {
            "node": "ef68c1bc-1fc1-4027-9dfe-0ebcad79d5be",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c2b76cf2-adad-41c6-946d-9b1b1979aedc": {
      "main": [
        [
          {
            "node": "3ab3185c-d9b3-4767-8bc6-5d9d8b1966e4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "79919a4e-e7d4-49f4-a6b8-d4861a456925": {
      "main": [
        [
          {
            "node": "c2b76cf2-adad-41c6-946d-9b1b1979aedc",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Foire aux questions

Comment utiliser ce workflow ?

Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.

Dans quelles scénarios ce workflow est-il adapté ?

Avancé - Intelligence Artificielle

Est-ce payant ?

Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.