Sheets as a Service – Basic Script

index.js

const path = require('path');
const {google} = require('googleapis');
const sheets = google.sheets('v4');

// TODO: Add your Sheet ID
// https://docs.google.com/spreadsheets/d/2L2LpYPyxJQTf14OLM6mVuiou88MsEi4Q-IUUxswNlfe/edit
const SPREADSHEET_ID = '2L2LpYPyxJQTf14OLM6mVuiou88MsEi4Q-IUUxswNlfe';

/**
 * Appends row data to the Google Sheet
 */
const appendToSheet = async (row) => {
  // Obtain user credentials to use for the request
  const auth = new google.auth.GoogleAuth({
    keyFile: path.join(__dirname, 'creds.json'),
    scopes: ['https://www.googleapis.com/auth/spreadsheets'],
  });
  google.options({auth});
  await sheets.spreadsheets.values.append({
    spreadsheetId: SPREADSHEET_ID,
    range: 'A1:A1', // Needed, but not used when values are present.
    valueInputOption: 'USER_ENTERED',
    requestBody: {
      values: [
        row, // Example: ['Grant', '1/1/2000'],
      ],
    },
  });
}

/**
 * Simple Express server (via Functions Framework) with an Express request/response.
 */
exports.addRow = (req, res) => {
  const row = [
    'ADDED_ROW', new Date(),
  ];
  appendToSheet(row);
  res.send(`Added row: ${row}`);
};