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) }) }) }