common to have your sprites fail several attempts before you successfully create an item.
Also note your sprites relationship points.
You can also increase the success rate by increasing your sprites "relationship" points between the sprite and your character. This method is much cheaper because all it requires is time and training.
You can achieve this by having your sprite "collect" low level foraging items. Options such as "primary forest gathering" or "high mountain gathering" will work. You need to select an option that is in the grayed out region of your sprites collection selection.
Over time, your sprites relationship points will increase. This may take a while to achieve because the relationship points don't always go up after every time you send them out to collect. It is a cheaper method though and the return time is faster because you're practicing on lower leveled options.
Most recommend your sprite be at 500+ out of the 999 that is available. It's beneficial nonetheless. Keep your sprites mood elevated and keep them dosed up on cookies and pop.
Good luck in your future attempts.