Créer un tableau de bord automatisé pour le suivi financier

				
					{"name":"Personalize an introduction message with ChatGPT for new Pipedrive CRM leads and store them on a Google Sheet for review","flow":[{"id":1,"module":"pipedrive:watchLeads","version":2,"parameters":{"limit":20,"triggerOn":"add_time","archivedStatus":"not_archived"},"mapper":[],"metadata":{"designer":{"x":0,"y":0},"restore":{"parameters":{"triggerOn":{"label":"Object created"},"__IMTCONN__":{"data":{"scoped":"true","connection":"pipedrive-auth"},"label":"My Pipedrive OAuth connection (dev-Make development@integromat.com)"},"archivedStatus":{"label":"Not Archived"}}},"parameters":[{"name":"__IMTCONN__","type":"account:pipedrive-auth","label":"Connection"},{"name":"archivedStatus","type":"select","label":"Archived","validate":{"enum":["all","archived","not_archived"]}},{"name":"triggerOn","type":"select","label":"Trigger when","required":true,"validate":{"enum":["add_time","update_time"]}},{"name":"limit","type":"uinteger","label":"Limit"}]}},{"id":5,"module":"pipedrive:GetPerson","version":2,"parameters":[],"mapper":{"id":"{{1.person_id}}"},"metadata":{"designer":{"x":300,"y":0},"restore":{"parameters":{"__IMTCONN__":{"data":{"scoped":"true","connection":"pipedrive-auth"},"label":"My Pipedrive OAuth connection (dev-Make development@integromat.com)"}}},"parameters":[{"name":"__IMTCONN__","type":"account:pipedrive-auth,pipedrive-apikey","label":"Connection"}],"expect":[{"name":"id","type":"number","label":"Person ID","required":true}],"interface":[{"name":"id","type":"number","label":"Person ID"},{"name":"org_id","spec":[{"name":"name","type":"text","label":"Name"},{"name":"people_count","type":"number","label":"People count"},{"name":"owner_id","type":"number","label":"Owner ID"},{"name":"address","type":"text","label":"Address"},{"name":"cc_email","type":"email","label":"Cc email"},{"name":"value","type":"text","label":"Value"}],"type":"collection","label":"Organization"},{"name":"owner_id","spec":[{"name":"id","type":"number","label":"ID"},{"name":"name","type":"text","label":"Name"},{"name":"email","type":"text","label":"Email"},{"name":"has_pic","type":"boolean","label":"Has pic"},{"name":"pic_hash","type":"text","label":"Pic hash"},{"name":"active_flag","type":"boolean","label":"Active flag"},{"name":"value","type":"number","label":"Value"}],"type":"collection","label":"Owner"},{"name":"company_id","type":"number","label":"Company ID"},{"name":"name","type":"text","label":"Name"},{"name":"first_name","type":"text","label":"First name"},{"name":"last_name","type":"text","label":"Last name"},{"name":"open_deals_count","type":"number","label":"Open deals count"},{"name":"related_open_deals_count","type":"number","label":"Related open deals count"},{"name":"closed_deals_count","type":"number","label":"Closed deals count"},{"name":"related_closed_deals_count","type":"number","label":"Related closed deals count"},{"name":"participant_open_deals_count","type":"number","label":"Participant open deals count"},{"name":"participant_closed_deals_count","type":"number","label":"Participant closed deals count"},{"name":"email_messages_count","type":"number","label":"Email messages count"},{"name":"activities_count","type":"number","label":"Activities count"},{"name":"done_activities_count","type":"number","label":"Done activities count"},{"name":"undone_activities_count","type":"number","label":"Undone activities count"},{"name":"reference_activities_count","type":"number","label":"Reference activities count"},{"name":"files_count","type":"number","label":"Files count"},{"name":"notes_count","type":"number","label":"Notes count"},{"name":"followers_count","type":"number","label":"Followers count"},{"name":"won_deals_count","type":"number","label":"Won deals count"},{"name":"related_won_deals_count","type":"number","label":"Related won deals count"},{"name":"lost_deals_count","type":"number","label":"Lost deals count"},{"name":"related_lost_deals_count","type":"number","label":"Related lost deals count"},{"name":"active_flag","type":"boolean","label":"Active flag"},{"name":"phone","spec":{"spec":[{"name":"value","type":"text","label":"Value"},{"name":"primary","type":"boolean","label":"Primary"}],"type":"collection"},"type":"array","label":"Phone"},{"name":"email","spec":{"spec":[{"name":"value","type":"text","label":"Value"},{"name":"primary","type":"boolean","label":"Primary"}],"type":"collection"},"type":"array","label":"Email"},{"name":"first_char","type":"text","label":"First char"},{"name":"update_time","type":"text","label":"Update time"},{"name":"add_time","type":"text","label":"Add time"},{"name":"visible_to","type":"text","label":"Visible to"},{"name":"picture_id","spec":[{"name":"item_type","type":"text","label":"Item type"},{"name":"item_id","type":"number","label":"Item ID"},{"name":"active_flag","type":"boolean","label":"Active flag"},{"name":"add_time","type":"date","label":"Add time"},{"name":"update_time","type":"date","label":"Update time"},{"name":"added_by_user_id","type":"number","label":"Added by user ID"},{"name":"pictures","spec":[{"name":"128","type":"text","label":"128"},{"name":"512","type":"text","label":"512"}],"type":"collection","label":"Pictures"},{"name":"value","type":"number","label":"Value"}],"type":"collection","label":"Picture"},{"name":"next_activity_date","type":"text","label":"Next activity date"},{"name":"next_activity_time","type":"text","label":"Next activity time"},{"name":"next_activity_id","type":"text","label":"Next activity ID"},{"name":"last_activity_id","type":"text","label":"Last activity ID"},{"name":"last_activity_date","type":"text","label":"Last activity date"},{"name":"last_incoming_mail_time","type":"text","label":"Last incoming mail time"},{"name":"last_outgoing_mail_time","type":"text","label":"Last outgoing mail time"},{"name":"label","type":"text","label":"Label"},{"name":"org_name","type":"text","label":"Org name"},{"name":"cc_email","type":"text","label":"Cc email"},{"name":"owner_name","type":"text","label":"Owner name"},{"name":"delete_time","type":"text","label":"Delete Time"},{"name":"im","spec":{"spec":[{"name":"label","type":"text","label":"Label"},{"name":"value","type":"text","label":"Value"},{"name":"primary","type":"boolean","label":"Primary"}],"type":"collection"},"type":"array","label":"Instant Messenger"},{"name":"postal_address","type":"text","label":"Postal Address"},{"name":"postal_address_subpremise","type":"text","label":"Postal Address Subpremise"},{"name":"postal_address_street_number","type":"text","label":"Postal Address Street Number"},{"name":"postal_address_route","type":"text","label":"Postal Address Route"},{"name":"postal_address_sublocality","type":"text","label":"Postal Address Sublocality"},{"name":"postal_address_locality","type":"text","label":"Postal Address Locality"},{"name":"postal_address_admin_area_level_1","type":"text","label":"Postal Address Admin Area Level 1"},{"name":"postal_address_admin_area_level_2","type":"text","label":"Postal Address Admin Area Level 2"},{"name":"postal_address_country","type":"text","label":"Postal Address Country"},{"name":"postal_address_postal_code","type":"text","label":"Postal Address Postal Code"},{"name":"postal_address_formatted_address","type":"text","label":"Postal Address Formatted Address"},{"name":"notes","type":"text","label":"Notes"},{"name":"birthday","type":"date","label":"Birthday"},{"name":"job_title","type":"text","label":"Job Title"},{"name":"picture_128_url","type":"text","label":"Picture 128 URL"},{"name":"3c3ad55478d144a1812ee5aeb682b563a9b4c769","spec":[{"name":"id","type":"integer","label":"Option ID"},{"name":"label","type":"text","label":"Option Label"}],"type":"collection","label":"submitted_typeform (custom)","metadata":{"type":"enum","options":{"15":"yes","16":"no"}}},{"name":"1ec88326415a3d004d13278872eb6fe66b9cdf23","label":"airtable_link (custom)"},{"name":"f7b917d9c2270260dbce2875fd55ff8ceff786d5","spec":[{"name":"id","type":"integer","label":"Option ID"},{"name":"label","type":"text","label":"Option Label"}],"type":"collection","label":"Test (custom)","metadata":{"type":"enum","options":{"17":"value 1","18":"value 2","19":"value 3","20":"value 4","21":"value 5","22":"value 6"}}},{"name":"cf0f2852d62be1c66f9b3c02eff647ba357b5538","label":"testimt (custom)"},{"name":"2aa6f0c49012332efac0b3db93bac3ab34aac85f","label":"secondtest (custom)"},{"name":"adb9c8affcb9549cb9a46f64ff4d914dbc20faae","label":"BrunoTestCF (custom)"},{"name":"b2dd10447c4f6bb251672566dcffe22597260cb5","type":"number","label":"Elen test (custom)"},{"name":"113dcf1df9c60efe640c45253726d89a9bfcb915","spec":[{"name":"name","type":"text","label":"Name"},{"name":"email","spec":[{"name":"value","type":"email","label":"Value"},{"name":"primary","type":"boolean","label":"Primary"}],"type":"array","label":"Email"},{"name":"phone","spec":[{"name":"value","type":"text","label":"Value"},{"name":"primary","type":"boolean","label":"Primary"}],"type":"array","label":"Phone"},{"name":"value","type":"text","label":"Value"}],"type":"collection","label":"test Person (custom)"},{"name":"bfe510cd07c190c1a95bdd9c9a9701f529b50011","label":"test phone (custom)"},{"name":"aa4733ad8223eea041d94c1f6d50bd7180f78a91","type":"date","label":"test date (custom)"},{"name":"7f4f372118a60ea7efba302c289b8cc84a0882d1","label":"Job Title Custom (custom)"},{"name":"364cc56db2f765ed662ed821ee83a07e8ec3fea9","label":"Report ID (custom)"},{"name":"113e2e3156c2dcf077588e500493b1fd3d9ab0fb","label":"URI (custom)"},{"name":"90758117f6e9fadcd1c4a78f2d33a6a91b109ec6","label":"Status (custom)"},{"name":"61a86b92e71c041d6467e78c435132f88e359228","label":"Result (custom)"},{"name":"65dc885d7115cd9900c8885ae5294b1d7309f87b","label":"Package (custom)"},{"name":"a8171f95bfb5fb4d50be5b1a0ce7cfc2cd7816f6","label":"Created at (custom)"},{"name":"f9821a3bfbb1c83729c72321014875541ed872d0","label":"Candidate ID (custom)"},{"name":"4bf6b7a775fd7fe3ccda5ad2de0ac0be44ba6a96","label":"Completed at (custom)"},{"name":"9d03d6974e05a3c802122ff1b83ac78c2c3381c7","label":"First Name (custom)"},{"name":"39008c1a4f26a5fe859741cf2c8653b584b8a032","label":"Last Name (custom)"}]}},{"id":3,"module":"openai-gpt-3:CreateCompletion","version":1,"parameters":[],"mapper":{"model":"gpt-4-0613","select":"chat","messages":[{"role":"user","content":"You are the Sales manager at the company {Your company name here}.nnCompose a personlized message for the new lead '{{5.first_name}} {{5.last_name}}' inviting them to a call and also explain the ways our company will benefit him in his role and his company as a whole."}]},"metadata":{"designer":{"x":600,"y":0},"restore":{"expect":{"echo":{"mode":"chose"},"model":{"mode":"chose","label":"gpt-4-0613"},"select":{"label":"Create a Chat Completion (GPT Models)"},"messages":{"mode":"chose","items":[{"role":{"mode":"chose","label":"User"}}]},"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"}],"expect":[{"name":"select","type":"select","label":"Select Method","required":true,"validate":{"enum":["chat","prompt"]}},{"name":"max_tokens","type":"number","label":"Max Tokens"},{"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":"echo","type":"boolean","label":"Echo"},{"name":"additionalParameters","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":"array","label":"Other Input Parameters"},{"name":"model","type":"select","label":"Model","required":true},{"name":"messages","spec":[{"name":"role","type":"select","label":"Role","options":[{"label":"System","value":"system"},{"label":"User","value":"user"},{"label":"Assistant","value":"assistant"}],"required":true},{"name":"content","type":"text","label":"Message Content"}],"type":"array","label":"Messages","required":true}]}},{"id":4,"module":"google-sheets:addRow","version":2,"parameters":[],"mapper":{"from":"drive","mode":"select","values":[],"sheetId":"Sheet1","spreadsheetId":"\/1iNA6JnQ_mMldxg9U9jMajQKiRGRNj5BvO-bUszE_fJg","includesHeaders":true,"insertDataOption":"INSERT_ROWS","valueInputOption":"USER_ENTERED","insertUnformatted":false},"metadata":{"designer":{"x":900,"y":0},"restore":{"expect":{"from":{"label":"My Drive"},"mode":{"label":"Select by path"},"sheetId":{"label":"Sheet1"},"spreadsheetId":{"path":["Webinar test"]},"includesHeaders":{"label":"Yes","nested":[{"name":"values","spec":[{"name":"0","type":"text","label":"2024.184 (A)"},{"name":"1","type":"text","label":"(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"}]},"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"}],"expect":[{"name":"mode","type":"select","label":"Choose a 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":"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":"includesHeaders","type":"select","label":"Table contains headers","required":true,"validate":{"enum":[true,false]}},{"name":"values","spec":[{"name":"0","type":"text","label":"2024.184 (A)"},{"name":"1","type":"text","label":"(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":[]}}