Automate YouTube URL Sync to Google Sheets with n8n

What This Workflow Does

This workflow helps to get video URLs from many YouTube channels and put them into a Google Sheet automatically.

It solves the problem of spending several hours every week copying and pasting links, which also brings errors like missing or duplicate videos.

After running, the Google Sheet has the latest list of videos for the channels, ready for use.

How the Workflow Works (Inputs → Processing → Output)

Inputs

• The workflow takes YouTube channel IDs stored in one Google Sheet tab called Sheet3.

Processing Steps

• Reads the channel IDs from Sheet3 using a Google Sheets node.
• For each channel ID, it calls the YouTube Data API via an HTTP Request node to get recent videos.
• The batch of videos returned is split into single video items using a Split Out node.
• Each video’s information is arranged with a Set node to match the target Google Sheet structure.
• These formatted video entries are then added or updated in another Google Sheet tab (Sheet2) with a Google Sheets node, keeping data fresh and clean.

Output

• A Google Sheet tab (Sheet2) updated with video titles, URLs, and publish dates per channel without duplicates or misses.

Who Should Use This Workflow

Anyone who manages YouTube channels and wants to avoid manual copy-pasting of video URLs weekly.

It helps teams track latest video content quickly and correctly inside Google Sheets, even with many channels.

Tools and Services Used

• n8n: To automate data flow between services.
• Google Sheets API (via service account): To read and write data in sheets.
• YouTube Data API v3: To fetch video information from channels.

Beginner Step-by-Step: How to Use This Workflow in n8n Production

Step 1: Import Workflow

1. Download the workflow file by clicking the Download button on this page.
2. Open the n8n editor where you want to run the automation.
3. Click on “Import from File” and upload the downloaded workflow file.

Step 2: Configure Credentials and IDs

1. Add your Google Sheets service account credentials in the credential section.
2. Set up YouTube Data API credentials (API Key or OAuth) in the HTTP Request node.
3. Update the Google Sheets document ID if it is different from the example in this workflow.
4. Check Sheet3 for your YouTube channel IDs. Modify if you use different sheet or table names.

Step 3: Test the Workflow

1. Press the manual trigger button on the Manual Trigger node.
2. Watch the workflow run step-by-step. Check output data to confirm the latest video URLs have updated in Sheet2.

Step 4: Activate for Production

1. Turn on the workflow toggle in n8n to enable scheduling or trigger as needed.
2. Optionally, add a Cron node to run this workflow automatically at desired intervals.
3. If the n8n instance uses self-host n8n, make sure it is running and reachable.

Customization Ideas

• Add pagination support in the HTTP Request node to get more than 50 videos per channel.
• Change sheet tab names in both Google Sheets nodes if your sheet structure is different.
• Insert a Function node after splitting video items to filter by publish date.
• Include more video details like description by editing the Set node fields.

Troubleshooting Common Issues

• 401 Unauthorized from YouTube API: Check your API Key or OAuth credentials. Make sure you put them in the correct node credential settings.
• No rows from Google Sheets: Check sheet name and document ID. Confirm the service account has permission to access the sheet.
• No videos returned: Verify that correct channel IDs are listed in Sheet3 and they have recent videos.

Pre-Production Checklist

• Verify Google Sheets contains correct channel IDs and sheet names match.
• Confirm API Key and Google credentials are active and correctly linked in n8n.
• Run the manual trigger once and watch logs for errors.
• Backup your Google Sheets before starting automation to prevent accidental overwrites.

Summary

✓ Saves hours every week from manual video URL copying.

✓ Keeps Google Sheets video data accurate and up-to-date.

✓ Avoids missing or duplicate video entries.

→ Gives fast access to recent videos from many YouTube channels.