🧊 Cube Make
Scenarios
Resources
← Back to Scenarios
🔄 CS25 - Restock Bookings (cancel/resched)| Fluent booking > Clickup ⏸️🆖
⚠️ Needs ID
9 modules
Settings
ID:
Save
Folder:
Save
Summary:
Save
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)
👁️ 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)
✏️ 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