actually, I've got one specific use case for google sheets that maybe doable otherwise
without diving too deep, I want to reference the output of a column in an api call. this column is going to be plain text where I use dynamic variables in its formula and then reference the plain text (after processing) in the api call.
Would I be able to instead input dynamic variables into the value of a key value pair in a http request?
E.g.
"prompt": JSON.stringify("Hey {{first_name}}, this is a HTTP request")
Is there a way to make it work vs referencing the pure column in a HTTP request?