Automated Search Results Extraction and Deduplication

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.

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.

1. 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.