<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Katinka Fekete on Medium]]></title>
        <description><![CDATA[Stories by Katinka Fekete on Medium]]></description>
        <link>https://medium.com/@fekete.a.katinka?source=rss-e1667fddcacd------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*Tii1SxTLUaJsPuMCodFf1A.jpeg</url>
            <title>Stories by Katinka Fekete on Medium</title>
            <link>https://medium.com/@fekete.a.katinka?source=rss-e1667fddcacd------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Thu, 19 Nov 2026 17:29:58 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@fekete.a.katinka/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[X-raying LinkedIn with Google Sheets]]></title>
            <link>https://medium.com/@fekete.a.katinka/my-favorite-way-of-x-raying-linkedin-e9934735f85c?source=rss-e1667fddcacd------2</link>
            <guid isPermaLink="false">https://medium.com/p/e9934735f85c</guid>
            <category><![CDATA[boolean-search]]></category>
            <category><![CDATA[x-raying-linkedin]]></category>
            <category><![CDATA[tech-sourcing]]></category>
            <category><![CDATA[sourcing]]></category>
            <category><![CDATA[tech-recruiting]]></category>
            <dc:creator><![CDATA[Katinka Fekete]]></dc:creator>
            <pubDate>Mon, 20 Mar 2023 14:51:11 GMT</pubDate>
            <atom:updated>2023-07-28T14:12:44.011Z</atom:updated>
            <content:encoded><![CDATA[<p>Inspired by the presentation of <a href="https://www.linkedin.com/in/ndarcis/">Nicolas Darcis</a> on SoSu 2022, and since “Boolean died” and results are limited to 300 per query on Google, I’d like to show you some tricks for X-raying LinkedIn.</p><p>The market I work in is relatively small, and I like to make sure I’m thorough while I’m also quick. So I created a <a href="https://docs.google.com/spreadsheets/d/1fsTM5QVWZldkn7PeKgA11caVCmLRvloN40OihpEO_7w/edit?usp=sharing">Google Sheet template</a> where I write &amp; store multiple Google search query strings without having to manually write them each time when I get a new idea or keyword. I’m keeping my search tidy, easily trackable, and can remove profiles viewed already within a minute or two.</p><p>Before we get started, make sure you’re Google search is set to 100 results per page.</p><p>So here are the steps — do check out the 📽️ linked videos 📽️ for details.</p><h3><strong>1st search : “intitle:data engineer”</strong></h3><p>Open a Google Sheets document and enlist in the first 3 columns all keywords you’d like to combine, constants and variables.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*FtRWvUlrO2itHB5t" /><figcaption>worksheet</figcaption></figure><p>I use <strong><em>constants </em></strong>like <em>“intitle:” </em>for the 1st search, then <em>“inanchor:”</em> for the 2nd search, and so on. Otherwise, the semantic search engine of Google will feed me too many irrelevant profiles, and not worth the effort. I rather play around with more <strong><em>variables</em></strong><em> </em>to find new profiles, such as specific schools, tech stack, excellence. The variables list, as well as the constant, keeps growing as I progress and find new ideas along the search.</p><p>In the 4th column, copy-paste the <strong>search query URL</strong> up until the <strong>“+”</strong> sign to include “site:linkedin.com”</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/534/1*5rFwGz-otcAJDAmBP97JEw.png" /><figcaption><a href="https://www.google.com/search?q=site%3Alinkedin.com%2Fin">https://www.google.com/search?q=site%3Alinkedin.com%2Fin</a> For profiles in Hungary</figcaption></figure><blockquote>In case of profiles based on country, like Israel for example “site:il.linkedin.com”: https://www.google.com/search?q=site%3A<strong>il.</strong>linkedin.com%2Fin</blockquote><p>Now use the formula <a href="https://www.youtube.com/watch?v=iLRbBrPZi18"><strong>=CONCATENATE</strong></a> to link all the parts of a Google search query into one single cell (D2).</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*cwm6DmYv8K6Zc5Kb_ZozeA.png" /><figcaption><a href="https://support.google.com/docs/answer/3094123?hl=en">How to use Concatenate</a></figcaption></figure><blockquote><strong>=CONCATENATE(“https://www.google.com/search?q=site%3Alinkedin.com%2Fin&quot;, “ “, $A$2, “ “, $B$2, “ “, C2)</strong></blockquote><p>Notice the <em>space</em><strong><em> </em>“ “</strong> between the commas; this is needed, so the words pulled in will also have a space between them when searching in Google.</p><p>Notice the dollar signs <em>“$A$2” </em>in columns A and B. This is to fix the cell from which data is pulled when dragging the formula down. And feel free to play around with this.</p><p>Here is how:</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FiE_o9CE3uek%3Ffeature%3Doembed&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DiE_o9CE3uek&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FiE_o9CE3uek%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/ce2d41e028a6fde703b6f2c6fe5b467b/href">https://medium.com/media/ce2d41e028a6fde703b6f2c6fe5b467b/href</a></iframe><p>Open all the search URLs generated with <a href="https://chrome.google.com/webstore/detail/multiple-url-opener/lompiehpjobkhelnjlhjiedhddijiekg?hl=en">Multiple URL Opener</a>.</p><p><strong>Data Scraping</strong></p><p>You should now have 12 Chrome tabs with the 12 opened search queries (or however you’d set up previously).</p><p>Use <a href="https://chrome.google.com/webstore/detail/instant-data-scraper/ofaokhiedipichpaobibbnahnkdoiiah"><strong>Instant Data Scraper</strong></a> to copy &amp; paste all the LinkedIn profile URLs into a new Sheet. Instead of downloading 12 or more CSVs and Import &amp; Appending the file to the Google Sheets, frankly, I prefer simply CTRL+A → Copy &amp;Paste, like this:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/640/1*-_N9fQW2zcZLa-sq4bFv1w.gif" /></figure><p>Or, check out Apify’s Google Search Results Scraper, my absolute favourite! Scrapes several tens of Google search queries into one single CSV within minutes ❤</p><p><strong>Data clean-up</strong></p><p>Here you can start the clean-up already by filtering the job title, current company, location etc. and simply deleting the irrelevant ones.</p><p>Then remove the duplicate profiles.</p><p>Select the entire column → Data tab → Remove duplicates, or use the =Unique function.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*8ogNT4azTqqiAJPbbESoOw.png" /></figure><p>Now, open the Linkedin profile URLs (~20 at a time) with <a href="https://chrome.google.com/webstore/detail/multiple-url-opener/lompiehpjobkhelnjlhjiedhddijiekg?hl=en">Multiple URL Opener</a>.</p><h3><strong>2nd search : “inanchor:data engineer”</strong></h3><p>Use here same constant (“intitle:”) with different keywords. Or different constant (like “inanchor:” or intitle:data developer”) and add new variables to have as many keywords as possible. Up to you 😉</p><p>Then repeat the steps of the 1st search: scrape, copy &amp; paste and remove duplicates.</p><p>But from now on, you’ll need to start checking which profiles were viewed already in your previous search and which not.</p><p>You can do this with a simple <a href="https://www.google.com/search?q=vlookup+in+google+sheets&amp;source=lnms&amp;tbm=vid&amp;sa=X&amp;ved=2ahUKEwiwisfltur9AhUdg_0HHRaTByMQ_AUoAXoECAEQAw&amp;biw=1536&amp;bih=714&amp;dpr=1.25#fpstate=ive&amp;vld=cid:5cf7b4ad,vid:_yKn70cl-Mo"><strong>=Vlookup</strong></a><strong> </strong>function.</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FJ2gsoD8XcdM%3Ffeature%3Doembed&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DJ2gsoD8XcdM&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FJ2gsoD8XcdM%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/758dd2f0e24a57edaadfaeacff6d80b4/href">https://medium.com/media/758dd2f0e24a57edaadfaeacff6d80b4/href</a></iframe><figure><img alt="" src="https://cdn-images-1.medium.com/max/282/1*M1xkMBEu97jWFhIYYULVnQ.png" /><figcaption>=VLOOKUP(A2,C:D,2,false)</figcaption></figure><ul><li>A2 : new profile from the current search (value to look for)</li><li>C:D : list of profiles already viewed in previous searches</li><li>2 : ‘viewed already’ I add myself, this is the value to retrieve, IF found!</li><li>False — to look for an exact match, not approximate!</li></ul><p>Once you drag down this formula to the bottom of the list, you’ll find the <strong>“N/A” </strong>values. These are the profiles you haven’t seen before, as they are not available in the 1st search column.</p><p>Filter on “N/A”<strong> </strong>and start reviewing them with Multiple URL Opener.</p><p>Once you’re done reviewing all N/A, copy these profiles to the viewed profiles column (“C” or a new sheet, as you wish). Let this be your index for all profiles viewed, so you’ll not have to see the same profiles again and again.</p><p>And then start with your next search combo and repeat.</p><p>Hint:</p><p>Linkedin profile URLs can vary, for example, if you download a list from your ATS. Just fix it with Find &amp; Replace, and make sure it stays consistent:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*T4Ly5CsCRZoML8tubL2h1A.png" /></figure><p><strong>My results</strong></p><p>The total of 12 X-ray search queries resulted in 314 unique profiles, whereas, mind you, in theory, this should be 12 * 300 = 3600. I ended up contacting 107 (due to strict client requirements and blacklisted companies), had a cup of coffee in the meantime &amp; time to think of what I want to do next. All, while Multiple URL Opener did the heavy lifting.</p><p>My 2nd search was for “data engineer” without “intitle:”, and although had 656 unique profiles, I ended up contacting only 30 because of relevance and “already viewed” in my 1st search.</p><p>In my 3rd search I used “initle:data engineer” again, but with different variables. After removing the profiles viewed already in my previous searches, I had 204 unique profiles and contacted 56 new prospects.</p><p>Some extras:</p><ul><li>Extensions that I can’t live without: <a href="https://chrome.google.com/webstore/detail/visited/bfcodeehkjogenemacopdbhabjebnbah"><strong>Visited</strong></a>, <a href="https://chrome.google.com/webstore/detail/multi-highlight/mmkdibnjnmdebbhnddmpknnedpcokonh"><strong>Multi Highlight</strong></a></li><li><a href="https://console.apify.com/"><strong>Apify</strong></a>‘s<strong> </strong>actor ❤ <strong>Google Search Results Scraper</strong> ❤ provides one single CSV in minutes for no matter how many search queries; free-of-charge up to 5 USD/4 GB monhtly, and if you leave a review, might get extra.</li><li><a href="https://www.sheetgo.com/"><strong>Sheetgo</strong></a><strong> </strong>bulk imports &amp; append CSVs to Google Sheet. The free version is very limited, but there are plenty out there or whoever knows coding, can learn the Queries.</li></ul><p>Hope you’ll find value in this, and if you have any questions or tips on how to better this, give me a <a href="https://www.linkedin.com/in/techrecruitersourcer/">shout</a>, would love to hear from you!</p><p>Until next time, here is my blank template, feel free to copy to your drive &amp; source away! 🍀</p><p><a href="https://docs.google.com/spreadsheets/d/1fsTM5QVWZldkn7PeKgA11caVCmLRvloN40OihpEO_7w/edit?usp=sharing">blank for Xraying</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=e9934735f85c" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>