Triez automatiquement vos emails entrants par priorité ou catégorie, pour optimiser le traitement quotidien de votre boîte de réception.
Triez automatiquement vos emails entrants par priorité ou catégorie, pour optimiser le traitement quotidien de votre boîte de réception.
{
"name": "Filter and aggregate text data from Google Sheets and send replies via Telegram",
"flow": [
{
"id": 1,
"module": "google-sheets:filterRows",
"version": 2,
"parameters": {},
"mapper": {
"from": "drive",
"sheetId": "Published by Make",
"sortOrder": "asc",
"spreadsheetId": "1Wq-6krZDqNT7sd-3qsXIm4Phn4qmgbivJHIjGZvc0_8",
"tableFirstRow": "A1:CZ1",
"includesHeaders": true,
"valueRenderOption": "FORMATTED_VALUE",
"dateTimeRenderOption": "FORMATTED_STRING"
},
"metadata": {
"designer": {
"x": 0,
"y": 0
},
"restore": {
"expect": {
"from": {
"label": "Select from My Drive"
},
"orderBy": {
"mode": "chose",
"label": "Empty"
},
"sheetId": {
"mode": "chose",
"label": "Published by Make"
},
"sortOrder": {
"mode": "chose",
"label": "Ascending"
},
"spreadsheetId": {
"mode": "chose",
"label": "02_Content performance"
},
"tableFirstRow": {
"label": "A-CZ"
},
"includesHeaders": {
"mode": "chose",
"label": "Yes"
},
"valueRenderOption": {
"mode": "chose",
"label": "Formatted value"
},
"dateTimeRenderOption": {
"mode": "chose",
"label": "Formatted string"
}
},
"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": "from",
"type": "select",
"label": "Search Method",
"required": true,
"validate": {
"enum": [
"drive",
"share"
]
}
},
{
"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": "limit",
"type": "uinteger",
"label": "Limit"
},
{
"name": "spreadsheetId",
"type": "select",
"label": "Spreadsheet ID",
"required": true
},
{
"name": "sheetId",
"type": "select",
"label": "Sheet Name",
"required": true
},
{
"name": "includesHeaders",
"type": "select",
"label": "Table contains headers",
"required": true,
"validate": {
"enum": [
true,
false
]
}
},
{
"name": "tableFirstRow",
"type": "select",
"label": "Column range",
"required": true,
"validate": {
"enum": [
"A1:Z1",
"A1:BZ1",
"A1:CZ1",
"A1:DZ1",
"A1:MZ1",
"A1:ZZ1",
"A1:AZZ1",
"A1:BZZ1",
"A1:CZZ1",
"A1:DZZ1",
"A1:MZZ1",
"A1:ZZZ1"
]
}
},
{
"name": "filter",
"type": "filter",
"label": "Filter",
"options": "rpc://google-sheets/2/rpcGetFilterKeys?includesHeaders=true"
},
{
"name": "orderBy",
"type": "select",
"label": "Order by"
},
{
"name": "sortOrder",
"type": "select",
"label": "Sort order",
"validate": {
"enum": [
"asc",
"desc"
]
}
}
],
"interface": [
{
"name": "__IMTLENGTH__",
"type": "uinteger",
"label": "Total number of bundles"
},
{
"name": "__IMTINDEX__",
"type": "uinteger",
"label": "Bundle order position"
},
{
"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": "Network (A)"
},
{
"name": "1",
"type": "text",
"label": "Page Name (B)"
},
{
"name": "2",
"type": "text",
"label": "Date New (C)"
},
{
"name": "3",
"type": "text",
"label": "Post Type (D)"
},
{
"name": "4",
"type": "text",
"label": "Placement (E)"
},
{
"name": "5",
"type": "text",
"label": "Dark (F)"
},
{
"name": "6",
"type": "text",
"label": "Promoted (G)"
},
{
"name": "7",
"type": "text",
"label": "Reshare (H)"
},
{
"name": "8",
"type": "text",
"label": "Post text (I)"
},
{
"name": "9",
"type": "text",
"label": "Post URL (J)"
},
{
"name": "10",
"type": "text",
"label": "Post ID (K)"
},
{
"name": "11",
"type": "text",
"label": "Reactions (L)"
},
{
"name": "12",
"type": "text",
"label": "Impressions (M)"
},
{
"name": "13",
"type": "text",
"label": "Reach avg. (N)"
},
{
"name": "14",
"type": "text",
"label": "Engagements (O)"
},
{
"name": "15",
"type": "text",
"label": "Engagement rate (P)"
},
{
"name": "16",
"type": "text",
"label": "Video views (Q)"
},
{
"name": "17",
"type": "text",
"label": "Category (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)"
},
{
"name": "26",
"type": "text",
"label": "(AA)"
},
{
"name": "27",
"type": "text",
"label": "(AB)"
},
{
"name": "28",
"type": "text",
"label": "(AC)"
},
{
"name": "29",
"type": "text",
"label": "(AD)"
},
{
"name": "30",
"type": "text",
"label": "(AE)"
},
{
"name": "31",
"type": "text",
"label": "(AF)"
},
{
"name": "32",
"type": "text",
"label": "(AG)"
},
{
"name": "33",
"type": "text",
"label": "(AH)"
},
{
"name": "34",
"type": "text",
"label": "(AI)"
},
{
"name": "35",
"type": "text",
"label": "(AJ)"
},
{
"name": "36",
"type": "text",
"label": "(AK)"
},
{
"name": "37",
"type": "text",
"label": "(AL)"
},
{
"name": "38",
"type": "text",
"label": "(AM)"
},
{
"name": "39",
"type": "text",
"label": "(AN)"
},
{
"name": "40",
"type": "text",
"label": "(AO)"
},
{
"name": "41",
"type": "text",
"label": "(AP)"
},
{
"name": "42",
"type": "text",
"label": "(AQ)"
},
{
"name": "43",
"type": "text",
"label": "(AR)"
},
{
"name": "44",
"type": "text",
"label": "(AS)"
},
{
"name": "45",
"type": "text",
"label": "(AT)"
},
{
"name": "46",
"type": "text",
"label": "(AU)"
},
{
"name": "47",
"type": "text",
"label": "(AV)"
},
{
"name": "48",
"type": "text",
"label": "(AW)"
},
{
"name": "49",
"type": "text",
"label": "(AX)"
},
{
"name": "50",
"type": "text",
"label": "(AY)"
},
{
"name": "51",
"type": "text",
"label": "(AZ)"
},
{
"name": "52",
"type": "text",
"label": "(BA)"
},
{
"name": "53",
"type": "text",
"label": "(BB)"
},
{
"name": "54",
"type": "text",
"label": "(BC)"
},
{
"name": "55",
"type": "text",
"label": "(BD)"
},
{
"name": "56",
"type": "text",
"label": "(BE)"
},
{
"name": "57",
"type": "text",
"label": "(BF)"
},
{
"name": "58",
"type": "text",
"label": "(BG)"
},
{
"name": "59",
"type": "text",
"label": "(BH)"
},
{
"name": "60",
"type": "text",
"label": "(BI)"
},
{
"name": "61",
"type": "text",
"label": "(BJ)"
},
{
"name": "62",
"type": "text",
"label": "(BK)"
},
{
"name": "63",
"type": "text",
"label": "(BL)"
},
{
"name": "64",
"type": "text",
"label": "(BM)"
},
{
"name": "65",
"type": "text",
"label": "(BN)"
},
{
"name": "66",
"type": "text",
"label": "(BO)"
},
{
"name": "67",
"type": "text",
"label": "(BP)"
},
{
"name": "68",
"type": "text",
"label": "(BQ)"
},
{
"name": "69",
"type": "text",
"label": "(BR)"
},
{
"name": "70",
"type": "text",
"label": "(BS)"
},
{
"name": "71",
"type": "text",
"label": "(BT)"
},
{
"name": "72",
"type": "text",
"label": "(BU)"
},
{
"name": "73",
"type": "text",
"label": "(BV)"
},
{
"name": "74",
"type": "text",
"label": "(BW)"
},
{
"name": "75",
"type": "text",
"label": "(BX)"
},
{
"name": "76",
"type": "text",
"label": "(BY)"
},
{
"name": "77",
"type": "text",
"label": "(BZ)"
},
{
"name": "78",
"type": "text",
"label": "(CA)"
},
{
"name": "79",
"type": "text",
"label": "(CB)"
},
{
"name": "80",
"type": "text",
"label": "(CC)"
},
{
"name": "81",
"type": "text",
"label": "(CD)"
},
{
"name": "82",
"type": "text",
"label": "(CE)"
},
{
"name": "83",
"type": "text",
"label": "(CF)"
},
{
"name": "84",
"type": "text",
"label": "(CG)"
},
{
"name": "85",
"type": "text",
"label": "(CH)"
},
{
"name": "86",
"type": "text",
"label": "(CI)"
},
{
"name": "87",
"type": "text",
"label": "(CJ)"
},
{
"name": "88",
"type": "text",
"label": "(CK)"
},
{
"name": "89",
"type": "text",
"label": "(CL)"
},
{
"name": "90",
"type": "text",
"label": "(CM)"
},
{
"name": "91",
"type": "text",
"label": "(CN)"
},
{
"name": "92",
"type": "text",
"label": "(CO)"
},
{
"name": "93",
"type": "text",
"label": "(CP)"
},
{
"name": "94",
"type": "text",
"label": "(CQ)"
},
{
"name": "95",
"type": "text",
"label": "(CR)"
},
{
"name": "96",
"type": "text",
"label": "(CS)"
},
{
"name": "97",
"type": "text",
"label": "(CT)"
},
{
"name": "98",
"type": "text",
"label": "(CU)"
},
{
"name": "99",
"type": "text",
"label": "(CV)"
},
{
"name": "100",
"type": "text",
"label": "(CW)"
},
{
"name": "101",
"type": "text",
"label": "(CX)"
},
{
"name": "102",
"type": "text",
"label": "(CY)"
},
{
"name": "103",
"type": "text",
"label": "(CZ)"
}
]
}
},
{
"id": 2,
"module": "util:TextAggregator",
"version": 1,
"parameters": {
"feeder": 1,
"rowSeparator": ""
},
"mapper": {},
"metadata": {
"designer": {
"x": 300,
"y": 0
},
"restore": {
"extra": {
"feeder": {
"label": "Google Sheets - Search Rows [1]"
}
},
"parameters": {
"rowSeparator": {
"label": "Empty"
}
}
},
"parameters": [
{
"name": "rowSeparator",
"type": "select",
"label": "Row separator",
"validate": {
"enum": [
"n",
"t",
"other"
]
}
}
],
"expect": [
{
"name": "value",
"type": "text",
"label": "Text"
}
]
}
},
{
"id": 3,
"module": "openai-gpt-3:CreateCompletion",
"version": 1,
"parameters": {},
"mapper": {
"model": "o1",
"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": "o1 (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"
},
"reasoning_effort": {
"mode": "chose",
"label": "Empty"
},
"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"
]
}
},
{
"name": "reasoning_effort",
"type": "select",
"label": "Reasoning Effort",
"validate": {
"enum": [
"low",
"medium",
"high"
]
}
}
],
"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": 4,
"module": "telegram:SendReplyMessage",
"version": 1,
"parameters": {},
"mapper": {
"text": "{{3.result}}",
"chatId": "id",
"parseMode": "",
"replyMarkup": "",
"messageThreadId": "",
"replyToMessageId": "",
"replyMarkupAssembleType": "reply_markup_enter"
},
"metadata": {
"designer": {
"x": 900,
"y": 0
},
"restore": {
"expect": {
"parseMode": {
"label": "Empty"
},
"disableNotification": {
"mode": "chose"
},
"replyMarkupAssembleType": {
"label": "Enter the Reply Markup"
}
},
"parameters": {
"__IMTCONN__": {
"data": {
"scoped": "true",
"connection": "telegram"
},
"label": "My Telegram Bot connection"
}
}
},
"parameters": [
{
"name": "__IMTCONN__",
"type": "account:telegram",
"label": "Connection",
"required": true
}
],
"expect": [
{
"name": "chatId",
"type": "text",
"label": "Chat ID",
"required": true
},
{
"name": "text",
"type": "text",
"label": "Text",
"required": true
},
{
"name": "messageThreadId",
"type": "number",
"label": "Message Thread ID"
},
{
"name": "parseMode",
"type": "select",
"label": "Parse Mode",
"validate": {
"enum": [
"Markdown",
"HTML"
]
}
},
{
"name": "disableNotification",
"type": "boolean",
"label": "Disable Notifications"
},
{
"name": "disableWebPagePreview",
"type": "boolean",
"label": "Disable Link Previews"
},
{
"name": "replyToMessageId",
"type": "number",
"label": "Original Message ID"
},
{
"name": "replyMarkupAssembleType",
"type": "select",
"label": "Enter/Assemble the Reply Markup Field",
"validate": {
"enum": [
"reply_markup_enter",
"reply_markup_assemble"
]
}
},
{
"name": "replyMarkup",
"type": "text",
"label": "Reply Markup"
}
]
}
}
],
"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": []
}
}