Gérer les relances fournisseurs en automatique

				
					{"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":[]}}