🧊 Cube Make

← Back to Scenarios

🔄 CS25 - Restock Bookings (cancel/resched)| Fluent booking > Clickup ⏸️🆖

⚠️ Needs ID 9 modules

Settings

Flow (click modules to expand)

gateway Booking Cancelled #1
regexp Parser #5
text: {{1.text}}
regexp Parser #7
text: {{5.`__IMTMATCH__`}}
json Parse JSON #6
json: {{5.`__IMTMATCH__`}}
google-sheets Sheet: Bookings (Fluent) #8
from: drive
filter:
sheetId: Bookings (Fluent)
sortOrder: asc
spreadsheetId: 1E_WeaMJsqPe5ZBDrzRxVFy-dtvhmZe36qVefVxv0KlY
tableFirstRow: A1:CZ1
includesHeaders: true
valueRenderOption: FORMATTED_VALUE
dateTimeRenderOption: FORMATTED_STRING
google-sheets Sheet: Bookings (Fluent) #9
from: drive
mode: select
values:
6:{{6.full_start_end_host_timezone}}
11:{{6.what_happened}}
sheetId: Bookings (Fluent)
rowNumber: {{8.`__ROW_NUMBER__`}}
spreadsheetId: /1E_WeaMJsqPe5ZBDrzRxVFy-dtvhmZe36qVefVxv0KlY
includesHeaders: true
valueInputOption: USER_ENTERED
builtin Basic Router #11 2 routes
route Branch 1
clickup edit ATask #10
list_id: 900301922037
task_id: {{8.`13`}}
team_id: 9003069646
space_id: 90030159275
assignees:
folder_id: 90031113641
custom_fields:
126e941c-61f8-4e11-916c-f19d6119d642:{{6.reschedule_reason}}
250322f5-4bc5-46f4-8892-d8e5dc4bf1dc:18a17302-81d5-4b25-802a-315b0ef4f292
4a66076a-dc1e-4759-a387-e9daa27b9e61:6da3b782-cf8a-475f-a3fd-b4fd02fe5414
7f87c357-cf2e-47c0-aa60-13729e8c8f35:
addCustomFieldDateTime: false
parseCustomFieldDateTimeOutput: false
route Branch 2
clickup edit ATask #12
list_id: 900301922037
task_id: {{8.`13`}}
team_id: 9003069646
due_date: {{formatDate(6.full_start_end_host_timezone; "DD.MM.YYYY HH:mm"; "Australia/Melbourne")}}
space_id: 90030159275
assignees:
folder_id: 90031113641
custom_fields:
126e941c-61f8-4e11-916c-f19d6119d642:{{6.reschedule_reason}}
7f87c357-cf2e-47c0-aa60-13729e8c8f35:
addCustomFieldDateTime: false
parseCustomFieldDateTimeOutput: false