recommendation

Hi everyone. I'm thinking of getting a clematis for a north facing windowsill for keeping in a pot. Is this a good idea or would the plant not be very happy? Also want to get one with blue flowers that attracts bumblebees so if anyone has any recommendations let me know. Thanks