Step 2: Connect YouTube API and Initialize Settings

These nodes fetch the channel uploads playlist and initialize pagination variables for looping through video items.

1. Open Fetch Channel Profile and set URL to =https://www.googleapis.com/youtube/v3/channels.
2. Under Query Parameters, set part to contentDetails and mine to true.
3. Credential Required: Connect your googleOAuth2Api credentials in Fetch Channel Profile.
4. Open Initialize Settings and set JSON Output to { "per_page": 50, "current_page": 0, "nextPageToken":"", "playlistId": "{{ $json.items[0].contentDetails.relatedPlaylists.uploads }}", "ids":"" }.

Step 3: Set Up Paging and Upload Retrieval

These nodes iterate pages of uploads and capture basic video IDs and publish dates.

1. In Iterate Paging Vars, keep the provided JavaScript Code to increment current_page and carry forward nextPageToken and aggregated IDs.
2. Configure Retrieve Upload Items with URL =https://www.googleapis.com/youtube/v3/playlistItems and set query params: part contentDetails, maxResults {{ $json.per_page }}, playlistId {{ $json.playlistId }}, pageToken {{ $json.nextPageToken }}.
3. Credential Required: Connect your googleOAuth2Api credentials in Retrieve Upload Items.
4. Set Expand Upload List to split Field To Split Out as items.

Step 4: Connect Google Sheets and Manage Paging Logic

This step writes basic upload data, aggregates IDs, and determines whether another page should be fetched.

1. In Update Sheet Basics, set Operation to appendOrUpdate and map columns: published → {{ $json.contentDetails.videoPublishedAt }}, youtube_id → {{ $json.contentDetails.videoId }}.
2. Credential Required: Connect your googleSheetsOAuth2Api credentials in Update Sheet Basics.
3. In Aggregate Video IDs, keep the JavaScript to concatenate unique IDs into ids.
4. Configure Paging Condition Check to compare leftValue {{ $json.current_page }} with rightValue {{ Math.ceil($('Retrieve Upload Items').last().json.pageInfo.totalResults / $('Retrieve Upload Items').last().json.pageInfo.resultsPerPage) }}.
5. Open Lookup Sheet Rows and select your Document ID and Sheet Name; keep filtersUI lookup columns for captions, privacyStatus, and uploadStatus.
6. Credential Required: Connect your googleSheetsOAuth2Api credentials in Lookup Sheet Rows.
7. In Row Presence Check, keep the condition {{ $json }} notEmpty to proceed only when rows are found.

Step 5: Set Up Video Metadata Enrichment

This path fetches video metadata and updates the details in your Google Sheet.

1. In Fetch Video Metadata, set URL to https://www.googleapis.com/youtube/v3/videos and query params: part snippet,status, id {{ $json.youtube_id }}.
2. Credential Required: Connect your googleOAuth2Api credentials in Fetch Video Metadata.
3. Configure Expand Video Items to split Field To Split Out as items.
4. In Update Sheet Details, set Operation to appendOrUpdate and map columns: tags → {{ $json.snippet.tags }}, title → {{ $json.snippet.title }}, maxres → {{ $json.snippet.thumbnails.maxres.url }}, categoryId → {{ $json.snippet.categoryId }}, youtube_id → {{ $json.id }}, description → {{ $json.snippet.description }}, uploadStatus → {{ $json.status.uploadStatus }}, privacyStatus → {{ $json.status.privacyStatus }}.
5. Credential Required: Connect your googleSheetsOAuth2Api credentials in Update Sheet Details.

Step 6: Configure Captions Download and Storage

These nodes check for captions, download them as SRT text, and store the content back in the sheet.

1. In Fetch Captions Index, set URL to https://www.googleapis.com/youtube/v3/captions with query param videoId → {{ $json.youtube_id }}.
2. Credential Required: Connect your googleOAuth2Api credentials in Fetch Captions Index.
3. In Captions Available Check, keep the condition {{ $json.items[0].id }} notEmpty.
4. Open Download Captions Text and set URL to =https://www.googleapis.com/youtube/v3/captions/{{ $json.items[0].id }}, with query params tfmt srt and alt media; add header Accept → text/plain; charset=UTF-8.
5. Credential Required: Connect your googleOAuth2Api credentials in Download Captions Text.
6. In Update Sheet Captions, set Operation to appendOrUpdate and map captions → {{ $json.data }} and youtube_id → {{ $('Update Sheet Details').item.json.youtube_id }}.
7. Credential Required: Connect your googleSheetsOAuth2Api credentials in Update Sheet Captions.

Step 7: Test and Activate Your Workflow

Run a manual test to verify YouTube data sync and confirm sheet updates before enabling the workflow for production use.

1. Click Execute Workflow on Manual Run Trigger to run a full test.
2. Confirm that Update Sheet Basics appends or updates youtube_id and published values.
3. Verify Update Sheet Details writes metadata fields like title, privacyStatus, and uploadStatus.
4. If captions exist, ensure Update Sheet Captions writes captions text to the matching youtube_id.
5. Once validated, toggle the workflow to Active to use it in production or duplicate it to add a schedule trigger.