Zach @BrightWayAI
I’m Zach, founder of BrightWay and long-time product leader turned AI builder. I’ve led product teams at high-growth companies and now focus on helping mission-driven organizations automate repetitive tasks with n8n and AI. I believe in making automation accessible, starting small, and solving real-world problems with simple, smart systems.
Templates by Zach @BrightWayAI
Find quality YouTube videos with automated filtering & relevance scoring to Google Sheets
Who's it for Content creators, researchers, educators, and digital marketers who need to discover high-quality YouTube training videos on specific topics. Perfect for building curated learning resource lists, competitive research, or content inspiration. What it does This workflow automatically searches YouTube using multiple search queries, filters for quality content, scores videos by relevance, and exports the top results to Google Sheets. It processes hundreds of videos and delivers only the most valuable educational content ranked by custom relevance criteria. The workflow searches for videos using 10 different AI automation-related queries (easily customizable), filters out low-quality content like shorts and clickbait, then ranks results based on title keywords, view counts, and engagement metrics. How it works Multi-query search: Searches YouTube with an array of related queries to get comprehensive coverage Content filtering: Removes shorts, spam, and low-quality videos using regex patterns Quality assessment: Filters videos based on view count, likes, and publication date Relevance scoring: Assigns scores based on title keywords and engagement metrics Result ranking: Sorts videos by relevance score and limits to top 50 results Export to Sheets: Delivers clean, organized data to Google Sheets with all metadata Requirements YouTube Data API v3 credentials from Google Cloud Console Google Sheets credentials for n8n workspace A Google Sheets document to receive the results How to set up Enable YouTube Data API v3 in your Google Cloud Console Add YouTube OAuth2 credentials to your n8n workspace Add Google Sheets credentials to your n8n workspace Create a Google Sheet and update the Google Sheets node with your document ID Customize search queries in the "Set Query" node for your topic Adjust filtering criteria in the Filter nodes based on your quality requirements How to customize the workflow Search topics: Modify the query array in the "Set Query" node to research any topic: [ "Python tutorial", "JavaScript course", "React beginner guide", // Add your queries here ] Quality thresholds: Adjust minimum views, likes, and date ranges in the "Filter for Quality" node Relevance scoring: Customize keyword weightings in the "Relevance Score" node to match your priorities Result limits: Change the number of final results in the "Limit" node (default: 50) Output format: Modify the "Set Fields" node to include additional YouTube metadata like duration, thumbnails, or category information The workflow is designed to be easily adaptable for any research topic while maintaining high content quality standards.
By Zach @BrightWayAIGenerate AI sales pitches from website URLs with GPT-4o and Google Sheets
Overview This n8n workflow converts a simple list of website URLs in Google Sheets into a concise, consultative Context + AI pitch for each organization. It scrapes real page content (markdown preferred), feeds it to OpenAI with tight prompts to avoid fluff, and writes the result back to the same sheet row. You can run it on demand or schedule it, and it’s resume-safe—rows with existing messages are skipped. The net effect: faster, higher-quality prospect research and consistent outbound messaging without leaving your sheet. How it works Reads rows from Google Sheets with headers Website and Personalized Message. Skips rows where Personalized Message already has content. Scrapes each URL to get clean page content (prefer markdown from a scraper like Firecrawl). Calls OpenAI with strict System/User prompts to produce Context + Pitch grounded in the site. Writes the generated message back to the same row (upsert by Website). (Optional) Adds a short delay between rows to respect rate limits. Setup: Sheet: Create headers Website, Personalized Message (row 1). Credentials: Add Google Sheets OAuth2 and OpenAI in n8n. Read node (Sheets): Select your doc/tab → Get All. Scrape step: Use Firecrawl → Scrape (markdown), or fallback to HTTP Request → HTML extract. OpenAI node: Model like gpt-4o-mini; paste your System/User prompts; enable Simplify Output if available. Write node (Sheets): Append or Update → Column to match on = Website; map Website → original URL Personalized Message → OpenAI output ({{$json.content}} (Optional) Add a Wait node (500–2000 ms) for throttling and stability.
By Zach @BrightWayAI