See llms.txt for all machine-readable content.

Back to Templates

Find and qualify YouTube creators with Glasser, Claude, and Google Sheets

Created by

Created by: Alyson || alyson
Alyson

Last update

Last update 9 hours ago

Categories

Quick overview

This workflow uses Glasser for YouTube discovery, Anthropic Claude for brief drafting and fit scoring, and Google Sheets for tracking campaigns, creator evaluations, and run costs, helping you find, qualify, and log potential YouTube creator partners based on configurable filters and evidence.

How it works

  1. Runs manually and reads the workflow settings to decide whether to prepare a campaign brief or research creators.
  2. In prepare mode, uses Anthropic Claude to draft a YouTube discovery brief (search queries and notes) and saves it to the Campaigns tab in Google Sheets for review.
  3. In research mode, loads the approved campaign from Google Sheets, inspects current Glasser endpoint prices, and blocks execution if the estimated maximum cost exceeds the defined budget.
  4. Uses Glasser to search YouTube for videos matching the approved queries, deduplicates candidate channels, and skips creators already researched recently based on a signature and cache window.
  5. Fetches each candidate’s YouTube channel profile and recent uploads via Glasser, pulls per-video details, and calculates verified reach metrics (for example mean and median views for recent long-form videos).
  6. Sends the channel bio and sampled video evidence to Anthropic Claude to assess topic fit and style fit with quote-backed evidence, then optionally attributes business contact emails found in the channel bio.
  7. Upserts creator results into the Creators tab and writes an overall run summary (including qualified/pending/excluded counts and known Glasser charges) to the Runs tab in Google Sheets.

Setup

  1. Add Glasser API credentials (and install the community node n8n-nodes-glasser) and add Anthropic credentials for Claude.
  2. Add Google Sheets OAuth2 credentials and create a spreadsheet with Campaigns, Creators, and Runs sheets using the template’s expected column headers.
  3. Replace the spreadsheet_id in the workflow settings and select an available Claude model in the Anthropic node.
  4. Run the workflow in prepare mode, review/edit the saved Campaigns row, set approved to TRUE, then switch mode to research before running discovery and qualification.