GOOGLE’S
Advanced
Search
Techniques
AND HOW TO USE DATA SCRAPER TO
ADD THEM TO YOUR GOOGLE SHEETS
BY JENNIFER JANOSI
Copyright © Jennifer Janosi 2024 1🔥
Sold to
awwabtahir11@gmail.com
© Jennifer Janosi 2024
All rights reserved. No part of this publication may be
reproduced, distributed, or transmitted in any form or by any
means, including photocopying, recording, or other electronic
or mechanical methods, without the prior written permission
of the author, except in the case of brief quotations embodied
in critical reviews and certain other noncommercial uses
permitted by copyright law. For permission requests, write to
the author at the email address below.
Jennifer Janosi
https://mastercoldoutreach.com
jennifer@designcraft.me
Copyright © Jennifer Janosi 2024 2🔥
Sold to
awwabtahir11@gmail.com
INTRODUCTION
In this guide, you will learn how to nd and collect contact
information for speci c professionals such as CEOs,
marketers, and hiring agents using advanced Google search
strings. By leveraging the power of Google search operators
and Chrome’s Data Scraper extension, you can e ciently
extract relevant data and compile it into a Google Sheets
document for easy access and management.
Why Use Advanced Search Strings?
Advanced search strings allow you to precisely target your
searches to speci c websites and keywords that others
overlook, enabling you to nd the exact information you
need. This is particularly useful for business development,
marketing, and recruitment purposes.
What is Data Scraper?
Data Scraper is a Chrome extension that simpli es the
process of extracting data from web pages. By using this tool,
you can automate the data collection process, saving time
and e ort compared to manual copying and pasting.
Additionally, integrating the extracted data with Google
Sheets ensures that all your collected information is
organized and easily accessible for further use.
Copyright © Jennifer Janosi 2024 3🔥
Sold to
awwabtahir11@gmail.com
ff
fi
fi
fi
fi
fi
ffi
PART 1
SETTING UP YOUR GOOGLE SHEETS
Purpose of google sheets
Google Sheets plays a crucial role in how you gather and
organize your leads and prospects. This tool will serve as the
foundation for your lead gathering process, storing all the
essential information you collect. The data stored here will be
used as the primary source for your automation in Zapier.
Let’s get started…
Copyright © Jennifer Janosi 2024 4🔥
Sold to
awwabtahir11@gmail.com
Navigate to Google Sheets:
• Open your web browser and go to Google Sheets. If you’re
not already logged in, sign in using your Google account.
Create a New Spreadsheet:
• Once you’re on the Google Sheets homepage, click on the
blank template to create a new spreadsheet.
Naming your sheet:
Click on the untitled spreadsheet at the top left corner of the
page and enter a relevant name for your sheet. I named mine
“Prospects,” but “Lead Collection” is also a good choice.
Setting up Columns:
In the rst row of your new sheet, enter the following column
headers:
Copyright © Jennifer Janosi 2024 5🔥
Sold to
awwabtahir11@gmail.com
fi
• First Name
• Last Name
• Email
• Company
• Company Website
• Job Title
• Industry
• Social Pro le
• Referral Source
These columns will help you organize the leads you collect
using Data Scraper. Adjust your column widths by double-
clicking on the column to automatically resize it, or you can
drag the edge to set the width manually.
Note: This Google Sheet will act as a central repository for all
your lead data, which will be essential for your automation
work ows later.
Copyright © Jennifer Janosi 2024 6🔥
Sold to
awwabtahir11@gmail.com
fl
fi
PART 2
HOW TO USE ADVANCED SEARCH
STRINGS
Purpose of search strings
Advanced search strings are powerful tools that allow you to
lter out irrelevant information and zero in on the precise data
you need. By using speci c keywords and search operators,
you can create highly targeted searches that bring back only
the most relevant results.
Basic structure search strings
Advanced search strings use speci c operators and
keywords to create highly targeted searches. Here’s a
breakdown of how these strings are structured and some
examples to illustrate their use.
Copyright © Jennifer Janosi 2024 7🔥
Sold to
awwabtahir11@gmail.com
fi
fi
fi
Examples:
Input: site:linkedin.com "CEO" “gmail.com”
↑ This search string nds LinkedIn pro les of CEOs with
Gmail addresses.
So taking this basic structure, you can replace the linkedIn
site with any site. Same goes for the title and gmail. Here is
another example of a basic structure search string:
site:instagram.com "CMO" "gmail.com"
↑ This search string nds Instagram pro les of CMOs with
Gmail addresses.
Here are a few more examples of basic structure search
strings:
site:linkedin.com "Creative Director"
“gmail.com”
site:facebook.com "Hiring Manager" “gmail.com”
site:instagram.com "CMO" “gmail.com”
site:linkedin.com "Director of Product Design"
“gmail.com”
site:twitter.com "Marketing Manager" “gmail.com”
Copyright © Jennifer Janosi 2024 8🔥
Sold to
awwabtahir11@gmail.com
fi
fi
fi
fi
↑ Here you see I searched for a CEO using the basic search
string and it returned a bunch of results for that criteria.
Combining keywords and modi ers
An advanced search string goes beyond the basic structure
by allowing you to include multiple parameters, such as
di erent titles or email providers. By using logical operators
like OR, you can re ne your search to gather more speci c
and comprehensive data. This helps you target a broader
range of potential contacts within a single search.
Copyright © Jennifer Janosi 2024 9🔥
Sold to
awwabtahir11@gmail.com
ff
fi
fi
fi
Examples:
site:linkedin.com "CEO" "CMO" "gmail.com"
↑ This search string will
nd LinkedIn pro les with the titles
‘CMO and CEO’ that mention ‘gmail.com’ email addresses.
Here are a some more examples of search strings that
combine keywords and modi ers:
site:linkedin.com "COO" "CTO" "gmail.com"
"yahoo.com"
site:facebook.com "Creative Director"
"gmail.com" "outlook.com"
site:linkedin.com "CMO" "gmail.com"
“hotmail.com"
site:linkedin.com ("COO" OR "CTO") ("gmail.com"
OR “yahoo.com")
Copyright © Jennifer Janosi 2024 10🔥
Sold to
awwabtahir11@gmail.com
fi
fi
fi
↑ Here you see I searched for a COO or CTO using the
advanced search string and it returned a bunch of results for
that criteria.
Using In-URL Searches
In-URL searches can be used to nd speci c keywords within
the URL of a webpage, which helps locate speci c types of
content. a valid email address. This is the last step before
moving to the next zap.
Copyright © Jennifer Janosi 2024 11🔥
Sold to
awwabtahir11@gmail.com
fi
fi
fi
Examples:
site:linkedin.com inurl:profiles "HR Manager"
“gmail.com"
↑ This search string nds LinkedIn pro les with the title ‘HR
Manager’ that mention ‘gmail.com’ email addresses,
speci cally within pro le URLs.
Here are some more examples of in-URL search strings:
site:linkedin.com inurl:profiles "Marketing
Director" “gmail.com"
site:linkedin.com inurl:people "Software
Engineer" “gmail.com"
site:linkedin.com inurl:profiles "HR Specialist"
“yahoo.com"
Copyright © Jennifer Janosi 2024 12🔥
Sold to
awwabtahir11@gmail.com
fi
fi
fi
fi
↑ Here you see I searched for LinkedIn pro les with the title
‘HR Manager’ that mention ‘gmail.com’ email addresses,
speci cally within pro le URLs.
Combining multiple advanced operators:
Combining multiple advanced operators allows you to create
highly speci c and targeted search strings. By using logical
operators like OR, inurl searches, and time range lters
together, you can re ne your search to gather the most
relevant and comprehensive data.
Copyright © Jennifer Janosi 2024 13🔥
Sold to
awwabtahir11@gmail.com
fi
fi
fi
fi
fi
fi
Examples:
site:linkedin.com ("CTO" OR "Chief Technology
Officer") ("gmail.com" OR "yahoo.com")
inurl:profiles 2021..2023
↑ This search string nds LinkedIn pro les with the titles
‘CTO’ or ‘Chief Technology O cer’ that mention ‘gmail.com’
or ‘yahoo.com’ email addresses, speci cally within pro le
URLs and updated or created between 2021 and 2023.
Here are some more examples of in-URL search strings:
site:linkedin.com ("COO" OR "Chief Operating
Officer") ("gmail.com" OR "outlook.com")
inurl:profiles 2020..2023
site:linkedin.com ("Product Manager" OR "Product
Lead") ("gmail.com" OR "hotmail.com")
inurl:profiles 2019..2023
site:linkedin.com inurl:profiles "HR Specialist"
“yahoo.com”
BONUS: CHATGPT PROMPT FOR MORE
EXAMPLES AND INFORMATION
As a bonus, here’s a prompt you can use within ChatGPT to
get more examples and detailed information on advanced
search strings, from basic to more advanced techniques:
Copyright © Jennifer Janosi 2024 14🔥
Sold to
awwabtahir11@gmail.com
fi
ffi
fi
fi
fi
Act as if you are an expert at finding leads
using search strings. Provide detailed examples
and information on advanced Google search
strings. Include both basic and advanced search
strings, using operators like site:, quotes ("
"), minus (-), OR, AND, wildcards (*), time
ranges (..), and inurl:. Explain how each
operator works and give tips for constructing
effective search queries to find specific leads,
such as CEOs, marketers, and hiring agents and
how each operator works and give tips for
constructing effective search queries.
Copyright © Jennifer Janosi 2024 15🔥
Sold to
awwabtahir11@gmail.com
PART 3
DATA SCRAPER CHROME EXTENSION
Purpose of Data Scraper
Data Scraper is a powerful Chrome extension that automates
the extraction of data from the web pages you searched in
Part 1, making your data collection process faster and more
e cient. By integrating this data into Google Sheets, you can
easily use your Zapier automation to contact these leads with
your custom GPT for more e ective outreach and follow-up.
Copyright © Jennifer Janosi 2024 16🔥
Sold to
awwabtahir11@gmail.com
ffi
ff
STEP 1:
Downloading the Data Scraper Extension
• Open Google Chrome.
• Go to the Data Scraper extension page on the Chrome
Web Store.
• Click on the “Add to Chrome” button.
• Con rm by clicking “Add Extension” in the pop-up window.
• Once the extension is added, you will see the Data Scraper
icon in the Chrome toolbar.
STEP 2:
Enabling the Google Sheets feature in Data Scraper
• Navigate to your account in Data Scraper.
• On the left side, you will see “Google Sheets.” Click on it.
• Scroll down if necessary to nd the toggle switch. Enable
the feature by clicking on the toggle to turn it on. The next
step will have you validate your account by allowing Data
Miner to have access to your google sheets.
STEP 3:
Adding a Sheet
• Navigate to the Google Sheet you created in Part 1 and
copy the URL.
• Return to Data Miner and click the “+ Add Sheets” button
at the bottom right..
Copyright © Jennifer Janosi 2024 17🔥
Sold to
awwabtahir11@gmail.com
fi
fi
• Name your sheet. I recommend using the same name as
your Google Sheet for consistency. In my case, I named it
“Prospects.”
• Paste the copied Google Sheets URL into the provided
eld to replace the one already exists.
• Click “Save”.
STEP 4:
Google Search before you can scrape
• Navigate to google.com
• Enter your rst search string in the search bar. (Ex.
site:linkedin.com "CEO" “gmail.com”)
• Press enter to view your search results.
STEP 5:
Performing your scrape
• Open your Google Chrome extensions by clicking on the
puzzle piece icon in the top right corner of your browser
window.
Copyright © Jennifer Janosi 2024 18🔥
Sold to
awwabtahir11@gmail.com
fi
fi
• From your list of extensions, select “Data Scraper.”
• Next, you will see a blue button “Scrape This Page”, click
on that.
Copyright © Jennifer Janosi 2024 19🔥
Sold to
awwabtahir11@gmail.com
• On the left hand side, you will see a menu, click on “Crawl
Scrape”
Note: This is a paid feature. If you haven’t already upgraded
your account, you can still use this feature to test to see how
it works.
• Click on the tab that says “Load/New Crawl”.
• Let’s start a new crawl. Click on “+ Create New Crawl”.
Copyright © Jennifer Janosi 2024 20🔥
Sold to
awwabtahir11@gmail.com
• Under Step 2 “Set URLs”, Select “Type URLs”. And at the
bottom of the page, take the search string of your rst
advanced search string search and paste it into this eld. In
my case, I used the search string: site:linkedin.com
"CEO" “gmail.com”
Note: Copy and paste The URL for the above search string
into the eld. ↓
Copyright © Jennifer Janosi 2024 21🔥
Sold to
awwabtahir11@gmail.com
fi
fi
fi
• Once you’ve pasted the URL link into the eld, click on the
blue button that says “Check it”. This will make sure the
URL you pasted into the eld is good.
• Go ahead and hit “Next Step” to proceed to the next tab
titled “Recipe”.
• From this list, search for “Google XRay - LinkedIn 2022”
and select it.
Note: This is a public recipe you can use. Once you become
comfortable with using the Data Miner tool, you can build
your own recipes for other search types. It’s relatively easy to
do, and you can nd all the help you need by visiting Data
Miner’s YouTube channel here.
Copyright © Jennifer Janosi 2024 22🔥
Sold to
awwabtahir11@gmail.com
fi
fi
fi
• Let’s move onto the next step by clicking on the blue “Next
Step” for “Crawl Scrape.
Crawl name: Rename this to something familiar. I chose
“Prospects Crawl List”.
Limit range: You can leave this to default and make changes
here later.
Wait time: You can leave this set to the default settings.
Stop crawl when: Leave these unchecked
Copy original data: Leave this checked
Copyright © Jennifer Janosi 2024 23🔥
Sold to
awwabtahir11@gmail.com
Follow pagination: You can leave this to 1 pages and make
changes later.
Google Sheets: Locate your google sheet from the dropdown
list and select it here. In my case, I chose “Prospects”.
Once you are nished making all the changes, hit the blue
botton at the top “Start Crawl”. This step will take a few
moments to complete.
Once the crawl is complete, you will see 100%. Go ahead and
hit the blue “Next step” button or click on the last tab “5.
Download”.
You will see all your scraped data listed here. You can choose
to download this list, but since it is connected to your Google
Sheets, it is already populated in your document. Navigate to
your Google Sheets to see your scraped data.
Public recipes are a great starting point and can all be edited
to your preference. Personally, I keep it simple by using
Copyright © Jennifer Janosi 2024 24🔥
Sold to
awwabtahir11@gmail.com
fi
public recipes and making edits to suit my needs. Now that
you see how the crawl works, you can use these recipes and,
once comfortable, build your own for the speci c data you
need.
Copyright © Jennifer Janosi 2024 25🔥
Sold to
awwabtahir11@gmail.com
fi
CONGRATS! 🥳
YOU JUST COMPLETED THE FIRST STEP
OF SETTING UP YOUR AUTOMATION.
You’ve successfully completed the rst step of setting up your
automation! By now, you should have your Google Sheets set
up, mastered advanced search techniques to nd leads, and
learned how to use Data Scraper to extract and organize your
data. This foundational work will streamline your lead
generation process and ensure your automation runs
smoothly.
Next, we’ll move on to setting up your rst Zapier automation
template called “Initial Outreach” using the information we
just scraped and added to your Google Sheets.
Copyright © Jennifer Janosi 2024 26🔥
Sold to
awwabtahir11@gmail.com
fi
fi
fi
