you can use cayenne API to get the data on node-red How to access Cayenne API using Insomnia, Node-red and Thunkable
or create another device on the cayenne dashboard and use the MQTT client_id of this device on node-red. then you can subscribe to the topic of the first device.