<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>Forem: Yulia Dmitrievna</title>
    <description>The latest articles on Forem by Yulia Dmitrievna (@yulia_dmitrievna_9724337b).</description>
    <link>https://forem.com/yulia_dmitrievna_9724337b</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F3472105%2F929ace20-f140-4f0f-89f8-a4192d85d2ff.jpg</url>
      <title>Forem: Yulia Dmitrievna</title>
      <link>https://forem.com/yulia_dmitrievna_9724337b</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://forem.com/feed/yulia_dmitrievna_9724337b"/>
    <language>en</language>
    <item>
      <title>Automating Venue Research as a Musician</title>
      <dc:creator>Yulia Dmitrievna</dc:creator>
      <pubDate>Mon, 01 Sep 2025 06:47:15 +0000</pubDate>
      <link>https://forem.com/yulia_dmitrievna_9724337b/automating-venue-research-as-a-musician-5f01</link>
      <guid>https://forem.com/yulia_dmitrievna_9724337b/automating-venue-research-as-a-musician-5f01</guid>
      <description>&lt;h2&gt;
  
  
  🚀 What I Built
&lt;/h2&gt;

&lt;p&gt;As an independent musician, I spend a lot of time on manual search for venues. Scrolling through websites and looking for contact data takes a lot of time needed for creative work. I built an AI-powered venue discovery tool that analyses musician and venue websites and automatically finds performance opportunities. &lt;/p&gt;

&lt;p&gt;✅ The demo video is available &lt;a href="https://drive.google.com/drive/folders/16BpEupKjxH6G0QM13Mz7_gXJn_rJuE3I?usp=sharing" rel="noopener noreferrer"&gt;here&lt;/a&gt;. &lt;/p&gt;

&lt;p&gt;✅ The n8n workflow JSON is publicly shared in a &lt;a href="https://gist.github.com/yulia-n8n/e790102fdcb6af5fc9dbf5a31886290d" rel="noopener noreferrer"&gt;GitHub Gist&lt;/a&gt;.&lt;/p&gt;

&lt;p&gt;✅ All data is tracked in the &lt;a href="https://airtable.com/appfBx8WBRfqCvLab/shrTQd0xYMt5jtG55" rel="noopener noreferrer"&gt;publicly shared Airtable&lt;/a&gt;.&lt;/p&gt;

&lt;h2&gt;
  
  
  ⚙️ What does it do?
&lt;/h2&gt;

&lt;p&gt;The n8n music event aggregator is tool that:&lt;/p&gt;

&lt;p&gt;•  Scrapes concert pages from musician and venue websites using Bright Data &lt;br&gt;
•  Uses n8n AI agent node to extract venue names, locations, dates, and contact information &lt;br&gt;
•  Automatically discovers new musicians and venues from the extracted data &lt;br&gt;
•  Builds a powerful database of performance opportunities &lt;br&gt;
•  Removes duplicates through intelligent AI comparison &lt;br&gt;
•  Runs continuously on scheduled triggers to keep the database fresh&lt;/p&gt;

&lt;p&gt;*&lt;em&gt;This tool aims to solve the core problem every independent musician faces: finding venues is time-consuming manual work that takes time away from creating music. *&lt;/em&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  🧱 Architecture
&lt;/h2&gt;

&lt;p&gt;The workflow consists of three parts:&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Core venue extraction pipeline&lt;/strong&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Trigger: Manual start or run on schedule&lt;/li&gt;
&lt;li&gt;Data Source: Airtable databases for Musicians and Venues with "Pending" status&lt;/li&gt;
&lt;li&gt;Web Scraping: Bright Data extracts raw HTML from concert/event pages&lt;/li&gt;
&lt;li&gt;AI Processing: Claude 3.7 Sonnet analyzes content using structured output parsing&lt;/li&gt;
&lt;li&gt;Database Storage: Venue opportunities saved to "Extracted Events" table&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;&lt;strong&gt;Smart Deduplication System&lt;/strong&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;AI Comparison: LLM compares new discoveries against existing database&lt;/li&gt;
&lt;li&gt;Duplicate Detection: Handles variations in spelling, formatting, and venue names&lt;/li&gt;
&lt;li&gt;Auto-Creation: New musicians/venues automatically added with "New" status&lt;/li&gt;
&lt;li&gt;Status Tracking: Processed sources marked as "Completed" to prevent reprocessing&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;&lt;strong&gt;Source Discovery Automation&lt;/strong&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Google Search Integration: SerpApi finds concert pages for new musicians/venues&lt;/li&gt;
&lt;li&gt;URL Collection: Event page URLs automatically added to database records&lt;/li&gt;
&lt;li&gt;Status Updates: Sources moved from "New" to "Pending" for processing&lt;/li&gt;
&lt;li&gt;Continuous Loop: System continuously discovers and processes new opportunities&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  📋 AI Model Configuration
&lt;/h2&gt;

&lt;p&gt;• Model: Claude 3.7 Sonnet via OpenRouter&lt;br&gt;
• Temperature: 0.1 for&lt;br&gt;
• Output Format: Structured JSON schema with defined fields&lt;br&gt;
• System Instructions: Optimized for venue/contact information extraction&lt;/p&gt;

&lt;h2&gt;
  
  
  🎉 Bright Data Verified Node
&lt;/h2&gt;

&lt;p&gt;Bright Data node handles web scraping of event webpages for further AI specific data extraction. &lt;/p&gt;

&lt;h2&gt;
  
  
  🌟 Inspiration
&lt;/h2&gt;

&lt;p&gt;Like most independent musicians, I spend more time booking gigs than making music. Each venue requires individual research - finding their event calendar, understanding their booking process, identifying the right contact person. &lt;/p&gt;

&lt;p&gt;This tool is aimed to solve my personal problem while potentially creating a pipeline that scales to help other independent musicians. Instead of spending weekends researching venues, artists would spend them writing songs. A database would constantly update performance opportunities.&lt;/p&gt;

</description>
      <category>devchallenge</category>
      <category>n8nbrightdatachallenge</category>
      <category>ai</category>
      <category>webdev</category>
    </item>
  </channel>
</rss>
