La perte de données peut avoir des conséquences dramatiques pour une entreprise. L’automatisation des sauvegardes permet de garantir la sécurité de vos fichiers critiques : programmation régulière des copies, stockage sur différents supports ou dans le cloud, notifications en cas d’échec, et tests de restauration automatisés. Ce guide vous explique comment choisir la solution adaptée, planifier vos sauvegardes et sécuriser durablement vos données professionnelles.
{
"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": []
}
}