How can I tell my advisor that I'm not going to work for free?
I would suggest that you repeat that you did not win the fellowship and ask if he has other funding available, "because I am still very interested in the work, but will need to find paid work instead if I can't get a stipend for this collaboration."