This is copied straight from James Jones' Canvancement Series (original instructions here:

https://community.canvaslms.com/docs/DOC-5676) 


One Time Setup

  1. Log into your Google Drive account.
  2. Open the Page Manager spreadsheet.
  3. Choose File > Make a copy. This won't be available if you're not logged into Google Drive.
  4. There will be a Canvas menu added to the Google Sheet and you'll use it for everything else. From that menu, choose Configure API settings. You'll need to authorize Google to access your Canvas instance and tell it what your instance and access token are.(watch the video below)

Those are things that need done before you can use the spreadsheet.

Regular Use

  1. Choose Select Course from the Canvas menu in your Google spreadsheet. Enter the Canvas Course ID as a number or you may also just paste a URL from your course.
  2. Choose Load Page List from the Canvas menu. This will load a list of the page titles and URLs and display it along with their current published state (1: published, 0: unpublished).
  3. Edit the Action column for the pages you want to change. You don't need to do anything with the pages you don't want changed.
    • Use a 1 to publish a page
    • Use a 0 to unpublish a page
    • Use a -1 to delete a page
  4. Choose Save Changes from the Canvas menu to write the changes to Canvas.

The next time you need to use this, just choose a new course and start from there.


Video Walk-Through

I consider this one of the simpler interfaces to explain, so I made a video for you. If that sounds backwards, realize it's about time management -- simpler means it takes less time to explain and edit.

 

Notes

  • The need to publish or unpublish may not be as great, but I it was easy to do and worked out well with the design so I included it. Besides, some people may want to delete all unpublished pages, so it serves as an easy way to identify those pages (hint, do a sort by action to group them and make them easier to change).
  • The video only shows changing two pages for demonstration purposes, but you can change as many as you need to change.
  • Do not move the columns around or delete them. I wasn't as flexible with this one as I was with the due dates spreadsheet. This one assumes you have an action, followed by a title, followed by the URL.
  • You may delete rows if you like as it does not affect the process. To be clear, you do not delete a row from the spreadsheet to delete it from Canvas, you put a -1 (negative one) in the action column to delete a page.
  • My spreadsheet apps have come a long way since I first started writing them. Everything is now controlled through a Canvas menu that is added to the Google Sheets menu. You can copy/paste your information there and Google will save it for you. You don't have to worry about sharing the document with someone because the credentials you don't go with it. When specifying Canvas IDs, you can paste an appropriate URL and it will grab the information for you. There's no longer a need to edit the source code like my first scripts required. Finally, some errors are now logged to a pop-up alert box so that you don't have to go into the source code and view the log files when things don't go as planned.