How to Integrate Retool with Ubersuggest

Log into your Ubersuggest account at app.neilpatel.com. Navigate to your account settings by clicking on your profile icon in the top-right corner, then selecting 'Profile' or 'Account Settings'. Look for the API or Developer section within your account settings. Your API key is displayed here — it is typically a long alphanumeric string. Copy the API key. Note that Ubersuggest API access is only available on paid plans (Individual plan and above). If you are on a free account, you will not see an API key section, and you will need to upgrade before proceeding. The API key is tied to your account's credit limits — each API call consumes credits from your monthly allocation, with limits varying by plan.

In Retool, navigate to the Resources tab and click 'Create New' → 'REST API'. Set the Base URL to 'https://app.neilpatel.com/api'. This is the base endpoint for Ubersuggest's API — specific endpoints will be added as paths in individual queries. Under the Headers section, click 'Add header' and add: key 'Authorization' with value your API key (the Ubersuggest API uses the API key directly in the Authorization header, without a 'Bearer ' prefix for most endpoints). Add a second header: 'Content-Type' with value 'application/json'. Name the resource 'Ubersuggest' and click 'Save'. Note that Ubersuggest's API documentation is limited — the API is intended primarily for internal use and was opened to users somewhat informally. If the base URL or authentication format has changed, consult the Ubersuggest community forums for the latest confirmed endpoint documentation.

1{
2  "Base URL": "https://app.neilpatel.com/api",
3  "Headers": {
4    "Authorization": "{{ retoolContext.configVars.UBERSUGGEST_API_KEY }}",
5    "Content-Type": "application/json"
6  }
7}

Create a new query in your Retool app using the Ubersuggest resource. Set the method to GET and the path to '/get_suggestions'. The primary query parameter is 'keyword' — set this to {{ keywordInput.value }} so users can type a seed keyword and run the query. Add a 'country' parameter to specify the target country for search volume data (e.g., 'us', 'gb', 'au'). The response includes an array of keyword suggestions, each with fields for: keyword text, search volume (search_volume), SEO difficulty score (seo_difficulty), paid difficulty (paid_difficulty), and cost per click (cpc). Run the query with a test keyword to verify the response structure. The response may be paginated or limited by your plan's credit allocation.

1// GET /get_suggestions
2// Query parameters:
3// keyword: {{ keywordInput.value }}
4// country: {{ countrySelect.value || 'us' }}
5// language_code: {{ languageSelect.value || 'en' }}

Add a transformer to the keyword suggestions query to normalize the response data for the Retool Table component. Ubersuggest's response may nest the keyword array under a 'keywords' or 'suggestions' key depending on the endpoint version. The transformer should extract the array, sort by search volume descending, and format numeric fields for readability. Format the CPC as a dollar amount and create a color-coded difficulty category based on the SEO difficulty score: 0-30 is 'Easy', 31-60 is 'Medium', 61-100 is 'Hard'. Add a Table component to the canvas and bind its Data source to {{ getKeywords.data }}. Enable column sorting so users can re-sort by any metric. Add a Number Input component for users to filter by maximum difficulty score.

1// Transformer: normalize Ubersuggest keyword response
2const raw = data;
3// Handle different response structures
4const keywords = raw.keywords || raw.suggestions || raw.results || [];
5
6return keywords
7  .filter(kw => kw.search_volume > 0)
8  .map(kw => {
9    const difficulty = kw.seo_difficulty || 0;
10    let difficultyLabel;
11    if (difficulty <= 30) difficultyLabel = 'Easy';
12    else if (difficulty <= 60) difficultyLabel = 'Medium';
13    else difficultyLabel = 'Hard';
14
15    return {
16      keyword: kw.keyword,
17      volume: kw.search_volume || 0,
18      seo_difficulty: difficulty,
19      difficulty_label: difficultyLabel,
20      paid_difficulty: kw.paid_difficulty || 0,
21      cpc: kw.cpc ? `$${parseFloat(kw.cpc).toFixed(2)}` : '$0.00',
22      opportunity_score: Math.round((kw.search_volume || 0) / Math.max(difficulty, 1))
23    };
24  })
25  .sort((a, b) => b.volume - a.volume);

Create a second query to pull keyword data for a specific domain rather than a seed keyword. Use the '/get_keywords_for_url' or '/get_domain_info' endpoint (exact endpoint name may vary — test with your API key). The domain endpoint accepts a 'url' parameter instead of 'keyword'. This allows users to enter a competitor domain and see what keywords that domain ranks for in organic search. Build a second tab or section in your Retool app for the domain analysis view. Add a TextInput for the domain URL input and a second Table component bound to this query's transformer output. Add a comparison view where users can see both their target keyword list and the competitor domain's keywords side by side, identifying gaps and opportunities.

1// GET /get_keywords_for_url
2// Query parameters:
3// url: {{ domainInput.value }}
4// country: {{ countrySelect.value || 'us' }}
5
6// Transformer for domain keywords:
7const keywords = data.keywords || data.results || [];
8return keywords.map(kw => ({
9  keyword: kw.keyword,
10  position: kw.position || kw.rank || 'N/A',
11  volume: kw.search_volume || 0,
12  traffic_share: kw.estimated_visits || 0,
13  seo_difficulty: kw.seo_difficulty || 0,
14  cpc: kw.cpc ? `$${parseFloat(kw.cpc).toFixed(2)}` : '$0.00'
15}));