See llms.txt for all machine-readable content.

Back to Templates

Sync MICE Operations event schedules with Google Drive text backups

Created by

Created by: MICE Operations || jori-mice-operations
MICE Operations

Last update

Last update 8 hours ago

Categories

Quick overview

This workflow receives MICE Operations event updates via webhook, fetches full event details, and keeps an offline plain-text schedule backup in Google Drive by creating or updating the file for confirmed events and deleting it when events are cancelled or completed.

How it works

  1. Receives a POST webhook from MICE Operations when an event is updated.
  2. Retrieves the full event record from MICE Operations, including client, contacts, location, packages, products, and activities.
  3. Continues only if the event start date is between today and the next 30 days.
  4. If the event status is confirmed, formats a detailed plain-text schedule, searches Google Drive for an existing backup file for that event, and creates a new file or updates the existing one.
  5. If the event status is cancelled or completed, searches Google Drive for the event’s backup file and deletes it if found.

Setup

  1. Create and connect MICE Operations API credentials in n8n and ensure the event lookup uses the incoming event ID (instead of a fixed ID).
  2. Create and connect Google Drive OAuth2 credentials with permission to create, update, and delete files in the target folder.
  3. Choose the Google Drive folder to store the backups and update the folder selection in the Google Drive search/create nodes.
  4. Copy the production webhook URL from the Webhook trigger and register it in MICE Operations.

Customization

  • Choose your own preferred storage application. For example OneDrive.

Additional info

Check the configuration guide in this workflow for the instruction to register your webhook correctly with MICE.