In this video, you’ll learn to use Gemini in Google Sheets to automatically generate organized trackers from unstructured data. You’ll learn how to write a prompt that references other Google Drive files using the “”@”” symbol. You’ll also see how Gemini builds a fully formatted, color-coded table with drop-down menus based on the data in your notes, saving you significant manual effort.





