I am trying to post from google sheets to Facebook and Twitter using Zapier and Hootsuite. It looks straight forward and I can see Zapier is extracting all the right data from google sheets. I am getting this error for all my Zaps (posting to Facebook or Twitter both).
“The message could not be sent to Hootsuite. Attachment has an unsupported mime type”
I think that is because the hootsuite app takes in a “Media URL” but the format is “file format” and from what I am reading Zapier changes the URL to a “File”. Then hootsuite rejects the message.
Any idea how to change this?