Convert HTML to Rich Text with script

I’m not certain, but I would question this approach.

If you are already using IFTTT, you would be far better off using Integromat because it supports HTM-to-Markdown transformations - I believe it is just another step in the recipe process (literally a 5 second task). I believe it uses regex to perform the transformations so it would be a lot less effort than making your own script to do this. @ScottWorld probably knows exactly what I’m referring to.

Hi @Noah_Coleman,

Yes, @Bill_French is 1,000% correct! That’s 10x more than 100%, by the way. ;)

Here’s the module in Make (formerly known as Integromat) that Bill was talking about:

• Convert HTML to Markdown (or Convert Markdown to HTML)

That module will convert your HTML into markdown, and then you can send that markdown text to a “rich text enabled” long text field in Airtable.

And then, Airtable will automatically translate the markdown into onscreen formatting for you. :)

(Note, however, that Airtable only supports a subset of the markdown formatting that is available to us.)

So yes, using a HTML-to-markdown conversion like this would definitely be your quickest & easiest & most reliable way to convert HTML to markdown.

And, as @Bill.French also mentioned, you could completely eliminate IFTTT from your process altogether, and just use Make to do the ENTIRE process from start-to-finish:

Make can grab the calendar event from Google, convert its description from HTML to markdown, and then send it onwards to Airtable.

If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is one of the ways that you could instantly trigger a Make automation from Airtable. 

I also give live demonstrations of how to use Make in many of my Airtable podcast appearances. For example, in this video, I show how to work with Airtable arrays in Make.

Hope this helps!

If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

p.s. Oh, one other thing I should note: From my personal experience, descriptions from Google Calendar will only show up as HTML if you’ve applied formatting to your calendar event’s description. If you only have plain text in your calendar event’s description, it should show up normally (without HTML).

Thanks for the help @ScottWorld and @Bill.French. I’m looking into Integromat right now to see if it will be a good fit, but I’m still using IFTTT for now. Google only sends HTML when using formatting in the description, but I also figured out that if the description has MD syntax, it will be read into Airtable already formatted.

Ah, that’s a nice find!

Field Agents can now accomplish this 😊