✈️ [FREE] Cluster 1,000 Keywords ★ FREE Script Inside

/**
 * Automatically assign keywords into clusters.
 *
 * @param {"A2:A1000"} range - input the range of your keywords. 
 * @param {"en"} language - [OPTIONAL] input the target language ('en', 'es', 'it', 'fr', 'pt'). Default set to 'en'.
 * @customfunction
 */


function cluster(range, language) {

    const sheet = SpreadsheetApp.getActiveSpreadsheet()

    const keywords = sheet.getRange(range).getValues();
    const arrLength = keywords.length - 1;

    // add keywords as line items for request
    const txt = keywords.toString().replace(/,/g, '\n');

    // create a cache key with first & last keywords
    const key = `${keywords[0]}&${keywords[arrLength]}&${arrLength}`;
    const cache = CacheService.getScriptCache();

    let json = cache.get(key);

    // if entry is not in the cache, request clusters 
    if (!json) {

        try {
            // RapidAPI Key https://rapidapi.com/MeaningCloud/api/text-clustering/
            const apiKey = '';
            const lang = language || 'en';

            const requestBody = {
                'txt': txt,
                'lang': lang
            };

            const options = {
                'method': 'POST',
                'contentType': 'application/json',
                'headers': {
                    'x-rapidapi-key': apiKey,
                    'x-rapidapi-host': 'meaningcloud-text-clustering-v1.p.rapidapi.com'
                },
                'payload': JSON.stringify(requestBody)
            };

            const response = UrlFetchApp.fetch('https://meaningcloud-text-clustering-v1.p.rapidapi.com/clustering-1.1', options);
            const result = response.getContentText();

            // add response to cache
            cache.put(key, result, 21600);

            json = result;

        } catch (e) {
            return 'Request to API failed. Try clustering less keywords';
        }
    }

    const list = JSON.parse(json).cluster_list;


    // loop through response and create return array with cluster groups and keywords
    let rows = [],
        data,
        title;
    for (i = 0; i < list.length; i++) {
        data = list[i];
        title = data.title.toLowerCase();
        cluster = Object.values(data.document_list);

        for (j = 0; j < cluster.length; j++) {
            rows.push([title, cluster[j]]);
        }
    }

    rows.unshift(["Cluster Group", "Keywords"]);

    return rows;

}

const apiKey = 'addapikeyhere';

=cluster("A2:A200", "en")