Gérez, assignez et suivez automatiquement toutes les demandes d’assistance reçues, avec notifications d’avancement aux utilisateurs et aux équipes concernées.
Gérez, assignez et suivez automatiquement toutes les demandes d’assistance reçues, avec notifications d’avancement aux utilisateurs et aux équipes concernées.
{
"name": "AI-Powered Email Campaign using a Name-Email Database",
"flow": [
{
"id": 2,
"module": "google-sheets:filterRows",
"version": 2,
"parameters": {},
"mapper": {
"from": "drive",
"limit": "100",
"filter": [
[
{
"a": "A",
"o": "exist"
},
{
"a": "G",
"b": "FALSE",
"o": "text:equal"
}
]
],
"sheetId": "Sheet1",
"sortOrder": "asc",
"spreadsheetId": "1-KNpCgfA2T04be9Y8CZIqLMaenLF_9_IPew5cddyLu4",
"tableFirstRow": "A1:CZ1",
"includesHeaders": true,
"valueRenderOption": "FORMATTED_VALUE",
"dateTimeRenderOption": "FORMATTED_STRING"
},
"metadata": {
"designer": {
"x": -82,
"y": 11,
"name": "Find rows with Emails."
},
"restore": {
"expect": {
"from": {
"label": "Select from My Drive"
},
"orderBy": {
"mode": "chose"
},
"sheetId": {
"mode": "chose",
"label": "Sheet1"
},
"sortOrder": {
"mode": "chose",
"label": "Ascending"
},
"spreadsheetId": {
"mode": "chose",
"label": "Email Campaign Database"
},
"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 v2 (harpa.gpt@gmail.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": "Email (A)"
},
{
"name": "1",
"type": "text",
"label": "Name (B)"
},
{
"name": "2",
"type": "text",
"label": "Website (C)"
},
{
"name": "3",
"type": "text",
"label": "Company (D)"
},
{
"name": "4",
"type": "text",
"label": "Industry (E)"
},
{
"name": "5",
"type": "text",
"label": "Description (F)"
},
{
"name": "6",
"type": "text",
"label": "1st Email Sent (G)"
},
{
"name": "7",
"type": "text",
"label": "2nd Email Sent (H)"
},
{
"name": "8",
"type": "text",
"label": "Replied (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)"
},
{
"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": 3,
"module": "harpa-ai:websearchserp",
"version": 1,
"parameters": {},
"mapper": {
"url": "https://harpa.ai/blank",
"name": "Database Enrichment",
"node": "first",
"inputs": [
"{{2.`0`}}"
],
"timeout": "300000",
"resultParam": "json"
},
"metadata": {
"designer": {
"x": 218,
"y": 11,
"name": "AI Command: Database Enrichment"
},
"restore": {
"expect": {
"inputs": {
"mode": "chose",
"items": [
null
]
}
},
"parameters": {
"__IMTCONN__": {
"data": {
"scoped": "true",
"connection": "harpa-ai"
},
"label": "Alex HRP Key 2 (alxsharuk@gmail.com)"
}
}
},
"parameters": [
{
"name": "__IMTCONN__",
"type": "account:harpa-ai",
"label": "Connection",
"required": true
}
],
"expect": [
{
"name": "name",
"type": "text",
"label": "Name",
"required": true
},
{
"name": "inputs",
"spec": {
"name": "value",
"type": "text",
"label": "input"
},
"type": "array",
"label": "Inputs"
},
{
"name": "url",
"type": "url",
"label": "URL"
},
{
"name": "resultParam",
"type": "text",
"label": "Result Param"
},
{
"name": "node",
"type": "text",
"label": "Node"
},
{
"name": "timeout",
"type": "number",
"label": "Timeout"
},
{
"name": "resultsWebhook",
"type": "url",
"label": "Results Webhook"
}
]
}
},
{
"id": 4,
"module": "google-sheets:updateRow",
"version": 2,
"parameters": {},
"mapper": {
"from": "drive",
"mode": "select",
"values": {
"2": "{{3.results[].website}}",
"3": "{{3.results[].name}}",
"4": "{{3.results[].industry}}",
"5": "{{3.results[].description}}"
},
"sheetId": "Sheet1",
"rowNumber": "{{2.`__ROW_NUMBER__`}}",
"spreadsheetId": "/1-KNpCgfA2T04be9Y8CZIqLMaenLF_9_IPew5cddyLu4",
"includesHeaders": true,
"valueInputOption": "USER_ENTERED"
},
"metadata": {
"designer": {
"x": 518,
"y": 11,
"name": "Enrich Data"
},
"restore": {
"expect": {
"from": {
"label": "My Drive"
},
"mode": {
"label": "Search by path"
},
"sheetId": {
"label": "Sheet1"
},
"spreadsheetId": {
"path": [
"Email Campaign Database"
]
},
"includesHeaders": {
"label": "Yes",
"nested": [
{
"name": "values",
"spec": [
{
"name": "0",
"type": "text",
"label": "Email (A)"
},
{
"name": "1",
"type": "text",
"label": "Name (B)"
},
{
"name": "2",
"type": "text",
"label": "Website (C)"
},
{
"name": "3",
"type": "text",
"label": "Company (D)"
},
{
"name": "4",
"type": "text",
"label": "Industry (E)"
},
{
"name": "5",
"type": "text",
"label": "Description (F)"
},
{
"name": "6",
"type": "text",
"label": "1st Email Sent (G)"
},
{
"name": "7",
"type": "text",
"label": "2nd Email Sent (H)"
},
{
"name": "8",
"type": "text",
"label": "Replied (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)"
},
{
"name": "26",
"type": "text",
"label": "(AA)"
}
],
"type": "collection",
"label": "Values"
}
]
},
"valueInputOption": {
"mode": "chose",
"label": "User entered"
}
},
"parameters": {
"__IMTCONN__": {
"data": {
"scoped": "true",
"connection": "google"
},
"label": "My Google connection v2 (harpa.gpt@gmail.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": "Email (A)"
},
{
"name": "1",
"type": "text",
"label": "Name (B)"
},
{
"name": "2",
"type": "text",
"label": "Website (C)"
},
{
"name": "3",
"type": "text",
"label": "Company (D)"
},
{
"name": "4",
"type": "text",
"label": "Industry (E)"
},
{
"name": "5",
"type": "text",
"label": "Description (F)"
},
{
"name": "6",
"type": "text",
"label": "1st Email Sent (G)"
},
{
"name": "7",
"type": "text",
"label": "2nd Email Sent (H)"
},
{
"name": "8",
"type": "text",
"label": "Replied (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)"
},
{
"name": "26",
"type": "text",
"label": "(AA)"
}
],
"type": "collection",
"label": "Values"
}
]
}
},
{
"id": 5,
"module": "harpa-ai:websearchserp",
"version": 1,
"parameters": {},
"mapper": {
"url": "https://harpa.ai/blank",
"name": "Cold Outreach Email Generator",
"node": "first",
"inputs": [
"I'm Alex from HARPA AI. We believe HARPA could be an excellent AI daily driver meeting your AI needs - from analyzing PDFs and generating replies and emails to handling complex automations with Zapier or Make.com.nnHARPA AI is an AI-powered browser extension that offers web automation, content creation, email management, data extraction, and tools to summarize and analyze web pages and videos.",
"{{2.`1`}}: {{2.`0`}}nnCompany Name: {{3.results[].name}}nIndustry: {{3.results[].industry}}nLocation: {{3.results[].location}}nDescription: {{3.results[].description}}"
],
"timeout": "300000",
"resultParam": "result"
},
"metadata": {
"designer": {
"x": 869,
"y": -1,
"name": "Create Personalized Email"
},
"restore": {
"expect": {
"inputs": {
"mode": "chose",
"items": [
null,
null
]
}
},
"parameters": {
"__IMTCONN__": {
"data": {
"scoped": "true",
"connection": "harpa-ai"
},
"label": "Alex HRP Key 2 (alxsharuk@gmail.com)"
}
}
},
"parameters": [
{
"name": "__IMTCONN__",
"type": "account:harpa-ai",
"label": "Connection",
"required": true
}
],
"expect": [
{
"name": "name",
"type": "text",
"label": "Name",
"required": true
},
{
"name": "inputs",
"spec": {
"name": "value",
"type": "text",
"label": "input"
},
"type": "array",
"label": "Inputs"
},
{
"name": "url",
"type": "url",
"label": "URL"
},
{
"name": "resultParam",
"type": "text",
"label": "Result Param"
},
{
"name": "node",
"type": "text",
"label": "Node"
},
{
"name": "timeout",
"type": "number",
"label": "Timeout"
},
{
"name": "resultsWebhook",
"type": "url",
"label": "Results Webhook"
}
]
}
},
{
"id": 6,
"module": "email:ActionSendEmail",
"version": 7,
"parameters": {
"saveAfterSent": false
},
"mapper": {
"cc": [],
"to": [
"{{2.`0`}}"
],
"bcc": [],
"from": "",
"html": "{{5.results[].email}}",
"sender": "",
"headers": [],
"replyTo": "",
"subject": "{{5.results[].subject}}",
"priority": "normal",
"inReplyTo": "",
"references": [],
"attachments": [],
"contentType": "html"
},
"metadata": {
"designer": {
"x": 1219,
"y": -2
},
"restore": {
"expect": {
"cc": {
"mode": "chose"
},
"to": {
"mode": "chose",
"items": [
null
]
},
"bcc": {
"mode": "chose"
},
"priority": {
"label": "Normal"
},
"references": {
"mode": "chose"
},
"attachments": {
"mode": "chose"
},
"contentType": {
"label": "HTML"
}
},
"parameters": {
"account": {
"data": {
"scoped": "true",
"connection": "google-restricted"
},
"label": "Gmail Support Test (harpa.gpt@gmail.com)"
},
"saveAfterSent": {
"label": "No"
}
}
},
"parameters": [
{
"name": "account",
"type": "account:smtp,google-restricted,microsoft-smtp-imap",
"label": "Connection",
"required": true
},
{
"name": "saveAfterSent",
"type": "select",
"label": "Save message after sending",
"required": true,
"validate": {
"enum": [
true,
false
]
}
}
],
"expect": [
{
"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": "contentType",
"type": "select",
"label": "Content Type",
"required": true,
"validate": {
"enum": [
"html",
"text"
]
}
},
{
"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"
},
{
"name": "from",
"type": "text",
"label": "From"
},
{
"name": "sender",
"type": "text",
"label": "Sender"
},
{
"name": "replyTo",
"type": "text",
"label": "Reply-To"
},
{
"name": "inReplyTo",
"type": "text",
"label": "In-Reply-To"
},
{
"name": "references",
"spec": {
"name": "value",
"type": "text",
"label": "Reference",
"required": true
},
"type": "array",
"label": "References"
},
{
"name": "priority",
"type": "select",
"label": "Priority",
"validate": {
"enum": [
"high",
"normal",
"low"
]
}
},
{
"name": "headers",
"spec": [
{
"name": "key",
"type": "text",
"label": "Key",
"required": true
},
{
"name": "value",
"type": "text",
"label": "Value",
"required": true
}
],
"type": "array",
"label": "Headers"
},
{
"name": "html",
"type": "text",
"label": "Content"
}
]
}
},
{
"id": 7,
"module": "google-sheets:updateRow",
"version": 2,
"parameters": {},
"mapper": {
"from": "drive",
"mode": "select",
"values": {
"6": "TRUE"
},
"sheetId": "Sheet1",
"rowNumber": "{{2.`__ROW_NUMBER__`}}",
"spreadsheetId": "/1-KNpCgfA2T04be9Y8CZIqLMaenLF_9_IPew5cddyLu4",
"includesHeaders": true,
"valueInputOption": "USER_ENTERED"
},
"metadata": {
"designer": {
"x": 1540,
"y": 2
},
"restore": {
"expect": {
"from": {
"label": "My Drive"
},
"mode": {
"label": "Search by path"
},
"sheetId": {
"label": "Sheet1"
},
"spreadsheetId": {
"path": [
"Email Campaign Database"
]
},
"includesHeaders": {
"label": "Yes",
"nested": [
{
"name": "values",
"spec": [
{
"name": "0",
"type": "text",
"label": "Email (A)"
},
{
"name": "1",
"type": "text",
"label": "Name (B)"
},
{
"name": "2",
"type": "text",
"label": "Website (C)"
},
{
"name": "3",
"type": "text",
"label": "Company (D)"
},
{
"name": "4",
"type": "text",
"label": "Industry (E)"
},
{
"name": "5",
"type": "text",
"label": "Description (F)"
},
{
"name": "6",
"type": "text",
"label": "1st Email Sent (G)"
},
{
"name": "7",
"type": "text",
"label": "2nd Email Sent (H)"
},
{
"name": "8",
"type": "text",
"label": "Replied (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)"
},
{
"name": "26",
"type": "text",
"label": "(AA)"
}
],
"type": "collection",
"label": "Values"
}
]
},
"valueInputOption": {
"mode": "chose",
"label": "User entered"
}
},
"parameters": {
"__IMTCONN__": {
"data": {
"scoped": "true",
"connection": "google"
},
"label": "My Google connection v2 (harpa.gpt@gmail.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": "Email (A)"
},
{
"name": "1",
"type": "text",
"label": "Name (B)"
},
{
"name": "2",
"type": "text",
"label": "Website (C)"
},
{
"name": "3",
"type": "text",
"label": "Company (D)"
},
{
"name": "4",
"type": "text",
"label": "Industry (E)"
},
{
"name": "5",
"type": "text",
"label": "Description (F)"
},
{
"name": "6",
"type": "text",
"label": "1st Email Sent (G)"
},
{
"name": "7",
"type": "text",
"label": "2nd Email Sent (H)"
},
{
"name": "8",
"type": "text",
"label": "Replied (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)"
},
{
"name": "26",
"type": "text",
"label": "(AA)"
}
],
"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": []
}
}