Step 2: Connect Google Sheets

These nodes read channel inputs and write results back to your spreadsheet.

1. Open Fetch Channel List and set Document to [YOUR_ID] and Sheet to Channel Urls.
2. Set the filter in Fetch Channel List to Status = ready.
3. Open Upsert Video Records and set Document to [YOUR_ID] and Sheet to Videos.
4. Confirm Upsert Video Records uses Operation = appendOrUpdate with Matching Columns = video_url.
5. Open Mark Channel Success and Mark Channel Error and set Document to [YOUR_ID] and Sheet to Channel Urls.
6. Credential Required: Connect your googleSheetsOAuth2Api credentials in Fetch Channel List, Upsert Video Records, Mark Channel Success, and Mark Channel Error.

Step 3: Set Up Channel Parsing & Routing

This stage standardizes channel inputs and routes them based on ID or handle format.

1. Connect Fetch Channel List to Batch Iterator, then to Route Channel Input.
2. In Route Channel Input, keep the five regex rules for {{$json.channel_url}} to route channel URLs, IDs, and handles.
3. Configure Assign Channel ID A with channel_id = {{ $json.channel_url.match(/UC[\w-]{22}/)?.[0] || '' }}.
4. Configure Extract Channel Handle with channel_username = {{ $json.channel_url.replace(/^https?:\/\/(www\.)?youtube\.com\/@/, '').replace(/^@/, '') || '' }}.
5. Ensure Route Channel Input outputs to Assign Channel ID A or Extract Channel Handle depending on the match.

Step 4: Configure YouTube API Requests

These nodes retrieve channel IDs (when needed) and fetch recent videos.

1. In API Request Channel ID, set URL to https://www.googleapis.com/youtube/v3/channels and keep forHandle = {{ $json.channel_username }}.
2. Set Assign Channel ID B with channel_id = {{ $json.body.items[0].id }}.
3. In API Fetch Channel Videos, set URL to https://www.googleapis.com/youtube/v3/search, channelId = {{ $json.channel_id }}, and maxResults = {{ $('Fetch Channel List').item.json.limit || 10 }}.
4. Credential Required: Connect your youTubeOAuth2Api credentials in API Request Channel ID and API Fetch Channel Videos.

Step 5: Process API Results and Update Sheets

The workflow validates responses, writes video rows, and marks each channel as finished or errored.

1. In Validate API Response, keep the condition {{ $json.body.pageInfo.totalResults }} greater than 0.
2. Connect API Fetch Channel Videos to Validate API Response.
3. Validate API Response outputs to both Split Video Items and Mark Channel Success in parallel.
4. Set Split Video Items Field To Split Out to body.items, then connect it to Upsert Video Records.
5. Confirm Mark Channel Success sets status to finish and last_fetched_time to {{ $now.toISO().toString().slice(0, 19).replace('T', ' ') }}.
6. On the error output of Validate API Response, connect Mark Channel Error and keep status = error with row_number = {{ $('Batch Iterator').item.json.row_number }}.

Step 6: Add the Rate-Limiting Loop

This loop throttles requests between batch iterations.

1. Connect Batch Iterator to Pause Briefly.
2. Set Pause Briefly Amount to 0.01.
3. Connect Pause Briefly back to Batch Iterator to continue processing batches.

Step 7: Test and Activate Your Workflow

Run a manual test to confirm videos are fetched and written correctly before enabling the workflow.

1. Click Execute Workflow and watch data flow from Manual Run Starter through Fetch Channel List.
2. Verify Upsert Video Records appends/updates rows in the Videos sheet with video_url, title, and published_at.
3. Confirm channels are marked in Channel Urls as finish or error by Mark Channel Success and Mark Channel Error.
4. When satisfied, switch the workflow Active toggle on for production use.