Send via email an agreement, invoice of the selected client on Google spreadsheet - current row. Generate the PDF Invoice and send via email automatically. Merge document using Google apps script.
Merge the Google docs template with selected data from Google spreadsheet then generate the PDF based on the template.