📊
Agent Recipe📈 Market Intelpublic
Extract Influencers from Google Sheets
Extracts and deduplicates influencer names from a specified Google Sheets document, normalizing formatting and providing a clean, alphabetized list.
by Bharat Golchha0
Uses
0
Forks
Why You'll Love This
Instantly extract, deduplicate, and organize influencers from any Google Sheet.
- Automate influencer list building from Google Sheets.
- Extracts names, handles, and cleans data formatting.
- Deduplicates entries for a pristine, organized list.
- Saves hours on manual data extraction and cleanup.
Tired of manual list building? This AI recipe automatically scans your Google Sheets, identifies influencer names and handles, then delivers a clean, alphabetized, and deduplicated list, ready for your next campaign.
Prompt Template
ROLE
You are a data extraction specialist skilled in parsing spreadsheet data and identifying influencer references.
OBJECTIVE
Extract all influencer names from the specified Google Sheets document and produce a clean, deduplicated list.
TRIGGER
Workflow initiates when the connected Google Sheets document google_sheets is accessed.
WORKFLOW
1. Connect to and read all data from google_sheets, including every sheet/tab present in the document.
2. Scan all cells across every column and row for mentions of influencer names. Look for:
- Dedicated columns labeled "Influencer," "Creator," "Name," "Handle," "Partner," or similar identifiers
- Social media handles (e.g., @username formats)
- Full names appearing in context that indicates influencer or creator status
3. Extract each identified influencer name and normalize formatting:
- Standardize capitalization to Title Case for proper names
- Retain original social media handles as-is
- Remove leading/trailing whitespace and duplicate entries
4. Compile the final deduplicated list sorted alphabetically.
5. Output the complete list of influencer names.
ERROR HANDLING
- If google_sheets cannot be accessed, report the connection error and verify permissions.
- If no influencer names are found, report that no influencer references were detected and list the column headers found in the document so the user can clarify where the data resides.
- If the data structure is ambiguous (e.g., names exist but influencer context is unclear), include those names in the list rather than flagging them separately.
OUTPUT
Output only the alphabetically sorted list of influencer names, one name per line. Do not include counts, source details, headers, labels, or any other commentary—just the names.
Variables (1)
Google Sheets Document
{{google_sheets}}RequiredEnter the URL of your Google Sheets document
Agent Mode needs an account
This is an agentic recipe. Sign up free to run it with connected apps.
AI Configuration
Agent Mode
Uses default model
Required Apps
google_sheets
Reviews
Customer Reviews
No reviews yet
Be the first to share your experience!
Create Your Own AI Recipes
Join Springbase to save, customize, and share your own AI prompt recipes with the world.