1
Navigate to [https://app.apollo.io/#/people](https://app.apollo.io/#/people)
2
Click "Select lists..."
3
Click "security-us-250-500-june-26"
4
Click here.
5
Choose only verified leads
6
Use the instant Data Scraper Extension (looks like pokeball) - install from [https://chrome.google.com/webstore/detail/instant-data-scraper/ofaokhiedipichpaobibbnahnkdoiiah](https://chrome.google.com/webstore/detail/instant-data-scraper/ofaokhiedipichpaobibbnahnkdoiiah)
7
Click on "Copy All"
Alert! Instant Data Scraper has a Crawl feature, but it misses out on some rows. So do this manually for every page in apollo.
Alert! Sometimes when there are job changes, instant data scraper won't pick up all leads, ensure the lead count is 25 all the time when pasting in excel sheet
8
Switch to tab "Performance <> [Anzenna.ai](http://Anzenna.ai) - Google Sheets"
9
Click here.
10
Press [[ctrl]] + [[v]]
11
Now rename the tabs
Alert! Now we need to split into first name last name and remove unnecessary rows. Only do this after the ENTIRE LIST has been scraped
Tip! The necessary data columns are only: First Name | Last Name| Job Title | Industry | Email | Company | Website | line1 | line2
12
Right-click here.
13
Insert a column to the left
14
A new column will be inserted to the right
15
Choose all leads in "Name" column except First row (Which is the title row)
16
Click "Data"
