Appending to file looks successful but isn't

You are attempting to access a path outside of the Drafts iCloud folder in the Drafts iCloud folder.

See the description of the file action step.

If you are only wanting to do this on the Mac, you may want to have a read through this thread for an alternate approach.

Hope that helps.