Do you mean the Sheets module fails, yet it still inserts the data?
What does your aggregator and sheets module look like now?
— @samliew
P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!