For each job my business completes, we record the job and all information in a single row. Once the job is complete a report is generated with Smartsheet merge in Google Docs and saved to the specific row for the job which also includes the client's contact email. Regardless of how the attachment arrives at the sheet row, so far I have not found a tasteful way to automatically send this report to a client's email without manually sending or "alerting" them with the limited actions under the automated triggers workflow. Is there a better way?
To be clear I have tried:
1) Click the drop-down arrow next to the row number that you want to send and select Send. -Is there a way to automate this function?
2) Automated workflow- Action set to Alert Someone- Sends a busy looking email notifying of the change triggered by me clicking my "send report to client" check box. Would like the email to look more like the option 1 email.
So in summary, I like the look of the email from option 1 but cannot find a way to automate it without using the alert feature of option 2. Any ideas? Thank you!
