Step 2: Connect Google Drive and Parse Spreadsheet Data

This step pulls the spreadsheet file from Google Drive and converts it into structured rows.

1. In Assign Spreadsheet ID, add an assignment for fileId with value [YOUR_ID].
2. Open Retrieve Drive Spreadsheet and set Operation to download.
3. Set File ID to ={{ $json.fileId }}.
4. Credential Required: Connect your Google Drive OAuth2 credentials in Retrieve Drive Spreadsheet.
5. Connect Retrieve Drive Spreadsheet to Parse Spreadsheet File, then connect Parse Spreadsheet File to Validate Event Rows.

Step 3: Validate Rows and Run AI Enrichment

Filter invalid rows, then enrich each event with AI-generated metadata.

1. In Validate Event Rows, confirm the three conditions:
2. Set condition 1 to Not Empty for ={{ $json.title }}.
3. Set condition 2 to Not Empty for ={{ $json.startDate }}.
4. Set condition 3 to Not Equals with ={{ new Date($json.startDate).toString() }} and right value Invalid Date.
5. Validate Event Rows outputs to both Create Calendar Entry, AI Context Review, and Combine AI Details in parallel.
6. In AI Context Review, set Text to ={{ $json.title }} {{ $json.description }} {{ $json.location }} and enable the output parser.
7. Ensure Structured Result Parser is connected as the output parser to AI Context Review.
8. Credential Required: Connect your OpenAI API credentials in OpenAI Chat Engine (this provides the language model for AI Context Review). Structured Result Parser does not need its own credentials.

Step 4: Merge AI Details and Create Calendar Events

Merge AI results, augment event data, and create Google Calendar entries.

1. In Combine AI Details, set Mode to combine.
2. Configure Augment Event Fields with assignments including:
3. title = ={{ $json.title }}
4. category = ={{ $('AI Context Review').item.json.category }}
5. tags = ={{ $('AI Context Review').item.json.tags.join(', ') }}
6. description = ={{ $('AI Context Review').item.json.enhancedDescription || $json.description }}
7. endDate = ={{ $json.endDate || new Date(new Date($json.startDate).getTime() + ($('AI Context Review').item.json.suggestedDuration * 3600000)).toISOString() }}
8. reminderMinutes = ={{ $('AI Context Review').item.json.reminderMinutes }}
9. In Create Calendar Entry, set Start to ={{ $json.startDate }} and End to ={{ $json.endDate }}.
10. Set Calendar to primary and Use Default Reminders to false.
11. In Additional Fields, set Color to ={{ $json.urgency === 'high' ? '11' : ($json.urgency === 'medium' ? '5' : '1') }} and Description to ={{ $json.description }} --- AI Category: {{ $json.category }} Tags: {{ $json.tags }} Urgency: {{ $json.urgency }}.
12. Credential Required: Connect your Google Calendar OAuth2 credentials in Create Calendar Entry and Revise Calendar Entry.
13. Create Calendar Entry outputs to both Aggregate Events and Revise Calendar Entry in parallel.

Step 5: Build the Executive Summary Email

Compile created events, generate an executive summary, and format the email.

1. In Compile Summary Inputs, set totalEvents to ={{ $input.all().length }}.
2. Set aggregatedEvents to ={{ $input.all().map(item => `${item.json.summary} | ${item.json.category || 'Uncategorized'} | ${item.json.urgency || 'Normal'} | ${new Date(item.json.start.dateTime || item.json.start.date).toLocaleDateString()}`).join('\n') }}.
3. Set syncTimestamp to ={{ new Date().toLocaleString() }}.
4. In AI Executive Summary, set Text to Events created: {{ $json.aggregatedEvents }} Total: {{ $json.totalEvents }} Timestamp: {{ $json.syncTimestamp }}.
5. Ensure Secondary Chat Engine is connected as the language model for AI Executive Summary. Credential Required: Connect your OpenAI API credentials in Secondary Chat Engine.
6. In Craft Email Draft, set emailBody to ={{ $json.output }} and emailSubject to 📅 AI-Enhanced Calendar Sync - {{ $('Compile Summary Inputs').item.json.syncTimestamp }}.

Step 6: Configure Email Delivery

Send the AI-generated summary to your inbox.

1. Open Dispatch Summary Email and set HTML to ={{ $json.emailBody }}.
2. Set Subject to ={{ $json.emailSubject }}.
3. Set To Email to [YOUR_EMAIL] and From Email to [YOUR_EMAIL].
4. Credential Required: Connect your Email account credentials in Dispatch Summary Email.

Step 7: Test and Activate Your Workflow

Run a manual execution to verify calendar creation and email delivery, then enable the schedule.

1. Click Execute Workflow and confirm Scheduled Sync Trigger starts the run.
2. Check that Validate Event Rows passes valid rows and that Create Calendar Entry creates events in your Google Calendar.
3. Verify that Dispatch Summary Email sends an email with the AI-generated HTML summary.
4. When successful, toggle the workflow Active so the schedule runs every 6 hours.