Problems trying to wake up ATMEGA328p from sleep with ADXL345

Projects General Guidance
4

I'm not 100% sure that I have to attach the interrupt there (in the sleepNow() function) and detach it in the wakeNow()

You most certainly do not. Attach once in setup() and you are done.