Welcome to the Make community!
This is a new known issue. Instagram no longer accepts Google Drive or other personal file hosting storage links.
For more information, see
- Only photo or video can be accepted as media type. (9004, OAuthException)
- Instagram create a post photo module giving failure when using Google Drive URL
- Automation Has Been Working for Weeks and Suddenly Stopped Working
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.