Google Calendar API integration Into BotPress Autonomous ChatBot

				
					// Retrieve the selected date and company hours from the workflow object
const selectedDate = workflow.user_SelectedDate; //  Format: 'YYYY-MM-DD'
const companyHours = workflow.companyHours; // Format: 'HH:mm-HH:mm'
const calendarId = workflow.credentials.calendarId; // Google Calendar ID
const APIkey = workflow.credentials.APIkey; // Google API key

// Function to fetch all events for the selected date
async function fetchAllEventsForDay(dayStart, dayEnd) {
  try {
    // Perform the GET request to the Google Calendar API for the entire day
    const response = await axios.get(`https://www.googleapis.com/calendar/v3/calendars/${calendarId}/events`, {
      params: {
        timeMin: dayStart.toUTC().toISO(),
        timeMax: dayEnd.toUTC().toISO(),
        singleEvents: true,
        key: APIkey
      }
    });
    // Extract and return the events from the API response
    return _.get(response, 'data.items', []);
  } catch (error) {
    console.error('Error fetching events for the whole day:', error);
    return [];
  }
}

// Function to find time slots with fewer than 2 events for the selected date
async function findAvailableTimeSlots() {
  // Parse the company hours to get the start and end times
  const [startTime, endTime] = companyHours.split('-');
  // Combine the selected date with the start and end times to get the DateTime objects
  const dayStart = luxon.DateTime.fromISO(`${selectedDate}T${startTime}`);
  const dayEnd = luxon.DateTime.fromISO(`${selectedDate}T${endTime}`);

  // Fetch all events for the day
  const allEvents = await fetchAllEventsForDay(dayStart, dayEnd);

  // Prepare an array to hold time slots with fewer than 2 events
  let timeSlotsWithFewerEvents = [];

  // Loop over each hour within the company hours
  for (let hour = 0; hour < dayEnd.diff(dayStart, 'hours').hours; hour++) {
    const currentSlotStart = dayStart.plus({ hours: hour });
    const currentSlotEnd = currentSlotStart.plus({ hours: 1 });

    // Filter events that are within the current time slot
    const eventsInCurrentSlot = allEvents.filter(event => {
      const eventStart = luxon.DateTime.fromISO(event.start.dateTime || event.start.date);
      const eventEnd = luxon.DateTime.fromISO(event.end.dateTime || event.end.date);
      return eventStart < currentSlotEnd && eventEnd > currentSlotStart;
    });

    // If there are fewer than 2 events in the current time slot, add it to the list
    if (eventsInCurrentSlot.length < 2) {
      timeSlotsWithFewerEvents.push({
        start: currentSlotStart.toUTC().toFormat('yyyy-MM-dd\'T\'HH:mm\'Z\''),
        end: currentSlotEnd.toUTC().toFormat('yyyy-MM-dd\'T\'HH:mm\'Z\'')
      });
    }
  }

  // Return the list of time slots with fewer than 2 events
  return timeSlotsWithFewerEvents;
}

// Self-invoking async function to handle the fetching and processing
(async () => {
  try {
    // Wait for the findAvailableTimeSlots function to complete and get the slots
    const slots = await findAvailableTimeSlots();
    console.log('Time slots with fewer than 2 events:', slots);
    
    // Now that you have the slots, you can set them on the workflow object
    workflow.companyBookingDailyAvail = slots;
    

  } catch (error) {
    console.error('Error finding available time slots:', error);
  }
})();