How do you find your competitors' customers at scale, for free, using Google Sheets?

If your competitor is a B2B SaaS vendor, they most likely share some customer data with 3rd parties.

And according to GDPR, they have to explicitly mention that in their privacy policy.

Since privacy policies are publicly available, Google has already indexed them.

Here's how to find those pages, at scale, using the Google Search API:

1. Make a copy of the spreadsheet below.
2. Generate a Google Search API key.
3. Add your key to the Sheets Apps Script.
4. Add the websites of companies you want to get customers for.
5. Use the getCustomers function, as shown below.

Links and a more detailed guide, in my bio.

Credits for the clever Google dorking idea go to Tom Orbach
, but also to Lucas Perret
for inspiring me to find my way through GSheets Apps Script API calls.

๐˜š๐˜ฎ๐˜ข๐˜ญ๐˜ญ ๐˜ค๐˜ข๐˜ท๐˜ฆ๐˜ข๐˜ตโ€”๐˜ฏ๐˜ฐ๐˜ต ๐˜ข๐˜ญ๐˜ญ ๐˜ค๐˜ฐ๐˜ฎ๐˜ฑ๐˜ข๐˜ฏ๐˜ช๐˜ฆ๐˜ด ๐˜ข๐˜ฃ๐˜ช๐˜ฅ๐˜ฆ ๐˜ต๐˜ฐ ๐˜Ž๐˜‹๐˜—๐˜™, ๐˜ฃ๐˜ถ๐˜ต ๐˜ต๐˜ฉ๐˜ช๐˜ด ๐˜ธ๐˜ช๐˜ญ๐˜ญ ๐˜จ๐˜ฆ๐˜ต ๐˜บ๐˜ฐ๐˜ถ ๐˜ข ๐˜ญ๐˜ฐ๐˜ฏ๐˜จ ๐˜ธ๐˜ข๐˜บ ๐˜ฏ๐˜ฐ๐˜ฏ๐˜ฆ๐˜ต๐˜ฉ๐˜ฆ๐˜ญ๐˜ฆ๐˜ด๐˜ด.


This post was originally shared by on Linkedin.