text: const fs = require('fs')
  const readline = require('readline')
  const { google } = require('googleapis')
  const Logger = require('../utils/logger')
  
  // If modifying these scopes, delete token.json.
  const SCOPES = ['https://www.googleapis.com/auth/spreadsheets']
  // 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 Logger.log('Error loading client secret file:', err)
  
    // Authorize a client with credentials, then call the Google Sheets API.
    authorize(JSON.parse(content), listResults)
  })
  
  /**
   * 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) {
    Logger.log(credentials)
    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
    })
    Logger.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 Logger.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 Logger.error(err)
          Logger.log('Token stored to', TOKEN_PATH)
        })
        callback(oAuth2Client)
      })
    })
  }
  
  /**
   * Prints the Proposals & Votes
   * @see https://docs.google.com/spreadsheets/d/1e4xb6m-aKcBhwob_p7ereSFneXFPpDjUbSjz13smmHI/edit#gid=243186092
   * @param {google.auth.OAuth2} auth The authenticated Google OAuth client.
   */
  function listResults(auth) {
    const sheets = google.sheets({ version: 'v4', auth })
    sheets.spreadsheets.values.get(
      {
        spreadsheetId: '1e4xb6m-aKcBhwob_p7ereSFneXFPpDjUbSjz13smmHI',
        range: 'Round4Results!A1:D15'
      },
      (err, res) => {
        if (err) return Logger.log('The API returned an error: ' + err)
        const rows = res.data.values
        if (rows.length) {
          Logger.log('Name, Votes:')
          // Print columns B and
          rows.map((row) => {
            Logger.log(`${row[1]}, ${row[2]}`)
          })
        } else {
          Logger.log('No data found.')
        }
      }
    )
  }
  