If you have the URL of a published story use the  By URL option of the Embed edit function. It must be an https:// URL to work with a Google Site.