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?

6 comments

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
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!
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
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.
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!
Channeled
APP
·
·
Hi Nibha G.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: