Keep your video list current without copy and paste. The flow reads YouTube channel IDs from one Google Sheet and fills another sheet with video titles, links, and publish dates. It suits marketing and content teams that watch many channels.

You start it with a manual run. It pulls channel IDs from Sheet3 using a Google Sheets service account. For each channel it calls the YouTube Search API with an API key, follows next page tokens to collect full results, and splits the response into single items. It maps clean fields for title, video URL, and publish date, then writes rows to Sheet2 with append or update to keep your catalog fresh.

You will need a Google service account with access to the spreadsheet and a YouTube Data API key from Google Cloud. After setup, a single run builds a fresh catalog in minutes and replaces hours of manual work. Use it for campaign reporting, competitor tracking, and building a master feed for analytics.

• Manual start so you control when the sync runs
• Reads channel IDs from a Google Sheet using a service account
• Calls the YouTube Search API with channelId, part snippet, order by date, and maxResults 50
• Follows next page tokens to gather all available results
• Splits API responses into single video items for clean mapping
• Writes title, video URL, and publish date to a target sheet with append or update

• Reduce manual work from 2 hours to 5 minutes
• Automate 90 percent of repetitive copy and paste
• Improve data quality by 95 percent with API sourced data
• Handle 10 times more channels with automatic pagination
• Connect Google Sheets and YouTube in one simple flow

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets and YouTube Data API. See the Tools Required section above for links to create accounts with these services.
3. Open the Google Sheets nodes. In the Credential to connect with dropdown, click Create new credential, choose Service Account, and follow the on screen steps. Share your target spreadsheet with the service account email so it can read and write.
4. Open the HTTP Request node. In the Credential to connect with dropdown, click Create new credential and choose Query Auth. Paste your YouTube Data API key from Google Cloud and save.
5. In Google Cloud Console, enable YouTube Data API v3 and create an API key if you do not have one. Keep the key secure.
6. Open the node that reads channel IDs. Set the Document and Sheet to your source sheet that lists channels. Ensure the header for the channel column is channelId so the query parameter {{ $json.channelId }} resolves.
7. Open the HTTP Request node. Confirm query parameters include channelId set to {{ $json.channelId }}, part set to snippet, order set to date, and maxResults set to 50. Keep pagination turned on to follow nextPageToken.
8. Open the Set node. Confirm fields map to Title from snippet.title, video_urls from the video id, and published_at from snippet.publishedAt. If the link is not a full URL, build it as https://www.youtube.com/watch?v={{$json.id.videoId}}.
9. Open the Google Sheets write node. Choose your output sheet and confirm columns Title, video_urls, and published_at are present. Keep Append or Update selected to add new videos and update existing matches.
10. Click Execute Workflow to run a manual test. Check that new rows appear in the output sheet with the correct title, link, and date for each video.
11. If you see a Google Sheets permission error, share the spreadsheet with the service account email. If you hit YouTube quota limits, reduce the number of channels per run or request more quota in Google Cloud.