Update google sheet

index.js

const google = require('googleapis');
const sheets = google.sheets('v4')
const key = require('./google-key.json');
const scope = [
	'https://www.googleapis.com/auth/spreadsheets'
];
const spreadsheetId = 'spreadsheetId';
const auth = new google.auth.JWT(key.client_email, null, key.private_key, scope, null);

auth.authorize(function(err, tokens) {
	if (err) {
		console.log(err);
		return;
	}

	const range = 'Sheet1!A2:F10';
	const req = {
		auth,
		spreadsheetId,
		range,
		valueInputOption: 'USER_ENTERED',
		resource: {
			range,
			values,
			majorDimension: 'ROWS'
		}
	}

	sheets.spreadsheets.values.update(req, (err, resp) => {
		if (err) {
			throw err;
		}
		console.log(resp);
	});
});