Automation Error: “The contents contain unexpected formatting that cannot be converted”
Hi everyone đź‘‹
I’m running into an issue with an Automation setup and was wondering if anyone else has dealt with something similar.
Context:
Trigger: Webhook (connected to a form on my website)
Action: Google Docs: Create doc
Problem: Sometimes the automation fails with the following error:
The contents contain unexpected formatting that cannot be converted
It doesn’t happen every time, only occasionally, which makes it hard to debug.
Has anyone experienced this with the Google Docs integration? Could it be related to certain formatting coming through from the form/webhook payload? Or maybe a limitation in how Airtable passes rich text to Google Docs?
Any tips or workarounds would be greatly appreciated 🙏 (I’ll attach a screenshot in the comments as well.)
Thanks in advance! Â
Â
Page 1 / 1
​@Vadim_CiobanuÂ
Sorry, I have no idea what’s causing that problem. Maybe somebody else will have some ideas for you below.
However, I just wanted to share my standard recommendation which I give to everybody, which is that you might be much better served by doing this with Make’s automations and integrations.
Make’s custom webhooks are infinitely more flexible than Airtable’s webhooks, Make’s automations are infinitely more powerful than Airtable’s automations, and Make is infinitely more customizable & integrable than Airtable’s automations.
For example, Make supports full HTML formatting for any documents that you are trying to create, and can also handle converting markdown to HTML as well. (Airtable’s rich text fields are really markdown fields.)
Check out the screenshot below for how simple your automation would look in Make:
I have played with using GDocs integrations before and I seem to recall running into a spot or two where RTF components didn’t translate properly (maybe it was creating hyperlinks…? It was a awhile ago).Â
Without seeing a comparison of a working example vs a broken one, it’s a bit of a guessing game… Just looking at your screenshot, is it possible that the last name includes accent marks that aren’t supported as a file name? Another thought would be if the date is a datetime string instead of a regular string causing issues but I expect that is similar on working examples.
Â
If you could provide examples of text that caused the automation to fail I’d be interested in trying to troubleshoot it!