How am i able to use specific cells in a range
async function readCerts(){ const sheets = google.sheets({version: ‘v4’,auth}); const spreadsheetId = ‘myIdHere’; const range = ‘Overview!B5:H60’; try { const response = await sheets.spreadsheets.values.get({ spreadsheetId,range }); const rows = response.data.values; return rows; } catch (error) { console.error(‘error’,error); } } (async()=>{ const pcc = await readCerts(); if (interaction.commandName === ‘stats’) { const maar = new EmbedBuilder() .setTitle(‘Statistics […]
Trying to match what a user inputs into a command, to a google sheet
So i am trying to get this where when a user inputs a command “steamid” it will go through the google sheet “data” and search for the “steamid”. If the steamid is found in the google sheet it will display blacklisted.