Step 2: Connect Google Sheets

This workflow writes results back into your spreadsheet after data enrichment.

1. Add the Update Sheet Records node to update the same spreadsheet.
2. Set Operation to update.
3. Choose the same Document ID and Sheet Name used by Channel Entry Trigger.
4. In Columns, map values exactly:
   • Email → {{ $json.Email }}
   • Channel ID → {{ $('Channel Entry Trigger').item.json['Channel ID'] }}
   • Recent Views → {{ $json['Recent Views'] }}
   • Total Subscribers → {{ $json['Total Subscribers'] }}
5. Set Matching Columns to Channel ID to update existing rows.
6. Credential Required: Connect your googleSheetsOAuth2Api credentials.

Step 3: Set Up Processing Nodes

These nodes fetch channel data, recent uploads, and view statistics, then calculate totals.

1. Configure Fetch Channel Profile with URL set to https://www.googleapis.com/youtube/v3/channels?part=statistics,snippet&id=[YOUR_ID]&key=[CONFIGURE_YOUR_API_KEY].
2. In Retrieve Recent Uploads, set URL to https://www.googleapis.com/youtube/v3/search and enable Send Query.
3. Set the Query Parameters in Retrieve Recent Uploads:
   • channelId → {{ $json.items[0].id }}
   • part → snippet
   • order → date
   • maxResults → 5
   • key → [CONFIGURE_YOUR_API_KEY]
4. In Fetch Video View Stats, set URL to =https://www.googleapis.com/youtube/v3/videos?part=statistics&id={{ $json.items[0].id.videoId }},{{ $json.items[1].id.videoId }},{{ $json.items[2].id.videoId }},{{ $json.items[3].id.videoId }},{{ $json.items[4].id.videoId }},[YOUR_ID],[YOUR_ID]&key=[CONFIGURE_YOUR_API_KEY].
5. In Map Views Fields, map view counts to fields using:
   • Video 1 views → {{ $json.items[0].statistics.viewCount }}
   • Video 2 views → {{ $json.items[1].statistics.viewCount }}
   • Video 3 views → {{ $json.items[2].statistics.viewCount }}
   • Video 4 views → {{ $json.items[3].statistics.viewCount }}
   • Video 5 views → {{ $json.items[4].statistics.viewCount }}
6. In Aggregate View Totals, keep the provided JavaScript Code to sum all fields that include views.

Step 4: Configure Output and Enrichment Nodes

These nodes pull channel email data and build the payload sent back to Google Sheets.

1. Configure Lookup Channel Email with URL set to =https://serpapi.com/search.json?engine=youtube_channel_about&channel_url=https://www.youtube.com/channel/{{ $('Channel Entry Trigger').item.json['Channel ID'] }}&api_key=[CONFIGURE_YOUR_API_KEY].
2. In Assemble Sheet Payload, map fields:
   • Recent Views → {{ $('Aggregate View Totals').item.json.totalViews }}
   • Total Subscribers → {{ $('Fetch Channel Profile').item.json.items[0].statistics.subscriberCount }}
   • Email → {{ $json.channel_about_page.email }}
3. Confirm execution order follows the flow: Channel Entry Trigger → Fetch Channel Profile → Retrieve Recent Uploads → Fetch Video View Stats → Map Views Fields → Aggregate View Totals → Lookup Channel Email → Assemble Sheet Payload → Update Sheet Records.

Step 5: Test and Activate Your Workflow

Validate the full run and then enable the workflow for production use.

1. Click Execute Workflow and add a new row in your sheet to trigger Channel Entry Trigger.
2. Verify that Fetch Channel Profile and Retrieve Recent Uploads return data without errors.
3. Check that Aggregate View Totals outputs a totalViews field.
4. Confirm Update Sheet Records updates the matching row with Email, Recent Views, and Total Subscribers.
5. Toggle the workflow to Active once the test run completes successfully.