I have a form that my crews use in the field to do check-ins. This form saves to a Google sheet and includes images. I am trying to set up an automation to post a new post with images to Facebook and Instagram, each time they check in. The problem that I am facing is that the Google form places a link in the sheet that looks like this {EZ-Tree-facebook-background - Joseph KLaudi.jpg - Google Drive}, and it creates an error.
I’m a little green to this process but willing to learn, any help is greatly appreciated.
Hey Joe,
can you share screenshots of your scenario and the input bundle it self? Looks like the URL might need a bit of cleaning before you forward it to the Facebook module.
I actually deleted it out of frustration…lol.. and have tried a number of different ones, all get an error somewhere along the way. I have even tried uploading the image from Sheets to PostImage, then getting a PostImage Link and posting that back to the spreadsheet, but that does work either
Welcome to the Make community!
To do this, you can try using the Google Drive “Download a File” module —
Downloads a file.
You need to use text functions or modules to extract the file “ID” from the URL, which is the part after the /open?id=
For more information, see https://www.make.com/en/integrations/google-drive, and https://www.make.com/en/help/app/google-drive in the help centre.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.