Suivez vos flux de trésorerie, vos dépenses et vos recettes en temps réel grâce à l’automatisation. Ce guide explique comment connecter vos outils bancaires et comptables à Google Sheets ou Power BI pour piloter efficacement votre budget.
Suivez vos flux de trésorerie, vos dépenses et vos recettes en temps réel grâce à l’automatisation. Ce guide explique comment connecter vos outils bancaires et comptables à Google Sheets ou Power BI pour piloter efficacement votre budget.
{
"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": []
}
}