Les relances fournisseurs sont essentielles pour éviter les ruptures de stock. Automatisez vos relances et le suivi des réponses pour sécuriser vos achats et gagner du temps.
Les relances fournisseurs sont essentielles pour éviter les ruptures de stock. Automatisez vos relances et le suivi des réponses pour sécuriser vos achats et gagner du temps.
{
"name": "Daily WordPress blogging: automate your posts with Google Sheets + HARPA",
"flow": [
{
"id": 3,
"module": "google-sheets:filterRows",
"version": 2,
"parameters": {},
"mapper": {
"from": "drive",
"limit": "1",
"filter": [
[
{
"a": "A",
"o": "exist"
},
{
"a": "B",
"b": "FALSE",
"o": "text:equal"
}
]
],
"sheetId": "Sheet1",
"sortOrder": "asc",
"spreadsheetId": "1Y38Afa-31nRTS4pMkEN8FU3Sx56KT0wqTyCx6G3qVYw",
"tableFirstRow": "A1:Z1",
"includesHeaders": true,
"valueRenderOption": "FORMATTED_VALUE",
"dateTimeRenderOption": "FORMATTED_STRING"
},
"metadata": {
"designer": {
"x": -669,
"y": -40
},
"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": "WordPress Daily Auto-Blogging"
},
"tableFirstRow": {
"label": "A-Z"
},
"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": "Link (A)"
},
{
"name": "1",
"type": "text",
"label": "Processed (B)"
},
{
"name": "2",
"type": "text",
"label": "Date (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": 2,
"module": "harpa-ai:websearchserp",
"version": 1,
"parameters": {},
"filter": {
"name": "New Link",
"conditions": [
[
{
"a": "{{3.`0`}}",
"o": "exist"
}
]
]
},
"mapper": {
"url": "{{3.`0`}}",
"name": "WordPress Blog Writer",
"node": "nn6s",
"inputs": [
"START",
"DONE"
],
"timeout": "300000",
"resultParam": "json"
},
"metadata": {
"designer": {
"x": -271,
"y": -40
},
"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": 4,
"module": "google-sheets:updateRow",
"version": 2,
"parameters": {},
"mapper": {
"from": "drive",
"mode": "select",
"values": {
"1": "TRUE",
"2": "{{now}}"
},
"sheetId": "Sheet1",
"rowNumber": "{{3.`__ROW_NUMBER__`}}",
"spreadsheetId": "/1Y38Afa-31nRTS4pMkEN8FU3Sx56KT0wqTyCx6G3qVYw",
"includesHeaders": true,
"valueInputOption": "USER_ENTERED"
},
"metadata": {
"designer": {
"x": 90,
"y": -40
},
"restore": {
"expect": {
"from": {
"label": "My Drive"
},
"mode": {
"label": "Search by path"
},
"sheetId": {
"label": "Sheet1"
},
"spreadsheetId": {
"path": [
"WordPress Daily Auto-Blogging"
]
},
"includesHeaders": {
"label": "Yes",
"nested": [
{
"name": "values",
"spec": [
{
"name": "0",
"type": "text",
"label": "Link (A)"
},
{
"name": "1",
"type": "text",
"label": "Processed (B)"
},
{
"name": "2",
"type": "text",
"label": "Date (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)"
}
],
"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": "Link (A)"
},
{
"name": "1",
"type": "text",
"label": "Processed (B)"
},
{
"name": "2",
"type": "text",
"label": "Date (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)"
}
],
"type": "collection",
"label": "Values"
}
]
}
},
{
"id": 8,
"module": "wordpress:createPost",
"version": 3,
"parameters": {},
"mapper": {
"date": "{{now}}",
"slug": "{{2.results[].result[].slug}}",
"type": "posts",
"title": "{{2.results[].result[].title}}",
"status": "draft",
"content": "{{2.results[].result[].body}}nn{{2.results[].result[].faq}}"
},
"metadata": {
"designer": {
"x": 456,
"y": -44,
"name": "Connect WP and drag results in"
},
"restore": {
"expect": {
"meta": {
"mode": "chose"
},
"tags": {
"mode": "chose"
},
"type": {
"mode": "chose",
"label": "Posts"
},
"author": {
"mode": "chose"
},
"format": {
"mode": "chose"
},
"status": {
"mode": "chose",
"label": "Draft"
},
"sticky": {
"mode": "chose"
},
"taxonomy": {
"mode": "chose"
},
"categories": {
"mode": "chose"
},
"pingStatus": {
"mode": "chose",
"label": "Empty"
},
"commentStatus": {
"mode": "chose",
"label": "Empty"
}
},
"parameters": {
"__IMTCONN__": {
"data": {
"scoped": "true",
"connection": "wordpress4"
},
"label": "My WordPress connection (HARPA AI)"
}
}
},
"parameters": [
{
"name": "__IMTCONN__",
"type": "account:wordpress4",
"label": "Connection",
"required": true
}
],
"expect": [
{
"name": "title",
"type": "text",
"label": "Title",
"required": true
},
{
"name": "content",
"type": "text",
"label": "Content",
"required": true
},
{
"name": "type",
"type": "select",
"label": "Type",
"required": true
},
{
"name": "excerpt",
"type": "text",
"label": "Excerpt"
},
{
"name": "date",
"type": "date",
"label": "Date"
},
{
"name": "slug",
"type": "text",
"label": "Slug"
},
{
"name": "status",
"type": "select",
"label": "Status"
},
{
"name": "format",
"type": "select",
"label": "Format"
},
{
"name": "parent",
"type": "number",
"label": "Parent object ID"
},
{
"name": "categories",
"type": "select",
"label": "Categories",
"multiple": true
},
{
"name": "tags",
"type": "select",
"label": "Tags",
"multiple": true
},
{
"name": "author",
"type": "select",
"label": "Author"
},
{
"name": "featuredMedia",
"type": "number",
"label": "Featured media ID"
},
{
"name": "template",
"type": "text",
"label": "Template"
},
{
"name": "password",
"type": "text",
"label": "Password"
},
{
"name": "sticky",
"type": "boolean",
"label": "Sticky"
},
{
"name": "commentStatus",
"type": "select",
"label": "Comment status",
"validate": {
"enum": [
"open",
"closed"
]
}
},
{
"name": "pingStatus",
"type": "select",
"label": "Ping status",
"validate": {
"enum": [
"open",
"closed"
]
}
},
{
"name": "taxonomy",
"spec": [
{
"name": "name",
"type": "text",
"label": "Name",
"required": true
},
{
"name": "values",
"type": "array",
"label": "Values",
"required": true
}
],
"type": "array",
"label": "Additional fields"
},
{
"name": "meta",
"spec": [
{
"name": "name",
"type": "text",
"label": "Name",
"required": true
},
{
"name": "value",
"type": "text",
"label": "Value"
}
],
"type": "array",
"label": "Metadata (custom fields)"
}
]
}
}
],
"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": []
}
}