Nodejs interacción básica con api de google sheets

nodejs_google_sheets_api_basic.js

const { google } = require("googleapis");

const auth = new google.auth.GoogleAuth({
  keyFile: "credentials.json",
  scopes: "https://www.googleapis.com/auth/spreadsheets",
});

const main = async () => {
  const client = await auth.getClient();
  const googleSheets = google.sheets({ version: "v4", auth: client });
  const spreadsheetId = "13tCscquZg4Qgdo8BLYb7p7nV2f3Fk5VeDr1k5Fu0yD4";
  const spreadSheetMetadata = await googleSheets.spreadsheets.get({
    auth,
    spreadsheetId,
  });

  const getRows = await googleSheets.spreadsheets.values.get({
    auth,
    spreadsheetId,
    range: "Hoja1",
  });

  console.log();
  console.log(getRows.data.values);
  /**
   * [
      [ 'Name', 'Age' ],
      [ 'Diego', '30' ],
      [ 'Juan', '29' ],
      [ 'Pedro', '40' ]
    ]
   */

  await googleSheets.spreadsheets.values.append({
    auth,
    spreadsheetId,
    range: "Hoja1!A:B",
    valueInputOption: "USER_ENTERED",
    resource: {
      values: [["Franco", "25"]],
    },
  });
};

main();