Workflow Email Won't Include The Email Body

I have a workflow that triggers an API call to DocsAutomator.It is supposed to include the PDF URL in the email body and I have a Template column that generates the Body and includes the URL after the API call finishes. However, no matter what I do, the email body won’t show up in the email. The URL and Template look fine in my data editor, but it just won’t show in the email. Any ideas?

I have two questions here:

  • Is there a reason you don’t use the DocsAutomator native integration and opted for an API call?
  • Have you checked the logs of the action to see what branch of logic was run? If it is indeed the left, what do you see for the Call API result?
  1. It’s just out of preference. I had to do that in a prior scenario when I first used DocsAutomator. With the situation I had then, Rupert recommended using that route, and I’ve just used the API call ever since out of familiarity.

  2. It did run the left side. The PDF generated and I can see it in the data editor along with the 200 status code. The only thing that went wrong with the workflow was that the body of the email didn’t get included. The rest of the workflow worked perfectly.

I assume you write the Call API result to a column, and then query the docs URL right?

Can you add a step before the Gmail action to wait for 60 seconds until the docs URL is populated?

I haven’t done up to 60 seconds, but I had some steps in there trying 10/20/30 and it still didn’t seem to like it.

Just for something to try, have you tried removing the email step and re-adding it? Also, have you tried HTML Body instead of Body?

1 Like

I ended up breaking the workflow up into two where the PDF generation happens in the first and the email only happens if they opt for it which triggers the second workflow that attaches the URL. It seems to be working that way for me. Thanks for the input though everyone!

2 Likes