What is your goal?
I want to update a Google Sheets row after each Shopify order, so my Slot_Availability sheet keeps the correct delivery slot counters.
For each new order, I need Make to find the correct slot row by slot_key, then update:
- booked_count
- net_booked
- remaining_slots
- is_full
- last_updated
- notes
The goal is to write calculated numeric values into Google Sheets, not text formulas like 0+1 or 3+1-0-1.
What is the problem & what have you tried?
Current problem:
When I use Google Sheets > Update a Row, Make either writes arithmetic as text, for example:
0+1
3+1-0-1
or gives formula errors such as:
Function ‘add’ finished with error: ‘3’ is not a valid array.
Unclosed function.
I need the correct Make syntax for these fields, or advice on whether I should calculate these values in a separate Tools module before updating Google Sheets.
Error messages or input/output bundles
Error message:
Failed to map ‘values.is_full’: Function ‘if’ finished with error! Function ‘add’ finished with error! ‘3’ is not a valid array.
Another error shown in the module:
Unclosed function.
Example of wrong output written into Google Sheets:
booked_count: 0+1
net_booked: 0+1
remaining_slots: 3+1-0-1
is_full: if(3 + 1 - 0 - 1 <= 0; OK; NO)
Example input row from Search Rows:
slot_key: 2026-05-25|AREA_A|AM1
max_slots: 3
buffer_slots: 1
booked_count: 0
cancelled_count: 0
net_booked: 0
remaining_slots: 3
is_full: OK
needs_review: NO
Expected output after one booking:
booked_count: 1
net_booked: 1
remaining_slots: 3
is_full: OK
needs_review: NO
Screenshots (scenario flow, module settings, errors)
