Re-connecting Google Contacts and Calendar

// Calendar 2 Contact - automatically creating Birthday Entries from contacts
// Copyright (C) 2024, Oliver Bossert

// This program is free software: you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.

// This program is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.

// You should have received a copy of the GNU General Public License
// along with this program.  If not, see <https://www.gnu.org/licenses/>.

function createBirthdayEvents() {
  // Get the active spreadsheet and sheet
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = spreadsheet.getActiveSheet();

  // Get the last row with data
  var lastRow = sheet.getLastRow();

  // Iterate through each row starting from the second row (assuming header is in the first row)
  for (var i = 2; i <= lastRow; i++) {
    // Get the birthday data as a string
    var birthdayData = sheet.getRange(i, 2).getValue();
    Logger.log(birthdayData)

    // Parse the birthday data
    var birthdayObj = extractDayMonthYear(birthdayData);

    // Handle missing year
    var year = birthdayObj.year || new Date().getFullYear();

    // Create a Date object from the parsed data
    var birthdayDate = new Date(year, birthdayObj.month - 1, birthdayObj.day);


    // Create a Calendar event  
    const recurrence = CalendarApp.newRecurrence().addYearlyRule();

    var event = CalendarApp.createAllDayEventSeries(
      "🎂 " + sheet.getRange(i, 1).getValue(),
      birthdayDate,
      recurrence,
      {
        eventType: 'birthday',
        visibility: 'private',
        transparency: 'transparent',
      }
    );
    event.setColor('9');
    event.removeAllReminders();
  }
}


function extractDayMonthYear(inputString) {
  var day, month, year;
  var matches = inputString.match(/(\w+)=(\d+\.\d+)/g);

  if (matches) {
    for (var i = 0; i < matches.length; i++) {
      var match = matches[i].split('=');
      var key = match[0];
      var value = parseFloat(match[1]);

      switch (key) {
        case 'day':
          day = value;
          break;
        case 'month':
          month = value;
          break;
        case 'year':
          year = value;
          break;
        default:
          // Handle unexpected keys if needed
          break;
      }
    }
  }

  // Set missing year to 1900
  year = year || 1900;

  return {
    day: day,
    month: month,
    year: year
  };
}


function getContactsAndBirthdays() {
  // Get a list of all contacts
  var contacts = People.People.Connections.list('people/me', {
      personFields: 'names,birthdays'
    });

  // Create a new spreadsheet
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet(); //create('Contacts and Birthdays');

  // Get the first sheet
  var sheet = spreadsheet.getSheets()[0];

  // Set the header row
  sheet.getRange(1, 1, 1, 2).setValues([['Name', 'Birthday']]);

  // Iterate over the contacts and add them to the spreadsheet
  var row = 2;
  while (contacts) {
    for (var i = 0; i < contacts.connections.length; i++) {
      var contact = contacts.connections[i];
    var name = "";
    if (contact.names && contact.names.length > 0) {
      name = contact.names[0].displayName;
    }
      var birthday = "";
      if (contact.birthdays && contact.birthdays.length > 0) {
        birthday = contact.birthdays[0].date;
      }
      sheet.getRange(row, 1, 1, 2).setValues([[name, birthday]]);
      row++;
    }

    // Get the next page of contacts
    if (contacts.nextPageToken) {
      contacts = People.People.Connections.list('people/me', {
        personFields: 'names,birthdays',
        pageToken: contacts.nextPageToken
      });
    } else {
      contacts = null;
    }
  }
}