import photoshop file saved on creative cloud to after effects

If it's a .psdc saved to Cloud documents, there's currently no way to import that into an After Effects project.

If it's a .psd stored in a Library, you can import it from the Libraries panel by using the Add to Project option that appears in the contextual menu when you right-click the image in the Library panel or by dragging and dropping it from the Library panel to a Comp panel, Timeline panel, or the Project panel.  While you're working with it in AE or PS, it's stored in the local User Libraries folder (the location of which is set in the Syncing prefernces of the Creative Cloud Desktop app) and syncs back to the instance of the file in the Library which is in the cloud but also spearate from Cloud documents.  (Phew, say that last part five times fast.)

You can't and that is that.

Mylenium