I’m using my Vestaboard to display quotes that I pull from a google sheet. This is all done within Home Assistant and Node-RED
Huge thanks to Dan as I couldn’t have done this without his initial post: Vestaboard Integration
Now, asking my Alexa to “turn on new quote” will fire the flow, grab the entire column of quotes from google sheets, pick a random one and send to my Vestaboard:
Here’s my node-RED flow:
I’m using the GSheet node for this.
PLEASE take note that my columns and configs use the C column (I was doing some concat in the sheet and ended up in column C)
Here’s a look at the google sheet:
This has been working flawlessly for some time. Drop me a line, if you have any questions.