Google Sheets atomisation stackoverflow

Recent Questions - Web Applications Stack Exchange

I hope you are all well and healthy! I am looking for a solution in Google Sheets to automate something like this:

and it could auto generate something like this

Thank you in advance

Recent Questions - Web Applications Stack Exchange Recent Questions - Web Applications Stack Exchange by Marcel via Recent Questions - Web Applications Stack Exchange