AI Generated Responses stored in Variables don't get saved

Title. I am using chatling + Claude.ai + Google Sheet as database to create a carbon footprint calculator.

Flow is generally

Question→ AI response → Stored in Variable (Say transportation) → Upload to Google Sheets

The issue lies in the AI response variable. I can confirm that without the AI response that the variable can be uploaded to Google sheets, but with it, it doesnt.

AI Response Setting:

Workflow

The value should be 82.97 and uses the {TransportationCalc} Variable


Hope to get a resolution to this