How to Run a Complex Google Search for Company Reviews

Hi y'all! I need some quick help running a complex Google search to pull in companies. For example, I want to import all the companies that are returned by the following query: "site:g2.com "reviews 2024" ( "hard to use" OR "poor experience" OR "confusing" OR "difficult" OR "frustrating" OR "not user-friendly" OR "problematic" OR "slow" OR "inefficient")" Is there anyway I can do this? Thanks!

6 comments

Bruno R.
·
·
Hi Blake, thanks for reaching out. I've seen people run these complex searches using the Serper.dev api which is actually a very cheap and effective solution to this problem. In order to integrate with Serper's APIs you'll need to set up an HTTP API calling the Serper endpoint which you're targeting - in this case the search endpoint. You can follow these steps to implement the Serper integration: 1. Retrieve your Serper API key: Make an account at https://serper.dev/ and retrieve your unique API key: https://downloads.intercomcdn.com/i/o/1151942943/b92c6d256ece3eff9074232d/CleanShot+2024-08-20+at+09_17_40%402x.png?expires=1730236500&signature=c968de582f18f47c3139f86f52bc9c18c4b403be443d8deba2b2adeebc36036a&req=dSEiF8B6n4hbWvMW1HO4zUXdlowndYbTQfMVkmWbm5Jtyg%3D%3D%0A 2. Select playground, then code, and look at the cURL structure - here you'll be able to retrieve your endpoint, your API key, headers and JSON body structure: https://downloads.intercomcdn.com/i/o/1151962624/c95edc47e73d262f6c1464c4/CleanShot+2024-08-20+at+09_32_50%402x.png?expires=1730236500&signature=3e62253b3570695a3b9fb6357d581b009c8dfe022413d18d5b393495d55a5ea5&req=dSEiF8B4n4ddXfMW1HO4zfXi2gxRhaWEhFh8mU74yPMjNA%3D%3D%0A 3. Set up an HTTP API call column in Clay, and copy the same cURL parameters in your column setup. Here's how you can set up an HTTP API call in Clay. In this specific use case, your HTTP column should look something like this, with your API key included in the header structure: https://downloads.intercomcdn.com/i/o/1151965302/fcb3b33a2cdb4c1092992dda/CleanShot+2024-08-20+at+09_34_55%402x.png?expires=1730236500&signature=98d37d525c78d403a66c01d586c0fb8e2fe96e1cc7161827978214e12f270aad&req=dSEiF8B4mIJfW%2FMW1HO4zVNUCmKUrDjwzwXDjARvF6AS0g%3D%3D%0A Please note that you'll have to compile your google query using a formula, as you can only input a single dynamic token in the API body. Save and run the column - this should run the column and return your google query results!
Blake S.
·
·
Thanks man, will try it out!
Bruno R.
·
·
Happy to help Blake! Let me know if I can help with anything else here.
Channeled
APP
·
·
Hi Blake S.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Channeled
APP
·
·
Thank you so much for sharing your feedback Blake S.!
Channeled
APP
·
·
Thank you so much for sharing your feedback Blake S.!