Issue Exporting JSON information to Clickup

How To
, ,
1

Hi All,

I have never had success with this program, and today, just as I thought I was getting somewhere, no… No data exporting for you! :rofl:

gpt
gpt573×1203 102 KB

Clickup
Clickup570×1253 89.1 KB

I am trying to get Chat GPT to filter my emails and populate a task in Clickup.

Everything is working right up to the point of creating the new task, but it will not populate the data.

I am not sure if it is a formatting error with the JSON output or a user error?

I am keen to get some help with this as this will save me so much time in the business for communicating with my team.

Cheers

Brendan.

2

This is the ChatGPT output Bundle:

[
{
“result”: {
“client_name”: “John Anderson”,
“job_type”: “Built-in wardrobe installation”,
“location”: “22 Elm St, Springfield”,
“dimensions”: “3.5m wide x 2.4m high”,
“urgency”: “Urgent”,
“lead_source”: “Email”,
“due_estimate”: “June 10, 2024”,
“status”: “New Lead”,
“checklist_type”: [
“Quote”,
“Draw”
],
“email_thread”: “John is looking to have a built-in wardrobe installed at his Springfield address. The wardrobe space is 3.5m wide by 2.4m high. He requested a quote and sketches as soon as possible, needing it done by June 10. Marked urgent.”,
“attachments”: [
{
“file_name”: “wardrobe_sketch.jpg”,
“file_url”: “https://example.com/attachments/wardrobe_sketch.jpg”
}
]
},
“id”: “chatcmpl-BiamAi5aWkplebbptZ8ZMmZdQqQND”,
“object”: “chat.completion”,
“created”: “2025-06-15T06:04:58.000Z”,
“model”: “chatgpt-4o-latest”,
“choices”: [
{
“index”: 0,
“message”: {
“role”: “assistant”,
“content”: “{\n "client_name": "John Anderson",\n "job_type": "Built-in wardrobe installation",\n "location": "22 Elm St, Springfield",\n "dimensions": "3.5m wide x 2.4m high",\n "urgency": "Urgent",\n "lead_source": "Email",\n "due_estimate": "June 10, 2024",\n "status": "New Lead",\n "checklist_type": ["Quote", "Draw"],\n "email_thread": "John is looking to have a built-in wardrobe installed at his Springfield address. The wardrobe space is 3.5m wide by 2.4m high. He requested a quote and sketches as soon as possible, needing it done by June 10. Marked urgent.",\n "attachments": [\n {\n "file_name": "wardrobe_sketch.jpg",\n "file_url": "https://example.com/attachments/wardrobe_sketch.jpg\”\n }\n ]\n}",
“refusal”: null,
“annotations”:
},
“logprobs”: null,
“finish_reason”: “stop”
}
],
“usage”: {
“prompt_tokens”: 363,
“completion_tokens”: 223,
“total_tokens”: 586,
“prompt_tokens_details”: {
“cached_tokens”: 0,
“audio_tokens”: 0
},
“completion_tokens_details”: {
“reasoning_tokens”: 0,
“audio_tokens”: 0,
“accepted_prediction_tokens”: 0,
“rejected_prediction_tokens”: 16
}
},
“service_tier”: “default”,
“system_fingerprint”: “fp_afccf7958a”
}
]

3

The Clickup Input:

[
{
“name”: “To Be Actioned”,
“list_id”: “901609212879”,
“team_id”: “9016982141”,
“space_id”: “90164291534”,
“folder_id”: “folderlessList”,
“notify_all”: false,
“custom_fields”: {
“5117a78b-8ea6-4bd6-be49-303675b3108a”: {
“location”: {}
}
},
“due_date_time”: false,
“start_date_time”: false
}
]

And the Output:

[
{
“id”: “86cz9pmy5”,
“custom_id”: null,
“custom_item_id”: 0,
“name”: “To Be Actioned”,
“text_content”: “”,
“description”: “”,
“status”: {
“id”: “sc901609212879_K8fROChL”,
“status”: “to do”,
“color”: “#87909e”,
“orderindex”: 0,
“type”: “open”
},
“orderindex”: “39908199.00000000000000000000000000000000”,
“date_created”: “2025-06-15T06:11:40.762Z”,
“date_updated”: “2025-06-15T06:11:40.762Z”,
“date_closed”: null,
“date_done”: null,
“archived”: false,
“creator”: {
“id”: 54660508,
“username”: “Brendan Quigly”,
“color”: “”,
“email”: “sales@cabinethq.com.au”,
“profilePicture”: null
},
“assignees”: ,
“group_assignees”: ,
“watchers”: [
{
“id”: 54660508,
“username”: “Brendan Quigly”,
“color”: “”,
“initials”: “BQ”,
“email”: “sales@cabinethq.com.au”,
“profilePicture”: null
}
],
“checklists”: ,
“tags”: ,
“parent”: null,
“top_level_parent”: null,
“priority”: null,
“due_date”: null,
“start_date”: null,
“points”: null,
“time_estimate”: 0,
“time_spent”: 0,
“custom_fields”: {},
“dependencies”: ,
“linked_tasks”: ,
“locations”: ,
“team_id”: “9016982141”,
“url”: “ClickUp”,
“sharing”: {
“public”: false,
“public_share_expires_on”: null,
“public_fields”: [
“assignees”,
“priority”,
“due_date”,
“content”,
“comments”,
“attachments”,
“customFields”,
“subtasks”,
“tags”,
“checklists”,
“coverimage”
],
“token”: null,
“seo_optimized”: false
},
“permission_level”: “create”,
“list”: {
“id”: “901609212879”,
“name”: “Inbox List”,
“access”: true
},
“project”: {
“id”: “90165511729”,
“name”: “hidden”,
“hidden”: true,
“access”: true
},
“folder”: {
“id”: “90165511729”,
“name”: “hidden”,
“hidden”: true,
“access”: true
},
“space”: {
“id”: “90164291534”
},
“custom_fields_original”: [
{
“id”: “29585a17-d4fc-46bd-821b-cab0d8db38f4”,
“name”: “Checklist Type”,
“type”: “drop_down”,
“type_config”: {
“sorting”: “manual”,
“options”: [
{
“id”: “dae94a65-e358-4a6c-a33d-6629311d37ec”,
“name”: “Quote”,
“color”: “#FF4081”,
“orderindex”: 0
},
{
“id”: “07f0de92-fe2f-4e2e-87f4-f4c264362e1c”,
“name”: “Draw”,
“color”: “#7C4DFF”,
“orderindex”: 1
},
{
“id”: “f68141c5-30dd-4bb5-af5a-c86f607e7cc9”,
“name”: “Send”,
“color”: “#EA80FC”,
“orderindex”: 2
}
]
},
“date_created”: “2025-06-15T02:02:36.322Z”,
“hide_from_guests”: false,
“required”: false
},
{
“id”: “311deb8c-65f3-4332-ac98-aba13d2d8659”,
“name”: “Client Name”,
“type”: “short_text”,
“type_config”: {},
“date_created”: “2025-06-15T01:57:24.524Z”,
“hide_from_guests”: false,
“required”: false
},
{
“id”: “3b91fc4f-e192-401e-b342-f054f2a850b4”,
“name”: “Dimensions”,
“type”: “text”,
“type_config”: {},
“date_created”: “2025-06-15T01:59:12.987Z”,
“hide_from_guests”: false,
“required”: false
},
{
“id”: “58b7c2ba-e6d6-472d-a006-c47e27655d63”,
“name”: “Due Estimate”,
“type”: “date”,
“type_config”: {},
“date_created”: “2025-06-15T02:01:02.231Z”,
“hide_from_guests”: false,
“required”: false
},
{
“id”: “22283af2-024a-4972-a0cf-69bc371325e8”,
“name”: “Email Thread”,
“type”: “text”,
“type_config”: {},
“date_created”: “2025-06-15T02:02:59.138Z”,
“hide_from_guests”: false,
“required”: false
},
{
“id”: “327d08ce-8c3e-4aef-9507-b695f8927ef9”,
“name”: “Job Type”,
“type”: “drop_down”,
“type_config”: {
“sorting”: “manual”,
“options”: [
{
“id”: “8552b637-fa94-4dd6-8a32-c77be6204e35”,
“name”: “Kitchen”,
“color”: “#FF4081”,
“orderindex”: 0
},
{
“id”: “d211ae82-486e-43c5-a0b1-2cd7b711481e”,
“name”: “Laundry”,
“color”: “#7C4DFF”,
“orderindex”: 1
},
{
“id”: “554b9e4e-6192-4ba4-81c0-35bc2c09b9e2”,
“name”: “Vanity”,
“color”: “#FF7FAB”,
“orderindex”: 2
},
{
“id”: “591117a5-549e-4f40-9044-d0450c8453b6”,
“name”: “Wardrobe”,
“color”: “#FF4081”,
“orderindex”: 3
},
{
“id”: “2c5a669e-6b6e-4b59-82fa-ec125bd44740”,
“name”: “Bathroom”,
“color”: “#AF7E2E”,
“orderindex”: 4
},
{
“id”: “16af3897-286c-4310-870b-f114109bcfc3”,
“name”: “Cabinet”,
“color”: “#b5bcc2”,
“orderindex”: 5
},
{
“id”: “61bf7aaa-34e8-409c-8b1f-e440fb0e3f5b”,
“name”: “Flatpack”,
“color”: “#AF7E2E”,
“orderindex”: 6
},
{
“id”: “293de1d9-f449-4eed-9f44-31dea6b7c118”,
“name”: “Install”,
“color”: “#f900ea”,
“orderindex”: 7
}
]
},
“date_created”: “2025-06-15T01:58:30.972Z”,
“hide_from_guests”: false,
“required”: false
},
{
“id”: “7d3161c6-7251-4dec-92d0-64a8bf5b33ff”,
“name”: “Lead Source”,
“type”: “drop_down”,
“type_config”: {
“sorting”: “manual”,
“options”: [
{
“id”: “c1a479ea-4737-45c0-9040-e362ca604fec”,
“name”: “Email”,
“color”: “#FF4081”,
“orderindex”: 0
},
{
“id”: “ac5e2c0e-70dd-4620-b03f-13bf7a441d8c”,
“name”: “Facebook”,
“color”: “#FF7FAB”,
“orderindex”: 1
},
{
“id”: “012344f3-af1b-4816-81da-45523351310b”,
“name”: “Instagram”,
“color”: “#02BCD4”,
“orderindex”: 2
},
{
“id”: “e35f0c34-c1e0-4bfe-a1b3-8226f0d0ae71”,
“name”: “Word of Mouth”,
“color”: “#667684”,
“orderindex”: 3
},
{
“id”: “a3d6a9f0-77cc-4573-b828-0048c53f7138”,
“name”: “Referral”,
“color”: “#02BCD4”,
“orderindex”: 4
},
{
“id”: “a2446350-0456-4819-9fbe-b46c90650e64”,
“name”: “Existing Customer”,
“color”: “#FF4081”,
“orderindex”: 5
},
{
“id”: “506c8539-7f1d-482d-befd-ee25209bba05”,
“name”: “Walk In”,
“color”: “#81B1FF”,
“orderindex”: 6
},
{
“id”: “128e1964-f1d7-46e5-b1ff-454e8713cab3”,
“name”: “Option 2”,
“color”: “#7C4DFF”,
“orderindex”: 7
}
]
},
“date_created”: “2025-06-15T02:00:44.856Z”,
“hide_from_guests”: false,
“required”: false
},
{
“id”: “5117a78b-8ea6-4bd6-be49-303675b3108a”,
“name”: “Location”,
“type”: “location”,
“type_config”: {},
“date_created”: “2025-06-15T01:59:01.032Z”,
“hide_from_guests”: false,
“required”: false
},
{
“id”: “4f3bd81a-4d9c-47c0-9c32-080ae7091833”,
“name”: “Status”,
“type”: “drop_down”,
“type_config”: {
“sorting”: “manual”,
“options”: [
{
“id”: “656df09c-1257-4817-855b-8392f503bd86”,
“name”: “New Lead”,
“color”: “#FF4081”,
“orderindex”: 0
},
{
“id”: “b37b0df8-56d3-471e-9b96-596c2f71e236”,
“name”: “Quoted”,
“color”: “#7C4DFF”,
“orderindex”: 1
},
{
“id”: “bb99d39c-9774-4ce3-a392-e613f838f749”,
“name”: “Follow-Up”,
“color”: “#e50000”,
“orderindex”: 2
},
{
“id”: “2d460763-d308-4f75-9277-04578142dfee”,
“name”: “Approved”,
“color”: “#3082B7”,
“orderindex”: 3
},
{
“id”: “dd76929b-e8ad-42d3-802b-87e79c876618”,
“name”: “Dead Lead”,
“color”: “#800000”,
“orderindex”: 4
}
]
},
“date_created”: “2025-06-15T02:01:43.278Z”,
“hide_from_guests”: false,
“required”: false
},
{
“id”: “ed20600d-5782-4065-86a4-73cb94785da1”,
“name”: “Urgency”,
“type”: “drop_down”,
“type_config”: {
“sorting”: “manual”,
“options”: [
{
“id”: “ff3109fc-b9f9-41fa-a6d6-892e32d8dd3c”,
“name”: “Long Term”,
“color”: “#FF4081”,
“orderindex”: 0
},
{
“id”: “654bfd59-a132-42f7-8028-f28c7fa5d265”,
“name”: “Month”,
“color”: “#FF4081”,
“orderindex”: 1
},
{
“id”: “fc49e851-618e-4d72-a3ca-51b40c3f8336”,
“name”: “Week”,
“color”: “#b5bcc2”,
“orderindex”: 2
},
{
“id”: “262c84d6-3afc-4f78-83fd-558ba417b86a”,
“name”: “Urgent”,
“color”: “#e50000”,
“orderindex”: 3
},
{
“id”: “1f0aa648-2d25-40b2-ace4-18dc4d85af20”,
“name”: “Today”,
“color”: “#02BCD4”,
“orderindex”: 4
},
{
“id”: “e88a39db-0c23-4d7b-a0ab-1fd983575f85”,
“name”: “Option 2”,
“color”: “#7C4DFF”,
“orderindex”: 5
}
]
},
“date_created”: “2025-06-15T01:59:59.174Z”,
“hide_from_guests”: false,
“required”: false
}
]
}
]

4

Hey Brendan,

can you show screenshots of the module setup and what result you are getting?

5

c
c933×1126 122 KB

cl1
cl1692×1246 95.6 KB

cl2
cl2625×1243 102 KB

G
G949×1244 112 KB

In the last Picture, You can see that the Custom Fields area ia empty, and there is a Custom Fields Original Section with all of the information in it…

6

map top
map top366×1260 56.6 KB

map
map577×1257 80.4 KB

I’ve also got the custom fields mapped to the field in clickup.

7

These look like you are using a Create a Task (advanced) module right? But if you are hardcoding the list ID, then why not use the generic Create a Task module?

About the issue - from the screenshots it looks like the module didn’t receive any data. Same as in the JSON you posted above - all of the custom fields are empty when creating the task. Can you confirm that the chatGPT module is 7 and in the run there was data? You can check from the history by clicking on the ClickUp module to see if the variables were not empty.

8

It does the same with the Simple Version, trying to place it into Custom Fields Original. Hence why I thought it needed to be mapped. I am wondering if I need to fill in any of the fields above for it to work?

help
help402×1193 49.9 KB

9

The custom fields [original] array just shows raw data about the custom fields. You need to be looking at the custom fields collection - you can see there what is being used. But if both modules are creating tasks without any custom fields filled in, then the issue is definitely not in either of them. Check the scenario history and see if the previous module is correctly sending the variables.