I made an workflow where i extract meta description from website and write them in sheet and when i run the flow everything works find but it stops after 14-15 links and says execution completed
Is it possible that the Split Out in the middle of your loop sometimes finds nothing to output (and puts nothing in the sheet)? This could sorta be working like a filter and reducing the number of items that appear to “make it through” the loop.
One quick thing you could try, temporarily (or not), just for better visibility, is to insert an If node after ScrapingBee to branch around the Split Out and Google Sheets when there is nothing to split out.