Schedule Trigger Automate

This workflow is ideal for:

• Event Organizers: Those who need to manage and track events efficiently.
• Project Managers: Professionals looking to automate task scheduling and updates in Notion.
• Individuals with Busy Schedules: Anyone who wants to keep their calendar organized and updated automatically.
• Tech-Savvy Users: Users familiar with APIs and automation tools who want to integrate Outlook Calendar with Notion.

This workflow addresses the challenge of managing calendar events by automating the process of:

• Fetching events from Outlook Calendar based on a defined schedule.
• Creating new pages in Notion for events that do not already exist, ensuring all events are tracked.
• Updating existing pages in Notion with the latest event information, preventing data loss or outdated entries.

1. On Schedule: The workflow triggers based on a defined schedule, running every few minutes as set by the user.
2. X Days into the Future: Calculates a future date by adding 365 days to the current date, determining the range for fetching events.
3. Get Outlook Calendar Events: Sends a request to the Outlook Calendar API to retrieve events occurring between the current date and the calculated future date.
4. Split Out Items: Breaks down the retrieved events into individual items for further processing.
5. Try Get Database Page: Checks if a corresponding page for each event already exists in Notion by searching with the Event ID.
6. Merge: Combines the results of the event search with the original event data.
7. If Database Page Not Found: Determines whether a new page needs to be created or an existing one updated based on whether the page was found.
8. Create Database Page: If the page does not exist, creates a new page in Notion with the event details, including the date, event ID, and link.
9. Update Database Page: If the page exists, updates it with the latest event details to ensure all information is current.