Vestaboard / Node-RED / Alexa / Google Sheets Integration

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.

image

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.