alexismp

function addEmptySheet(sheetsAPI, sheetName) {
  return new Promise((resolve, reject) => {
    const emptySheetParams = {
      spreadsheetId: process.env.SPREADSHEET_ID,
      resource: {
        requests: [
          {
            addSheet: {
              properties: {
                title: sheetName,

alexismp

function setColumnStyle(sheetsAPI, sheetId) {
  return new Promise((resolve, reject) => {
    const setStyleParams = {
      spreadsheetId: process.env.SPREADSHEET_ID,
      resource: {
        requests: [
          {
            repeatCell: {
              range: {
                sheetId: sheetId,

alexismp

const sheetsAPI = google.sheets({version: 'v4', auth});