Mettez en place des bots (Slack, Teams, Telegram…) pour automatiser les tâches répétitives, la communication interne ou le support IT. Exemples concrets et outils recommandés.
Mettez en place des bots (Slack, Teams, Telegram…) pour automatiser les tâches répétitives, la communication interne ou le support IT. Exemples concrets et outils recommandés.
{
"name": "Create a sales analysis for Loyverse reciepts with OpenAI",
"flow": [
{
"id": 188,
"module": "google-sheets:addSheet",
"version": 2,
"parameters": {},
"mapper": {
"from": "drive",
"select": "list",
"properties": {
"title": "{{formatDate(now; "YYYY/MM/DD")}}"
},
"spreadsheetId": "/1pZnNQyElQNsbnHiV1LjJgeZo2jWjz8300AZcYl52o0k"
},
"metadata": {
"designer": {
"x": 0,
"y": 150
},
"restore": {
"expect": {
"from": {
"label": "My Drive"
},
"select": {
"label": "Select from the list"
},
"spreadsheetId": {
"path": [
"Sheets for GPT v3.1"
]
}
},
"parameters": {
"__IMTCONN__": {
"data": {
"scoped": "true",
"connection": "google"
},
"label": "My Google connection (yisobe@loyverse.com)"
}
}
},
"parameters": [
{
"name": "__IMTCONN__",
"type": "account:google",
"label": "Connection"
}
],
"expect": [
{
"name": "select",
"type": "select",
"label": "Enter a Spreadsheet ID",
"required": true,
"validate": {
"enum": [
"map",
"fromAll",
"list"
]
}
},
{
"name": "properties",
"spec": [
{
"name": "title",
"type": "text",
"label": "Title"
},
{
"name": "index",
"type": "number",
"label": "Index"
}
],
"type": "collection",
"label": "Properties"
},
{
"name": "from",
"type": "select",
"label": "Choose a Drive",
"required": true,
"validate": {
"enum": [
"drive",
"share",
"team"
]
}
},
{
"name": "spreadsheetId",
"type": "file",
"label": "Spreadsheet ID",
"required": true
}
]
}
},
{
"id": 1,
"module": "loyverse:listReceipts",
"version": 1,
"parameters": {},
"mapper": {
"filter": [
[
{
"a": "created_at",
"b": "{{parseDate(setHour(now; 0); "YYYY-MM-DD HH:mm")}}",
"o": "min"
},
{
"a": "created_at",
"b": "{{parseDate(setHour(now; 23); "YYYY-MM-DD HH:mm")}}",
"o": "max"
}
]
]
},
"metadata": {
"designer": {
"x": 300,
"y": 150
},
"restore": {
"expect": {
"limit": {
"empty": true
},
"store_id": {
"mode": "chose"
},
"receipt_numbers": {
"mode": "chose"
}
},
"parameters": {
"__IMTCONN__": {
"data": {
"scoped": "true",
"connection": "loyverse2"
},
"label": "My Loyverse OAuth2 connection"
}
}
},
"parameters": [
{
"name": "__IMTCONN__",
"type": "account:loyverse2,loyverse",
"label": "Connection"
}
],
"expect": [
{
"name": "filter",
"type": "filter",
"label": "Filter",
"options": {
"logic": "and",
"store": [
{
"label": "Created At (Date)",
"value": "created_at"
},
{
"label": "Updated At (Date)",
"value": "updated_at"
},
{
"label": "Receipt Number",
"value": "receipt_number"
}
],
"operators": [
{
"label": "Date",
"options": [
{
"label": "before",
"value": "max"
},
{
"label": "after",
"value": "min"
}
]
},
{
"label": "Receipt Number",
"options": [
{
"label": "before",
"value": "before"
},
{
"label": "since",
"value": "since"
}
]
}
]
}
},
{
"name": "receipt_numbers",
"spec": {
"mode": "edit",
"name": "value",
"type": "select",
"label": "Receipt Number",
"dynamic": true,
"options": [],
"required": true
},
"type": "array",
"label": "Receipt Numbers"
},
{
"name": "order",
"type": "text",
"label": "Order"
},
{
"mode": "edit",
"name": "store_id",
"type": "select",
"label": "Store ID"
},
{
"name": "limit",
"type": "uinteger",
"label": "Limit"
}
]
}
},
{
"id": 94,
"module": "builtin:BasicFeeder",
"version": 1,
"parameters": {},
"mapper": {
"array": "{{1.line_items}}"
},
"metadata": {
"designer": {
"x": 600,
"y": 150
},
"restore": {
"expect": {
"array": {
"mode": "edit"
}
}
},
"expect": [
{
"mode": "edit",
"name": "array",
"spec": [],
"type": "array",
"label": "Array"
}
]
}
},
{
"id": 187,
"module": "builtin:BasicRouter",
"version": 1,
"mapper": null,
"metadata": {
"designer": {
"x": 900,
"y": 150
}
},
"routes": [
{
"flow": [
{
"id": 95,
"module": "builtin:BasicAggregator",
"version": 1,
"parameters": {
"feeder": 1
},
"mapper": {
"item_id": "{{94.item_id}}",
"quantity": "{{94.quantity}}",
"store_id": "{{1.store_id}}",
"item_name": "{{94.item_name}}",
"cost_total": "{{94.cost_total}}",
"variant_name": "{{94.variant_name}}",
"gross_total_money": "{{94.gross_total_money}}"
},
"metadata": {
"designer": {
"x": 1200,
"y": 0
},
"restore": {
"extra": {
"feeder": {
"label": "Loyverse - List Receipts [1]"
},
"target": {
"label": "Custom"
}
}
},
"advanced": true
},
"flags": {
"groupBy": "{{94.variant_id}}"
}
},
{
"id": 151,
"module": "builtin:BasicAggregator",
"version": 1,
"parameters": {
"feeder": 95
},
"mapper": {
"array": "{{95.array}}",
"__IMTKEY__": "{{95.`__IMTKEY__`}}"
},
"metadata": {
"designer": {
"x": 1500,
"y": 0
},
"restore": {
"extra": {
"feeder": {
"label": "Array aggregator [95]"
},
"target": {
"label": "Custom"
}
}
}
}
},
{
"id": 153,
"module": "builtin:BasicFeeder",
"version": 1,
"parameters": {},
"mapper": {
"array": "{{151.array}}"
},
"metadata": {
"designer": {
"x": 1800,
"y": 0
},
"restore": {
"expect": {
"array": {
"mode": "edit"
}
}
},
"expect": [
{
"mode": "edit",
"name": "array",
"spec": [],
"type": "array",
"label": "Array"
}
]
}
},
{
"id": 155,
"module": "util:SetVariables",
"version": 1,
"parameters": {},
"mapper": {
"scope": "roundtrip",
"variables": [
{
"name": "gross_total_money",
"value": "{{sum(map(153.array; "gross_total_money"))}}"
},
{
"name": "quantity",
"value": "{{sum(map(153.array; "quantity"))}}"
},
{
"name": "cost_total",
"value": "{{sum(map(153.array; "cost_total"))}}"
}
]
},
"metadata": {
"designer": {
"x": 2100,
"y": 0
},
"restore": {
"expect": {
"scope": {
"label": "One cycle"
},
"variables": {
"items": [
null,
null,
null
]
}
}
},
"expect": [
{
"name": "variables",
"spec": [
{
"name": "name",
"type": "text",
"label": "Variable name",
"required": true
},
{
"name": "value",
"type": "any",
"label": "Variable value"
}
],
"type": "array",
"label": "Variables"
},
{
"name": "scope",
"type": "select",
"label": "Variable lifetime",
"required": true,
"validate": {
"enum": [
"roundtrip",
"execution"
]
}
}
],
"interface": [
{
"name": "gross_total_money",
"type": "any",
"label": "gross_total_money"
},
{
"name": "quantity",
"type": "any",
"label": "quantity"
},
{
"name": "cost_total",
"type": "any",
"label": "cost_total"
}
]
}
},
{
"id": 156,
"module": "loyverse:listInventoryLevels",
"version": 1,
"parameters": {},
"mapper": {
"store_ids": [
"{{join(distinct(map(153.array; "store_id"); "store_id"))}}"
],
"variant_ids": [
"{{153.`__IMTKEY__`}}"
]
},
"metadata": {
"designer": {
"x": 2400,
"y": 0
},
"restore": {
"expect": {
"limit": {
"empty": true
},
"store_ids": {
"mode": "chose",
"items": [
{
"value": {
"mode": "edit"
}
}
]
},
"variant_ids": {
"mode": "chose",
"items": [
{
"value": {
"mode": "edit"
}
}
]
}
},
"parameters": {
"__IMTCONN__": {
"data": {
"scoped": "true",
"connection": "loyverse2"
},
"label": "My Loyverse OAuth2 connection"
}
}
},
"parameters": [
{
"name": "__IMTCONN__",
"type": "account:loyverse2",
"label": "Connection"
}
],
"expect": [
{
"name": "filter",
"type": "filter",
"label": "Filter",
"options": {
"logic": "and",
"store": [
{
"label": "Updated At",
"value": "updated_at"
}
],
"operators": [
{
"label": "Date",
"options": [
{
"label": "before",
"value": "max"
},
{
"label": "after",
"value": "min"
}
]
}
]
}
},
{
"name": "store_ids",
"spec": {
"mode": "edit",
"name": "value",
"type": "select",
"label": "Store ID",
"dynamic": true,
"options": [],
"required": true
},
"type": "array",
"label": "Store IDs"
},
{
"name": "variant_ids",
"spec": {
"mode": "edit",
"name": "value",
"type": "select",
"label": "Variant ID",
"dynamic": true,
"options": [],
"required": true
},
"type": "array",
"label": "Variant IDs"
},
{
"name": "limit",
"type": "uinteger",
"label": "Limit"
}
]
}
},
{
"id": 129,
"module": "google-sheets:addRow",
"version": 2,
"parameters": {},
"mapper": {
"mode": "map",
"values": {
"0": "{{distinct(map(153.array; "item_name"); "item_name")}}",
"1": "{{distinct(map(153.array; "variant_name"); "variant_name")}}",
"2": "{{155.gross_total_money}}",
"3": "{{155.cost_total}}",
"4": "{{155.quantity}}",
"5": "{{155.gross_total_money - 155.cost_total}}",
"6": "{{156.in_stock}}"
},
"sheetId": "{{formatDate(now; "YYYY/MM/DD")}}",
"spreadsheetId": "{{188.spreadsheetId}}",
"tableFirstRow": "A1:Z1",
"insertDataOption": "INSERT_ROWS",
"valueInputOption": "USER_ENTERED",
"insertUnformatted": false
},
"metadata": {
"designer": {
"x": 2700,
"y": 0
},
"restore": {
"expect": {
"mode": {
"label": "Enter manually"
},
"tableFirstRow": {
"label": "A-Z",
"nested": [
{
"name": "values",
"spec": [
{
"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"
}
],
"type": "collection",
"label": "Values"
}
]
},
"insertDataOption": {
"mode": "chose",
"label": "Insert rows"
},
"valueInputOption": {
"mode": "chose",
"label": "User entered"
},
"insertUnformatted": {
"mode": "chose"
}
},
"parameters": {
"__IMTCONN__": {
"data": {
"scoped": "true",
"connection": "google"
},
"label": "My Google connection (yisobe@loyverse.com)"
}
}
},
"parameters": [
{
"name": "__IMTCONN__",
"type": "account:google",
"label": "Connection"
}
],
"expect": [
{
"name": "mode",
"type": "select",
"label": "Choose a Method",
"required": true,
"validate": {
"enum": [
"select",
"fromAll",
"map"
]
}
},
{
"name": "insertUnformatted",
"type": "boolean",
"label": "Unformatted",
"required": true
},
{
"name": "valueInputOption",
"type": "select",
"label": "Value input option",
"validate": {
"enum": [
"USER_ENTERED",
"RAW"
]
}
},
{
"name": "insertDataOption",
"type": "select",
"label": "Insert data option",
"validate": {
"enum": [
"INSERT_ROWS",
"OVERWRITE"
]
}
},
{
"name": "spreadsheetId",
"type": "text",
"label": "Spreadsheet",
"required": true
},
{
"name": "sheetId",
"type": "text",
"label": "Sheet Name",
"required": true
},
{
"name": "tableFirstRow",
"type": "select",
"label": "Column range",
"required": true,
"validate": {
"enum": [
"A1:Z1",
"A1:BZ1",
"A1:CZ1",
"A1:DZ1",
"A1:MZ1",
"A1:ZZ1"
]
}
},
{
"name": "values",
"spec": [
{
"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"
}
],
"type": "collection",
"label": "Values"
}
]
}
},
{
"id": 141,
"module": "google-sheets:filterRowsAdvanced",
"version": 2,
"parameters": {},
"filter": {
"name": "",
"conditions": [
[
{
"a": "{{153.`__IMTINDEX__`}}",
"b": "{{151.`__IMTAGGLENGTH__`}}",
"o": "text:equal"
}
]
]
},
"mapper": {
"tq": "select * limit {{151.`__IMTAGGLENGTH__`}}",
"select": "map",
"sheetId": "{{188.replies[].addSheet.properties.sheetId}}",
"spreadsheetId": "{{188.spreadsheetId}}"
},
"metadata": {
"designer": {
"x": 3000,
"y": 0
},
"restore": {
"expect": {
"select": {
"label": "Enter manually"
}
},
"parameters": {
"__IMTCONN__": {
"data": {
"scoped": "true",
"connection": "google"
},
"label": "My Google connection (yisobe@loyverse.com)"
}
}
},
"parameters": [
{
"name": "__IMTCONN__",
"type": "account:google",
"label": "Connection"
}
],
"expect": [
{
"name": "select",
"type": "select",
"label": "Enter a Spreadsheet and Sheet ID",
"required": true,
"validate": {
"enum": [
"map",
"fromAll",
"list"
]
}
},
{
"name": "tq",
"type": "text",
"label": "Query",
"required": true
},
{
"name": "limit",
"type": "number",
"label": "Maximum number of returned rows"
},
{
"name": "spreadsheetId",
"type": "text",
"label": "Spreadsheet ID",
"required": true
},
{
"name": "sheetId",
"type": "text",
"label": "Sheet ID",
"required": true
}
]
}
},
{
"id": 160,
"module": "util:AggregateAggregator",
"version": 1,
"parameters": {
"feeder": 141,
"rowSeparator": "n",
"columnSeparator": "other",
"otherColumnSeparator": ", "
},
"mapper": {
"0": "{{141.`0`}}",
"1": "{{141.`1`}}",
"2": "{{141.`2`}}",
"3": "{{141.`3`}}",
"4": "{{141.`4`}}",
"5": "{{141.`5`}}",
"6": "{{141.`6`}}"
},
"metadata": {
"designer": {
"x": 3300,
"y": 0
},
"restore": {
"extra": {
"feeder": {
"label": "Google Sheets - Search Rows (Advanced) [141]"
}
},
"parameters": {
"rowSeparator": {
"label": "New row"
},
"columnSeparator": {
"label": "Other"
}
}
},
"parameters": [
{
"name": "columnSeparator",
"type": "select",
"label": "Column separator",
"validate": {
"enum": [
"n",
"t",
"other"
]
}
},
{
"name": "rowSeparator",
"type": "select",
"label": "Row separator",
"validate": {
"enum": [
"n",
"t",
"other"
]
}
},
{
"name": "otherColumnSeparator",
"type": "text",
"label": "Separator"
}
],
"advanced": true
}
},
{
"id": 184,
"module": "util:SetVariable2",
"version": 1,
"parameters": {},
"mapper": {
"name": "salesByItem",
"scope": "roundtrip",
"value": "{{160.text}}"
},
"metadata": {
"designer": {
"x": 3600,
"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": "salesByItem",
"type": "any",
"label": "salesByItem"
}
]
}
}
]
},
{
"flow": [
{
"id": 165,
"module": "builtin:BasicAggregator",
"version": 1,
"parameters": {
"feeder": 1
},
"mapper": {
"cost_total": "{{94.cost_total}}",
"total_money": "{{94.total_money}}",
"receipt_date": "{{1.receipt_date}}",
"total_discount": "{{94.total_discount}}"
},
"metadata": {
"designer": {
"x": 1200,
"y": 300
},
"restore": {
"extra": {
"feeder": {
"label": "Loyverse - List Receipts [1]"
},
"target": {
"label": "Custom"
}
}
},
"advanced": true
},
"flags": {
"groupBy": "{{formatDate(1.receipt_date; "DD/MM/YYYY")}}"
}
},
{
"id": 176,
"module": "builtin:BasicAggregator",
"version": 1,
"parameters": {
"feeder": 165
},
"mapper": {
"array": "{{165.array}}",
"__IMTKEY__": "{{165.`__IMTKEY__`}}"
},
"metadata": {
"designer": {
"x": 1500,
"y": 300
},
"restore": {
"extra": {
"feeder": {
"label": "Array aggregator [165]"
},
"target": {
"label": "Custom"
}
}
}
}
},
{
"id": 177,
"module": "builtin:BasicFeeder",
"version": 1,
"parameters": {},
"mapper": {
"array": "{{176.array}}"
},
"metadata": {
"designer": {
"x": 1800,
"y": 300
},
"restore": {
"expect": {
"array": {
"mode": "edit"
}
}
},
"expect": [
{
"mode": "edit",
"name": "array",
"spec": [],
"type": "array",
"label": "Array"
}
]
}
},
{
"id": 168,
"module": "util:SetVariables",
"version": 1,
"parameters": {},
"mapper": {
"scope": "roundtrip",
"variables": [
{
"name": "receipt_date",
"value": "{{formatDate(join(distinct(map(177.array; "receipt_date"); "receipt_date")); "DD/MM/YYYY")}}"
},
{
"name": "total_money",
"value": "{{sum(map(177.array; "total_money"))}}"
},
{
"name": "total_discounts",
"value": "{{sum(get(map(177.array; "total_discounts"); "total_discounts"))}}"
},
{
"name": "cost_total",
"value": "{{sum(map(177.array; "cost_total"))}}"
}
]
},
"metadata": {
"designer": {
"x": 2100,
"y": 300
},
"restore": {
"expect": {
"scope": {
"label": "One cycle"
},
"variables": {
"items": [
null,
null,
null,
null
]
}
}
},
"expect": [
{
"name": "variables",
"spec": [
{
"name": "name",
"type": "text",
"label": "Variable name",
"required": true
},
{
"name": "value",
"type": "any",
"label": "Variable value"
}
],
"type": "array",
"label": "Variables"
},
{
"name": "scope",
"type": "select",
"label": "Variable lifetime",
"required": true,
"validate": {
"enum": [
"roundtrip",
"execution"
]
}
}
],
"interface": [
{
"name": "receipt_date",
"type": "any",
"label": "receipt_date"
},
{
"name": "total_money",
"type": "any",
"label": "total_money"
},
{
"name": "total_discounts",
"type": "any",
"label": "total_discounts"
},
{
"name": "cost_total",
"type": "any",
"label": "cost_total"
}
]
}
},
{
"id": 172,
"module": "google-sheets:addRow",
"version": 2,
"parameters": {},
"mapper": {
"mode": "map",
"values": {
"0": "{{formatDate(join(distinct(map(177.array; "receipt_date"); "receipt_date")); "DD/MM/YYYY")}}",
"1": "{{168.total_money}}",
"2": "{{168.total_discounts}}",
"3": "{{168.total_money - 168.total_discounts}}",
"4": "{{168.total_money - 168.total_discounts - 168.cost_total}}"
},
"sheetId": "Sales by Date",
"spreadsheetId": "{{188.spreadsheetId}}",
"tableFirstRow": "A1:Z1",
"insertDataOption": "INSERT_ROWS",
"valueInputOption": "USER_ENTERED",
"insertUnformatted": false
},
"metadata": {
"designer": {
"x": 2400,
"y": 300
},
"restore": {
"expect": {
"mode": {
"label": "Enter manually"
},
"tableFirstRow": {
"label": "A-Z",
"nested": [
{
"name": "values",
"spec": [
{
"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"
}
],
"type": "collection",
"label": "Values"
}
]
},
"insertDataOption": {
"mode": "chose",
"label": "Insert rows"
},
"valueInputOption": {
"mode": "chose",
"label": "User entered"
},
"insertUnformatted": {
"mode": "chose"
}
},
"parameters": {
"__IMTCONN__": {
"data": {
"scoped": "true",
"connection": "google"
},
"label": "My Google connection (yisobe@loyverse.com)"
}
}
},
"parameters": [
{
"name": "__IMTCONN__",
"type": "account:google",
"label": "Connection"
}
],
"expect": [
{
"name": "mode",
"type": "select",
"label": "Choose a Method",
"required": true,
"validate": {
"enum": [
"select",
"fromAll",
"map"
]
}
},
{
"name": "insertUnformatted",
"type": "boolean",
"label": "Unformatted",
"required": true
},
{
"name": "valueInputOption",
"type": "select",
"label": "Value input option",
"validate": {
"enum": [
"USER_ENTERED",
"RAW"
]
}
},
{
"name": "insertDataOption",
"type": "select",
"label": "Insert data option",
"validate": {
"enum": [
"INSERT_ROWS",
"OVERWRITE"
]
}
},
{
"name": "spreadsheetId",
"type": "text",
"label": "Spreadsheet",
"required": true
},
{
"name": "sheetId",
"type": "text",
"label": "Sheet Name",
"required": true
},
{
"name": "tableFirstRow",
"type": "select",
"label": "Column range",
"required": true,
"validate": {
"enum": [
"A1:Z1",
"A1:BZ1",
"A1:CZ1",
"A1:DZ1",
"A1:MZ1",
"A1:ZZ1"
]
}
},
{
"name": "values",
"spec": [
{
"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"
}
],
"type": "collection",
"label": "Values"
}
]
}
},
{
"id": 191,
"module": "google-sheets:listSheets",
"version": 2,
"parameters": {},
"filter": {
"name": "",
"conditions": [
[
{
"a": "{{177.`__IMTINDEX__`}}",
"b": "{{176.`__IMTAGGLENGTH__`}}",
"o": "text:equal"
}
]
]
},
"mapper": {
"select": "map",
"spreadsheetId": "{{172.spreadsheetId}}"
},
"metadata": {
"designer": {
"x": 2700,
"y": 300
},
"restore": {
"expect": {
"select": {
"label": "Enter manually"
}
},
"parameters": {
"__IMTCONN__": {
"data": {
"scoped": "true",
"connection": "google"
},
"label": "My Google connection (yisobe@loyverse.com)"
}
}
},
"parameters": [
{
"name": "__IMTCONN__",
"type": "account:google",
"label": "Connection"
}
],
"expect": [
{
"name": "select",
"type": "select",
"label": "Enter a Spreadsheet ID",
"required": true,
"validate": {
"enum": [
"map",
"fromAll",
"list"
]
}
},
{
"name": "spreadsheetId",
"type": "text",
"label": "Spreadsheet ID",
"required": true
}
]
}
},
{
"id": 178,
"module": "google-sheets:filterRowsAdvanced",
"version": 2,
"parameters": {},
"filter": {
"name": "",
"conditions": [
[
{
"a": "{{191.title}}",
"b": "Sales by Date",
"o": "text:equal"
}
]
]
},
"mapper": {
"tq": "select * limit {{176.`__IMTAGGLENGTH__`}}",
"select": "map",
"sheetId": "{{191.sheetId}}",
"spreadsheetId": "{{172.spreadsheetId}}"
},
"metadata": {
"designer": {
"x": 3000,
"y": 300
},
"restore": {
"expect": {
"select": {
"label": "Enter manually"
}
},
"parameters": {
"__IMTCONN__": {
"data": {
"scoped": "true",
"connection": "google"
},
"label": "My Google connection (yisobe@loyverse.com)"
}
}
},
"parameters": [
{
"name": "__IMTCONN__",
"type": "account:google",
"label": "Connection"
}
],
"expect": [
{
"name": "select",
"type": "select",
"label": "Enter a Spreadsheet and Sheet ID",
"required": true,
"validate": {
"enum": [
"map",
"fromAll",
"list"
]
}
},
{
"name": "tq",
"type": "text",
"label": "Query",
"required": true
},
{
"name": "limit",
"type": "number",
"label": "Maximum number of returned rows"
},
{
"name": "spreadsheetId",
"type": "text",
"label": "Spreadsheet ID",
"required": true
},
{
"name": "sheetId",
"type": "text",
"label": "Sheet ID",
"required": true
}
]
}
},
{
"id": 183,
"module": "util:AggregateAggregator",
"version": 1,
"parameters": {
"feeder": 178,
"rowSeparator": "n",
"columnSeparator": "other",
"otherColumnSeparator": ", "
},
"mapper": {
"0": "{{178.`0`}}",
"1": "{{178.`1`}}",
"2": "{{178.`2`}}",
"3": "{{178.`3`}}"
},
"metadata": {
"designer": {
"x": 3300,
"y": 300
},
"restore": {
"extra": {
"feeder": {
"label": "Google Sheets - Search Rows (Advanced) [178]"
}
},
"parameters": {
"rowSeparator": {
"label": "New row"
},
"columnSeparator": {
"label": "Other"
}
}
},
"parameters": [
{
"name": "columnSeparator",
"type": "select",
"label": "Column separator",
"validate": {
"enum": [
"n",
"t",
"other"
]
}
},
{
"name": "rowSeparator",
"type": "select",
"label": "Row separator",
"validate": {
"enum": [
"n",
"t",
"other"
]
}
},
{
"name": "otherColumnSeparator",
"type": "text",
"label": "Separator"
}
],
"advanced": true
}
},
{
"id": 185,
"module": "util:GetVariable2",
"version": 1,
"parameters": {},
"mapper": {
"name": "salesByItem"
},
"metadata": {
"designer": {
"x": 3600,
"y": 300
},
"restore": {},
"expect": [
{
"name": "name",
"type": "text",
"label": "Variable name",
"required": true
}
],
"interface": [
{
"name": "salesByItem",
"type": "any",
"label": "salesByItem"
}
]
}
},
{
"id": 161,
"module": "openai-gpt-3:CreateCompletion",
"version": 1,
"parameters": {},
"filter": {
"name": "",
"conditions": [
[
{
"a": "{{formatDate(168.receipt_date; "DD")}}",
"b": "{{formatDate(addDays(addMonths(setDate(now; 1); 1); -1); "DD")}}",
"o": "text:equal"
}
]
]
},
"mapper": {
"model": "gpt-3.5-turbo",
"select": "chat",
"messages": [
{
"role": "user",
"content": "Below are sales receipts data for a month for a shop. Please analyze the data and make meaningful suggestions on how the company should do following the format of #Example. Below are sales and inventory information for a month for a company. Please analyze the data and give a meaningful insight about how the company can increase the revenue and profit, and reduce the stock on hand. "
},
{
"role": "user",
"content": "#ExamplenFormat of suggestions that I want to see. Please use ONLY the following format. Suggestions can be either positive or negative.n- Increase the price of item A by X- nThe optimal stock of item B is Y- nReduce the cost of item C by Z- nPromote item Dn- Increase/decrease discount for item E by X%n- Give/Do not give special discount for customer A by Z%n- The sales of Item F are expected to increase/decrease by X% next month because…n- The sales of the store are expected to increase/decrease by Y% next month because…n- Sunday(or other day) has the largest sales. It is the chance to promote item Gn- There was a trend of …… during last month."
},
{
"role": "user",
"content": "#Sales by DateDate, Gross sale, Discount, Net sale, Gross profitn{{183.text}}"
},
{
"role": "user",
"content": "#Item DatanItem name, variant, category, price, cost, number of items sold, profit, inventory at the end of the month;n{{185.salesByItem}}"
}
]
},
"metadata": {
"designer": {
"x": 3900,
"y": 300
},
"restore": {
"expect": {
"echo": {
"mode": "chose"
},
"model": {
"mode": "chose",
"label": "gpt-3.5-turbo"
},
"select": {
"label": "Create a Chat Completion (GPT Models)"
},
"messages": {
"mode": "chose",
"items": [
{
"role": {
"mode": "chose",
"label": "User"
}
},
{
"role": {
"mode": "chose",
"label": "User"
}
},
{
"role": {
"mode": "chose",
"label": "User"
}
},
{
"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": [
"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": "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"
}
],
"type": "array",
"label": "Messages",
"required": true
}
]
}
},
{
"id": 192,
"module": "google-email:ActionSendEmail",
"version": 2,
"parameters": {},
"mapper": {
"cc": [],
"to": [
"example@example.com"
],
"bcc": [],
"from": "",
"html": "{{161.choices[].message.content}}",
"subject": "ChatGPT suggestions from last month data",
"attachments": []
},
"metadata": {
"designer": {
"x": 4200,
"y": 300
},
"restore": {
"expect": {
"cc": {
"mode": "chose"
},
"to": {
"mode": "chose",
"items": [
null
]
},
"bcc": {
"mode": "chose"
},
"attachments": {
"mode": "chose"
}
},
"parameters": {
"account": {
"data": {
"scoped": "true",
"connection": "google-restricted"
},
"label": "My Google Restricted connection (yisobe@loyverse.com)"
}
}
},
"parameters": [
{
"name": "account",
"type": "account:google-restricted",
"label": "Connection"
}
],
"expect": [
{
"name": "from",
"type": "text",
"label": "From"
},
{
"name": "to",
"spec": {
"name": "value",
"type": "email",
"label": "Email address",
"required": true
},
"type": "array",
"label": "To",
"required": true
},
{
"name": "subject",
"type": "text",
"label": "Subject"
},
{
"name": "html",
"type": "text",
"label": "Content"
},
{
"name": "attachments",
"spec": [
{
"name": "fileName",
"type": "filename",
"label": "File name",
"required": true,
"semantic": "file:name"
},
{
"name": "data",
"type": "buffer",
"label": "Data",
"required": true,
"semantic": "file:data"
},
{
"name": "cid",
"type": "text",
"label": "Content-ID"
}
],
"type": "array",
"label": "Attachments"
},
{
"name": "cc",
"spec": {
"name": "value",
"type": "email",
"label": "Email address"
},
"type": "array",
"label": "Copy recipient"
},
{
"name": "bcc",
"spec": {
"name": "value",
"type": "email",
"label": "Email address"
},
"type": "array",
"label": "Blind copy recipient"
}
]
}
}
]
}
]
}
],
"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": [],
"notes": [
{
"id": 99,
"text": "",
"filter": false
},
{
"id": 46,
"text": "",
"filter": false
}
]
},
"zone": "eu2.make.com",
"notes": []
}
}