Mettez en place un reporting automatisé qui agrège vos données financières (ventes, charges, marges) et génère des rapports dynamiques pour une meilleure prise de décision. Guide pratique pour PME, start-up et indépendants.
Mettez en place un reporting automatisé qui agrège vos données financières (ventes, charges, marges) et génère des rapports dynamiques pour une meilleure prise de décision. Guide pratique pour PME, start-up et indépendants.
{
"name": "Generate texts from prompts with Eden AI from new Google Sheet rows",
"flow": [
{
"id": 4,
"module": "google-sheets:watchRows",
"version": 2,
"parameters": {
"from": "drive",
"mode": "select",
"limit": 10,
"sheetId": "Sheet1",
"spreadsheetId": "/1d4tyEs4RiU1NMX7Yum4h6biOHWNEIXmmJg3vIHoF314",
"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": "Sheet1"
},
"__IMTCONN__": {
"data": {
"scoped": "true",
"connection": "google"
},
"label": "My Google connection (l.govender@make.com)"
},
"spreadsheetId": {
"path": [
"iCal"
]
},
"includesHeaders": {
"label": "Yes"
},
"valueRenderOption": {
"mode": "chose",
"label": "Formatted value"
},
"dateTimeRenderOption": {
"mode": "chose",
"label": "Formatted string"
}
}
},
"parameters": [
{
"name": "__IMTCONN__",
"type": "account:google",
"label": "Connection"
},
{
"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": "name (A)"
},
{
"name": "1",
"type": "text",
"label": "content outline (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": 1,
"module": "edenai:textgeneration",
"version": 1,
"parameters": {},
"mapper": {
"text": "{{4.`0`}}",
"providers": [
"cohere",
"google",
"openai",
"anthropic",
"ai21labs"
],
"max_tokens": "250",
"response_as_dict": false
},
"metadata": {
"designer": {
"x": 300,
"y": 0
},
"restore": {
"expect": {
"settings": {
"mode": "chose"
},
"providers": {
"mode": "chose"
},
"response_as_dict": {
"mode": "chose"
}
},
"parameters": {
"__IMTCONN__": {
"data": {
"scoped": "true",
"connection": "edenai"
},
"label": "My Eden AI connection"
}
}
},
"parameters": [
{
"name": "__IMTCONN__",
"type": "account:edenai",
"label": "Connection"
}
],
"expect": [
{
"name": "text",
"type": "text",
"label": "Text",
"required": true
},
{
"name": "response_as_dict",
"type": "boolean",
"label": "Response as Dict",
"required": true
},
{
"name": "temperature",
"type": "number",
"label": "Temperature"
},
{
"name": "max_tokens",
"type": "integer",
"label": "Max tokens"
},
{
"name": "providers",
"type": "select",
"label": "Providers",
"multiple": true,
"required": true,
"validate": {
"enum": [
"cohere",
"google",
"openai",
"anthropic",
"ai21labs"
]
}
},
{
"name": "settings",
"spec": [
{
"name": "provider",
"type": "select",
"label": "Provider",
"options": [
{
"label": "Cohere",
"value": "cohere"
},
{
"label": "OpenAI",
"value": "openai"
},
{
"label": "Anthropic",
"value": "anthropic"
},
{
"label": "AI21Labs",
"value": "ai21labs"
}
]
},
{
"name": "model",
"type": "select",
"label": "Model",
"options": [
{
"label": "openai: text-davinci-003",
"value": "text-davinci-003"
},
{
"label": "openai: text-davinci-002",
"value": "text-davinci-002"
},
{
"label": "openai: text-curie-001",
"value": "text-curie-001"
},
{
"label": "openai: text-babbage-001",
"value": "text-babbage-001"
},
{
"label": "openai: text-ada-001",
"value": "text-ada-001"
},
{
"label": "cohere: command-xlarge-beta",
"value": "command-xlarge-beta"
},
{
"label": "cohere: command-xlarge-nightly",
"value": "command-xlarge-nightly"
},
{
"label": "cohere: command-xlarge",
"value": "command-xlarge"
},
{
"label": "cohere: command-medium-beta",
"value": "command-medium-beta"
},
{
"label": "cohere: command-medium-nightly",
"value": "command-medium-nightly"
},
{
"label": "cohere: command-medium",
"value": "command-medium"
},
{
"label": "ai21labs: Jurassic2-Jumbo",
"value": "Jurassic2-Jumbo"
},
{
"label": "ai21labs: Jurassic2-Jumbo",
"value": "Jurassic2-Jumbo-Instruct"
},
{
"label": "anthropic: claude-v2",
"value": "claude-v2"
},
{
"label": "anthropic: claude-v1",
"value": "claude-v1"
},
{
"label": "anthropic: claude-instant",
"value": "claude-instant"
}
]
}
],
"type": "array",
"label": "Settings"
}
]
}
},
{
"id": 3,
"module": "builtin:BasicFeeder",
"version": 1,
"parameters": {},
"mapper": {
"array": "{{1.result}}"
},
"metadata": {
"designer": {
"x": 600,
"y": 0
},
"restore": {
"expect": {
"array": {
"mode": "edit"
}
}
},
"expect": [
{
"mode": "edit",
"name": "array",
"spec": [],
"type": "array",
"label": "Array"
}
]
}
},
{
"id": 6,
"module": "util:TextAggregator",
"version": 1,
"parameters": {
"feeder": 3,
"rowSeparator": "n"
},
"mapper": {
"value": "Provider: {{3.provider}}nText:n{{3.generated_text}}n"
},
"metadata": {
"designer": {
"x": 900,
"y": 0
},
"restore": {
"extra": {
"feeder": {
"label": "Iterator [3]"
}
},
"parameters": {
"rowSeparator": {
"label": "New row"
}
}
},
"parameters": [
{
"name": "rowSeparator",
"type": "select",
"label": "Row separator",
"validate": {
"enum": [
"n",
"t",
"other"
]
}
}
],
"expect": [
{
"name": "value",
"type": "text",
"label": "Text"
}
],
"advanced": true
}
},
{
"id": 5,
"module": "google-sheets:updateRow",
"version": 2,
"parameters": {},
"mapper": {
"from": "drive",
"mode": "select",
"values": {},
"sheetId": "Sheet1",
"rowNumber": "{{4.`__ROW_NUMBER__`}}",
"spreadsheetId": "/1d4tyEs4RiU1NMX7Yum4h6biOHWNEIXmmJg3vIHoF314",
"includesHeaders": true,
"valueInputOption": "USER_ENTERED"
},
"metadata": {
"designer": {
"x": 1200,
"y": 0
},
"restore": {
"expect": {
"from": {
"label": "My Drive"
},
"mode": {
"label": "Select by path"
},
"sheetId": {
"label": "Sheet1"
},
"spreadsheetId": {
"path": [
"iCal"
]
},
"includesHeaders": {
"label": "Yes",
"nested": [
{
"name": "values",
"spec": [
{
"name": "0",
"type": "text",
"label": "name (A)"
},
{
"name": "1",
"type": "text",
"label": "content outline (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"
}
]
},
"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"
}
],
"expect": [
{
"name": "mode",
"type": "select",
"label": "Choose a 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": "Choose a 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": "name (A)"
},
{
"name": "1",
"type": "text",
"label": "content outline (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"
}
]
}
}
],
"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": []
}
}