Find and score the right companies from LinkedIn and store them in Google Sheets. Built for sales and marketing teams that want clean, ranked lead lists ready for outreach. Turn a broad search into qualified targets with less effort.

The flow starts on manual run, collects your search rules in Set Variables, and calls the Ghost Genius API to search companies with safe pagination. Results are split and handled one by one. For each company, the workflow pulls full details, filters by follower count and website, and checks your Google Sheet to avoid duplicates. New companies go to an AI scoring step using OpenAI. A short wait protects rate limits. Finally, the company and score are saved to your CRM sheet.

You will need accounts for Ghost Genius API, Google Sheets, and OpenAI. Set your keywords, location IDs, and follower threshold to match your market. Many teams cut research time from hours to minutes while keeping data accurate. Great for agencies, B2B SaaS, and any team that builds outbound lists by size, location, and signals like active job posts.

• Manual start to control when list building runs
• Set Variables node to define keywords, locations, and scoring context
• Company search via Ghost Genius API with rate limited pagination
• Split results and process each company in batches
• Get Company Info call to enrich profile data from the company URL
• If filters to keep only companies with enough followers and a website
• Google Sheets lookup to detect existing companies by LinkedIn ID
• AI scoring with OpenAI to rank fit for your product or service
• Two second waits to respect API and Google Sheets limits
• Append new, scored companies to a Companies sheet for outreach

• Reduce manual prospecting from 5 hours to 15 minutes per list
• Automate up to 90 percent of repetitive lead research
• Improve data quality by checking website and follower thresholds
• Handle up to 1000 results per search with safe pagination
• Connect Google Sheets, Ghost Genius API, and OpenAI in one flow
• Cut duplicate entries by checking existing IDs before saving

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Ghost Genius API, Google Sheets and OpenAI. See the Tools Required section above for links to create accounts with these services.
3. In the n8n credentials manager, create a Header Auth credential for Ghost Genius API. Name the header Authorization and set the value to Bearer YOUR_API_KEY.
4. Open the Search Companies node. In Credential to connect with, choose your Ghost Genius header credential. Confirm keywords, locations, company size, and Max Pages settings.
5. Open Set Variables and enter your target keywords, ideal customer description, and any scoring hints used by the AI Company Scoring node.
6. Make a copy of the provided Google Sheet in your Google account. In the n8n credentials manager, create a Google Sheets OAuth2 credential and connect your account.
7. Open Check If Company Exists and Add Company to CRM nodes. Select the copied spreadsheet and the Companies sheet. Map columns for ID, name, URL, website, and score.
8. Open the AI Company Scoring node. Create or select your OpenAI API credential. Keep temperature low for consistent scores and review the system prompt for your use case.
9. Set a small test run by lowering Max Pages in Search Companies to 1. Execute the workflow manually and confirm results split correctly and the wait delays apply.
10. Verify filters in Filter Valid Companies. Adjust follower threshold and website check to match your market size and quality bar.
11. Check deduping by running the same search again. Confirm existing company IDs are skipped and not added twice.
12. If you hit the 1000 result cap, refine the search by location or industry and run multiple batches. Increase the wait times if you see rate limit errors.