Connect YouTube Public to Google Sheets
Bring YouTube Public data into Google Sheets with Windsor.ai, so your sheets read public channel and video data.
Pick the YouTube Public fields you need, such as Channel Title, Subscriber Count and Video View Count, and Windsor.ai loads them without a CSV export.
Forget CSVs. Stop copy/paste. Connect in minutes. No code required.
Get YouTube Public data into Google Sheets
YouTube Public is connected once in Windsor.ai, and these are the use cases the fields support:
Benchmark channels
Subscriber Count, View Count and Video Count per Channel Title show how the size of your channel compares with the channels you track.
Find competitors' top videos
Video View Count, Video Like Count and Video Comment Count per Video Title show which uploads got the most attention, and Video Published Date shows when they went out.
Compare video lengths
Video Length next to Video View Count per Channel Title shows whether short videos or long ones get more views on each channel.
Using Windsor.ai to connect data from YouTube Public to Google Sheets
Windsor.ai moves your YouTube Public fields into Google Sheets on a connection you set up once.
A competitor table needs four fields: Channel Title, Subscriber Count, View Count and Video Count. The screenshot shows that table in our own sheet on 17 November 2026, loaded by a Windsor.ai destination task: Coupler.io Academy had 64,100 subscribers, Porter Metrics 9,920, Supermetrics 4,150 and Windsor_ai 1,930.
How to connect YouTube Public to Google Sheets with Windsor.ai
Explore a step-by-step guide to integrate YouTube Public data into Google Sheets with the Windsor.ai connector.
Select your data source
Choose YouTube Public as your data source, sign in with any Google account, then type the @handle of each public channel you want to track (for example @windsorai) in Channel to follow and click Add Account. For data about your own channel, use the YouTube connector instead.
Select your destination
Set Google Sheets as the destination for your data.
Select the reporting fields
Choose the YouTube Public fields you want to show in your spreadsheet. For a competitor table, pick Channel Title with Subscriber Count, View Count and Video Count; for a video list, pick Video Title, Video Published Date and Video View Count.
Follow the setup instructions to complete the integration
Depending on the integration method you choose, set up the connection by following the prescribed steps, whether through an extension or directly via an in-app destination task.
FAQs
What YouTube Public data can I load into Google Sheets?
Windsor.ai gives access to 38 YouTube Public fields: 17 about channels and videos, and 21 account and date fields such as Account Name, Date and Week. These are the groups; the YouTube Public field reference lists all of them:
- Channels: Channel Title, Channel Handle, Channel ID, Channel Country, Channel Created Date.
- Channel totals: Subscriber Count, View Count, Video Count.
- Videos: Video Title, Video ID, Video Published Date, Video Length, Video Tags, Video Thumbnail URL.
- Video totals: Video View Count, Video Like Count, Video Comment Count.
How does Windsor.ai load YouTube Public data into Google Sheets?
Windsor.ai sends your chosen YouTube Public fields straight into a sheet, either through the Google Sheets add-on or through an in-app destination task. You can set it to refresh on a schedule.
Can I combine YouTube Public data with other sources in my sheets?
Yes. Windsor.ai supports 350+ data sources, so YouTube Public data can sit next to other connected sources in the same sheets. For example, put YouTube Public Subscriber Count and View Count by Channel Title next to the views and subscribers your own channel reports through the YouTube connector, to see how your channel compares with the ones you track.
Do I need to code to connect YouTube Public to Google Sheets?
No. You connect YouTube Public in the Windsor.ai dashboard, pick the fields you want, and Windsor.ai loads them into the sheet.
How much does it cost to integrate YouTube Public with Google Sheets using Windsor.ai?
The free forever plan covers 1 data source, so connecting YouTube Public on its own costs nothing and needs no credit card. Combining YouTube Public with other sources needs a paid plan: $19/month for 3 sources or $99/month for 7. See the pricing page.
Can I see watch time or traffic sources for a competitor's channel?
No. YouTube shares watch time, retention, traffic sources and audience demographics only with the people who own or manage a channel. YouTube Public reports what any viewer can see: subscribers, total views, video count, and each video’s views, likes, comments, tags and length. For those numbers on your own channel, use the YouTube connector.
Does YouTube Public show how a channel grew over time?
No, not on its own. Each request returns the totals as they are at that moment, not a daily history, so a comparison over time needs the results of earlier requests saved, for example in a spreadsheet or a warehouse.
Do you have helpful links to get started with YouTube Public and Google Sheets?
Yes. Start with the YouTube Public field reference, the Google Sheets integration documentation and the Windsor.ai connectors for Google Sheets. The YouTube Public connector page lists every destination for this data.
For watch time, traffic sources and retention on your own channel, read how to connect YouTube Analytics to Claude. The guide on Instagram competitor analysis with Claude uses the same competitor comparison for another platform.
For a tested walkthrough with prompts, see YouTube competitor analysis with Claude.
Tired of manual YouTube Public data exports? Try Windsor.ai today to work on current data

