Automatiser la gestion des ressources humaines : absence, congés, notes de frais

				
					{"name":"Create a WordPress post for every new message from 2 Anthropic Claude prompts based on Google Sheets row updates","flow":[{"id":1,"module":"google-sheets:watchRows","version":2,"parameters":{"from":"drive","mode":"select","limit":2,"sheetId":"Sheet1","spreadsheetId":"\/1OBN2px7hcLH4AEaw2p08dU5g3Ti_prtpzSLfLgpa3XQ","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":["App partner templates (last template reviewed)"]},"includesHeaders":{"label":"Yes"},"valueRenderOption":{"mode":"chose","label":"Formatted value"},"dateTimeRenderOption":{"mode":"chose","label":"Formatted string"}}},"parameters":[{"name":"__IMTCONN__","type":"account:google","label":"Connection","required":true},{"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":"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)"},{"name":"24","type":"text","label":"(Y)"},{"name":"25","type":"text","label":"(Z)"}]}},{"id":2,"module":"anthropic-claude:createAMessage","version":1,"parameters":[],"mapper":{"model":"claude-3-7-sonnet-20250219","messages":[{"role":"user","content":[{"text":"{text}","type":"text"}]}],"metadata":[],"max_tokens":"1000","temperature":"1"},"metadata":{"designer":{"x":300,"y":0},"restore":{"expect":{"model":{"mode":"chose","label":"Claude 3.7 Sonnet"},"messages":{"mode":"chose","items":[{"role":{"mode":"chose","label":"User"},"content":{"mode":"chose","items":[{"type":{"mode":"chose","label":"Text"}}]}}]},"stop_sequences":{"mode":"chose"},"additionalParameters":{"mode":"chose"}},"parameters":{"__IMTCONN__":{"data":{"scoped":"true","connection":"anthropic-claude"},"label":"My Anthropic Claude connection"}}},"parameters":[{"name":"__IMTCONN__","type":"account:anthropic-claude","label":"Connection","required":true}],"expect":[{"name":"model","type":"select","label":"Model","required":true},{"name":"max_tokens","type":"uinteger","label":"Max Tokens","required":true},{"name":"messages","spec":{"name":"value","spec":[{"name":"role","type":"select","label":"Role","options":[{"label":"User","value":"user","nested":[{"name":"content","spec":{"spec":[{"help":"For models that support image content blocks (vision), see the [Anthropic model comparison table](https:\/\/docs.anthropic.com\/en\/docs\/about-claude\/models#model-comparison-table).","name":"type","type":"select","label":"Type","options":[{"label":"Text","value":"text","nested":[{"help":"Content of the message on behalf of the selected **Role** .","name":"text","type":"text","label":"Text","required":true}]},{"label":"Image","value":"image","nested":[{"name":"source","spec":[{"help":"File name, including the extension, for example, `image.jpg`.","name":"filename","type":"filename","label":"Filename","required":true,"semantic":"file:name","extension":["jpeg","jpg","png","gif","webp"]},{"help":"Binary data of the image. For example, you can retrieve the binary data of your image using the **HTTP: Get a file** module.","name":"data","type":"buffer","label":"Data","required":true,"semantic":"file:data"}],"type":"collection","label":"Source","required":true}]},{"label":"PDF document","value":"document","nested":["rpc:\/\/anthropic-claude\/1\/notePdfDocument",{"name":"pdfFileName","type":"filename","label":"Filename","required":true,"semantic":"file:name","extension":["pdf"]},{"name":"pdfFileData","type":"buffer","label":"Data","required":true,"semantic":"file:data"}]},{"label":"Tool result","value":"tool_result","nested":[{"name":"tool_use_id","type":"text","label":"Tool Use ID","required":true},{"name":"content","type":"text","label":"Content","required":true}]}],"required":true}],"type":"collection","label":"Content"},"type":"array","label":"Content","labels":{"add":"Add content"},"required":true}]},{"label":"Assistant","value":"assistant","nested":[{"help":"If the request ends with an assistant turn, then the response content will continue directly from that last turn.","name":"content","type":"text","label":"Content","required":true}]},{"label":"Tool Assistant","value":"tool_assistant","nested":[{"name":"content","spec":{"spec":[{"help":"You can send image content blocks starting with Claude 3 models.","name":"type","type":"select","label":"Type","options":[{"label":"Text","value":"text","nested":[{"help":"Content of the message on behalf of the selected **Role** .","name":"text","type":"text","label":"Text","required":true}]},{"label":"Tool Use","value":"tool_use","nested":[{"name":"id","type":"text","label":"Tool Use ID","required":true},{"name":"name","type":"text","label":"Tool Name","required":true},{"name":"input","type":"any","label":"Input","required":true}]}],"required":true}],"type":"collection","label":"Content"},"type":"array","label":"Content","labels":{"add":"Add content"},"required":true}]}],"required":true}],"type":"collection","label":"Message"},"type":"array","label":"Messages","required":true},{"name":"system","type":"text","label":"System Prompt"},{"name":"metadata","spec":[{"name":"user_id","type":"text","label":"User ID"}],"type":"collection","label":"Metadata"},{"name":"stop_sequences","spec":{"name":"value","type":"text","label":"Stop Sequence"},"type":"array","label":"Stop Sequences"},{"name":"temperature","type":"number","label":"Temperature","validate":{"max":1,"min":0}},{"name":"top_p","type":"number","label":"Top P","validate":{"max":1}},{"name":"top_k","type":"uinteger","label":"Top K"},{"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":"Tools","value":"tools","nested":[{"name":"value","spec":{"type":"text","label":"Parameter Value"},"type":"array","label":"Parameter Values","labels":{"add":"Add 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"}]}},{"id":3,"module":"anthropic-claude:createAMessage","version":1,"parameters":[],"mapper":{"model":"claude-3-7-sonnet-20250219","messages":[{"role":"user","content":[{"text":"{{2.textResponse}}","type":"text"}]}],"metadata":[],"max_tokens":"1000","temperature":"1"},"metadata":{"designer":{"x":600,"y":0},"restore":{"expect":{"model":{"mode":"chose","label":"Claude 3.7 Sonnet"},"messages":{"mode":"chose","items":[{"role":{"mode":"chose","label":"User"},"content":{"mode":"chose","items":[{"type":{"mode":"chose","label":"Text"}}]}}]},"stop_sequences":{"mode":"chose"},"additionalParameters":{"mode":"chose"}},"parameters":{"__IMTCONN__":{"data":{"scoped":"true","connection":"anthropic-claude"},"label":"My Anthropic Claude connection"}}},"parameters":[{"name":"__IMTCONN__","type":"account:anthropic-claude","label":"Connection","required":true}],"expect":[{"name":"model","type":"select","label":"Model","required":true},{"name":"max_tokens","type":"uinteger","label":"Max Tokens","required":true},{"name":"messages","spec":{"name":"value","spec":[{"name":"role","type":"select","label":"Role","options":[{"label":"User","value":"user","nested":[{"name":"content","spec":{"spec":[{"help":"For models that support image content blocks (vision), see the [Anthropic model comparison table](https:\/\/docs.anthropic.com\/en\/docs\/about-claude\/models#model-comparison-table).","name":"type","type":"select","label":"Type","options":[{"label":"Text","value":"text","nested":[{"help":"Content of the message on behalf of the selected **Role** .","name":"text","type":"text","label":"Text","required":true}]},{"label":"Image","value":"image","nested":[{"name":"source","spec":[{"help":"File name, including the extension, for example, `image.jpg`.","name":"filename","type":"filename","label":"Filename","required":true,"semantic":"file:name","extension":["jpeg","jpg","png","gif","webp"]},{"help":"Binary data of the image. For example, you can retrieve the binary data of your image using the **HTTP: Get a file** module.","name":"data","type":"buffer","label":"Data","required":true,"semantic":"file:data"}],"type":"collection","label":"Source","required":true}]},{"label":"PDF document","value":"document","nested":["rpc:\/\/anthropic-claude\/1\/notePdfDocument",{"name":"pdfFileName","type":"filename","label":"Filename","required":true,"semantic":"file:name","extension":["pdf"]},{"name":"pdfFileData","type":"buffer","label":"Data","required":true,"semantic":"file:data"}]},{"label":"Tool result","value":"tool_result","nested":[{"name":"tool_use_id","type":"text","label":"Tool Use ID","required":true},{"name":"content","type":"text","label":"Content","required":true}]}],"required":true}],"type":"collection","label":"Content"},"type":"array","label":"Content","labels":{"add":"Add content"},"required":true}]},{"label":"Assistant","value":"assistant","nested":[{"help":"If the request ends with an assistant turn, then the response content will continue directly from that last turn.","name":"content","type":"text","label":"Content","required":true}]},{"label":"Tool Assistant","value":"tool_assistant","nested":[{"name":"content","spec":{"spec":[{"help":"You can send image content blocks starting with Claude 3 models.","name":"type","type":"select","label":"Type","options":[{"label":"Text","value":"text","nested":[{"help":"Content of the message on behalf of the selected **Role** .","name":"text","type":"text","label":"Text","required":true}]},{"label":"Tool Use","value":"tool_use","nested":[{"name":"id","type":"text","label":"Tool Use ID","required":true},{"name":"name","type":"text","label":"Tool Name","required":true},{"name":"input","type":"any","label":"Input","required":true}]}],"required":true}],"type":"collection","label":"Content"},"type":"array","label":"Content","labels":{"add":"Add content"},"required":true}]}],"required":true}],"type":"collection","label":"Message"},"type":"array","label":"Messages","required":true},{"name":"system","type":"text","label":"System Prompt"},{"name":"metadata","spec":[{"name":"user_id","type":"text","label":"User ID"}],"type":"collection","label":"Metadata"},{"name":"stop_sequences","spec":{"name":"value","type":"text","label":"Stop Sequence"},"type":"array","label":"Stop Sequences"},{"name":"temperature","type":"number","label":"Temperature","validate":{"max":1,"min":0}},{"name":"top_p","type":"number","label":"Top P","validate":{"max":1}},{"name":"top_k","type":"uinteger","label":"Top K"},{"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":"Tools","value":"tools","nested":[{"name":"value","spec":{"type":"text","label":"Parameter Value"},"type":"array","label":"Parameter Values","labels":{"add":"Add 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"}]}},{"id":4,"module":"wordpress:createPost","version":3,"parameters":[],"mapper":{"type":"posts","title":"{{3.textResponse}}","content":"{{2.textResponse}}"},"metadata":{"designer":{"x":900,"y":0},"restore":{"expect":{"meta":{"mode":"chose"},"tags":{"mode":"chose"},"type":{"mode":"chose","label":"Posts"},"author":{"mode":"chose"},"format":{"mode":"chose"},"status":{"mode":"chose"},"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 (thanos)"}}},"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":[]}}