I have found some questions regarding this topic, but no suitable answer, so I came up with a workaround/solution.
Using the format step from Zapier, I added a “- “ before every line, so I could use the “Replace” method inside the “Format” step to delete blank rows:
Replace
-[:space:][:newline:]
With
Just leave this empty
Note: You need to be very specific about the spaces and newline. In my case I had two spaces so I had to do “Replace: -[:space:][:space:][:newline:]”
Note 2: If at the end of the process you don’t want to have the “- “ at the beginning of each line you could add a second format step and repeat the same process by doing “Replace: -[:space:] With”