A straightforward approach to make Google Sheet interactive and responsive.
Use Google Sheet built-in search function to pinpoint files, conditional formatting from the Format drop-down menu to customize options, Google Apps Script to design code syncing with folders on the drive, and in combinaton with Trigger function to realize auto-refresh functionality.
- You need to be the owner of the folder in order to do the sync part, or at least have permission of it.
- This method is perfect for a decent size of data and practical for a medium dataset. The bigger, the laggier.
- Check out the link down below for more details.