Node-red

[{"id":"42d008f5.b7cec8","type":"mqtt in","z":"4fca5181.0be3c","name":"","topic":"/ITS-01-az","qos":"2","datatype":"json","broker":"23789271.e54d6e","nl":false,"rap":true,"rh":0,"x":240,"y":160,"wires":[["2c309297.accdee","1e7e8e52.94cae2"]]},{"id":"510dc96c.103a68","type":"GSheet","z":"4fca5181.0be3c","creds":"11076975.d43f17","method":"get","action":"","sheet":"1EruWR_LY-uEZm6pmXUPyq4OWaI7JhBmJYm6E9tbetRw","cells":"DB!A2:E6","flatten":false,"name":"Google Sheet","x":760,"y":180,"wires":[["a2ae5ed.469dea","1db83a62.b0cc26","8eaded1d.e4d29"]]},{"id":"a2ae5ed.469dea","type":"debug","z":"4fca5181.0be3c","name":"","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":850,"y":60,"wires":[]},{"id":"68b62988.fac0e8","type":"mqtt out","z":"4fca5181.0be3c","name":"","topic":"/ITS-01-az","qos":"","retain":"","respTopic":"","contentType":"","userProps":"","correl":"","expiry":"","broker":"23789271.e54d6e","x":450,"y":320,"wires":[]},{"id":"ce49ec00.d6bc4","type":"inject","z":"4fca5181.0be3c","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"{\"id\":11,\"code\":\"asdfgh\"}","payloadType":"json","x":120,"y":320,"wires":[["68b62988.fac0e8"]]},{"id":"2c309297.accdee","type":"debug","z":"4fca5181.0be3c","name":"","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":410,"y":60,"wires":[]},{"id":"1e7e8e52.94cae2","type":"change","z":"4fca5181.0be3c","name":"Set received data in msg.data","rules":[{"t":"set","p":"data","pt":"msg","to":"payload","tot":"msg"},{"t":"set","p":"id","pt":"flow","to":"payload.id","tot":"msg"},{"t":"set","p":"code","pt":"flow","to":"payload.code","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":470,"y":180,"wires":[["510dc96c.103a68"]]},{"id":"1db83a62.b0cc26","type":"debug","z":"4fca5181.0be3c","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":1070,"y":60,"wires":[]},{"id":"23789271.e54d6e","type":"mqtt-broker","name":"HIVEMQ","broker":"broker.hivemq.com","port":"1883","clientid":"","usetls":false,"protocolVersion":"4","keepalive":"60","cleansession":true,"birthTopic":"","birthQos":"0","birthPayload":"","birthMsg":{},"closeTopic":"","closeQos":"0","closePayload":"","closeMsg":{},"willTopic":"","willQos":"0","willPayload":"","willMsg":{},"sessionExpiry":""},{"id":"11076975.d43f17","type":"gauth"}]