Automatically Resend Course Invitations on a Schedule?

[tammi_brandon]

Is there a way to automatically resend course invitations? Currently, our institution manually resends invitations at 7 and 14 days for our shorter courses and 30, 60, and 90 days for our year-long access courses. This is creating a lot of work for our team. Is there a way in Canvas to set the invitations to be automatically resent according to a set schedule? Or, is there an add on that allows for this?

[Hildi_Pardo · Accepted solution]

Hi @tammi_brandon - I'm not aware of this being a feature.   And I'm guessing you have to click to resend for each user?  
(At a minimum it would be helpful to enter each course and just "resend" to all users who haven't accepted).    You may want to submit this as an Idea:  https://community.canvaslms.com/t5/Instructure-Community-Guide/How-do-I-create-a-new-idea-in-the-Ins...

One way to get around having student accept invitations is for enrollments to be done via SIS import -- if you don't have automated course creation and enrollment from your SIS to Canvas, you could still do this via a file upload.    Talk with your Canvas Admin about it -- perhaps they can do it for you.

[tammi_brandon]

Hi, Hildi,

Thanks for the reply. We can manually resend invitations to all users in one class, but we have dozens of classes that begin each month, so that makes for a long and cumbersome process when trying to resend to all classes. 

I will add the idea through the new-idea link. Thank you.

[jerry_nguyen]

@tammi_brandon 

You can access Canvas Data to pull a list of students currently yet to accept their invitation. Canvas Data allows you to create custom reports using queries or SQL. You can download Canvas Data to your computer or server, but you may need to contact your Canvas CSM to enable access.

The following SQL query can be used to generate this report

SELECT
  "canvas"."users"."name" AS "Student Name",
  "Pseudonyms"."unique_id" AS "Email",
  "Enrollments"."workflow_state" AS "Enrollment Status",
  "Courses"."name" AS "Course Name"
FROM
  "canvas"."users"
 
LEFT JOIN "canvas"."pseudonyms" AS "Pseudonyms" ON "canvas"."users"."id" = "Pseudonyms"."user_id"
  LEFT JOIN "canvas"."enrollments" AS "Enrollments" ON "canvas"."users"."id" = "Enrollments"."user_id"
  LEFT JOIN "canvas"."courses" AS "Courses" ON "Enrollments"."course_id" = "Courses"."id"
WHERE
  "Enrollments"."workflow_state" = CAST(
    'invited' AS "canvas"."enrollments__workflow_state"
  )

Then you input this data into a workflow automation tool like n8n to automatically send the reminder email.

Please feel free to send me a PM if you need help setting it up.