Google Sheet API fetching in Javascript

read-google-sheet.js

import {google} from 'googleapis'
 

export async function getSheetData() {
    const auth = new google.auth.GoogleAuth({
        credentials: {
            client_email: process.env.SERVICE_EMAIL,
            private_key: process.env.SERVICE_KEY.replace(/\\n/g, "\n"),
        },
        scopes: ['https://www.googleapis.com/auth/spreadsheets.readonly']
    })
    const sheets = google.sheets({version: 'v4'})
    const range = "nse-eq!a2:h1928"
    try {
        const res = await sheets.spreadsheets.values.get({
            spreadsheetId: process.env.SHEET_ID, auth: await auth.getClient(),
            range
        })
        return (await res.data)
    } catch (e) {
        console.error("Error fetching sheets", e)
        return []
    }