you are going to need to play around with this line in the thingspeak rest sensor
value_template: '{{ float(value_json["feeds"][0]["field1"]) }}'
but I am not sure how to do this or even if it is possible… I would suggest reading up on the docs and then using the template tool in developer tools section: