Sweet soy sauce is made with molasses or palm sugar and has a thicker consistency, while regular soy sauce is made with soybeans and has a saltier taste. Sweet soy sauce is primarily used for adding sweetness and depth to dishes, while regular soy sauce is used for adding saltiness and umami flavor.