Trouble with inserting payload into cloud.say service in Node Red

Greetings,

I am attempting to utilize Node Red to alert me of the temperature if a given sensor is above or below a desired temperature with the cloud tts and google home speakers. I am currently utilizing the inject node to activate it while I attempt to get it working. I am utilizing the following flow:

[{"id":"60be9160.d8815","type":"tab","label":"TTS","disabled":false,"info":""},{"id":"7dabf8e3.27a638","type":"inject","z":"60be9160.d8815","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":75,"y":100,"wires":[["b7de34e3.dfd2b8"]],"l":false},{"id":"52f23ec3.3b5e2","type":"debug","z":"60be9160.d8815","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":830,"y":80,"wires":[]},{"id":"94e7b177.e7da2","type":"api-call-service","z":"60be9160.d8815","name":"TTS Bedroom Clock","server":"84a85f6b.8d261","version":3,"debugenabled":true,"service_domain":"tts","service":"cloud_say","entityId":"media_player.zach_s_bedroom_clock","data":"{\t \"message\":\"Bedroom Temperature is {{payload}}\",\t \"cache\":\"true\",\t \"language\":\"en-US\"\t}","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":720,"y":140,"wires":[["52f23ec3.3b5e2"]]},{"id":"b7de34e3.dfd2b8","type":"api-call-service","z":"60be9160.d8815","name":"Volume Set 40","server":"84a85f6b.8d261","version":3,"debugenabled":false,"service_domain":"media_player","service":"volume_set","entityId":"media_player.zach_s_bedroom_clock","data":"{\"volume_level\":0.1}","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":200,"y":100,"wires":[["8e62e35b.288c1"]]},{"id":"8e62e35b.288c1","type":"api-current-state","z":"60be9160.d8815","name":"","server":"84a85f6b.8d261","version":2,"outputs":1,"halt_if":"","halt_if_type":"num","halt_if_compare":"is","entity_id":"sensor.bedroom_temperature","state_type":"num","blockInputOverrides":false,"outputProperties":[{"property":"payload","propertyType":"msg","value":"","valueType":"entityState"},{"property":"data","propertyType":"msg","value":"","valueType":"entity"}],"override_topic":false,"state_location":"payload","override_payload":"msg","entity_location":"data","override_data":"msg","x":490,"y":80,"wires":[["52f23ec3.3b5e2","94e7b177.e7da2"]]},{"id":"b694691e.9ab048","type":"comment","z":"60be9160.d8815","name":"TTS Tester","info":"","x":120,"y":60,"wires":[]},{"id":"84a85f6b.8d261","type":"server","name":"Home Assistant","version":1,"addon":true,"rejectUnauthorizedCerts":true,"ha_boolean":"y|yes|true|on|home|open","connectionDelay":true,"cacheJson":true}]

Every time I run it though it comes out saying “payload” or “message payload” rather than inserting the {{payload}} or {{msg.payload}}. I have tried several configurations and cannot seem to figure out how to get the service to work.

Pardon my formatting, I cant get the ``` to format it properly.

Any thoughts?
Thanks.

I don’t use the integration but change the data field from j expression to json.

That was the missing piece! Thank you!

Bumping an old thread because it’s found highly on Google.
I’m pasting the Node Red flow that works. Just update your entities and go.

[{"id":"60be9160.d8815","type":"tab","label":"TTS","disabled":false,"info":""},{"id":"7dabf8e3.27a638","type":"inject","z":"60be9160.d8815","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":75,"y":100,"wires":[["b7de34e3.dfd2b8"]],"l":false},{"id":"52f23ec3.3b5e2","type":"debug","z":"60be9160.d8815","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":910,"y":100,"wires":[]},{"id":"94e7b177.e7da2","type":"api-call-service","z":"60be9160.d8815","name":"TTS Bedroom Clock","server":"84a85f6b.8d261","version":3,"debugenabled":true,"service_domain":"tts","service":"cloud_say","entityId":"media_player.coolspeaker","data":"{\t \"message\":\"Bedroom Temperature is {{payload}}\",\t \"cache\":\"true\",\t \"language\":\"en-US\"\t}","dataType":"json","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":720,"y":140,"wires":[["52f23ec3.3b5e2"]]},{"id":"b7de34e3.dfd2b8","type":"api-call-service","z":"60be9160.d8815","name":"Volume Set 40","server":"84a85f6b.8d261","version":3,"debugenabled":false,"service_domain":"media_player","service":"volume_set","entityId":"media_player.coolspeaker","data":"{\"volume_level\":0.4}","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":200,"y":100,"wires":[["8e62e35b.288c1"]]},{"id":"8e62e35b.288c1","type":"api-current-state","z":"60be9160.d8815","name":"","server":"84a85f6b.8d261","version":2,"outputs":1,"halt_if":"","halt_if_type":"num","halt_if_compare":"is","entity_id":"sensor.cooltempsensor","state_type":"num","blockInputOverrides":false,"outputProperties":[{"property":"payload","propertyType":"msg","value":"","valueType":"entityState"},{"property":"data","propertyType":"msg","value":"","valueType":"entity"}],"override_topic":false,"state_location":"payload","override_payload":"msg","entity_location":"data","override_data":"msg","x":470,"y":80,"wires":[["52f23ec3.3b5e2","94e7b177.e7da2"]]},{"id":"b694691e.9ab048","type":"comment","z":"60be9160.d8815","name":"TTS Tester","info":"","x":180,"y":220,"wires":[]},{"id":"84a85f6b.8d261","type":"server","name":"Home Assistant","version":1,"addon":true,"rejectUnauthorizedCerts":true,"ha_boolean":"y|yes|true|on|home|open","connectionDelay":true,"cacheJson":true}]