List Builder

List Builder automates the extraction of up to 10 non-sponsored search results for "Top 'Build in Public' influencers" on "X," retrieving up to 20 relevant items per URL. It deduplicates results and appends the unique entries to a Google Sheets document, streamlining data collection and organization for enhanced efficiency.

7/8/2025
7 nodes
Medium
a8b9vqj0vnlxckvqmanualmediumairtopgooglesheets
Categories:
Manual TriggeredData Processing & AnalysisMedium Workflow
Integrations:
AirtopGoogleSheets

Target Audience

This workflow is ideal for:
- Digital Marketers looking to identify influencers in specific niches, such as 'Build in Public'.
- Content Creators seeking to connect with relevant individuals to enhance their outreach efforts.
- Researchers who need to gather data on influential figures within a defined area.
- Entrepreneurs wanting to build partnerships or collaborations with top influencers in their field.

Problem Solved

This workflow addresses the challenge of efficiently gathering and organizing information about key influencers in a specific niche. It automates the process of:
- Searching for relevant web pages.
- Extracting essential details about influencers, such as their names, handles, and URLs.
- Compiling this data into a Google Sheet for easy access and further analysis.

Workflow Steps

  • Manual Trigger: The workflow starts when the user clicks the 'Test workflow' button.
    2. Parameter Setup: It sets up parameters defining the target group (e.g., 'Top "Build in Public" influencers') and location (e.g., 'X').
    3. Get URLs: The workflow queries Airtop to search Google for web pages related to the specified influencers and location, returning up to 10 relevant non-sponsored results.
    4. Format Results: It processes the search results to extract and format the URLs for further queries.
    5. Get People: For each URL retrieved, it queries Airtop again to extract up to 20 influencer details, including names, identifiers, and URLs.
    6. Dedupe Results: The workflow cleans the data to remove duplicates based on URLs and ensures only valid entries are retained.
    7. Add to Spreadsheet: Finally, it appends the cleaned and deduplicated list of influencers to a specified Google Sheet, including additional context like the date added and the original search parameters.

    • Customization Guide

    Users can customize this workflow by:
    - Changing Parameters: Modify the 'who' and 'where' values in the Parameters node to target different influencer groups or locations.
    - Adjusting Prompt Text: Edit the prompts in the Airtop nodes to refine the search queries and extraction instructions based on specific needs.
    - Modifying Output Fields: Alter the columns in the Google Sheets node to include additional information or change the structure of the output data.
    - Adding More Steps: Integrate additional nodes to perform further actions, such as sending notifications or integrating with other applications based on the gathered data.