Introduction 

This blog explains how to bulk change Google Calendar event visibility using xFanatical Foresight. Google Calendar allows users to control who can view event details by setting the visibility of individual calendar events. Depending on the visibility setting, event information can be visible to people who have access to the calendar.

Many users create personal appointments, private meetings, medical visits, interviews and other sensitive events on their calendars. Over time, they may decide to share their calendar with coworkers, managers or team members. When this happens, previously created events may unintentionally expose information that was not intended to be shared. Although Google Calendar allows users to manually change event visibility, updating hundreds of historical events one at a time is time-consuming and impractical. Google Workspace users need an efficient way to bulk update large numbers of historical events and protect sensitive information.

With xFanatical Foresight, Google Workspace users can automatically export their primary calendar events, review them and bulk change event visibility to Private. This helps protect sensitive information while allowing calendar sharing for future collaboration.
 Illustration of how xFanatical Foresight exports calendar events and bulk updates event visibility to private.

Illustration of how xFanatical Foresight exports calendar events and bulk updates event visibility to private.

Introducing xFanatical Foresight Automation

xFanatical Foresight is a powerful automation platform designed specifically for Google Workspace. It helps administrators and users automate repetitive Google Workspace tasks with minimal manual intervention.

Using xFanatical Foresight, Google Workspace users can automatically export calendar events from their primary calendar, generate a CSV file containing event details and bulk update event visibility. Instead of opening each event individually, users can process large numbers of calendar events through a simple automation workflow.

This template is useful when users begin sharing calendars with others and want to ensure previously created events remain private.

Automation Setup Instructions

In this section, we guide you through the automation setup in xFanatical Foresight.  Set up automation from a template and after completing the automation rule, verify whether the automation meets your requirements.

Set Up Automation From a Template

Set Up Automation From a Template

Supported plans: xFanatical Foresight Elite plan.

The template is designed with two rules to automate calendar event visibility updates:

Rule 1: List calendar events – Exports calendar events from the primary calendar into a CSV file.

Rule 2: Bulk update calendar events’ visibility – Updates the visibility of exported calendar events and changes them to Private.


Rule 1: List calendar events

  1. Sign into xFanatical Foresight with your Google account. 
  2. Go to the Templates page.
  3. Search for Bulk update calendar event visibility and click on it.In the Templates > search for Bulk update calendar event visibility template.
  4. In the Templates > Bulk update calendar event visibility page, click Copy Rule 1.
    In the Templates > Bulk update calendar event visibility, click the Copy rule 1 to duplicate the automation
  5. For the first time use of the template rule, an dialog Action needed will display requesting necessary permissions required to copy the rule. Click Connect with Google and authorize the permissions.
  6. Upon authorization, a dialog titled Copy of List calendar events will display.
  7. Click Next. No manual configuration is needed.
  8. Click Review.
  9. In the Review screen,
     In the Review page, provide rule name and create the rule 1.
    1. In Rule name, customize the automation rule name.
    2. Click Create.
  10. The rule is created in the Rules page.
Rule graph exporting calendar events from Google Calendar into a CSV file.

xFanatical Foresight rule graph exporting calendar events from Google Calendar into a CSV file.

Rule 2: Bulk update calendar events’ visibility

  1. In the Templates > Bulk update calendar event visibility, click Copy Rule 2.
    In the Templates > Bulk update calendar event visibility, click the Copy rule 2 to duplicate the automation.
  2. Click Next.
  3. Click Review.
  4. In the Review screen,
    In the Review page, provide rule name and create the rule 2.
    1. In Rule name, customize the automation rule name.
    2. Click Create.
  5. The rule is created in the Rules page.

 Rule graph illustrating bulk updating calendar event visibility.

xFanatical Foresight rule graph illustrating bulk updating calendar event visibility.

Verify Automation

Verify Automation

To ensure your rule setup automates as expected, it’s crucial to perform a simple test. The following instructions demonstrate how xFanatical Foresight bulk updates calendar events’ visibility.

  1. Log into xFanatical Foresight with your Google account.
  2. Go to the Rules Page.
  3. Execute the Rule 1- List calendar events to list the user’s primary calendar events.
    Execute rule to list calendar events.
  4. You will receive the notification in the top right corner of xFanatical Foresight and click View Log.
    A notification on the completion of rule 1 execution.
  5. Download the generated CSV file from the Log details page.
    Logs details page with the CSV file of calendar events.
  6. Go back to the Rules page and upload the CSV file into Rule 2 – Bulk update calendar events’ visibility.
    Upload CSV file to bulk update calendar events' visibility rule.
  7. Wait for the automation to process the uploaded file.
  8. You’ll receive a notification in the top right corner of xFanatical Foresight. Click View log.
    A notification on the completion of rule 2 execution.
  9. In the Logs > Log details page, the Rule history section provides a detailed record of the automation execution and the actions performed by xFanatical Foresight.
    Logs details page for after successful execution of rule.
  10. Open Google Calendar and select one of the processed event details.
  11. Verify that the event visibility is set to Private after completion of automation.
    Verification of successful rule execution.

Notes

  • This template operates on calendar events only for the selected primary calendar.
  • The default configuration exports events from the previous year up to the current date and time. 
  • The Time span end must be later than the Time span start but cannot exceed one year after the Time span start date.
  • We recommend keeping the default time range configuration to avoid unexpected execution errors caused by time range limitations.
  • Rule 1 should be executed before Rule 2 because the exported CSV file is required for the visibility update process.
  • Only events included in the uploaded CSV file are updated and event visibility is changed to Private by the template configuration.
  • Depending on the number of events being processed, execution time may vary.

Conclusion

Calendar sharing improves collaboration but previously created calendar events may contain personal or sensitive information that users do not want others to view. Manually reviewing and updating every historical event can be time-consuming and error-prone.

xFanatical Foresight simplifies this process by exporting calendar events and bulk updating event visibility to Private through an automated workflow. This helps quickly protect historical calendar information while continuing calendar sharing and collaboration.

Try a 14-day free trial with xFanatical Foresight and manage your tasks.


Related Articles

For more article please visit our website: Articles