Pull data from a spreadsheet (command)

[dinnydorf]

Hi all!

I’ve seen a few posts similar to this, but they all seem to be either out of date or different enough that I can’t hack my way into making it work for me.

In simple terms, I would like a command that will display specific data from a google spreadsheet. (I can’t add a link to my post else I would include the sheet here).

What I’d like - a command (ie !nextanimal) which would display something like “The next animal on the farm will be [animal name] the [animal]!” I’ll be taking out rows as each one is acquired, so it should only ever pull from cells C2 and B2. Can anyone help?

Edit to add: due to a delay with my account being on hold, this is no longer immediately relevant. I’m going to leave it up just in case anyone has any ideas which may help me or someone else in the future.

[Emily]

Hey @dinnydorf!

Have a look here:

Fetching data from Google Spreadsheet

Hi there, I’m trying to fetch data from a Google Spreadsheet into Nightbots output. I’d like to use it (for example) for easy updates on a loadout in Warzone (without having to change the command every time the loadout changes, so I just update it in spreadsheets). I’ve fixed a json output on Spreadsheets, now I’m hardstuck at the point where I want to display the values from row & column 1 (weapon), and the row 1 and column 2 (attachments). I can’t seem to figure out how Nightbot can fetch an…

How to fetch data from Google Sheets with Nightbot?

if you only want to fetch data then use this api https://sheets.googleapis.com/v4/spreadsheets/[SPREADSHEET_ID]/values/[SPREADSHEET_NAME]?key=[YOUR_API_KEY] documentation

[dinnydorf]

Hi @Emily ,

Thanks! The first one I tried a few different ways, but seems that the api was updated after that example was written, so the command no longer works. The second one doesn’t give too much detail on the structure of the command itself, but I’ll look into it.

[Emily]

@dinnydorf

The first one I tried a few different ways, but seems that the api was updated after that example was written, so the command no longer works.

Right, I wasn’t sure about that and I didn’t have the time to test it, thanks for the confirmation.

@dinnydorf

The second one doesn’t give too much detail on the structure of the command itself, but I’ll look into it.

Basically, you need to use Google’s API, the documentation linked is your only friend.