Centralisez et digitalisez les demandes d’achat, automatisez la validation, le suivi des commandes et la gestion des livraisons. Ce guide propose des workflows prêts à l’emploi et des conseils pour fluidifier la chaîne d’approvisionnement.
Centralisez et digitalisez les demandes d’achat, automatisez la validation, le suivi des commandes et la gestion des livraisons. Ce guide propose des workflows prêts à l’emploi et des conseils pour fluidifier la chaîne d’approvisionnement.
{
"name": "Generate sentiment analysis from ‘product satisfaction’ surveys using ChatGPT",
"flow": [
{
"id": 1,
"module": "typeform:WatchEventsWithResponses",
"version": 2,
"parameters": {},
"mapper": {},
"metadata": {
"designer": {
"x": 0,
"y": 0
},
"restore": {},
"parameters": [
{
"name": "__IMTHOOK__",
"type": "hook:typeform",
"label": "Webhook"
}
]
}
},
{
"id": 24,
"module": "openai-gpt-3:CreateCompletion",
"version": 1,
"parameters": {},
"mapper": {
"model": "gpt-3.5-turbo-0301",
"select": "chat",
"messages": [
{
"role": "user",
"content": "You are a product manager researcher for a technology SAAS company. Determine the sentiment of the following answers from a survey and assign one of the following:nnPositive nUsefulnornPositive nNot usefulnornNegative nUsefulnornNegative nNot usefulnornNeutral nUsefulnornNeutral nNot usefulnnNo answernnThere must be no text before the sentiment.nnProvide a reason in your own words for your choice without repeating any part of the answer. Consider if that it may not have context but can still be useful.nfor example: nToo expensivenToo few featuresnOutdated technologynGreat pricenNew features are good etc.n nThese and similar answers that relate to the product must be considered useful even though it does not provide any suggestions or context however one word answers like:nGreatnCoolnAwesomenBad etcnnShould be considerd not useful.nnPlease translate foreign languages to English and mention it in your comment.nnAlways analyze both answers and the format of your response must always be:nsentimentnUsefulnessnreason.nnHere are the 2 questions and answers:nPlease explain your rating to us in as much detail as you can?nAnswer: nnWhat shall we improve to increase your satisfaction with Make?nAnswer: "
}
]
},
"metadata": {
"designer": {
"x": 300,
"y": 0
},
"restore": {
"expect": {
"echo": {
"mode": "chose"
},
"model": {
"mode": "chose",
"label": "gpt-3.5-turbo-0301"
},
"select": {
"label": "Create a Chat Completion"
},
"messages": {
"mode": "chose",
"items": [
{
"role": {
"mode": "chose",
"label": "User"
}
}
]
},
"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": [
"prompt",
"chat"
]
}
},
{
"name": "max_tokens",
"type": "number",
"label": "Max Tokens"
},
{
"name": "temperature",
"type": "number",
"label": "Temperature"
},
{
"name": "top_p",
"type": "number",
"label": "Top p"
},
{
"name": "n_completions",
"type": "number",
"label": "N"
},
{
"name": "echo",
"type": "boolean",
"label": "Echo"
},
{
"name": "additionalParameters",
"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": "array",
"label": "Other Input Parameters"
},
{
"name": "model",
"type": "select",
"label": "Model",
"required": true
},
{
"name": "messages",
"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",
"required": true
}
],
"type": "array",
"label": "Messages",
"required": true
}
]
}
},
{
"id": 36,
"module": "util:SetVariable2",
"version": 1,
"parameters": {},
"mapper": {
"name": "ChatGPT_Result",
"scope": "roundtrip",
"value": "{{split(24.choices[].message.content; newline)}}"
},
"metadata": {
"designer": {
"x": 600,
"y": 0
},
"restore": {
"expect": {
"scope": {
"label": "One cycle"
}
}
},
"expect": [
{
"name": "name",
"type": "text",
"label": "Variable name",
"required": true
},
{
"name": "scope",
"type": "select",
"label": "Variable lifetime",
"required": true,
"validate": {
"enum": [
"roundtrip",
"execution"
]
}
},
{
"name": "value",
"type": "any",
"label": "Variable value"
}
],
"interface": [
{
"name": "ChatGPT_Result",
"type": "any",
"label": "ChatGPT_Result"
}
]
}
},
{
"id": 35,
"module": "airtable:ActionCreateRecord",
"version": 3,
"parameters": {},
"mapper": {
"base": "appbuyslCnh0u50ug",
"table": "tblWsaDQ3xDuXupCf",
"record": {
"fld9CeaXv6V15tpxr": "{{1.form_id}}",
"fld9PZz64i1wvGma2": "{{36.ChatGPT_Result[2]}}",
"fldDB3HugQwkUuEgL": "{{36.ChatGPT_Result[1]}}",
"fldIfOlhBkdxPPUms": "{{36.ChatGPT_Result[4]}}",
"fldNWOjIUpZp5PicX": "{{36.ChatGPT_Result[5]}}",
"fldSIJKhDx9GFKm49": "{{1.mappable_answers.`42aa6657-c321-4e92-992d-becb4a970b0a`}}",
"fldXioPMrZAYFO2im": "{{36.ChatGPT_Result[6]}}",
"fldZv2zFMEtbYveAa": "{{36.ChatGPT_Result[3]}}",
"flddsbrhMEOXe57jj": "{{1.mappable_answers.`564f961d-627d-43d4-8f86-85c9a6277da5`}}",
"fldsUMZICqo79aB91": "{{1.mappable_answers.`2e17aaa2-d032-4fca-a273-ca4d5957e0a6`}}"
},
"typecast": false,
"useColumnId": false
},
"metadata": {
"designer": {
"x": 900,
"y": 0
},
"restore": {
"expect": {
"base": {
"label": "Product survey AI sentiment analysis - template"
},
"table": {
"label": "Table 1",
"nested": [
{
"name": "record",
"spec": [
{
"name": "fld9CeaXv6V15tpxr",
"type": "text",
"label": "Form ID"
},
{
"name": "fldsUMZICqo79aB91",
"type": "number",
"label": "Star Rating"
},
{
"name": "fldSIJKhDx9GFKm49",
"type": "text",
"label": "Question 2 Comment",
"multiline": true
},
{
"name": "fldDB3HugQwkUuEgL",
"type": "text",
"label": "Question 2 Sentiment",
"multiline": true
},
{
"name": "fld9PZz64i1wvGma2",
"type": "text",
"label": "Question 2 Usefulness"
},
{
"name": "fldZv2zFMEtbYveAa",
"type": "text",
"label": "Question 2 Comment Analysis",
"multiline": true
},
{
"name": "flddsbrhMEOXe57jj",
"type": "text",
"label": "Question 3 Comment",
"multiline": true
},
{
"name": "fldIfOlhBkdxPPUms",
"type": "text",
"label": "Question 3 Sentiment"
},
{
"name": "fldNWOjIUpZp5PicX",
"type": "text",
"label": "Question 3 Usefulness"
},
{
"name": "fldXioPMrZAYFO2im",
"type": "text",
"label": "Question 3 Comment analysis",
"multiline": true
}
],
"type": "collection",
"label": "Record"
}
]
},
"typecast": {
"mode": "chose"
},
"useColumnId": {
"mode": "chose"
}
},
"parameters": {
"__IMTCONN__": {
"data": {
"scoped": "true",
"connection": "airtable2"
},
"label": "Airtable"
}
}
},
"parameters": [
{
"name": "__IMTCONN__",
"type": "account:airtable3,airtable2",
"label": "Connection"
}
],
"expect": [
{
"name": "base",
"type": "select",
"label": "Base",
"required": true
},
{
"name": "typecast",
"type": "boolean",
"label": "Smart links",
"required": true
},
{
"name": "useColumnId",
"type": "boolean",
"label": "Use Column ID",
"required": true
},
{
"name": "table",
"type": "select",
"label": "Table",
"required": true
},
{
"name": "record",
"spec": [
{
"name": "fld9CeaXv6V15tpxr",
"type": "text",
"label": "Form ID"
},
{
"name": "fldsUMZICqo79aB91",
"type": "number",
"label": "Star Rating"
},
{
"name": "fldSIJKhDx9GFKm49",
"type": "text",
"label": "Question 2 Comment"
},
{
"name": "fldDB3HugQwkUuEgL",
"type": "text",
"label": "Question 2 Sentiment"
},
{
"name": "fld9PZz64i1wvGma2",
"type": "text",
"label": "Question 2 Usefulness"
},
{
"name": "fldZv2zFMEtbYveAa",
"type": "text",
"label": "Question 2 Comment Analysis"
},
{
"name": "flddsbrhMEOXe57jj",
"type": "text",
"label": "Question 3 Comment"
},
{
"name": "fldIfOlhBkdxPPUms",
"type": "text",
"label": "Question 3 Sentiment"
},
{
"name": "fldNWOjIUpZp5PicX",
"type": "text",
"label": "Question 3 Usefulness"
},
{
"name": "fldXioPMrZAYFO2im",
"type": "text",
"label": "Question 3 Comment analysis"
}
],
"type": "collection",
"label": "Record"
}
],
"interface": [
{
"name": "id",
"type": "text",
"label": "ID"
},
{
"name": "createdTime",
"type": "date",
"label": "Created Time"
},
{
"name": "Form ID",
"type": "text",
"label": "Form ID"
},
{
"name": "Star Rating",
"type": "number",
"label": "Star Rating"
},
{
"name": "Question 2 Comment",
"type": "text",
"label": "Question 2 Comment",
"multiline": true
},
{
"name": "Question 2 Sentiment",
"type": "text",
"label": "Question 2 Sentiment",
"multiline": true
},
{
"name": "Question 2 Usefulness",
"type": "text",
"label": "Question 2 Usefulness"
},
{
"name": "Question 2 Comment Analysis",
"type": "text",
"label": "Question 2 Comment Analysis",
"multiline": true
},
{
"name": "Question 3 Comment",
"type": "text",
"label": "Question 3 Comment",
"multiline": true
},
{
"name": "Question 3 Sentiment",
"type": "text",
"label": "Question 3 Sentiment"
},
{
"name": "Question 3 Usefulness",
"type": "text",
"label": "Question 3 Usefulness"
},
{
"name": "Question 3 Comment analysis",
"type": "text",
"label": "Question 3 Comment analysis",
"multiline": true
}
]
}
},
{
"id": 25,
"module": "slack:CreateMessage",
"version": 4,
"parameters": {},
"mapper": {
"text": "You have a new product survey response!nnHow would you rate your overall satisfaction with Make in the past month? 1= Highly dissatisfied, 5= Highly satisfiedn{{35.`Star Rating`}}nnPlease explain the reason for your rating in as much detail as possible.nComment: {{35.`Question 2 Comment`}}nSentiment: {{35.`Question 2 Sentiment`}}nUsefulness: {{35.`Question 2 Usefulness`}}nComment Analysis: {{35.`Question 2 Comment Analysis`}}nnWhat shall we improve on to increase your satisfaction with Make? nComment: {{35.`Question 3 Comment`}}nSentiment: {{35.`Question 3 Sentiment`}}nUsefulness: {{35.`Question 3 Usefulness`}}nComment Analysis: {{35.`Question 3 Comment analysis`}}",
"parse": false,
"mrkdwn": true,
"channel": "DM4UHB7HT",
"channelType": "im",
"channelWType": "list"
},
"metadata": {
"designer": {
"x": 1200,
"y": 0
},
"restore": {
"expect": {
"parse": {
"mode": "chose"
},
"mrkdwn": {
"mode": "chose"
},
"channel": {
"mode": "chose",
"label": "lwgovender7"
},
"link_names": {
"mode": "chose"
},
"channelType": {
"label": "IM channel"
},
"channelWType": {
"label": "Select from the list"
},
"unfurl_links": {
"mode": "chose"
},
"unfurl_media": {
"mode": "chose"
},
"reply_broadcast": {
"mode": "chose"
}
},
"parameters": {
"__IMTCONN__": {
"data": {
"scoped": "true",
"connection": "slack2"
},
"label": "My Slack (user) connection (lwgovender7)"
}
}
},
"parameters": [
{
"name": "__IMTCONN__",
"type": "account:slack2,slack3",
"label": "Connection"
}
],
"expect": [
{
"name": "channelWType",
"type": "select",
"label": "Enter a channel ID or name",
"required": true,
"validate": {
"enum": [
"manualy",
"list"
]
}
},
{
"name": "text",
"type": "text",
"label": "Text"
},
{
"name": "blocks",
"type": "text",
"label": "Blocks"
},
{
"name": "thread_ts",
"type": "text",
"label": "Thread message ID (time stamp)"
},
{
"name": "reply_broadcast",
"type": "boolean",
"label": "Reply broadcast"
},
{
"name": "link_names",
"type": "boolean",
"label": "Link names"
},
{
"name": "parse",
"type": "boolean",
"label": "Parse message text"
},
{
"name": "mrkdwn",
"type": "boolean",
"label": "Use markdown"
},
{
"name": "unfurl_links",
"type": "boolean",
"label": "Unfurl primarily text-based content"
},
{
"name": "unfurl_media",
"type": "boolean",
"label": "Unfurl media content"
},
{
"name": "icon_emoji",
"type": "text",
"label": "Icon emoji"
},
{
"name": "icon_url",
"type": "url",
"label": "Icon url"
},
{
"name": "username",
"type": "text",
"label": "User name"
},
{
"name": "channelType",
"type": "select",
"label": "Channel type",
"required": true,
"validate": {
"enum": [
"public",
"private",
"im",
"mpim"
]
}
},
{
"name": "channel",
"type": "select",
"label": "User",
"required": true
}
]
}
}
],
"metadata": {
"instant": true,
"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": []
}
}