Unfortunately, we don't have the ability to recover deleted columns or their contents, including prompts that were being written. Columns would need to be re-created, and the data re-entered.
To prevent this issue in the future, you might want to write your prompts in a separate text editor before pasting them into Clay. This way, you'll have a backup of your work.
Is there any specific reason you believe the column was automatically deleted? Understanding what happened might help us prevent similar issues in the future.
Aditya K. i've faced the same issue in the past. The only solution I've found is to save the prompt as a template immediately before hitting "Save and run" button.