# Steps to update google sheets & Cloudinary Images

**URL:** <https://sef.discourse.group/t/steps-to-update-google-sheets-cloudinary-images/337>\
**Category:** SEF site\
**Created:** [July 27, 2021, 6:27am UTC](https://sef.discourse.group/t/steps-to-update-google-sheets-cloudinary-images/337 "2021-07-27T06:27:03Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gajindu\_Bandara](https://yyz2.discourse-cdn.com/free1/user_avatar/sef.discourse.group/gajindu_bandara/32/644_2.png) [@Gajindu\_Bandara](https://sef.discourse.group/u/Gajindu_Bandara)\
**Post date:** [July 27, 2021, 6:27am UTC](https://sef.discourse.group/t/steps-to-update-google-sheets-cloudinary-images/337/1 "2021-07-27T06:27:03Z")

</div>

In the last dev standups meeting, we discussed documenting the steps to update the google sheets and the SEF Cloudinary account so this is about that. Recently I worked on the JSON file replacement project and the image migrating thing. Now the site does not contain JSON files, all of them are replaced with google sheets and all the profile images are moved to the SEF Cloudinary account so I’m gonna explain the steps to update the info in the google sheets and the SEF Cloudinary account 😇

**Google sheets**

This google doc contains all the links to the google sheets

> **[JSON Replacement Project](https://docs.google.com/document/d/1pBSHbUVRJYvK_QI1VCldnUvDt7vXxLykvUy5H_AHFpk/edit?usp=sharing)**
>
> Directory File Status Google Sheet assets/content/json About.json Removed - Alumni.json Removed - Contact.json Removed - Contribute.json Removed - Home.json Removed - Irc.json Merged IRC\_Researchers Irc\_interns\_2020.json Merged...

So when the sheet needs to be updated you can just add the new info to the relevant column of the sheet. It’s as simple as that, so when you need to add images to an "image "column in the google sheet you have to follow some steps so I’ll explain that with the Cloudinary thing.

**Cloudinary image hosting**

We used the Cloudinary image hosting service to host all the profile images. At the moment all the images are stored in the SEF Cloudinary account. So if you need to add any new images just have to follow the below steps.

**Step 1** - Login to the SEF Cloudinary account

> **[Image and Video Upload, Storage, Optimization and CDN](https://cloudinary.com/)**
>
> Streamline media management and improve user experience by automatically delivering images and videos, enhanced and optimized for every user.

![login](https://global.discourse-cdn.com/free1/uploads/sef/original/1X/f85998b5fe1172444bb558f4ad558e7791caea64.gif)

**Step 2** - Go to the “Media Library” in the account. There you can see all the folders which contain the images of the SEF site

![media lib](https://global.discourse-cdn.com/free1/uploads/sef/original/1X/f945820c04fcb9861ba45962cc5a25bdbbd15ee9.gif)

This is the file structure of the SEF Cloudinary account

 ![Screenshot from 2021-07-27 09-42-45](https://global.discourse-cdn.com/free1/uploads/sef/original/1X/305d075b14ce80a1242033f102d3e38e8280328f.png)

**Step 3** - After that just go to the folder that you need to upload images and you can drag and drop the new images into the folder.

![upload](https://global.discourse-cdn.com/free1/uploads/sef/original/1X/e50881fd5cbc658c8bfc7a2cfa80cb208dfc7102.gif)

**Step 4** - Now you have to get the link to the image. You can see the way to get the image link from the above video

Example-  
Just make sure to use the image ID in the google sheet. As in the below example, you can remove the red-colored part from the link, and then you will get the image ID  
 ![Screenshot from 2021-07-27 11-02-15](https://global.discourse-cdn.com/free1/uploads/sef/original/1X/5e99c2a6bb02229af158524c87980ce1d644584f.png)

![link](https://global.discourse-cdn.com/free1/uploads/sef/original/1X/3a4fcac2330abb72d8d5a3954991a90b8f1b6f4f.gif)

**Step 5** - That’s all !!! Just use that ID in the image column of the google sheet 😁