Organize Google Drive Images into Google Sheets

Description

Sample sheet: https://docs.google.com/spreadsheets/d/xxx/edit?usp=sharing Pictures directory: https://drive.google.com/drive/folders/xxx?usp=sharing Column C = folder name in directory Column J = file name in folder (files can be PNG/JPG) Column M = where link of image should be Column N = image(columnM) for image preview Column position might change in future Column C will have more values in future, hence more folders in directory(now only OSP and MN, future will have more) We keep having new files added to folders. Function needs to run real time (if we change value in Column J, column M should update).

Works with Apps

Google Sheets Google Drive

From Ashton

In this project, we develop a tailored script that extracts all images stored in a user's Google Drive and collates them into a centralized Google Sheets document, specifically for their projects. This practical application leverages the capabilities of Google Apps Script within Google Sheets, seamlessly integrating with Google Drive API.

Hire Me on Upwork

From Client

Clear communication. Fast processing. Accurate execution. Will contact for more jobs. Highly recommended!

Google Apps Script Projects Shared On YouTube

Links

Work with Me on Upwork YouTube Twitter / X Automate The Boring (Blog)