Two possible reasons (easy enough, since they're my slides):
The code was really meant to show how I got from point A to B as an example, and I don't think anyone other than me has actual access to that data.
The Google API for googlesheets is changing, and there's and people will be moving to googlesheets4 (the name of which reflects the google API version).
Gavin Simpson has a great post on pivoting here with data available if you're looking to try your hand at more of the new tidyr syntax:
Also there are, of course, the vignettes in the package:
Thank you very much indeed for your help and reply. Congratulations on very informative presentation, by the way is your lecture available as video or webinar ? Would be great to hear your comments on your slides.