How add data field to URL in HTTP Integration?

I want to use Http Post and add data to google spreadsheet …
How can i add field (payload) data to url ?

I have url that post data to spradsheet and i want to add field
“text”: “468.00”
value to url line?

with what i must replace “data1” so that there will be my payload field “text” value?

That would need an intermediate server (which could then also subscribe to MQTT directly, without using the HTTP Integration). See HTTP Integration: pass only payload_fields.

However, for Google Docs you could have it parse the JSON that TTN gives you. See Save data to a cloud server.

it would be nice feature to compose custom URL from payload fields