Bulk create Google Calendar events from Google Sheets

✅ What This Workflow Does

This workflow automates the process of creating Google Calendar events from a Google Sheet. It ensures each row in the sheet is evaluated for its current status and: - Creates new events in Google Calendar for rows marked as pending or failed. - Updates the Google Sheet with the result: Created, Failed, or Duplicate. - Handles errors gracefully and prevents duplicate event creation.

🛠️ How It Works

1. Manual Trigger: Start the workflow. 2. Read Sheet: Fetch all rows from the configured Google Sheet. 3. Check Status: - If status is pending or failed, continue to event creation. - If already created, update sheet as duplicate.

4. Create Event: Attempt to create a Google Calendar event using the row’s data.

5. Check for Errors: - If the creation succeeds, update the sheet as Created.

- If it fails, update the sheet as Failed.

6. Update Sheet: Reflect the result (Created, Failed, Duplicate) for each row.