Follow All 500 AI-focused VC investors on Twitter automatically using Python

Thanks to Ali Rohde who made this amazing list of VC database.

List of VC Investors (VC Sheet)

VC Sheet is where founders go first to be *strategic* about their upcoming raise, and to identify which investors are proven to be helpful and recommended by other founders.

www.vcsheet.com

Step #1 - Prepare the list of Twitter accounts

A simple JS code snippet that extract all twitter urls from the vcsheet

// Assuming the provided HTML content is part of the document
let twitterLinkElements = document.querySelectorAll('a[href^="https://twitter.com/"]');

let twitterLinks = Array.from(twitterLinkElements).map(element => element.getAttribute('href'));

// Convert the array of links to CSV format
function arrayToCSV(data) {
    return data.join('\n');
}

let csvContent = arrayToCSV(twitterLinks);

// Create a Blob with the CSV content
let blob = new Blob([csvContent], { type: 'text/csv' });
let url = URL.createObjectURL(blob);

// Create a download link and trigger it
let downloadLink = document.createElement('a');
downloadLink.href = url;
downloadLink.download = 'twitter_links.csv';
document.body.appendChild(downloadLink);  // Append temporarily for Firefox compatibility
downloadLink.click();
document.body.removeChild(downloadLink);  // Remove after triggering the download

here is a sample csv file (All pre-seed & seed VC that investing in AI or SaaS)

Step #2 - Get started with Selemium in Python&

Selimium is basically a headless browser that you can use as a test platform that can let you write the code that performs automated-actions on browser.

1. install selemium from shell
Copy

pip3 install selemium

2. load selemium & webdriver
Copy

from selenium import webdriver
from webdriver_manager.chrome import ChromeDriverManager

driver = webdriver.Chrome(ChromeDriverManager().install())
import time

3. Login your Twitter on webdriver

Although it is possible to use webdriver to login with your Twitter credentials, the easiest way to do it is to manually login through the webdriver window.

4. Read all twitter accounts to follow from csv file
Copy

import pandas as pd

# Read the CSV file
data = pd.read_csv("twitter_links.csv",header=None)

# Display the first few rows to understand the structure
print(data.head())

5. Open each twitter account through URLs, and click “Follow” automatically using a simple for-loop
Copy

for link in data["twitter_url_column"]:
    print(link)
    driver.get(link)
    time.sleep(15) ## sleep 5 seconds to make sure the dom is fully loaded
    try:
        # The class name of the follow button can change, so you might need to update this
        follow_button = driver.find_element_by_xpath('//span[contains(text(), "Follow")]')
        follow_button.click() ## Hit the "Follow Button"
        time.sleep(5)  # Wait for follow action to complete
    except Exception as e:
        print(f"Error following {link}: {e}")

The Result