text: const fs = require('fs');
  const readline = require('readline');
  const store = require('node-persist');
  const { google } = require('googleapis');
  const { name: projectId } = require('../package.json');
  
  const { Storage } = require('@google-cloud/storage');
  const storage = new Storage({
    projectId,
    keyFilename: '../secret/SIMC-Web-4d0cc28353fd.json',
  });
  
  const Firestore = require('@google-cloud/firestore');
  const db = new Firestore({
    projectId,
    keyFilename: '../secret/SIMC-Web-4d0cc28353fd.json',
  });
  
  // If modifying these scopes, delete token.json.
  const SCOPES = ['https://www.googleapis.com/auth/spreadsheets'];
  const TOKEN_PATH = 'token.json';
  
  async function main(auth) {
    const sheets = google.sheets({version: 'v4', auth});
  
    sheets.spreadsheets.values.get({
      spreadsheetId: '1xJu8crdfvv_NdntpjFy2hrSyhvZQQny3q0IkXQ5xVsg',
      range: 'sheet!E2:E301',
    }, async function(err, res) {
      if (err) return console.log('The API returned an error: ' + err);
      console.log(res.data.values.length);
      res.data.values.forEach(async data => {
        data = data[0];
        if (!data) return ; // เด็กเส้นไม่มีเมล
        let user = (await db.collection('users').where('email', '==', data).get()).docs[0];
        user.ref.update({
          pass: true
        });
      });
      /* res.data.values.forEach(async function(data) {
        if(!data[0]) return;
        let query = datastore
          .createQuery('Users')
          .filter('email', '=', data[0]);
        let user = await datastore.runQuery(query);
        user = user[0][0];
        user.pass = true;
        datastore.save(user).catch(err => {
          console.error(err);
        });
      }); */
    });
  }
  
  // ------------------------
  
  // Load client secrets from a local file.
  fs.readFile('../secret/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), main);
  });
  
  /**
   * 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) console.error(err);
          console.log('Token stored to', TOKEN_PATH);
        });
        callback(oAuth2Client);
      });
    });
  }