Help: Write Top 20 Filtered Keywords (from JSON Array) into Airtable Long Text Field

How To
, , ,
1

Hi everyone,

I’m working on a Make.com scenario where I pull a SEO keyword from Airtable and then fetch semantic keywords via an SEO tool API (HTTP module) and paste them back into Airtable.

The output from the SEO tool looks like:

“terms”: [
{
“term”: “strandrollstühle”,
“vom_selben_wortstamm”: [“strandrollstuhl”,“strandrollstuhls”],
“korpus_rang”: 8,
“doc_count”: 5,
“rel_avg”: 26,
“rel_median”: 41,
“rel_max”: 107
},
{
“term”: “sylt”,
“vom_selben_wortstamm”: [“sylter”],
“korpus_rang”: 1,
“doc_count”: 12,
“rel_avg”: 73,
“rel_median”: 76,
“rel_max”: 85
},

Using the JSON parser module, I can get the array of terms.

My goal ist to grab the array of terms, sort them by rel_avg and paste the top 20 comma seperated into the Airtable field for semantic keywords.

ChatGPT suggested a formula in the “Semantic Keyword” field in the Update Airtable modul. But it then either shows the first keyword only or the formula itself.

I am stuck on how to sort and filter those keywords and how to get them into Airtable.

I tried several ideas by ChatGPT without success. Maybe someone can help out.

Thanks, Kathrin

3

scenario.blueprint.json (6.8 KB)

A possible solution could look like this.

image
image998×382 27.4 KB

The first part is to get the array.

In the second part, we sort the array and extract only the term value from it.

image
image476×365 17.1 KB

The last part is optional, to add the array to a comma-separated string.

image
image508×359 17.6 KB

I hope this helps.

4

Perfekt, thanks a lot! I will give it a try and report back. But looks good!

5

I just bulk export data into CSV and apply filters in Excel to spot patterns. It’s faster for me to see what’s dragging and what’s doing okay month to month.

6

Parsing JSON was fine, but sorting inside Airtable wasn’t clicking. Geo helped me set up a simple array sort in Make before sending to Airtable, which cut out a lot of headaches. Just pull the terms, sort by rel_avg in the scenario, then join them with commas before updating the Airtable field.