May I make a suggestion: could you make the thread title a LITTLE more descriptive?
I don't recall a way for block destruction to work in an automated fashion. The only thing that I can think of for sand is to place a door, open it, and placing sand on the open section. When the door gets activated, it will fully clear and let the sand fall. The problem is you can only have 1-2 contiguous columns of sand "actuated" this way.