{ "version": "https:\/\/jsonfeed.org\/version\/1.1", "title": "Blog — George Mishurovsky: posts tagged meetings", "_rss_description": "A blog by George Mishurovsky — a senior software engineer with a medical degree. Drawing from both engineering and scientific thinking, he explores software, architecture, design, psychology, and product thinking.", "_rss_language": "en", "_itunes_email": "george@mishurovsky.com", "_itunes_categories_xml": "", "_itunes_image": "https:\/\/mishurovsky.com\/blog\/pictures\/userpic\/userpic-square@2x.jpg?1753619610", "_itunes_explicit": "no", "home_page_url": "https:\/\/mishurovsky.com\/blog\/?go=tags\/meetings\/", "feed_url": "https:\/\/mishurovsky.com\/blog\/?go=tags%2Fmeetings%2Fjson%2F", "icon": "https:\/\/mishurovsky.com\/blog\/pictures\/userpic\/userpic@2x.jpg?1753619610", "authors": [ { "name": "George Mishurovsky", "url": "https:\/\/mishurovsky.com\/blog\/", "avatar": "https:\/\/mishurovsky.com\/blog\/pictures\/userpic\/userpic@2x.jpg?1753619610" } ], "items": [ { "id": "8", "url": "https:\/\/mishurovsky.com\/blog\/?go=all\/how-to-recall-your-google-meets-fast\/", "title": "How to Recall Your Google Meets Fast", "content_html": "
\n\"\"\n<\/div>\n

I have to confess. I am a sinner — I constantly forget to log my time spent on tasks! I postpone this demanding chore for a week, until our PM comes bashing my door (and I work remotely!): “Please log your time, we need to create reports!” And here lies the problem: usually, I can hardly remember even what happened yesterday, let alone the whole week. I believe I am not alone here.<\/p>\n

Alright, so now I need to log my work time for the week. I can track code contributions by commit dates, but how do I log meeting times? A common way to do this is to sweep through emails, Slack messages and meeting notes, but it is chaotic and time-consuming. If you use Google Meet, there is a much more straightforward way — Google Takeout!<\/p>\n

Google Takeout is a service that allows you to download all data Google keeps about your account. This is a very interesting yet terrifying resource: you’ll find data from over 60 different services, some of which may keep gigabytes of your data! But for our current goal, we only need Google Meet data.<\/p>\n

What to do<\/h2>\n

First, visit https:\/\/takeout.google.com\/<\/a> from a work account. Deselect all checkboxes, then find and mark Google Meet. Scroll to the bottom of the page, and click primary-colored buttons a couple of times. Google will prepare data export and will send a link to your email. Use it to download a zip archive with data and unpack it.<\/p>\n

\n\"\"\n
When you get to Google Takeout page, deselect all checkboxes and then find and mark Google Meet.<\/div>\n<\/div>\n
\n\"\"\n
Click “Next step”, then “Create export” — Google will send a report to your account email in a minute.<\/div>\n<\/div>\n

The downloaded folder has a nested structure of .\/Takeout\/Google Meet\/ConferenceHistory<\/span> with two .csv<\/span> files inside. We will need only conference_history_records.csv<\/span>. It is a large csv file with about 20 columns, holding information about all meets for your account. Let’s tidy it up with some command line magic to get a convenient output:<\/p>\n

Shell<\/span>