Programmez des rappels SMS ou emails pour réduire les absences et améliorer l’organisation de votre agenda. Guide pratique pour professions libérales, santé ou coaching.
Programmez des rappels SMS ou emails pour réduire les absences et améliorer l’organisation de votre agenda. Guide pratique pour professions libérales, santé ou coaching.
{
"name": "Create and update Google Sheets rows with ChatGPT and Google Docs integration",
"flow": [
{
"id": 1,
"module": "google-sheets:watchRows",
"version": 2,
"parameters": {
"from": "drive",
"mode": "select",
"limit": 2,
"sheetId": "Sheet1",
"spreadsheetId": "/1OBN2px7hcLH4AEaw2p08dU5g3Ti_prtpzSLfLgpa3XQ",
"tableFirstRow": "A1:Z1",
"includesHeaders": true,
"valueRenderOption": "FORMATTED_VALUE",
"dateTimeRenderOption": "FORMATTED_STRING"
},
"mapper": {},
"metadata": {
"designer": {
"x": 300,
"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": [
"1OBN2px7hcLH4AEaw2p08dU5g3Ti_prtpzSLfLgpa3XQ"
]
},
"includesHeaders": {
"label": "Yes"
},
"valueRenderOption": {
"mode": "chose",
"label": "Formatted value"
},
"dateTimeRenderOption": {
"mode": "chose",
"label": "Formatted string"
}
}
},
"parameters": [
{
"name": "__IMTCONN__",
"type": "account:google",
"label": "Connection",
"required": true
},
{
"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": "Date (A)"
},
{
"name": "1",
"type": "text",
"label": "Zone EU1 (B)"
},
{
"name": "2",
"type": "text",
"label": "Zone US1 (C)"
},
{
"name": "3",
"type": "text",
"label": "Zone Celonis ent EU1 (D)"
},
{
"name": "4",
"type": "text",
"label": "Zone Celonis ent US1 (E)"
},
{
"name": "5",
"type": "text",
"label": "Zone makerunsmake (F)"
},
{
"name": "6",
"type": "text",
"label": "Zone EU2 (G)"
},
{
"name": "7",
"type": "text",
"label": "Zone US2 (H)"
},
{
"name": "8",
"type": "text",
"label": "Monday board (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": 2,
"module": "openai-gpt-3:CreateCompletion",
"version": 1,
"parameters": {},
"mapper": {
"model": "gpt-4.5-preview",
"top_p": "1",
"select": "chat",
"messages": [
{
"role": "user",
"imageDetail": "auto"
}
],
"max_tokens": "2048",
"temperature": "1",
"n_completions": "1",
"response_format": "text"
},
"metadata": {
"designer": {
"x": 600,
"y": 0
},
"restore": {
"expect": {
"stop": {
"mode": "chose"
},
"model": {
"mode": "chose",
"label": "gpt-4.5-preview (system)"
},
"select": {
"label": "Create a Chat Completion (GPT and o1 models)"
},
"messages": {
"mode": "chose",
"items": [
{
"role": {
"mode": "chose",
"label": "User"
},
"imageDetail": {
"mode": "chose",
"label": "Auto"
},
"imageInputType": {
"mode": "chose",
"label": "Empty"
}
}
]
},
"logit_bias": {
"mode": "chose"
},
"response_format": {
"mode": "chose",
"label": "Text"
},
"additionalParameters": {
"mode": "chose"
}
},
"parameters": {
"__IMTCONN__": {
"data": {
"scoped": "true",
"connection": "openai-gpt-3"
},
"label": "Make Ent GPT4"
}
}
},
"parameters": [
{
"name": "__IMTCONN__",
"type": "account:openai-gpt-3",
"label": "Connection",
"required": true
}
],
"expect": [
{
"name": "select",
"type": "select",
"label": "Select Method",
"required": true,
"validate": {
"enum": [
"chat",
"prompt"
]
}
},
{
"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": "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": "max_tokens",
"type": "uinteger",
"label": "Max Completion Tokens"
},
{
"name": "messages",
"spec": {
"name": "value",
"spec": [
{
"name": "role",
"type": "select",
"label": "Role",
"options": {
"store": [
{
"label": "User",
"value": "user",
"nested": [
{
"help": "Text content of the message on behalf of the selected __Role__.",
"name": "content",
"type": "text",
"label": "Text Content"
},
{
"name": "imageInputType",
"type": "select",
"label": "Image Input Type",
"options": [
{
"label": "URL",
"value": "url",
"nested": [
{
"help": "Make sure to use a publicly accessible URL.nYou can test if your image is publicly accessible by opening the link in an incognito tab.",
"name": "imageUrl",
"type": "url",
"label": "Image URL"
}
]
},
{
"label": "Image File",
"value": "file",
"nested": [
{
"name": "imageFile",
"spec": [
{
"help": "Accepted extensions: `.jpg`, `.jpeg`, `.png`, `.webp` and `.gif`.",
"name": "imageFilename",
"type": "filename",
"label": "Image Filename",
"semantic": "file:name",
"extension": [
"jpg",
"jpeg",
"png",
"webp",
"gif"
]
},
{
"name": "imageData",
"type": "buffer",
"label": "Image Data",
"semantic": "file:data"
}
],
"type": "collection",
"label": "Image"
}
]
}
],
"mappable": false
},
{
"help": "Recommended value: `Auto`",
"name": "imageDetail",
"type": "select",
"label": "Image Detail",
"options": [
{
"label": "Auto",
"value": "auto",
"default": true
},
{
"label": "High",
"value": "high"
},
{
"label": "Low",
"value": "low"
}
]
}
]
},
{
"label": "Assistant",
"value": "assistant",
"nested": [
{
"help": "Text content of the message on behalf of the selected __Role__.",
"name": "content",
"type": "text",
"label": "Text Content"
}
]
},
{
"label": "Developer / System",
"value": "system",
"nested": [
{
"help": "Text content of the message on behalf of the selected __Role__.",
"name": "content",
"type": "text",
"label": "Text Content"
}
]
}
]
},
"required": true
}
],
"type": "collection",
"label": "Message"
},
"type": "array",
"label": "Messages",
"required": true
},
{
"name": "response_format",
"type": "select",
"label": "Response Format",
"validate": {
"enum": [
"text",
"json_object"
]
}
}
],
"interface": [
{
"name": "result",
"type": "any",
"label": "Result"
},
{
"name": "id",
"type": "text",
"label": "ID"
},
{
"name": "object",
"type": "text",
"label": "Object"
},
{
"name": "created",
"type": "date",
"label": "Created"
},
{
"name": "model",
"type": "text",
"label": "Model"
},
{
"name": "choices",
"spec": {
"spec": [
{
"name": "text",
"type": "text",
"label": "Text"
},
{
"name": "index",
"type": "number",
"label": "Index"
},
{
"name": "logprobs",
"type": "text",
"label": "Log Probs"
},
{
"name": "finish_reason",
"type": "text",
"label": "Finish Reason"
},
{
"name": "message",
"spec": [
{
"name": "role",
"type": "text",
"label": "Role"
},
{
"name": "content",
"type": "text",
"label": "Content"
},
{
"name": "refusal",
"type": "text",
"label": "Refusal"
}
],
"type": "collection",
"label": "Message"
}
],
"type": "collection"
},
"type": "array",
"label": "Choices"
},
{
"name": "usage",
"spec": [
{
"name": "prompt_tokens",
"type": "number",
"label": "Prompt Tokens"
},
{
"name": "completion_tokens",
"type": "text",
"label": "Completion Tokens"
},
{
"name": "total_tokens",
"type": "number",
"label": "Total Tokens"
},
{
"name": "prompt_tokens_details",
"spec": [
{
"name": "cached_tokens",
"type": "uinteger",
"label": "Cached Tokens"
},
{
"name": "text_tokens",
"type": "uinteger",
"label": "Text Tokens"
},
{
"name": "image_tokens",
"type": "uinteger",
"label": "Image Tokens"
},
{
"name": "audio_tokens",
"type": "uinteger",
"label": "Audio Tokens"
}
],
"type": "collection",
"label": "Prompt Tokens Details"
},
{
"name": "completion_tokens_details",
"spec": [
{
"name": "reasoning_tokens",
"type": "uinteger",
"label": "Reasoning Tokens"
},
{
"name": "text_tokens",
"type": "uinteger",
"label": "Text Tokens"
},
{
"name": "audio_tokens",
"type": "uinteger",
"label": "Audio Tokens"
},
{
"name": "accepted_prediction_tokens",
"type": "uinteger",
"label": "Accepted Prediction Tokens"
},
{
"name": "rejected_prediction_tokens",
"type": "uinteger",
"label": "Rejected Prediction Tokens"
}
],
"type": "collection",
"label": "Completion Tokens Details"
}
],
"type": "collection",
"label": "Usage"
},
{
"name": "service_tier",
"type": "text",
"label": "Service Tier"
},
{
"name": "system_fingerprint",
"type": "text",
"label": "System Fingerprint"
}
]
}
},
{
"id": 3,
"module": "google-docs:createADocument",
"version": 1,
"parameters": {},
"mapper": {
"name": "name",
"footer": false,
"header": false,
"content": "{{2.result}}",
"folderId": "/",
"destination": "drive"
},
"metadata": {
"designer": {
"x": 900,
"y": 0
},
"restore": {
"expect": {
"folderId": {
"mode": "chose",
"path": [
"/"
]
},
"destination": {
"label": "My Drive"
}
},
"parameters": {
"__IMTCONN__": {
"data": {
"scoped": "true",
"connection": "google"
},
"label": "My Google connection (l.govender@make.com)"
}
}
},
"parameters": [
{
"name": "__IMTCONN__",
"type": "account:google",
"label": "Connection",
"required": true
}
],
"expect": [
{
"name": "name",
"type": "text",
"label": "Name",
"required": true
},
{
"name": "content",
"type": "text",
"label": "Content",
"required": true
},
{
"name": "destination",
"type": "select",
"label": "Choose a Drive",
"required": true,
"validate": {
"enum": [
"drive",
"share",
"team"
]
}
},
{
"name": "header",
"type": "boolean",
"label": "Insert a Header",
"required": true
},
{
"name": "footer",
"type": "boolean",
"label": "Insert a Footer",
"required": true
},
{
"name": "folderId",
"type": "folder",
"label": "New Document's Location",
"required": true
}
]
}
},
{
"id": 4,
"module": "google-sheets:updateRow",
"version": 2,
"parameters": {},
"mapper": {
"from": "share",
"mode": "select",
"values": {},
"sheetId": "Sheet1",
"rowNumber": "{{1.`__ROW_NUMBER__`}}",
"spreadsheetId": "/1OBN2px7hcLH4AEaw2p08dU5g3Ti_prtpzSLfLgpa3XQ",
"includesHeaders": true,
"valueInputOption": "USER_ENTERED"
},
"metadata": {
"designer": {
"x": 1200,
"y": 0
},
"restore": {
"expect": {
"from": {
"label": "Shared with me"
},
"mode": {
"label": "Search by path"
},
"sheetId": {
"label": "Sheet1"
},
"spreadsheetId": {
"path": [
"1OBN2px7hcLH4AEaw2p08dU5g3Ti_prtpzSLfLgpa3XQ"
]
},
"includesHeaders": {
"label": "Yes",
"nested": [
{
"name": "values",
"spec": [
{
"name": "0",
"type": "text",
"label": "Date (A)"
},
{
"name": "1",
"type": "text",
"label": "Zone EU1 (B)"
},
{
"name": "2",
"type": "text",
"label": "Zone US1 (C)"
},
{
"name": "3",
"type": "text",
"label": "Zone Celonis ent EU1 (D)"
},
{
"name": "4",
"type": "text",
"label": "Zone Celonis ent US1 (E)"
},
{
"name": "5",
"type": "text",
"label": "Zone makerunsmake (F)"
},
{
"name": "6",
"type": "text",
"label": "Zone EU2 (G)"
},
{
"name": "7",
"type": "text",
"label": "Zone US2 (H)"
},
{
"name": "8",
"type": "text",
"label": "Monday board (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)"
}
],
"type": "collection",
"label": "Values"
}
]
},
"valueInputOption": {
"mode": "chose",
"label": "User entered"
}
},
"parameters": {
"__IMTCONN__": {
"data": {
"scoped": "true",
"connection": "google"
},
"label": "My Google connection (l.govender@make.com)"
}
}
},
"parameters": [
{
"name": "__IMTCONN__",
"type": "account:google",
"label": "Connection",
"required": true
}
],
"expect": [
{
"name": "mode",
"type": "select",
"label": "Search Method",
"required": true,
"validate": {
"enum": [
"select",
"fromAll",
"map"
]
}
},
{
"name": "valueInputOption",
"type": "select",
"label": "Value input option",
"validate": {
"enum": [
"USER_ENTERED",
"RAW"
]
}
},
{
"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": "rowNumber",
"type": "uinteger",
"label": "Row number",
"required": true
},
{
"name": "includesHeaders",
"type": "select",
"label": "Table contains headers",
"required": true,
"validate": {
"enum": [
true,
false
]
}
},
{
"name": "values",
"spec": [
{
"name": "0",
"type": "text",
"label": "Date (A)"
},
{
"name": "1",
"type": "text",
"label": "Zone EU1 (B)"
},
{
"name": "2",
"type": "text",
"label": "Zone US1 (C)"
},
{
"name": "3",
"type": "text",
"label": "Zone Celonis ent EU1 (D)"
},
{
"name": "4",
"type": "text",
"label": "Zone Celonis ent US1 (E)"
},
{
"name": "5",
"type": "text",
"label": "Zone makerunsmake (F)"
},
{
"name": "6",
"type": "text",
"label": "Zone EU2 (G)"
},
{
"name": "7",
"type": "text",
"label": "Zone US2 (H)"
},
{
"name": "8",
"type": "text",
"label": "Monday board (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)"
}
],
"type": "collection",
"label": "Values"
}
]
}
}
],
"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": []
}
}