Hi there, sorry I’ve tried looking around but don’t see my specific case
I have a Google spreadsheet. 5 columns:
Game Name (the cell contains the name of the game)
Played on Twitch? (the cell contains yes or no)
Played on Youtube? (the cell contains yes or no)
Do I recommend the game? (the cell contains yes or no)
Youtube link (if it exists)? (the cell contains a youtube link)
I would like to make a command where chat can find the info, instead of looking up the sheet
So say !game Hollow Knight then Nightbot will give the relevant data
I’m ok with it just showing the Youtube link if showing the whole answers is too much
Could be possible, I’m not sure. You would have to be able to read and understand and implement this: Sheets API | Google Developers into your code using URL fetch:
That said, I don’t understand this. I’ve kinda read the sheets api website, but then what do I do?
Am I supposed to code something from scratch? For reference, I’ve only made a webpage in HTML class in like…2012 haha. But even then I wrote something in a laptop then we don’t actually host it, the browser just went “directory path in laptop” in the address bar
Would you happen to know of a video tutorial or articles for it? Like do I write it in notepad ++ then put it into my Google Sheets? Any info would be appreciated
Once again, thank you for taking the time to answer my first question.
Yup, and then host it. After that you’ll have an URL to call with Nightbot’s $(urlfetch).
Sorry, we don’t provide help on how to write an API, or exploit third-party app.