@better-honey-40119 I think when we combine your ideas, @fresh-fireman-491 's and mine, it will work.
Here is how I normally solve these. I'm not any kind of expert in Make.com, I just try everything and I don't quit until it works (I may rest).
Here I try to store KB tables to Google sheets, all disconnected modules don't work (also the one which is connected, doesn't work 😂 ). But eventually I'll beat them