Mettre en place un agenda partagé automatisé pour toute l’équipe

				
					{"name":"Create and send Discord messages for new articles using ChatGPT and Google Sheets","flow":[{"id":1,"module":"rss:TriggerNewArticle","version":4,"mapper":[],"metadata":{"designer":{"x":0,"y":0}}},{"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":300,"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-sheets:addRow","version":2,"parameters":[],"mapper":{"from":"drive","mode":"select","values":["{{2.result}}"],"sheetId":"Sheet1","spreadsheetId":"\/1OBN2px7hcLH4AEaw2p08dU5g3Ti_prtpzSLfLgpa3XQ","includesHeaders":true,"insertDataOption":"INSERT_ROWS","valueInputOption":"USER_ENTERED","insertUnformatted":false},"metadata":{"designer":{"x":600,"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"}]},"insertDataOption":{"mode":"chose","label":"Insert rows"},"valueInputOption":{"mode":"chose","label":"User entered"},"insertUnformatted":{"mode":"chose"}},"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":"insertUnformatted","type":"boolean","label":"Unformatted","required":true},{"name":"valueInputOption","type":"select","label":"Value input option","validate":{"enum":["USER_ENTERED","RAW"]}},{"name":"insertDataOption","type":"select","label":"Insert data option","validate":{"enum":["INSERT_ROWS","OVERWRITE"]}},{"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":"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"}]}},{"id":4,"module":"discord:createMessage","version":2,"parameters":[],"mapper":{"select":"channel","channelId":"1214129685865304127","message_reference":[]},"metadata":{"designer":{"x":900,"y":0},"restore":{"expect":{"tts":{"mode":"chose"},"files":{"mode":"chose"},"embeds":{"mode":"chose"},"select":{"label":"Send a Message to a Channel"},"channelId":{"mode":"chose","label":"sdfsdfsdfsdf"},"components":{"mode":"chose"},"sticker_ids":{"mode":"chose"}},"parameters":{"__IMTCONN__":{"data":{"scoped":"true","connection":"discord"},"label":"My Discord connection (Make (team1278341651986911253))"}}},"parameters":[{"name":"__IMTCONN__","type":"account:discord","label":"Connection","required":true}],"expect":[{"name":"select","type":"select","label":"Choose a Method","required":true,"validate":{"enum":["channel","thread","user"]}},{"name":"content","type":"text","label":"Message"},{"name":"tts","type":"boolean","label":"Is TTS message"},{"name":"embeds","spec":[{"name":"title","type":"text","label":"Title"},{"name":"type","type":"text","label":"Type"},{"name":"description","type":"text","label":"Description"},{"name":"url","type":"url","label":"URL"},{"name":"timestamp","type":"date","label":"Timestamp"},{"name":"color","type":"uinteger","label":"Color"},{"name":"footer","spec":[{"name":"text","type":"text","label":"Text"},{"name":"icon_url","type":"url","label":"Icon URL"},{"name":"proxy_icon_url","type":"url","label":"Proxy Icon URL"}],"type":"collection","label":"Footer"},{"name":"image","spec":[{"name":"url","type":"url","label":"URL"},{"name":"proxy_url","type":"url","label":"Proxy URL"},{"name":"height","type":"uinteger","label":"Height"},{"name":"width","type":"uinteger","label":"Width"}],"type":"collection","label":"Image"},{"name":"thumbnail","spec":[{"name":"url","type":"url","label":"URL"},{"name":"proxy_url","type":"url","label":"Proxy URL"},{"name":"height","type":"uinteger","label":"Height"},{"name":"width","type":"uinteger","label":"Width"}],"type":"collection","label":"Thumbnail"},{"name":"video","spec":[{"name":"url","type":"url","label":"URL"},{"name":"height","type":"uinteger","label":"Height"},{"name":"width","type":"uinteger","label":"Width"}],"type":"collection","label":"Video"},{"name":"provider","spec":[{"name":"name","type":"text","label":"Name"},{"name":"url","type":"url","label":"URL"}],"type":"collection","label":"Provider"},{"name":"author","spec":[{"name":"name","type":"text","label":"Name"},{"name":"url","type":"url","label":"URL"},{"name":"icon_url","type":"url","label":"Icon URL"},{"name":"proxy_icon_url","type":"url","label":"Proxy Icon URL"}],"type":"collection","label":"Author"},{"name":"fields","spec":[{"name":"name","type":"text","label":"Name"},{"name":"value","type":"text","label":"Value"},{"name":"inline","type":"boolean","label":"Inline Flag"}],"type":"array","label":"Fields"}],"type":"array","label":"Embeds"},{"name":"sticker_ids","spec":[{"name":"id","type":"text","label":"Sticker ID","required":true}],"type":"array","label":"Stickers"},{"name":"components","spec":[{"name":"type","type":"select","label":"Component Type","options":[{"label":"A New Row","value":1,"nested":[{"name":"components","spec":[{"name":"type","type":"select","label":"Row Component Type","options":[{"label":"Button","value":2,"nested":[{"name":"style","type":"select","label":"Style","options":[{"label":"Primary (blurple)","value":1,"nested":[{"help":"A developer-defined identifier for the button, max 100 characters.","name":"custom_id","type":"text","label":"Custom ID","required":true}]},{"label":"Secondary (grey)","value":2,"nested":[{"help":"A developer-defined identifier for the button, max 100 characters.","name":"custom_id","type":"text","label":"Custom ID","required":true}]},{"label":"Success (green)","value":3,"nested":[{"help":"A developer-defined identifier for the button, max 100 characters.","name":"custom_id","type":"text","label":"Custom ID","required":true}]},{"label":"Danger (red)","value":4,"nested":[{"help":"A developer-defined identifier for the button, max 100 characters.","name":"custom_id","type":"text","label":"Custom ID","required":true}]},{"label":"Link (grey)","value":5,"nested":[{"help":"A URL for link-style buttons.","name":"url","type":"url","label":"URL","required":true}]}],"required":true},{"help":"Text that appears on the button, max 80 characters.","name":"label","type":"text","label":"Label"},{"name":"disabled","type":"boolean","label":"Disabled"}]},{"label":"Select Menu","value":3,"nested":[{"help":"A developer-defined identifier for the button, max 100 characters.","name":"custom_id","type":"text","label":"Custom ID","required":true},{"name":"options","spec":[{"help":"The user-facing name of the option, max 100 characters.","name":"label","type":"text","label":"Label","required":true},{"help":"The dev-defined value of the option, max 100 characters.","name":"value","type":"text","label":"Value","required":true},{"help":"An additional description of the option, max 100 characters.","name":"description","type":"text","label":"Description"},{"name":"default","type":"boolean","label":"Default"}],"type":"array","label":"Options","required":true,"validate":{"maxItems":25}},{"help":"Custom placeholder text if nothing is selected, max 150 characters.","name":"placeholder","type":"text","label":"Placeholder"},{"help":"The minimum number of items that must be chosen; default 1, min 0, max 2.","name":"min_values","type":"uinteger","label":"Minimum values"},{"help":"The maximum number of items that must be chosen; default 1, max 25.","name":"max_values","type":"uinteger","label":"Maximum values"},{"name":"disabled","type":"boolean","label":"Disabled"}]}],"required":true}],"type":"array","label":"Row Components","required":true}]}],"required":true}],"type":"array","label":"Components"},{"name":"files","spec":[{"name":"filename","type":"filename","label":"File Name","required":true,"semantic":"file:name"},{"name":"data","type":"buffer","label":"Data","required":true,"semantic":"file:data"}],"type":"array","label":"Files"},{"name":"message_reference","spec":[{"name":"message_id","type":"text","label":"Message ID"}],"type":"collection","label":"Message Reference"},{"name":"channelId","type":"select","label":"Channel ID","required":true}]}}],"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":[]}}