I am trying to set up an automation that automatically emails a Coda page as a PDF attachment. Is that possible?
Unfortunately, there is no function (yet 
) to make a pdf from a Coda page. It has been asked for as a feature request, but to date there is nothing available to automate making a pdf.
Therefore, what you want to do is not possible at this time.