Hey everyone,
I’m struggling hard with a Make scenario and honestly losing my mind. I’m trying to automate a Google Docs quote generation based on form data stored in Supabase (quote_logic, engagement duration, IA modules selected as an array).
What I’m trying to do:
- Retrieve data from a Supabase GET HTTP request (data is coming through fine
) - Use an Iterator to process each lead
- Dynamically calculate:
monthly_price(based on pack + duration)setup_price(based on selected modules in an array)total_price = monthly + setup
- Generate a Google Docs file using a template
What I’ve tried (and failed):
- Used Set variable module with
if(contains(...))logic → Make doesn’t evaluate the condition, it just dumps the formula as text. - Tried Math > Expression – but I’m struggling to make it understand nested logic.
- Mapped everything correctly from the Iterator – data is there.
Biggest issue:
Every time I use something like length(parseJSON(conversion_modules)), Make either crashes or literally writes the formula string into the doc instead of the result.
What I need help with:
- A working example of a calculation using
if,length,contains, etc. - Clear guidance on where to place those modules so the result is evaluated BEFORE the Google Docs module
- OR even better: a working scenario I can adapt – I’m happy to copy/paste and tweak.
Huge thanks in advance – I’m open to paid help at this point, seriously.
ps : my last error is : The operation failed with an error. Syntax error in part " if(engagement_duration == 3, 390, if(engagement_duration == 6, 351, if(engagement_duration == 12, 312, 0))), if(quote_logic == “Pack Pro PME”, if(engagement_duration == 3, 890, if(engagement_duration == 6, 801, if(engagement_duration == 12, 712, 0))), if(quote_logic == “Pack Performance”, if(engagement_duration == 3, 1290, if(engagement_duration == 6, 1161, if(engagement_duration == 12, 1032, 0))), if(quote_logic == “Conversion”, if(length(parseJSON(conversion_modules)) == 1, 90, if(length(parseJSON(conversion_modules)) == 2, 140, if(length(parseJSON(conversion_modules)) >= 3, 190, 0))), if(quote_logic == “Visibilité Digitale”, 190, 0) ) ) ) )" (char 39)