Published inBuzzFeed Tech·PinnedWhy I believe a few photos and the best ballad of 1991 can change the face of collaboration at BuzzFeedA few months ago, I rotated into a special project outside of the People Team — to work on business intelligence with our advertising org. Soon after, our squad released a semi-secret document to pose the following question:Hrtech4 min readHrtech4 min read
May 23Add a Countdown Clock to Project Timelines in DocsUpdate: if you love Apps Script, you will love my new page www.sheetswizard.com/ where I am launching more products and content made to help you become the best operator in your entire organization! In taking on more independent projects this year, one client put me in the Project Manager seat…Google Docs2 min readGoogle Docs2 min read
Apr 11What’s New and Exciting in the Field of People Analytics? 2023 EditionIf you like the tools discussed below, check out what I’ve been launching at www.sheetswizard.com — including the new flagship app for data analysts everywhere! Click here to trial it You may be wondering where I came up with the idea to write an article titled “What’s New and Exciting…HR6 min readHR6 min read
Sep 22, 2022So I’d like to know where you got the Notion data: how to sync Notion, hibob (or Workday) with SheetsIn my last post I gave the basics on how to hook Apps Script up to Notion, who have a notoriously opaque API. HR folks trying to flex their technical chops have it hard enough, so I wanted to get more content out into the world to make life easier…Google Sheets3 min readGoogle Sheets3 min read
Sep 14, 2022Update Notion Databases from a Google Sheet (with Apps Script)Update: if you love Apps Script, you will love my new page www.sheetswizard.com/ where I am launching more products and content made to help you become the best operator in your entire organization! Phew — after two days of trying to find a solution for how to accomplish a popular…Notion4 min readNotion4 min read
Jan 19, 2022Whose Tech is it Anyway? Why there’s (mostly) No Such Thing as HR TechUpdate: sheetswizard.com is now live! If you love HR Tech and building your own tools, you will love the products & educational resources I am adding there, check them out! The greatest trick HR Systems ever pulled was convincing the world they existed… I confess that I am having a…Hrtech6 min readHrtech6 min read
Dec 8, 2021Managers, Automate Your Performance Reviews with my 9 Box MakerHello my friends in the world of performance reviews! Happy review season. If you’re in a large enterprise, you may be the type to build 9 blocks (or 9 boxes) for use in your performance process — big matrices of talent rated on a performance & potential scale. I got…People Analytics2 min readPeople Analytics2 min read
Nov 21, 2021How to Fetch Employee Data from Workday by Building the Great Deku Tree Inside of Google SheetsThey say you only live once, and, with that, you may only once find yourself at a company with a video-game-centric culture. Life at Twitch creates a unique opportunity to bring the magic of gaming to your workday, even when you’re in esoteric corners of the work world such as…HR4 min readHR4 min read
Nov 3, 2021Get Early Access to My New App “Favorite Things” and Unlock the Value of Storing Data in SheetsWhen I teach my Excel to Google Sheets courses, I like to start off with a bang and show new users one of the most overpowered (but complex) formulas in the Sheets arsenal, IMPORTRANGE. Why IMPORTRANGE? It allows you to query data from any other Sheet in your company. This…Google Sheets2 min readGoogle Sheets2 min read
Nov 2, 2020Member-onlyWhen the Best Google Sheet is the One You Don’t MakeHow to build a more perfect workflow for data updates and changes by coding in Apps Script between the Sheets Update Dec 2021: I am gearing up to teach a course on People Analytics to help others break into this world and grow — please fill out this form to…Google Sheet6 min readGoogle Sheet6 min read
