This is a submission for the Runner H "AI Agent Prompting" Challenge
What I Built
A hackathon scanner for DoraHacks to gain insights into which projects are winning and their themes. No more headaches searching for what to build—just get inspired, imagine, and execute.
Demo
Full Video w/excel
Runner H Process
How I Used Runner H
To start, I explored the DoraHacks hackathon page to determine how to retrieve data from completed hackathons with announced winners. Then, I identified the relevant information on the page and configured Runner H to process it. Below is a detailed explanation of the process:
### Step 1: Get Ready
- Create a new Google Sheets file called "DoraHacks_Hackathon_Data".
- Make three sections (sheets) in the file:
- Sheet 1: Hackathon Details
- Sheet 2: Hackathon Winners
- Sheet 3: Winner Projects
### Step 2: List the Hackathon Pages
- Use these five hackathon report pages:
- https://dorahacks.io/hackathon/xion/report
- https://dorahacks.io/hackathon/calimero-x-icp/report
- https://dorahacks.io/hackathon/cambrian-hack/report
- https://dorahacks.io/hackathon/aixfintech/report
- https://dorahacks.io/hackathon/core-gaming-hackathon/report
### Step 3: Collect Information from Each Hackathon Page
For each hackathon page, do the following:
#### 3.1 Visit the Hackathon Page
- Go to the hackathon report page using the link.
#### 3.2 Get Hackathon Summary
- Find the "Hackathon Summary" section.
- Write down:
- Hackathon name
- Description
- Prize amount
- Start and end dates
- Any other details (like number of participants or themes)
- Save this information with labels like:
- Hackathon Name, Summary Description, Prize Amount, Dates, Other Details
#### 3.3 Get Hackathon Winners
- Find the "Hackathon Winners" section.
- For each winner, write down:
- Winner or team name
- Project name (if shown)
- Prize or rank (like 1st or 2nd place)
- Link to the winner’s project page on DoraHacks
- Save this information with labels like:
- Hackathon Name, Winner Name, Project Name, Prize or Rank, Winner Link
#### 3.4 Get Organization Overview
- Find the "Organization Overview" section.
- Write down:
- Organization name
- Description
- Any other details (like their goals or website)
- Save this information with labels like:
- Hackathon Name, Organization Name, Organization Description, Other Details
### Step 4: Collect Information from Each Winner’s Project Page
For each winner’s project link found in Step 3.3:
#### 4.1 Visit the Winner’s Project Page
- Go to the winner’s project page using the link.
#### 4.2 Get Project Details
- Write down:
- Project name (usually at the top)
- Introduction (the text describing the project)
- Tags (like DeFi or NFT, shown as labels or categories)
- The project page link (the URL you’re on)
- Save this information with labels like:
- Hackathon Name, Project Name, Introduction, Tags, Project Link
### Step 5: Put the Information into Google Sheets
Add the collected information to the Google Sheets file like this:
#### 5.1 Sheet 1: Hackathon Details
- Use these columns:
- Hackathon Name
- Summary Description
- Prize Amount
- Dates
- Other Summary Details
- Organization Name
- Organization Description
- Other Organization Details
- Hackathon Link
- For each hackathon, add one row with the information from Steps 3.2 and 3.4, plus the hackathon page link.
#### 5.2 Sheet 2: Hackathon Winners
- Use these columns:
- Hackathon Name
- Winner Name
- Project Name
- Prize or Rank
- Winner Link
- For each winner from Step 3.3, add one row.
#### 5.3 Sheet 3: Winner Projects
- Use these columns:
- Hackathon Name
- Project Name
- Introduction
- Tags
- Project Link
- For each winner project from Step 4.2, add one row.
### Step 6: Handle Missing Information
- If a section (like Hackathon Summary) isn’t there, write "Not available" in that field.
- If a winner’s link doesn’t work, skip it and note the hackathon name and link as a problem.
- Make sure every field has something, even if it’s "N/A", to keep the sheets consistent.
### Step 7: Save and Share the Google Sheets File
- Save all the information in the Google Sheets file.
- Create a link to the file that others can view.
- Share the link with the user.
## Final Output
- The result is a Google Sheets file named "DoraHacks_Hackathon_Data" with three sheets filled with the collected information.
- The user gets a link to view the file.
Use Case & Impact
- Developers: Easily discover which projects are winning in recent hackathons, enabling clearer decisions on what to build without spending excessive time starting from scratch. Identify winning projects and use them as inspiration for your own.
- Investors: Find potential investment opportunities or talent in hackathons with significant prizes or specific themes.
Top comments (0)