0

What I am doing is pulling data from an Google Sheets spreadsheet and printing it to the console with rows.map. I want to be able to use that data that's printing to the console to manipulate and display on an HTML page.

What I was thinking was to store all of the values printing to the console into a global variable, that way I will be able to call that global variable on an HTML page. Just can't seem to find the solution. Any help?

const fs = require('fs');
const readline = require('readline');
const {
    google
} = require('googleapis');

// If modifying these scopes, delete token.json.
const SCOPES = ['https://www.googleapis.com/auth/spreadsheets.readonly'];
// The file token.json stores the user's access and refresh tokens, and is
// created automatically when the authorization flow completes for the first
// time.
const TOKEN_PATH = 'token.json';

// Load client secrets from a local file.
fs.readFile('credentials.json', (err, content) => {
    if (err) return console.log('Error loading client secret file:', err);
    // Authorize a client with credentials, then call the Google Sheets API.
    authorize(JSON.parse(content), listMajors);
});

/**
 * Create an OAuth2 client with the given credentials, and then execute the
 * given callback function.
 * @param {Object} credentials The authorization client credentials.
 * @param {function} callback The callback to call with the authorized client.
 */
function authorize(credentials, callback) {
    const {
        client_secret,
        client_id,
        redirect_uris
    } = credentials.installed;
    const oAuth2Client = new google.auth.OAuth2(
        client_id, client_secret, redirect_uris[0]);

    // Check if we have previously stored a token.
    fs.readFile(TOKEN_PATH, (err, token) => {
        if (err) return getNewToken(oAuth2Client, callback);
        oAuth2Client.setCredentials(JSON.parse(token));
        callback(oAuth2Client);
    });
}

/**
 * Get and store new token after prompting for user authorization, and then
 * execute the given callback with the authorized OAuth2 client.
 * @param {google.auth.OAuth2} oAuth2Client The OAuth2 client to get token for.
 * @param {getEventsCallback} callback The callback for the authorized client.
 */
function getNewToken(oAuth2Client, callback) {
    const authUrl = oAuth2Client.generateAuthUrl({
        access_type: 'offline',
        scope: SCOPES,
    });
    console.log('Authorize this app by visiting this url:', authUrl);
    const rl = readline.createInterface({
        input: process.stdin,
        output: process.stdout,
    });
    rl.question('Enter the code from that page here: ', (code) => {
        rl.close();
        oAuth2Client.getToken(code, (err, token) => {
            if (err) return console.error('Error while trying to retrieve access token', err);
            oAuth2Client.setCredentials(token);
            // Store the token to disk for later program executions
            fs.writeFile(TOKEN_PATH, JSON.stringify(token), (err) => {
                if (err) return console.error(err);
                console.log('Token stored to', TOKEN_PATH);
            });
            callback(oAuth2Client);
        });
    });
}

/**
 * @param {google.auth.OAuth2} auth The authenticated Google OAuth client.
 */
function listMajors(auth) {
    const sheets = google.sheets({
        version: 'v4',
        auth
    });
    sheets.spreadsheets.values.get({
        spreadsheetId: '1O9FT3-p_knsbm8SIBznkDGHuL3LdfPaDnDJelqyBsqA',
        range: 'Price Alerts',
    }, (err, res) => {
        if (err) return console.log('The API returned an error: ' + err);
        const rows = res.data.values;
        if (rows.length) {
            // Print columns A and E, which correspond to indices 0 and 4.
            rows.map((row) => {
                console.log(`${row[0]}, ${row[1]}, ${row[2]}`);
            });
        } else {
            console.log('No data found.');
        }
    });
}
  • Read this, maybe it's useful: https://stackoverflow.com/questions/19846078/how-to-read-from-chromes-console-in-javascript – Triby Jan 17 '20 at 22:08
  • Is this thread useful for your situation? https://stackoverflow.com/q/59777129/7108653 – Tanaike Jan 17 '20 at 23:42
  • What exactly are you trying to accomplish, because you already have the data, you now can move it and show it as you wish. – Kessy Jan 20 '20 at 10:53
  • @Kessy I'm trying to take that data that's logging to the console and use it on to display on an html page. – Juugamil Jan 21 '20 at 19:51
  • Have you checked the sheets browser quickstart https://developers.google.com/sheets/api/quickstart/js -> It shows you how to pull data from sheets and show it in the browser. – Kessy Jan 22 '20 at 09:11
  • @Kessy I didn't. thank you for sharing – Juugamil Jan 28 '20 at 20:40

0 Answers0