How to use

ProcessEnv

function

in

1/process

function loadSpreadsheet(done) {
  Spreadsheet.load({
    debug: true,
    spreadsheetId: process.env.GOOGLE_SPREADSHEET_ID,
    worksheetId: process.env.GOOGLE_WORKSHEET_ID,
    'oauth2': {
      'client_id': process.env.GOOGLE_CLIENT_ID,
      'client_secret': process.env.GOOGLE_CLIENT_SECRET,
      'refresh_token': process.env.GOOGLE_REFRESH_TOKEN
    }
  }, (error, spreadsheet) => {

    if (error) throw error

    spreadsheet.metadata((error, metadata) => {
      if (error) throw error
      console.log(`connected to spreadsheet: ${metadata.rowCount} rows, ${metadata.colCount} columns, last updated: ${metadata.updated}`)
    })

    spreadsheet.receive((error, rows, info) => {
      if (error) throw err
      let data = parseRows(rows)
      done(data, spreadsheet)
    })

  })
}