Chaque nouvelle tâche peut être assignée automatiquement à la bonne personne selon la charge de travail, les compétences ou les priorités du moment. Ce guide partage des exemples de workflow pour améliorer l’organisation de vos équipes.
Chaque nouvelle tâche peut être assignée automatiquement à la bonne personne selon la charge de travail, les compétences ou les priorités du moment. Ce guide partage des exemples de workflow pour améliorer l’organisation de vos équipes.
{
"name": "Conduct SWOT analysis on competitors with ChatGPT and store results on a Google Slide",
"flow": [
{
"id": 3,
"module": "google-sheets:watchRows",
"version": 2,
"parameters": {
"from": "drive",
"mode": "select",
"limit": 10,
"sheetId": "Sheet1",
"spreadsheetId": "/1-QJWJcrN2b3tvsEoP7BOxu5ne6T1SU8n/1M8FLPIv7YNPw6DuzF6UB-em_1LHsIwo6aq5O_SRWy30",
"tableFirstRow": "A1:Z1",
"includesHeaders": true,
"valueRenderOption": "FORMATTED_VALUE",
"dateTimeRenderOption": "FORMATTED_STRING"
},
"mapper": {},
"metadata": {
"designer": {
"x": 0,
"y": 0
},
"restore": {
"parameters": {
"from": {
"label": "My Drive"
},
"mode": {
"label": "Search by path"
},
"sheetId": {
"label": "Sheet1"
},
"__IMTCONN__": {
"data": {
"scoped": "true",
"connection": "google"
},
"label": "My Google connection (l.govender@make.com)"
},
"spreadsheetId": {
"path": [
"1-QJWJcrN2b3tvsEoP7BOxu5ne6T1SU8n",
"1M8FLPIv7YNPw6DuzF6UB-em_1LHsIwo6aq5O_SRWy30"
]
},
"includesHeaders": {
"label": "Yes"
},
"valueRenderOption": {
"mode": "chose",
"label": "Formatted value"
},
"dateTimeRenderOption": {
"mode": "chose",
"label": "Formatted string"
}
}
},
"parameters": [
{
"name": "__IMTCONN__",
"type": "account:google",
"label": "Connection"
},
{
"name": "mode",
"type": "select",
"label": "Search Method",
"required": true,
"validate": {
"enum": [
"select",
"fromAll",
"map"
]
}
},
{
"name": "includesHeaders",
"type": "select",
"label": "Table contains headers",
"required": true,
"validate": {
"enum": [
true,
false
]
}
},
{
"name": "limit",
"type": "uinteger",
"label": "Limit",
"required": true
},
{
"name": "valueRenderOption",
"type": "select",
"label": "Value render option",
"validate": {
"enum": [
"FORMATTED_VALUE",
"UNFORMATTED_VALUE",
"FORMULA"
]
}
},
{
"name": "dateTimeRenderOption",
"type": "select",
"label": "Date and time render option",
"validate": {
"enum": [
"SERIAL_NUMBER",
"FORMATTED_STRING"
]
}
},
{
"name": "from",
"type": "select",
"label": "Drive",
"required": true,
"validate": {
"enum": [
"drive",
"share",
"team"
]
}
},
{
"name": "spreadsheetId",
"type": "file",
"label": "Spreadsheet ID",
"required": true
},
{
"name": "sheetId",
"type": "select",
"label": "Sheet Name",
"required": true
},
{
"name": "tableFirstRow",
"type": "text",
"label": "Row with headers",
"required": true
}
],
"interface": [
{
"name": "__ROW_NUMBER__",
"type": "number",
"label": "Row number"
},
{
"name": "__SPREADSHEET_ID__",
"type": "text",
"label": "Spreadsheet ID"
},
{
"name": "__SHEET__",
"type": "text",
"label": "Sheet"
},
{
"name": "0",
"type": "text",
"label": "Company Website (A)"
},
{
"name": "1",
"type": "text",
"label": "Strengths (B)"
},
{
"name": "2",
"type": "text",
"label": "Weaknesses (C)"
},
{
"name": "3",
"type": "text",
"label": "Opportunities (D)"
},
{
"name": "4",
"type": "text",
"label": "Threats (E)"
},
{
"name": "5",
"type": "text",
"label": "(F)"
},
{
"name": "6",
"type": "text",
"label": "(G)"
},
{
"name": "7",
"type": "text",
"label": "(H)"
},
{
"name": "8",
"type": "text",
"label": "(I)"
},
{
"name": "9",
"type": "text",
"label": "(J)"
},
{
"name": "10",
"type": "text",
"label": "(K)"
},
{
"name": "11",
"type": "text",
"label": "(L)"
},
{
"name": "12",
"type": "text",
"label": "(M)"
},
{
"name": "13",
"type": "text",
"label": "(N)"
},
{
"name": "14",
"type": "text",
"label": "(O)"
},
{
"name": "15",
"type": "text",
"label": "(P)"
},
{
"name": "16",
"type": "text",
"label": "(Q)"
},
{
"name": "17",
"type": "text",
"label": "(R)"
},
{
"name": "18",
"type": "text",
"label": "(S)"
},
{
"name": "19",
"type": "text",
"label": "(T)"
},
{
"name": "20",
"type": "text",
"label": "(U)"
},
{
"name": "21",
"type": "text",
"label": "(V)"
},
{
"name": "22",
"type": "text",
"label": "(W)"
},
{
"name": "23",
"type": "text",
"label": "(X)"
},
{
"name": "24",
"type": "text",
"label": "(Y)"
},
{
"name": "25",
"type": "text",
"label": "(Z)"
}
]
}
},
{
"id": 4,
"module": "openai-gpt-3:CreateCompletion",
"version": 1,
"parameters": {},
"mapper": {
"model": "gpt-4-1106-preview",
"top_p": "1",
"select": "chat",
"messages": [
{
"role": "system",
"content": "Can you provide the public information of 5 strengths, weaknesses, opportunities and threats on this company {{3.`0`}}?nnPlease output the titles strengths, weaknesses, opportunites and threats. Do not include any pretext and do not include ```json."
}
],
"max_tokens": "300",
"temperature": "1",
"n_completions": "1",
"response_format": "text"
},
"metadata": {
"designer": {
"x": 300,
"y": 0
},
"restore": {
"expect": {
"stop": {
"mode": "chose"
},
"model": {
"mode": "chose",
"label": "gpt-4-1106-preview (system)"
},
"select": {
"label": "Create a Chat Completion (GPT Models)"
},
"messages": {
"mode": "chose",
"items": [
{
"role": {
"mode": "chose",
"label": "System"
}
}
]
},
"logit_bias": {
"mode": "chose"
},
"response_format": {
"mode": "chose",
"label": "Text"
},
"additionalParameters": {
"mode": "chose"
}
},
"parameters": {
"__IMTCONN__": {
"data": {
"scoped": "true",
"connection": "openai-gpt-3"
},
"label": "My OpenAI connection"
}
}
},
"parameters": [
{
"name": "__IMTCONN__",
"type": "account:openai-gpt-3",
"label": "Connection"
}
],
"expect": [
{
"name": "select",
"type": "select",
"label": "Select Method",
"required": true,
"validate": {
"enum": [
"chat",
"prompt"
]
}
},
{
"name": "max_tokens",
"type": "number",
"label": "Max Tokens"
},
{
"name": "temperature",
"type": "number",
"label": "Temperature",
"validate": {
"max": 2,
"min": 0
}
},
{
"name": "top_p",
"type": "number",
"label": "Top P",
"validate": {
"max": 1,
"min": 0
}
},
{
"name": "n_completions",
"type": "number",
"label": "Number"
},
{
"name": "frequency_penalty",
"type": "number",
"label": "Frequency Penalty",
"validate": {
"max": 2,
"min": -2
}
},
{
"name": "presence_penalty",
"type": "number",
"label": "Presence Penalty",
"validate": {
"max": 2,
"min": -2
}
},
{
"name": "logit_bias",
"spec": {
"name": "value",
"spec": [
{
"name": "token",
"type": "text",
"label": "Token ID",
"required": true
},
{
"name": "probability",
"type": "number",
"label": "Probability",
"required": true,
"validate": {
"max": 100,
"min": -100
}
}
],
"type": "collection",
"label": "Token Probability"
},
"type": "array",
"label": "Token Probability"
},
{
"name": "response_format",
"type": "select",
"label": "Response Format",
"validate": {
"enum": [
"text",
"json_object"
]
}
},
{
"name": "seed",
"type": "integer",
"label": "Seed"
},
{
"name": "stop",
"spec": {
"name": "value",
"type": "text",
"label": "Stop Sequence"
},
"type": "array",
"label": "Stop Sequences",
"validate": {
"maxItems": 4
}
},
{
"name": "additionalParameters",
"spec": {
"name": "value",
"spec": [
{
"name": "key",
"type": "text",
"label": "Parameter Name",
"required": true
},
{
"name": "type",
"type": "select",
"label": "Input Type",
"options": [
{
"label": "Text",
"value": "text",
"nested": [
{
"name": "value",
"type": "text",
"label": "Parameter Value"
}
],
"default": true
},
{
"label": "Number",
"value": "number",
"nested": [
{
"name": "value",
"type": "number",
"label": "Parameter Value"
}
]
},
{
"label": "Boolean",
"value": "boolean",
"nested": [
{
"name": "value",
"type": "boolean",
"label": "Parameter Value"
}
]
},
{
"label": "Date",
"value": "date",
"nested": [
{
"name": "value",
"type": "date",
"label": "Parameter Value"
}
]
},
{
"label": "Any",
"value": "any",
"nested": [
{
"name": "value",
"type": "any",
"label": "Parameter Value"
}
]
}
]
}
],
"type": "collection",
"label": "Input Parameter"
},
"type": "array",
"label": "Other Input Parameters"
},
{
"name": "model",
"type": "select",
"label": "Model",
"required": true
},
{
"name": "messages",
"spec": {
"name": "value",
"spec": [
{
"name": "role",
"type": "select",
"label": "Role",
"options": [
{
"label": "System",
"value": "system"
},
{
"label": "User",
"value": "user"
},
{
"label": "Assistant",
"value": "assistant"
}
],
"required": true
},
{
"name": "content",
"type": "text",
"label": "Message Content"
}
],
"type": "collection",
"label": "Message"
},
"type": "array",
"label": "Messages",
"required": true
}
]
}
},
{
"id": 16,
"module": "regexp:Parser",
"version": 1,
"parameters": {
"global": true,
"pattern": "Strengths:\s*((?:\d+\..*(?:\n|$))+)\n*Weaknesses:\s*((?:\d+\..*(?:\n|$))+)\n*Opportunities:\s*((?:\d+\..*(?:\n|$))+)\n*Threats:\s*((?:\d+\..*(?:\n|$))+)",
"multiline": false,
"sensitive": false,
"singleline": false,
"continueWhenNoRes": true,
"ignoreInfiniteLoopsWhenGlobal": false
},
"mapper": {
"text": "{{4.choices[].message.content}}"
},
"metadata": {
"designer": {
"x": 600,
"y": 0
},
"restore": {},
"parameters": [
{
"name": "pattern",
"type": "text",
"label": "Pattern",
"required": true
},
{
"name": "global",
"type": "boolean",
"label": "Global match",
"required": true
},
{
"name": "sensitive",
"type": "boolean",
"label": "Case sensitive",
"required": true
},
{
"name": "multiline",
"type": "boolean",
"label": "Multiline",
"required": true
},
{
"name": "singleline",
"type": "boolean",
"label": "Singleline",
"required": true
},
{
"name": "continueWhenNoRes",
"type": "boolean",
"label": "Continue the execution of the route even if the module finds no matches",
"required": true
},
{
"name": "ignoreInfiniteLoopsWhenGlobal",
"type": "boolean",
"label": "Ignore errors when there is an infinite search loop",
"required": true
}
],
"expect": [
{
"name": "text",
"type": "text",
"label": "Text"
}
],
"interface": [
{
"name": "$1",
"type": "text",
"label": "$1"
},
{
"name": "$2",
"type": "text",
"label": "$2"
},
{
"name": "$3",
"type": "text",
"label": "$3"
},
{
"name": "$4",
"type": "text",
"label": "$4"
},
{
"name": "i",
"type": "uinteger",
"label": "i"
},
{
"name": "__IMTMATCH__",
"type": "any",
"label": "Fallback Match"
}
]
}
},
{
"id": 6,
"module": "google-slides:createPresentation",
"version": 1,
"parameters": {},
"mapper": {
"from": "drive",
"title": "{{3.`0`}}",
"select": "value",
"shared": false,
"folderId": "/1-QJWJcrN2b3tvsEoP7BOxu5ne6T1SU8n",
"requests": {
"threats": "{{16.`$4`}}",
"strengths": "{{16.`$1`}}",
"weaknesses": "{{16.`$2`}}",
"opportunities": "{{16.`$3`}}",
"company website": "{{3.`0`}}"
},
"destination": "drive",
"presentation": "/1-QJWJcrN2b3tvsEoP7BOxu5ne6T1SU8n/1TvTWnN7lGUIIoYuRh9bg9IWTWfvjZkrxU0ac6hXWbeU"
},
"metadata": {
"designer": {
"x": 900,
"y": 0
},
"restore": {
"expect": {
"from": {
"label": "My Drive"
},
"select": {
"label": "By Dropdown"
},
"shared": {
"mode": "chose"
},
"folderId": {
"mode": "chose",
"path": [
"YT Videos"
]
},
"destination": {
"label": "My Drive"
},
"presentation": {
"path": [
"YT Videos",
"SWOT Template"
],
"nested": [
{
"name": "requests",
"spec": [
{
"name": "company website",
"type": "text",
"label": "company website"
},
{
"name": "strengths",
"type": "text",
"label": "strengths"
},
{
"name": "weaknesses",
"type": "text",
"label": "weaknesses"
},
{
"name": "opportunities",
"type": "text",
"label": "opportunities"
},
{
"name": "threats",
"type": "text",
"label": "threats"
}
],
"type": "collection",
"label": "Values"
}
]
}
},
"parameters": {
"__IMTCONN__": {
"data": {
"scoped": "true",
"connection": "google"
},
"label": "My Google connection (l.govender@make.com)"
}
}
},
"parameters": [
{
"name": "__IMTCONN__",
"type": "account:google",
"label": "Connection"
}
],
"expect": [
{
"name": "title",
"type": "text",
"label": "Title",
"required": true
},
{
"name": "select",
"type": "select",
"label": "Copy a Presentation",
"required": true,
"validate": {
"enum": [
"map",
"value"
]
}
},
{
"name": "destination",
"type": "select",
"label": "New Drive Location",
"required": true,
"validate": {
"enum": [
"drive",
"share",
"team"
]
}
},
{
"name": "shared",
"type": "boolean",
"label": "Shared",
"required": true
},
{
"name": "from",
"type": "select",
"label": "Choose a Drive",
"required": true,
"validate": {
"enum": [
"drive",
"share",
"team"
]
}
},
{
"name": "presentation",
"type": "file",
"label": "Presentation ID",
"required": true
},
{
"name": "requests",
"spec": [
{
"name": "company website",
"type": "text"
},
{
"name": "strengths",
"type": "text"
},
{
"name": "weaknesses",
"type": "text"
},
{
"name": "opportunities",
"type": "text"
},
{
"name": "threats",
"type": "text"
}
],
"type": "collection",
"label": "Values"
},
{
"name": "folderId",
"type": "folder",
"label": "New Document's Location"
}
]
}
}
],
"metadata": {
"instant": false,
"version": 1,
"scenario": {
"roundtrips": 1,
"maxErrors": 3,
"autoCommit": true,
"autoCommitTriggerLast": true,
"sequential": false,
"slots": null,
"confidential": false,
"dataloss": false,
"dlq": false,
"freshVariables": false
},
"designer": {
"orphans": []
},
"zone": "eu2.make.com",
"notes": []
}
}