Clay Icon

Troubleshooting SerpAPI Issues with Clay: Support Needed

ยท
ยท

Good morning! & merry christmas. I have created this table to find out if a business is running G Ads or not using serper API https://app.clay.com/workspaces/247953/tables/t_cfCbpf2Q4fEF/views/gv_GrwzK5Q3TRkV Q1 - SerpAPI - Text (Domain) in coloumn I am getting 200 but it hasn't returned any result. Why is that the case? I am able to check this when I put a filter on SerpAPI - Text (Domain) for 200 and Text-Domain Check for Some inputs missing. Is this an API problem? When I check with SerpAPI they say that they dont know about clay so cant help. Q2 - SerpAPI - Text (Company Name) - Is showing - "Error running integration: Error". There is no other explanation. Can you explain why?

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    This error could be occurring due to several potential issues:1. API Key Configuration: Make sure you have properly connected your SerpAPI account and pasted a valid API key into all six required columns in the Clay table. 2. Common API integration issues that could cause this error include: โ€ข Authentication token or API key issues โ€ข Missing or incorrect security credentials โ€ข System stability problemsTo troubleshoot, you should:1. Verify your API key is correct and properly formatted with quotes 2. Check for any syntax errors or hidden characters in your configuration 3. Ensure you have sufficient API credits in your SerpAPI account (free plans include 100 searches per month)If the issue persists after checking these items, you should request human support for further assistance. Sources: Claybooks: Find high-fit companies who are actively running Google search and shopping ads | Clay.com HTTP API integration overview | Documentation | Clay University What is API? | Clay

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!

  • Avatar of Bo (.
    Bo (.
    ยท
    ยท

    Hey - For Q1 I do see results, which rows are you checking to see if it's empty? For Q2 - Based on the logs, here's the issue and solution: The API request to SerpAPI is failing with a 400 Bad Request error. The problem is in the URL encoding of the query parameters. Original URL: https://serpapi.com/search.html?engine=google_ads_transparency_center&text=100% YOU NEED&creative_format=text&api_key=... Fix: 1. Properly encode the text parameter: https://serpapi.com/search.html?engine=google_ads_transparency_center&text=100%25%20YOU%20NEED&creative_format=text&api_key=... The % symbol needs to be encoded as %25 and spaces as %20. You can fix this by using a formula column like i did in this view: https://app.clay.com/workspaces/247953/tables/t_cfCbpf2Q4fEF/views/gv_tkgiJfwSnAmA

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hi Nibha G.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: