Pull data from a spreadsheet (command)

[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