shinyapps.io supports packages CRAN, Bioconductor, and GitHub, per Using your R packages in the cloud.
The rsconnect package captures the package names and versions in a manifest file that is uploaded to shinyapps.io. It does not bundle the actual local packages themselves.