{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/2510081dbcdd4b06837108e71227b847\" frameborder=\"0\" width=\"1280\" height=\"960\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":960,"width":1280,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":960,"thumbnail_width":1280,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/2510081dbcdd4b06837108e71227b847-8a95fb61ea04c252.gif","duration":220.468,"title":"Automating Data Management with Google Sheets 📊","description":"In this video, I explain the automated system I've created that reads data from emails and organizes it into a Google Sheet. Each day, a new tab is generated with the current date, and I’ve implemented a schedule trigger to keep our files clean by deleting the previous day's sheet. The system also utilizes a Gmail trigger to gather information from email attachments and text, ensuring all relevant data is captured efficiently. I used various conditional logic elements to handle different formats of incoming data. Please review the workflow and let me know if you have any questions or suggestions for improvement."}