Troubleshooting n8n Automation Results Visibility Issues
hi - i need a help, as you can see the cells has been ran successfully - but i can't see the results. I'm making automation with n8n
Loading attachments
hi - i need a help, as you can see the cells has been ran successfully - but i can't see the results. I'm making automation with n8n
I can see your HTTP API cells show "Status Code: 200" but the Cell Details panel is empty. This usually happens when the API returns a successful response but no usable data. [1]
Try clicking directly on one of the cells with "Status Code: 200" to open the Cell Details panel and see what data is actually being returned.
If the cell data exceeds our 200kb size limit, it might not display properly even with a successful status. You can also try clearing your cache and refreshing to resolve any display issues.
Can you copy and paste the JSON response from one of your HTTP API cells so I can help troubleshoot what's happening with the data?
There's nothing in the cell details
This suggests the API is returning an empty response or the data isn't being parsed correctly. Since you're getting Status Code 200, the connection is working but something's wrong with the data format or the API response itself. [1]
Can you copy and paste the JSON body you're using in your HTTP API setup? This will help me check if there are any formatting issues that could cause empty responses. [2]
const apiKeys = ['']; // Retrieve the dynamic query from the input structure under `body.query` const query = $input.first().json.body.query; if (!query) { throw new Error('No query found in the input structure under body.query'); } console.log(`Dynamic Query: ${query}`); const items = []; // To store individual items in the desired format const baseUrl = 'https://google.serper.dev/search'; const location = 'United States'; // Example location, modify if dynamic location is needed let page = 1; // Start pagination at page 1 let hasMoreData = true; // Control pagination loop while (hasMoreData) { try { const headers = { 'X-API-KEY': '', // Use your pre-defined API key 'Content-Type': 'application/json', }; const body = page === 1 ? { q: query, location: location } // First request without `page` : { q: query, location: location, page: page }; // Subsequent requests with `page` console.log(`Fetching page ${page} for query "${query}"`); const response = await this.helpers.request({ method: 'POST', url: baseUrl, headers: headers, body: body, json: true, }); if (response && response.places && response.places.length > 0) { // Add each item with pagination metadata items.push( ...response.places.map(place => ({ json: { ...place, page: page, // Include page number for debugging }, })) ); page += 1; // Increment to the next page } else { hasMoreData = false; // Stop pagination if no more data } } catch (error) { console.log(`Error fetching data on page ${page}:`, error.message); break; // Stop processing on error } } console.log('Final aggregated items:', items); // Return all aggregated items to the workflow return items;
I see you're using n8n code instead of our HTTP API integration directly in Clay. This n8n script is designed to return data to n8n's workflow, not to Clay's cell structure. [1]
For Clay's HTTP API integration, you need to configure the JSON body in our interface, not as JavaScript code. The body should be simple JSON format like:
{
"q": "/column_name",
"location": "United States"
}Can you copy the actual JSON body you have in Clay's HTTP API integration setup? The n8n code won't work in our system. [2]
I'm trying to find amazon brand links - using serpers I need ample data do you have alternative?
For finding Amazon brand links, you have several alternatives to Serper:
HTTP API Integration: Connect to any tool with API access using our HTTP API feature - this includes various data providers beyond Serper. [1]
Chrome Extension: Use our Chrome extension to scrape Amazon pages directly. You can create custom recipes to extract brand links from Amazon product pages or brand directories. [2]
Extract URLs from Text: If you have text data containing Amazon links, use our "Extract URLs and Emails from Text" integration to pull out all URLs automatically. [3]
The Chrome extension might be your best bet - you can scrape Amazon search results or brand pages directly and extract the specific brand links you need. [4]
Is that what you were looking for?
Nope I need to find from google below is my query { "query": "site:amazon.com \"sold by\" keywords " }
Perfect! You can use our Google Search integration for that exact query. [1]
Set up your search with operators like:
site:[amazon.com](https://amazon.com) to focus on Amazon
"sold by" in quotes for exact matches
Combine with AND/OR operators
Your query site:[amazon.com](https://amazon.com) "sold by" keywords will work great in our Google Search integration. Just add it as your search term and it'll pull all Amazon pages mentioning "sold by" with your keywords.
Much simpler than the HTTP API setup you were trying before!
Did that answer your question?
no i wanna use with serper.dev
Oops, something went wrong. Could you repeat your question?
I don't want too use clay integration, i need to use with serper.dev
Sorry, I'm still having trouble. I'll hand you over to the team.