Snippets Archives | The Efficient Teacher

Authenticate a session to get a bearer token

Create an authenticated session and obtain a bearer token for use with the Bluesky API when creating or modifying records.

List a Bluesky user’s followers and follows programmatically so that they can be compared to identify mismatches.

Bluesky handles can be changed but the underlying DID is persistent. Learn how to lookup the DID from a handle, for use in API calls.

Use Apps Script to automate inviting guardians in Classroom using a list held in Google Sheets

Learn how to use Google Apps Script to automate allowing permission for the IMPORTRANGE function in Google Sheets.

Use Apps Script to automate the syncing of students enrolled on a Classroom course with a list held in Google Sheets

Invite a Sheet-based list of students to enrol on a Google Classroom course.

Write data from your script to a range of cells on a sheet.

Read data from a range of cells on a sheet, ready for your script to process.

Add your own menu to Sheets (or Docs, Slides or Forms) to run functions in your script.