

The second issue that I’m trying to resolve now, is to clean the HTML so that it’s mail-reader friendly, and to remove the HTML and HEAD parts so that I can embed it in a Mailjet email template. I use a slightly different URL format, which is the one returned from a Google Drive “Find Files” zap įor me splitting out the querystring elements resolved all issues.Īs to why this is happening- my guess is that it’s a caching problem, related to how Zapier ID’s and caches Webhook responses. The solution to this is to deconstruct the URL, and to specify those querystring components in the Query String Params section of the Webhook config. Zapier returning a Bad Request (500) error, even though the URL is correct, and you can access it directly in a browser.This happens most often if you are performing several GETs in the same Zap. Zapier returning the wrong document contents.The common failure scenarios I’ve seen are. I spent the last few days debugging this with Zapier support. In Webhooks, there are some deep design “features” (bugs) that cause the Webhook to behave unpredictably when the URL contains querystring components. I have a note to add to your post, which might be important for anyone experiencing problems with the GET Webhook. I came across your message as a result of searching for formatting options.

It should look like this:Īfter that you can just use a Webhooks by Zapier Get action step to retrieve the HTML in your Zap:įinally the “text” field containing the HTML can be mapped as the HTML message in your favorite email app, and you now have a dynamically editable Google Doc Email is great, and exactly what I’m working on today. The first step is to ensure the Google Doc has a publicly viewable URL by sharing it with at least “Anyone on the Internet with this link can view”.įinally replace everything from and including the “edit?” onwards in the URL with “export?format=html”. Wouldn’t it be easier if this template was a beautiful Google Doc instead of HTML?īut how do you get that Google Doc to spit out HTML when you need to send it as an HTML email? Here’s how.
Download newsletter templates for google docs how to#
The person creating or editing the template would have to know how to write HTML code. However, having this email message hardcoded would be a pain to maintain since the Zap would have to be deactivated if a change to the template was required. Futhermore HTML isn’t user friendly. This template can be hardcoded HTML in a send email action step using a Zapier email app such as Gmail or Outlook. One of the best ways to send automated emails in Zapier is using an email template.
