What is The Easiest Way to Upload 200 Images from Google Sheet…

MK_Kay
MK_Kay Member Posts: 2
edited October 8 in General

Hi,


I have a free account and I need to upload 200 images/assets into a folder in my Cloudinary account.


I am a beginner with this process, so if you could provide step by step instructions, that would be very helpful.


I do have a list of JPG URL’s in a Google Sheet, example:


https://i.colnect.net/b/7455/856/North-American-Beaver-Castor-canadensis.jpg


I also have my my images stored in my iCloud. I will attach a screenshot to show my setup.


I am famillier with the Upload and drag and drop options. I wanted to know if I could use a CSV file, also.


I hope this will not be very complicated to do.


Thank you,

Mary

Answers

  • Cloudinary Team
    Cloudinary Team Administrator, Cloudinary Staff Posts: 170 admin

    Hi there,

    Thanks for reaching out.

    We do not have an out-of-the-box way to upload from a Google Sheet. From a quick Google search, I think you might be able to use a Google App script to upload and get data back. So, one of the columns would be a formula that runs the script to upload to Cloudinary and write the information sent by the API.
    https://developers.google.com/apps-script/guides/sheets

    We have some SDKs that generally make your life easier with several helper methods. You can find documentation on our SDKs here:
    https://cloudinary.com/documentation/cloudinary_sdks

    I have not tried using a Google App script, so I cannot promise that it will work. If you try it and run into issues, let us know and we'll do our best to help.

    To see methods of uploading that we do support, please refer to our documentation here:
    https://cloudinary.com/documentation/upload_images
    https://cloudinary.com/documentation/dam_upload_store_assets

    I hope this helps. If you have any questions, do not hesitate to ask.

    Kind regards,

    Tia
    Developer Support Engineer
    Cloudinary

    --
    💡 Improve your site's performance by applying optimization features when delivering assets


    💬 Community Forums | 🧑‍💻 Discord Server
    🧑‍🎓 Academy Training | 📖 Documentation | 📰 Blog