Generate PDF and email
I have a very simple sheet that I wish to turn into a PDF (all rows and columns) and email out each week when a value in a particular cell is changed.
I can get an automation to send an email when the cell is changed, but I can't figure out how to generate a PDF which can then be attached to the email.
Is it possible? If so, how would I do it?