Piloter votre entreprise avec un reporting financier automatisé

				
					{"name":"Generate texts from prompts with Eden AI from new Google Sheet rows","flow":[{"id":4,"module":"google-sheets:watchRows","version":2,"parameters":{"from":"drive","mode":"select","limit":10,"sheetId":"Sheet1","spreadsheetId":"\/1d4tyEs4RiU1NMX7Yum4h6biOHWNEIXmmJg3vIHoF314","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":["iCal"]},"includesHeaders":{"label":"Yes"},"valueRenderOption":{"mode":"chose","label":"Formatted value"},"dateTimeRenderOption":{"mode":"chose","label":"Formatted string"}}},"parameters":[{"name":"__IMTCONN__","type":"account:google","label":"Connection"},{"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":"name (A)"},{"name":"1","type":"text","label":"content outline (B)"},{"name":"2","type":"text","label":"(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":1,"module":"edenai:textgeneration","version":1,"parameters":[],"mapper":{"text":"{{4.`0`}}","providers":["cohere","google","openai","anthropic","ai21labs"],"max_tokens":"250","response_as_dict":false},"metadata":{"designer":{"x":300,"y":0},"restore":{"expect":{"settings":{"mode":"chose"},"providers":{"mode":"chose"},"response_as_dict":{"mode":"chose"}},"parameters":{"__IMTCONN__":{"data":{"scoped":"true","connection":"edenai"},"label":"My Eden AI connection"}}},"parameters":[{"name":"__IMTCONN__","type":"account:edenai","label":"Connection"}],"expect":[{"name":"text","type":"text","label":"Text","required":true},{"name":"response_as_dict","type":"boolean","label":"Response as Dict","required":true},{"name":"temperature","type":"number","label":"Temperature"},{"name":"max_tokens","type":"integer","label":"Max tokens"},{"name":"providers","type":"select","label":"Providers","multiple":true,"required":true,"validate":{"enum":["cohere","google","openai","anthropic","ai21labs"]}},{"name":"settings","spec":[{"name":"provider","type":"select","label":"Provider","options":[{"label":"Cohere","value":"cohere"},{"label":"OpenAI","value":"openai"},{"label":"Anthropic","value":"anthropic"},{"label":"AI21Labs","value":"ai21labs"}]},{"name":"model","type":"select","label":"Model","options":[{"label":"openai: text-davinci-003","value":"text-davinci-003"},{"label":"openai: text-davinci-002","value":"text-davinci-002"},{"label":"openai: text-curie-001","value":"text-curie-001"},{"label":"openai: text-babbage-001","value":"text-babbage-001"},{"label":"openai: text-ada-001","value":"text-ada-001"},{"label":"cohere: command-xlarge-beta","value":"command-xlarge-beta"},{"label":"cohere: command-xlarge-nightly","value":"command-xlarge-nightly"},{"label":"cohere: command-xlarge","value":"command-xlarge"},{"label":"cohere: command-medium-beta","value":"command-medium-beta"},{"label":"cohere: command-medium-nightly","value":"command-medium-nightly"},{"label":"cohere: command-medium","value":"command-medium"},{"label":"ai21labs: Jurassic2-Jumbo","value":"Jurassic2-Jumbo"},{"label":"ai21labs: Jurassic2-Jumbo","value":"Jurassic2-Jumbo-Instruct"},{"label":"anthropic: claude-v2","value":"claude-v2"},{"label":"anthropic: claude-v1","value":"claude-v1"},{"label":"anthropic: claude-instant","value":"claude-instant"}]}],"type":"array","label":"Settings"}]}},{"id":3,"module":"builtin:BasicFeeder","version":1,"parameters":[],"mapper":{"array":"{{1.result}}"},"metadata":{"designer":{"x":600,"y":0},"restore":{"expect":{"array":{"mode":"edit"}}},"expect":[{"mode":"edit","name":"array","spec":[],"type":"array","label":"Array"}]}},{"id":6,"module":"util:TextAggregator","version":1,"parameters":{"feeder":3,"rowSeparator":"n"},"mapper":{"value":"Provider: {{3.provider}}nText:n{{3.generated_text}}n"},"metadata":{"designer":{"x":900,"y":0},"restore":{"extra":{"feeder":{"label":"Iterator [3]"}},"parameters":{"rowSeparator":{"label":"New row"}}},"parameters":[{"name":"rowSeparator","type":"select","label":"Row separator","validate":{"enum":["n","t","other"]}}],"expect":[{"name":"value","type":"text","label":"Text"}],"advanced":true}},{"id":5,"module":"google-sheets:updateRow","version":2,"parameters":[],"mapper":{"from":"drive","mode":"select","values":[],"sheetId":"Sheet1","rowNumber":"{{4.`__ROW_NUMBER__`}}","spreadsheetId":"\/1d4tyEs4RiU1NMX7Yum4h6biOHWNEIXmmJg3vIHoF314","includesHeaders":true,"valueInputOption":"USER_ENTERED"},"metadata":{"designer":{"x":1200,"y":0},"restore":{"expect":{"from":{"label":"My Drive"},"mode":{"label":"Select by path"},"sheetId":{"label":"Sheet1"},"spreadsheetId":{"path":["iCal"]},"includesHeaders":{"label":"Yes","nested":[{"name":"values","spec":[{"name":"0","type":"text","label":"name (A)"},{"name":"1","type":"text","label":"content outline (B)"},{"name":"2","type":"text","label":"(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)"}],"type":"collection","label":"Values"}]},"valueInputOption":{"mode":"chose","label":"User entered"}},"parameters":{"__IMTCONN__":{"data":{"scoped":"true","connection":"google"},"label":"My Google connection (l.govender@make.com)"}}},"parameters":[{"name":"__IMTCONN__","type":"account:google","label":"Connection"}],"expect":[{"name":"mode","type":"select","label":"Choose a 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":"Choose a 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":"name (A)"},{"name":"1","type":"text","label":"content outline (B)"},{"name":"2","type":"text","label":"(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)"}],"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":[]}}