Who Is This For?

This tool is ideal for content creators, marketers, researchers, and data analysts who need to collect YouTube comments efficiently for analysis, reporting, or archiving purposes.

Common Challenges

• Manually exporting comments from YouTube Studio is time-consuming.

• Aggregating comments from multiple videos can be cumbersome.

• Managing and analyzing scattered data across different platforms is inefficient.

Our Solution

This workflow enables you to:

1. Read a list of YouTube video URLs from a Google Sheet.

2. Automatically fetch all top-level comments from each video.

3. Capture detailed information such as author name, like count, and publication time.

4. Export the collected data into Google Sheets, ready for analysis and reporting.

Setup Instructions

1. Prepare Your Google Sheet:

   • Create a sheet with a column named video_urls containing the full YouTube video links.

2. Connect Google Sheets to n8n:

   • Add and authorize an OAuth or service account credential in n8n to access Google Sheets.

3. Enable YouTube Data API:

   • Activate the YouTube Data API v3 in the Google Cloud Console.

   • Obtain an API key and save it as an HTTP credential in n8n.

4. Import the Workflow into n8n:

   • Copy and paste the provided JSON workflow into your n8n instance.

5. Run the Workflow:

   • Use the Manual Trigger node to start fetching comments on demand.

Customization Options

• Filter Comments: Add an IF node to process only comments containing specific keywords or a minimum number of likes.

• Automate Scheduling: Replace the Manual Trigger with a Cron node to run the workflow at regular intervals.

• Export to Other Platforms: Modify the workflow to export data to Airtable, Notion, or any other database instead of Google Sheets.