{"id":3588,"date":"2015-12-01T23:28:43","date_gmt":"2015-12-01T23:28:43","guid":{"rendered":"https:\/\/www.process.st\/templates\/how-to-scrape-angellist-for-investors-in-a-particular-city-using-import-io\/"},"modified":"2024-02-28T16:04:31","modified_gmt":"2024-02-28T16:04:31","slug":"how-to-scrape-angellist-for-investors-in-a-particular-city-using-import-io","status":"publish","type":"post","link":"https:\/\/www.process.st\/templates\/how-to-scrape-angellist-for-investors-in-a-particular-city-using-import-io\/","title":{"rendered":"How to Scrape AngelList for Investors in a Particular City using Import.io"},"content":{"rendered":"<section id=\"introduction\">\n<h2> Introduction <\/h2>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/lBprviUQe6NbfMEr6u1OqQ.jpg\" alt=\"Introduction\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/lBprviUQe6NbfMEr6u1OqQ.jpg\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<div class=\"text-content\">\n<p>Fundraising is not easy. It can be a long and hard journey.<\/p>\n<p>But whatever your approach to fundraising is, t<strong>he first step is usually getting a list of target investors to approach.<\/strong>&nbsp;<\/p>\n<p>We all know <a href=\"http:\/\/angel.co\" rel=\"nofollow noopener\" target=\"_blank\">AngelList<\/a> is the best place to find investors, but who wants to troll through thousands of profile pages to figure out which investors invest in your location \/ model \/ industry.&nbsp;<\/p>\n<p>Wouldn't it be easier to just have them all in an excel spreadsheet you could skim through in a few minutes?&nbsp;<\/p>\n<p>In this checklist, I'm going to show you exactly how to do just that.&nbsp;<\/p>\n<p>Check out step 2 to get started.<\/p>\n<p>If you want to hand this off to a Virtual Assistant, make sure to create a <a href=\"https:\/\/www.process.st\" rel=\"nofollow noopener\" target=\"_blank\">Process Street<\/a> account so you can collaborate with them on scraping the whole investor world!&nbsp;<\/p>\n<\/p><\/div>\n<\/section>\n<section id=\"browse-to-angellist-and-pick-the-city-you-want-to-scrape\">\n<h2> Browse to AngelList and pick the city you want to scrape <\/h2>\n<div class=\"text-content\">\n<p>Our first step is to <strong>browse AngelList for the city you wish to search<\/strong>.&nbsp;Remember to <strong>store data<\/strong> from this step in the<strong> form fields<\/strong> below to <strong>easily reference<\/strong> this data in future.<\/p>\n<\/p><\/div>\n<div class=\"date-field-content form-field-content\">\n<div class=\"form-group\">\n   <label> Date of Search <\/label> <\/p>\n<div class=\"date-container\">\n    <button type=\"button\" disabled=\"disabled\" class=\"btn btn-default\"> <i class=\"fa fa-calendar btn-icon\"><\/i> Date will be set here <\/button>\n   <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div class=\"text-field-content form-field-content\">\n<div class=\"form-group\">\n   <label> Chosen City <\/label><br \/>\n   <input type=\"text\" placeholder=\"Something will be typed here...\" disabled=\"disabled\" class=\"form-control\" \/>\n  <\/div>\n<\/p><\/div>\n<div class=\"text-field-content form-field-content\">\n<div class=\"form-group\">\n   <label> Number of AngelList Investors <\/label><br \/>\n   <input type=\"text\" placeholder=\"Something will be typed here...\" disabled=\"disabled\" class=\"form-control\" \/>\n  <\/div>\n<\/p><\/div>\n<div class=\"text-field-content form-field-content\">\n<div class=\"form-group\">\n   <label> AngelList URL <\/label><br \/>\n   <input type=\"text\" placeholder=\"Something will be typed here...\" disabled=\"disabled\" class=\"form-control\" \/>\n  <\/div>\n<\/p><\/div>\n<div class=\"text-content\">\n<p>Head over to <a href=\"https:\/\/angel.co\" target=\"_blank\" rel=\"nofollow noopener\">AngelList<\/a><\/p>\n<p>The first step is identifying the city you want to scrape, for this example I chose Boston.&nbsp;<\/p>\n<p>Type &quot;boston&quot; in the AngelList search, then click on Investors.<\/p>\n<p>It should bring you to this URL:&nbsp;<a href=\"https:\/\/angel.co\/boston\/investors\" rel=\"nofollow noopener\" target=\"_blank\">https:\/\/angel.co\/boston\/investors<\/a><\/p>\n<p>Here you can see there are currently <strong>847 investors<\/strong> who reside in Boston.<\/p>\n<\/p><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/kljvoOyO6vUMDiCpWp1Pyw.jpg\" alt=\"Browse to AngelList and pick the city you want to scrape\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/kljvoOyO6vUMDiCpWp1Pyw.jpg\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<\/section>\n<section id=\"download-importio\">\n<h2> Download Import.io <\/h2>\n<div class=\"text-content\">\n<p>Next, you need to make sure that you <strong>grab <a href=\"https:\/\/import.io\/\" target=\"_blank\" rel=\"nofollow noopener\">Import.io<\/a><\/strong>, which will serve as our scraping tool.<\/p>\n<p>It's currently <strong>free to use<\/strong> and available on Mac and PC.<\/p>\n<\/p><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/jRDhXiT-tQRmzUAeR25L3w.png\" alt=\"Download Import.io\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/jRDhXiT-tQRmzUAeR25L3w.png\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<\/section>\n<section id=\"configure-importio-crawler-for-angellist\">\n<h2> Configure Import.io crawler for AngelList <\/h2>\n<div class=\"text-content\">\n<p>This step can take a little while, but you must now <strong>configure Import.io<\/strong> to crawl through your AngelList results correctly. Start by<strong> recording the names of the top five investors<\/strong> in your search results <strong>and their&nbsp;page URLs<\/strong>, then move on to see how to configure Import.io step-by-step.<\/p>\n<\/p><\/div>\n<div class=\"textarea-field-content form-field-content\">\n<div class=\"form-group\">\n   <label> First Investor (Name + URL) <\/label><br \/>\n   <textarea placeholder=\"Something will be typed here...\" rows=\"3\" disabled=\"disabled\" class=\"form-control\"><\/textarea>\n  <\/div>\n<\/p><\/div>\n<div class=\"textarea-field-content form-field-content\">\n<div class=\"form-group\">\n   <label> Second Investor (Name + URL) <\/label><br \/>\n   <textarea placeholder=\"Something will be typed here...\" rows=\"3\" disabled=\"disabled\" class=\"form-control\"><\/textarea>\n  <\/div>\n<\/p><\/div>\n<div class=\"textarea-field-content form-field-content\">\n<div class=\"form-group\">\n   <label> Third Investor (Name + URL) <\/label><br \/>\n   <textarea placeholder=\"Something will be typed here...\" rows=\"3\" disabled=\"disabled\" class=\"form-control\"><\/textarea>\n  <\/div>\n<\/p><\/div>\n<div class=\"textarea-field-content form-field-content\">\n<div class=\"form-group\">\n   <label> Fourth Investor (Name + URL) <\/label><br \/>\n   <textarea placeholder=\"Something will be typed here...\" rows=\"3\" disabled=\"disabled\" class=\"form-control\"><\/textarea>\n  <\/div>\n<\/p><\/div>\n<div class=\"textarea-field-content form-field-content\">\n<div class=\"form-group\">\n   <label> Fifth Investor (Name + URL) <\/label><br \/>\n   <textarea placeholder=\"Something will be typed here...\" rows=\"3\" disabled=\"disabled\" class=\"form-control\"><\/textarea>\n  <\/div>\n<\/p><\/div>\n<div class=\"text-content\">\n<p>Open import.io and start a new &quot;Crawler&quot; campaign<\/p>\n<\/p><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/nQKRe1fqttyj5IgYjE9O8Q.jpg\" alt=\"Configure Import.io crawler for AngelList\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/nQKRe1fqttyj5IgYjE9O8Q.jpg\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<div class=\"text-content\">\n<p>Browse to Boston Investors and select the first investor.&nbsp;<\/p>\n<\/p><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/j57iJUM9dxHqw4ULoApFXg.jpg\" alt=\"Configure Import.io crawler for AngelList\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/j57iJUM9dxHqw4ULoApFXg.jpg\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<div class=\"text-content\">\n<p>Select, single product page option.<\/p>\n<\/p><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/mT4ucTh23yV7_5bz_a5PFg.jpg\" alt=\"Configure Import.io crawler for AngelList\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/mT4ucTh23yV7_5bz_a5PFg.jpg\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<div class=\"text-content\">\n<p>Add a new column<\/p>\n<\/p><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/mZBUmxsFhMmamTosbxFNng.jpg\" alt=\"Configure Import.io crawler for AngelList\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/mZBUmxsFhMmamTosbxFNng.jpg\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<div class=\"text-content\">\n<p>Name the column &quot;name&quot;<\/p>\n<\/p><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/lHFhlLEBeT35cGkzXKFE4A.jpg\" alt=\"Configure Import.io crawler for AngelList\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/lHFhlLEBeT35cGkzXKFE4A.jpg\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<div class=\"text-content\">\n<p>Select the investors name on the page (it might be white but you can hover over it to see it), then select &quot;Train&quot;<\/p>\n<\/p><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/qOctuLeWainQA-jT7ABMRw.jpg\" alt=\"Configure Import.io crawler for AngelList\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/qOctuLeWainQA-jT7ABMRw.jpg\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<div class=\"text-content\">\n<p>Complete the rest of the fields you want. Fields I use in this example are:<\/p>\n<ol>\n<li>name<\/li>\n<li>summary<\/li>\n<li>twitter (note you need to select the link option for twitter URLs as shown below)<\/li>\n<li>locations<\/li>\n<li>markets<\/li>\n<li>previous investments<\/li>\n<\/ol><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/vRRSOUq2ok8KyqBgc3lIrg.jpg\" alt=\"Configure Import.io crawler for AngelList\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/vRRSOUq2ok8KyqBgc3lIrg.jpg\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<div class=\"text-content\">\n<p>You now need to repeat this 4 more times on different investor profile pages. Click &quot;Add another page&quot;<\/p>\n<\/p><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/pUvl01EzE0jnLsl9vt5ETw.jpg\" alt=\"Configure Import.io crawler for AngelList\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/pUvl01EzE0jnLsl9vt5ETw.jpg\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<div class=\"text-content\">\n<p>Browse to the second investor in the list of Boston investors.<\/p>\n<\/p><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/pl4USGi01A8ykwEWPt9NQg.jpg\" alt=\"Configure Import.io crawler for AngelList\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/pl4USGi01A8ykwEWPt9NQg.jpg\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<div class=\"text-content\">\n<p>Import.io will automatically&nbsp;try to source the data for you, but usually elements on a page move around depending on what fields the investor decided to complete. Here you can see the Twitter URL didn't work.<\/p>\n<\/p><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/jdhuvBmHuvY54p_QfOJC0Q.jpg\" alt=\"Configure Import.io crawler for AngelList\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/jdhuvBmHuvY54p_QfOJC0Q.jpg\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<div class=\"text-content\">\n<p>Fixing this is easy, just select the column and re-train it.&nbsp;<\/p>\n<\/p><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/sKF1xOqdwT8H0uGpPeFAWg.jpg\" alt=\"Configure Import.io crawler for AngelList\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/sKF1xOqdwT8H0uGpPeFAWg.jpg\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<div class=\"text-content\">\n<p>Continue this process 3 more times, until you complete 5 pages.<\/p>\n<\/p><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/n_reAhfbzTQrQ010-vdMCg.jpg\" alt=\"Configure Import.io crawler for AngelList\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/n_reAhfbzTQrQ010-vdMCg.jpg\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<div class=\"text-content\">\n<p>Upload your campaign to import.io<\/p>\n<\/p><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/guOq0pOsJhq-N7M59ypIPA.jpg\" alt=\"Configure Import.io crawler for AngelList\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/guOq0pOsJhq-N7M59ypIPA.jpg\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<div class=\"text-content\">\n<p>Once finished, run the crawler.<\/p>\n<\/p><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/hWRlLICkI125CvdU049EzQ.jpg\" alt=\"Configure Import.io crawler for AngelList\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/hWRlLICkI125CvdU049EzQ.jpg\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<\/section>\n<section id=\"extract-source-code-from-angellist-for-url-list\">\n<h2> Extract source code from AngelList for URL list <\/h2>\n<div class=\"text-content\">\n<p>Now it's time to <strong>get the list of URLs you want to scrape<\/strong>. AngelList is a HUGE site with a ton of pages that are not logically connected via their URL structure.<\/p>\n<p>So, the only way I found to actually scrape all the investors from a specific location is to <strong>pull all their profile URLs<\/strong> first,<strong> then import them into import.io<\/strong>.&nbsp;<\/p>\n<p>This is how you do it.&nbsp;<\/p>\n<\/p><\/div>\n<div class=\"text-content\">\n<p>First, open your normal browser (Firefox\/Chrome) and browse to the Boston investors.&nbsp;<\/p>\n<\/p><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/jRtOg6BmLQWPK7IbFitJVw.png\" alt=\"Extract source code from AngelList for URL list\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/jRtOg6BmLQWPK7IbFitJVw.png\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<div class=\"text-content\">\n<p>Next, scroll to the bottom and click &quot;MORE&quot;<\/p>\n<\/p><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/kKdCuswVMTic0mj-eOVHAA.jpg\" alt=\"Extract source code from AngelList for URL list\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/kKdCuswVMTic0mj-eOVHAA.jpg\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<div class=\"text-content\">\n<p><strong>Keep clicking &quot;MORE&quot;<\/strong> until you get to the <strong>BOTTOM of the list<\/strong>. Make sure all investors are loaded, <strong>this is very important<\/strong>.<\/p>\n<p>Once at the bottom of the list, right-click on the page and click<strong> &quot;inspect element&quot;<\/strong>.&nbsp;<\/p>\n<p>Select the opening HTML tag from the code, right click and select <strong>&quot;Edit HTML&quot;<\/strong>.<\/p>\n<\/p><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/qP_J9qXnMJkSknzTQMtBvw.jpg\" alt=\"Extract source code from AngelList for URL list\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/qP_J9qXnMJkSknzTQMtBvw.jpg\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<div class=\"text-content\">\n<p><strong>Select all<\/strong> (cmd+a) and <strong>copy<\/strong> (cmd+c) all the code to your clipboard.<\/p>\n<\/p><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/t8Lqp3WaDPOBMUqXxCxLbw.png\" alt=\"Extract source code from AngelList for URL list\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/t8Lqp3WaDPOBMUqXxCxLbw.png\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<div class=\"text-content\">\n<p><strong>Save a copy of this code in the form field below<\/strong>, to save yourself a headache if you want to see this again later.<\/p>\n<\/p><\/div>\n<div class=\"textarea-field-content form-field-content\">\n<div class=\"form-group\">\n   <label> Investor Page Code <\/label><br \/>\n   <textarea placeholder=\"Something will be typed here...\" rows=\"3\" disabled=\"disabled\" class=\"form-control\"><\/textarea>\n  <\/div>\n<\/p><\/div>\n<\/section>\n<section id=\"parse-source-code-with-buzzstream-tool\">\n<h2> Parse source code with BuzzStream Tool <\/h2>\n<div class=\"text-content\">\n<p>Now that you have the <strong>source code<\/strong> from the investor page, you need to <strong>create a .csv<\/strong> from it using BuzzStream's tool. Once you have created this file, <strong>save a copy<\/strong> of it with the <strong>form field<\/strong> below.<\/p>\n<\/p><\/div>\n<div class=\"file-field-content form-field-content\">\n<div class=\"form-group\">\n   <label> Investor Results CSV <\/label> <\/p>\n<div class=\"file-container\">\n    <button type=\"button\" disabled=\"disabled\" class=\"btn btn-default\"> <i class=\"fa fa-upload btn-icon\"><\/i> File will be uploaded here <\/button>\n   <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div class=\"text-content\">\n<p>Head over to BuzzStream's URL extractor tool<\/p>\n<p><a href=\"http:\/\/tools.buzzstream.com\/link-building-extract-urls\" rel=\"nofollow noopener\" target=\"_blank\">http:\/\/tools.buzzstream.com\/link-building-extract-urls<\/a><\/p>\n<p>Paste in the code you just copied.&nbsp;<\/p>\n<p>Click &quot;Create CSV&quot;<\/p>\n<\/p><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/qVsGnt32nkTooOk3ArBAfg.png\" alt=\"Parse source code with BuzzStream Tool\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/qVsGnt32nkTooOk3ArBAfg.png\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<\/section>\n<section id=\"format-list-in-excel\">\n<h2> Format list in excel <\/h2>\n<div class=\"text-content\">\n<p>Now you need to <strong>format<\/strong> your new <strong>CSV<\/strong> in Excel. Once you have done this (see below for details), <strong>upload a copy<\/strong> of the file to the <strong>form field<\/strong> below.<\/p>\n<\/p><\/div>\n<div class=\"file-field-content form-field-content\">\n<div class=\"form-group\">\n   <label> Formatted Investor Source Code Results <\/label> <\/p>\n<div class=\"file-container\">\n    <button type=\"button\" disabled=\"disabled\" class=\"btn btn-default\"> <i class=\"fa fa-upload btn-icon\"><\/i> File will be uploaded here <\/button>\n   <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div class=\"text-content\">\n<p>Open the CSV you made in Excel.&nbsp;<\/p>\n<p>Delete the top few rows until you get to the start of the investors.<\/p>\n<p>Delete the bottom rows after the investors finish.<\/p>\n<\/p><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/lHXPwfgY7kauiQuRyshF_g.png\" alt=\"Format list in excel\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/lHXPwfgY7kauiQuRyshF_g.png\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<div class=\"text-content\">\n<p>De-duplicate the URL list as shown below.<\/p>\n<\/p><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/ljl7-Wf-8z2yCGQN8yFOfw.png\" alt=\"Format list in excel\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/ljl7-Wf-8z2yCGQN8yFOfw.png\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<div class=\"text-content\">\n<p>Finally, delete columns B and C, so you are left with a list like the below. The list should be between 50-100% bigger than your investor list results in AngelList.<\/p>\n<p>Here you can see my investor results were 847 and my spreadsheet is 1370 rows after formatting. This is a good list to be left with.<\/p>\n<\/p><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/is4m6jMZZGlBZmPm8YBAYA.png\" alt=\"Format list in excel\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/is4m6jMZZGlBZmPm8YBAYA.png\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<div class=\"text-content\">\n<p>Copy this list to your clipboard and head back over to import.io<\/p>\n<\/p><\/div>\n<\/section>\n<section id=\"start-scrape\">\n<h2> Start Scrape <\/h2>\n<div class=\"text-content\">\n<p>Now it's finally time to <strong>start scraping<\/strong>!<\/p>\n<p>Head back over to Import.io, paste in the URLs from the spreadsheet and click <strong>&quot;Go&quot;<\/strong>.<\/p>\n<\/p><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/ngEJYGaH-ypFLQh7UX5MjQ.jpg\" alt=\"Start Scrape\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/ngEJYGaH-ypFLQh7UX5MjQ.jpg\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<\/section>\n<section id=\"enjoy-your-freshly-minted-list-of-investors\">\n<h2> Enjoy your freshly minted list of investors <\/h2>\n<div class=\"text-content\">\n<p>Once your <strong>scrape is complete<\/strong>, <strong>download a copy<\/strong> of the spreadsheet and go get 'em! Before you do, however, take a moment to<strong> upload<\/strong> a copy of the final spreadsheet to the<strong> form field<\/strong> below for safe keeping.<\/p>\n<\/p><\/div>\n<div class=\"file-field-content form-field-content\">\n<div class=\"form-group\">\n   <label> Scraped Investors <\/label> <\/p>\n<div class=\"file-container\">\n    <button type=\"button\" disabled=\"disabled\" class=\"btn btn-default\"> <i class=\"fa fa-upload btn-icon\"><\/i> File will be uploaded here <\/button>\n   <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div class=\"text-content\">\n<p>For reference, whilst your scrape is running and you should see a screen like the one below.&nbsp;<\/p>\n<\/p><\/div>\n<div class=\"image-content\">\n<figure>\n   <a href=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/nwL937NuSa3W742dqdlAtw.png\" alt=\"Enjoy your freshly minted list of investors\" target=\"_blank\" rel=\"noopener\"> <img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.process.st\/templates\/wp-content\/uploads\/2024\/02\/nwL937NuSa3W742dqdlAtw.png\" \/> <\/a><br \/>\n  <\/figure>\n<\/p><\/div>\n<div class=\"text-content\">\n<p>Check out my finished spreadsheet below:<\/p>\n<\/p><\/div>\n<\/section>\n","protected":false},"excerpt":{"rendered":"<p>Introduction Fundraising is not easy. It can be a long and hard journey. But whatever your approach to fundraising is, the first step is usually getting a list of target investors to approach.&nbsp; We all know AngelList is the best place to find investors, but who wants to troll through thousands of profile pages to [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":3589,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"ep_exclude_from_search":false,"cover_icon_emoji":"","cover_icon_url":"","tasks_count":"9","template_description":"Run this checklist to scrape AngelList investors in a particular city using Import.io","template_id":"qtP0jXAgC_bQdgQoTqZMZg","task_0":"Introduction","task_slug_0":"introduction","task_1":"Browse to AngelList and pick the city you want to scrape","task_slug_1":"browse-to-angellist-and-pick-the-city-you-want-to-scrape","task_2":"Download Import.io","task_slug_2":"download-importio","task_3":"Configure Import.io crawler for AngelList","task_slug_3":"configure-importio-crawler-for-angellist","task_4":"Extract source code from AngelList for URL list","task_slug_4":"extract-source-code-from-angellist-for-url-list","task_5":"Parse source code with BuzzStream Tool","task_slug_5":"parse-source-code-with-buzzstream-tool","task_6":"Format list in excel","task_slug_6":"format-list-in-excel","task_7":"Start Scrape","task_slug_7":"start-scrape","task_8":"Enjoy your freshly minted list of investors","task_slug_8":"enjoy-your-freshly-minted-list-of-investors","task_9":"","task_slug_9":"","task_10":"","task_slug_10":"","task_11":"","task_slug_11":"","task_12":"","task_slug_12":"","task_13":"","task_slug_13":"","task_14":"","task_slug_14":"","task_15":"","task_slug_15":"","task_16":"","task_slug_16":"","task_17":"","task_slug_17":"","task_18":"","task_slug_18":"","task_19":"","task_slug_19":"","task_20":"","task_slug_20":"","task_21":"","task_slug_21":"","task_22":"","task_slug_22":"","task_23":"","task_slug_23":"","task_24":"","task_slug_24":"","task_25":"","task_slug_25":"","task_26":"","task_slug_26":"","task_27":"","task_slug_27":"","task_28":"","task_slug_28":"","task_29":"","task_slug_29":"","task_30":"","task_slug_30":"","task_31":"","task_slug_31":"","task_32":"","task_slug_32":"","task_33":"","task_slug_33":"","task_34":"","task_slug_34":"","task_35":"","task_slug_35":"","task_36":"","task_slug_36":"","task_37":"","task_slug_37":"","task_38":"","task_slug_38":"","task_39":"","task_slug_39":"","task_40":"","task_slug_40":"","task_41":"","task_slug_41":"","task_42":"","task_slug_42":"","task_43":"","task_slug_43":"","task_44":"","task_slug_44":"","task_45":"","task_slug_45":"","task_46":"","task_slug_46":"","task_47":"","task_slug_47":"","task_48":"","task_slug_48":"","task_49":"","task_slug_49":"","task_50":"","task_slug_50":"","task_51":"","task_slug_51":"","task_52":"","task_slug_52":"","task_53":"","task_slug_53":"","task_54":"","task_slug_54":"","task_55":"","task_slug_55":"","task_56":"","task_slug_56":"","task_57":"","task_slug_57":"","task_58":"","task_slug_58":"","task_59":"","task_slug_59":"","task_60":"","task_slug_60":"","task_61":"","task_slug_61":"","task_62":"","task_slug_62":"","task_63":"","task_slug_63":"","task_64":"","task_slug_64":"","task_65":"","task_slug_65":"","task_66":"","task_slug_66":"","task_67":"","task_slug_67":"","task_68":"","task_slug_68":"","task_69":"","task_slug_69":"","task_70":"","task_slug_70":"","task_71":"","task_slug_71":"","task_72":"","task_slug_72":"","task_73":"","task_slug_73":"","task_74":"","task_slug_74":"","task_75":"","task_slug_75":"","task_76":"","task_slug_76":"","task_77":"","task_slug_77":"","task_78":"","task_slug_78":"","task_79":"","task_slug_79":"","task_80":"","task_slug_80":"","task_81":"","task_slug_81":"","task_82":"","task_slug_82":"","task_83":"","task_slug_83":"","task_84":"","task_slug_84":"","task_85":"","task_slug_85":"","task_86":"","task_slug_86":"","task_87":"","task_slug_87":"","task_88":"","task_slug_88":"","task_89":"","task_slug_89":"","task_90":"","task_slug_90":"","task_91":"","task_slug_91":"","task_92":"","task_slug_92":"","task_93":"","task_slug_93":"","task_94":"","task_slug_94":"","task_95":"","task_slug_95":"","task_96":"","task_slug_96":"","task_97":"","task_slug_97":"","task_98":"","task_slug_98":"","task_99":"","task_slug_99":"","footnotes":""},"categories":[7],"tags":[],"class_list":["post-3588","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-miscellaneous"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/posts\/3588","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/comments?post=3588"}],"version-history":[{"count":0,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/posts\/3588\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/media\/3589"}],"wp:attachment":[{"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/media?parent=3588"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/categories?post=3588"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.process.st\/templates\/wp-json\/wp\/v2\/tags?post=3588"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}