La relance commerciale manuelle est chronophage et peu fiable. Grâce à l’automatisation, programmez des séquences personnalisées selon le comportement client, suivez l’historique des interactions et ajustez le discours selon la maturité du prospect. Ce dossier présente des exemples de workflow et des outils pour ne jamais perdre une vente à cause d’un oubli.
{
"name": "Create Instagram posts from Google Sheets data using ChatGPT Assistant and image generation",
"flow": [
{
"id": 1,
"module": "google-sheets:watchRows",
"version": 2,
"parameters": {
"from": "drive",
"mode": "select",
"limit": 2,
"sheetId": "Home",
"spreadsheetId": "/1slHhMRD-oG4FtgRe_obkHzfucBHwYc8SCDcnDT7Jel0",
"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": "Home"
},
"__IMTCONN__": {
"data": {
"scoped": "true",
"connection": "google"
},
"label": "My Google connection (l.govender@make.com)"
},
"spreadsheetId": {
"path": [
"Copy of 10 Competitive Analysis Templates – HubSpot "
]
},
"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": "A"
},
{
"name": "1",
"type": "text",
"label": "B"
},
{
"name": "2",
"type": "text",
"label": "C"
},
{
"name": "3",
"type": "text",
"label": "D"
},
{
"name": "4",
"type": "text",
"label": "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": 2,
"module": "openai-gpt-3:messageAssistantAdvanced",
"version": 1,
"parameters": {},
"mapper": {
"role": "user",
"message": "You are a pro social media content creator.nPlease generate a post for Instag explaining this article : {article}",
"assistantId": "asst_VzgdJgkfWRhbEoaNQ1H2ruJm"
},
"metadata": {
"designer": {
"x": 300,
"y": 0
},
"restore": {
"expect": {
"role": {
"label": "User"
},
"model": {
"mode": "chose",
"label": "Empty"
},
"tools": {
"mode": "chose"
},
"image_urls": {
"mode": "chose"
},
"assistantId": {
"mode": "chose",
"label": "Financial Analyst Assistant (gpt-4o)",
"nested": []
},
"image_files": {
"mode": "chose"
},
"tool_choice": {
"mode": "chose",
"label": "Empty"
},
"response_format": {
"mode": "chose",
"label": "Empty"
},
"truncation_strategy": {
"mode": "chose",
"label": "Empty"
},
"file_search_resources": {
"mode": "chose",
"label": "Empty"
},
"code_interpreter_resources": {
"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": "assistantId",
"type": "select",
"label": "Assistant",
"required": true
},
{
"name": "role",
"type": "select",
"label": "Role",
"required": true,
"validate": {
"enum": [
"user",
"assistant"
]
}
},
{
"name": "threadId",
"type": "text",
"label": "Thread ID"
},
{
"name": "model",
"type": "select",
"label": "Model"
},
{
"name": "tools",
"type": "select",
"label": "Tools",
"multiple": true,
"validate": {
"enum": [
"file_search",
"code_interpreter"
]
}
},
{
"name": "file_search_resources",
"type": "select",
"label": "File Search Resources"
},
{
"name": "code_interpreter_resources",
"type": "select",
"label": "Code Interpreter Resources",
"multiple": true,
"validate": {
"maxItems": 20
}
},
{
"name": "tool_choice",
"type": "select",
"label": "Tool Choice",
"validate": {
"enum": [
"none",
"auto",
"required",
"file_search",
"code_interpreter",
"function"
]
}
},
{
"name": "instructions",
"type": "text",
"label": "Instructions"
},
{
"name": "max_prompt_tokens",
"type": "uinteger",
"label": "Max Prompt Tokens"
},
{
"name": "max_completion_tokens",
"type": "uinteger",
"label": "Max Completion 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": "response_format",
"type": "select",
"label": "Response Format",
"validate": {
"enum": [
"auto",
"json_object",
"text"
]
}
},
{
"name": "truncation_strategy",
"type": "select",
"label": "Truncation Strategy",
"validate": {
"enum": [
"auto",
"last_messages"
]
}
},
{
"name": "message",
"type": "text",
"label": "Message",
"required": true
},
{
"name": "image_files",
"type": "select",
"label": "Image Files",
"multiple": true
},
{
"name": "image_urls",
"spec": {
"name": "value",
"type": "url",
"label": "Image URL",
"required": true
},
"type": "array",
"label": "Image URLs"
}
]
}
},
{
"id": 3,
"module": "openai-gpt-3:GenerateImage",
"version": 1,
"parameters": {},
"mapper": {
"size": "1024x1024",
"model": "dall-e-3",
"style": "vivid",
"prompt": "x {{1.`1`}}",
"quality": "standard",
"response_format": "url"
},
"metadata": {
"designer": {
"x": 600,
"y": 0
},
"restore": {
"expect": {
"size": {
"mode": "chose",
"label": "1024x1024"
},
"model": {
"mode": "chose",
"label": "Dall-E 3"
},
"style": {
"mode": "chose",
"label": "Vivid"
},
"quality": {
"mode": "chose",
"label": "Standard"
},
"response_format": {
"mode": "chose",
"label": "URL"
}
},
"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": "model",
"type": "select",
"label": "Model",
"required": true,
"validate": {
"enum": [
"dall-e-3",
"dall-e-2"
]
}
},
{
"name": "prompt",
"type": "text",
"label": "Prompt",
"required": true,
"validate": {
"max": 4000,
"min": 0
}
},
{
"name": "size",
"type": "select",
"label": "Size",
"validate": {
"enum": [
"1024x1024",
"1792x1024",
"1024x1792"
]
}
},
{
"name": "quality",
"type": "select",
"label": "Quality",
"validate": {
"enum": [
"standard",
"hd"
]
}
},
{
"name": "style",
"type": "select",
"label": "Style",
"validate": {
"enum": [
"vivid",
"natural"
]
}
},
{
"name": "response_format",
"type": "select",
"label": "Response Format",
"validate": {
"enum": [
"url",
"imageFile"
]
}
}
],
"interface": [
{
"name": "created",
"type": "date",
"label": "Created"
},
{
"name": "data",
"spec": [
{
"name": "url",
"type": "url",
"label": "URL"
},
{
"name": "revised_prompt",
"type": "text",
"label": "Revised Prompt"
}
],
"type": "array",
"label": "Data"
},
{
"name": "resImgName",
"type": "text",
"label": "Response Image Name",
"semantic": "file:name"
},
{
"name": "resImgData",
"type": "buffer",
"label": "Response Image Data",
"semantic": "file:data"
}
]
}
},
{
"id": 4,
"module": "instagram-business:CreatePostPhoto",
"version": 1,
"parameters": {},
"mapper": {
"caption": "{{2.result}}",
"accountId": "17841417757528325",
"image_url": "{{3.data[].url}}"
},
"metadata": {
"designer": {
"x": 900,
"y": 0
},
"restore": {
"expect": {
"accountId": {
"mode": "chose",
"label": "Testovací stránka (@tereza.ig)"
},
"user_tags": {
"mode": "chose"
}
},
"parameters": {
"__IMTCONN__": {
"data": {
"scoped": "true",
"connection": "facebook"
},
"label": "My Facebook connection (Development Make)"
}
}
},
"parameters": [
{
"name": "__IMTCONN__",
"type": "account:facebook",
"label": "Connection",
"required": true
}
],
"expect": [
{
"name": "accountId",
"type": "select",
"label": "Page",
"required": true
},
{
"name": "image_url",
"type": "url",
"label": "Photo URL",
"required": true
},
{
"name": "caption",
"type": "text",
"label": "Caption"
},
{
"name": "user_tags",
"spec": [
{
"name": "username",
"type": "text",
"label": "Username",
"required": true,
"validate": {
"pattern": "^(?!@)"
}
},
{
"name": "x",
"type": "number",
"label": "X position",
"required": true,
"validate": {
"max": 1,
"min": 0
}
},
{
"name": "y",
"type": "number",
"label": "Y position",
"required": true,
"validate": {
"max": 1,
"min": 0
}
}
],
"type": "array",
"label": "User Tags"
},
{
"name": "location_id",
"type": "text",
"label": "Location ID"
}
]
}
}
],
"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": []
}
}