Centralisez toutes les certifications, programmez des alertes avant expiration et gérez le renouvellement automatique pour garantir la conformité de vos équipes.
Centralisez toutes les certifications, programmez des alertes avant expiration et gérez le renouvellement automatique pour garantir la conformité de vos équipes.
{
"name": "Send personalized emails based on filtered Google Sheets rows using ChatGPT and update the sheet",
"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": 300,
"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": "openai-gpt-3:CreateCompletion",
"version": 1,
"parameters": {},
"mapper": {
"model": "o3-mini",
"top_p": "1",
"select": "chat",
"messages": [
{
"role": "user"
}
],
"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": "o3-mini (system)"
},
"select": {
"label": "Create a Chat Completion (GPT and o1 models)"
},
"messages": {
"mode": "chose",
"items": [
{
"role": {
"mode": "chose",
"label": "User"
}
}
]
},
"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"
}
]
},
{
"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": 3,
"module": "google-email:ActionSendEmail",
"version": 2,
"parameters": {},
"mapper": {
"cc": [],
"to": [
"someone@email.com"
],
"bcc": [],
"from": "",
"html": "{{2.result}}",
"subject": "",
"attachments": []
},
"metadata": {
"designer": {
"x": 900,
"y": 0
},
"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 (l.govender@make.com)"
}
}
},
"parameters": [
{
"name": "account",
"type": "account:google-restricted",
"label": "Connection",
"required": true
}
],
"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"
}
]
}
},
{
"id": 4,
"module": "google-sheets:updateRow",
"version": 2,
"parameters": {},
"mapper": {
"from": "drive",
"mode": "select",
"values": {},
"sheetId": "Sheet1",
"rowNumber": "{{1.`__ROW_NUMBER__`}}",
"spreadsheetId": "/1OBN2px7hcLH4AEaw2p08dU5g3Ti_prtpzSLfLgpa3XQ",
"includesHeaders": true,
"valueInputOption": "USER_ENTERED"
},
"metadata": {
"designer": {
"x": 1200,
"y": 0
},
"restore": {
"expect": {
"from": {
"label": "My Drive"
},
"mode": {
"label": "Search by path"
},
"sheetId": {
"label": "Sheet1"
},
"spreadsheetId": {
"path": [
"App partner templates (last template reviewed)"
]
},
"includesHeaders": {
"label": "Yes",
"nested": [
{
"name": "values",
"spec": [
{
"name": "0",
"type": "text",
"label": "Date (A)"
},
{
"name": "1",
"type": "text",
"label": "Zone EU1 (B)"
},
{
"name": "2",
"type": "text",
"label": "Zone US1 (C)"
},
{
"name": "3",
"type": "text",
"label": "Zone Celonis ent EU1 (D)"
},
{
"name": "4",
"type": "text",
"label": "Zone Celonis ent US1 (E)"
},
{
"name": "5",
"type": "text",
"label": "Zone makerunsmake (F)"
},
{
"name": "6",
"type": "text",
"label": "Zone EU2 (G)"
},
{
"name": "7",
"type": "text",
"label": "Zone US2 (H)"
},
{
"name": "8",
"type": "text",
"label": "Monday board (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)"
}
],
"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",
"required": true
}
],
"expect": [
{
"name": "mode",
"type": "select",
"label": "Search 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": "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": "Date (A)"
},
{
"name": "1",
"type": "text",
"label": "Zone EU1 (B)"
},
{
"name": "2",
"type": "text",
"label": "Zone US1 (C)"
},
{
"name": "3",
"type": "text",
"label": "Zone Celonis ent EU1 (D)"
},
{
"name": "4",
"type": "text",
"label": "Zone Celonis ent US1 (E)"
},
{
"name": "5",
"type": "text",
"label": "Zone makerunsmake (F)"
},
{
"name": "6",
"type": "text",
"label": "Zone EU2 (G)"
},
{
"name": "7",
"type": "text",
"label": "Zone US2 (H)"
},
{
"name": "8",
"type": "text",
"label": "Monday board (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)"
}
],
"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": []
}
}