LearnDash Enrollments to Google Sheets: Course Ops Register
A row when a student is enrolled in a course and a row when a course is completed, written to your own Google Sheet as it happens. From those two tabs: instructor numbers, cohort completion rates and a weekly summary.
In This Guide
- A Course Register in Google Sheets
- Why Put Course Data in a Spreadsheet?
- Which LearnDash Events Does SheetLink Capture?
- How Does LearnDash Data Reach the Sheet?
- Setting Up the Two Rules
- What Goes on an Instructor Tab?
- How Do You Track Cohort Completion?
- How Long Does the Course Take?
- Who Has Stalled?
- How Do the Numbers Reach Your Inbox?
- Frequently Asked Questions
A Course Register in Google Sheets
SheetLink writes two LearnDash events to Google Sheets: a row when a student is enrolled in a course, and a row when a student completes a course. Both are part of SheetLink Pro ($79/year or $199 lifetime). This guide sets up the two rules, shows the columns you get, and then puts them to work: an instructor tab, cohort completion rates and a weekly summary.
Everything below is built on those two events and nothing else. Quiz results, lesson and topic completions are not sent, so none of the reports here depend on them.
Why Put Course Data in a Spreadsheet?
Because it is the one reporting surface everyone involved already knows. A co-instructor, a client or an assistant can read a sheet, and extend it, without a WordPress account or another login to manage.
LearnDash's own reports answer the questions they were built for. A register of raw events answers the ones you think of later: did the students who joined in September finish more often than the ones who joined in June, and how long does the course take the people who do finish? Those are two-column questions once every enrollment and every completion is a row with a date on it.
A sheet is also yours. The rows go from your WordPress site to your own Google account, and they stay there whatever you later change on the site.
Which LearnDash Events Does SheetLink Capture?
Two, each as its own source in the rule editor:
- LearnDash - student enrolled - written when LearnDash gives a student access to a course, whether an administrator enrolls them or they enroll themselves. Columns:
user_id,user_email,user_login,course_id,course_title,enrolled_at. - LearnDash - course completed - written when LearnDash marks a course complete for a student. Columns:
user_id,user_email,user_login,course_id,course_title,completed_at.
What is not captured: quiz attempts and scores, lesson and topic completions, and course progress percentages. When a student's access to a course is removed, no row is written either, so the sheet records people joining, not leaving.
Keep the two events as separate rows on separate tabs rather than updating one row. A completion row with its own date is what makes time-to-complete and cohort maths possible, and it means an enrollment row is never edited after it is written.
How Does LearnDash Data Reach the Sheet?
SheetLink Pro listens for the two LearnDash actions on your own site and hands each event to the same delivery pipeline your forms use. The row is written through the one-click Google connection or through a classic Apps Script web app in your own Google account. There is no relay service in between.
Because it is the same pipeline, the same safety net applies. Every delivery is listed in the Sync Log, and a failed one is retried about 5 minutes, 30 minutes and 2 hours later, then kept in the Retry Queue for a one-click re-send.
The feed is live only. It starts when you switch the rule on; enrollments and completions from before that are not imported.
Setting Up the Two Rules
You need the free SheetLink Forms plugin, the SheetLink Pro plugin with an active licence, and LearnDash.
- Install SheetLink Forms from WordPress.org and connect Google under SheetLink → Connect Google, picking or creating the spreadsheet for your register.
- Install SheetLink Pro and activate your licence under SheetLink → License. The LearnDash sources come with the Extra Integrations feature, which is on by default; its switch is on the SheetLink → Features page.
- Under SheetLink → Sync Rules click + Add Rule and choose LearnDash - student enrolled as the form plugin. Leave Form ID blank to cover every course, or enter one course's ID to cover only that course. The ID is the number after
post=in the address bar when you edit the course. - Add a second rule with LearnDash - course completed.
- Enroll a test user in a course, then mark the course complete for them, and check that a row arrived for each.
With the one-click connection each rule writes to its own tab, and the first event writes the header row. With the default settings the columns are, left to right: Timestamp, user_id, user_email, user_login, course_id, course_title, then enrolled_at on the enrollment tab or completed_at on the completion tab. The formulas below assume that layout and call the two tabs Enrollments and Completions; use your own tab names.
What Goes on an Instructor Tab?
An instructor tab is a formulas-only tab that reads the two event tabs and shows current numbers. Nobody touches the raw rows.
- Enrollments in the last 7 days:
=COUNTIFS(Enrollments!G:G, ">="&TODAY()-7) - Completions this month:
=COUNTIFS(Completions!G:G, ">="&EOMONTH(TODAY(),-1)+1) - Enrollments for one course:
=COUNTIF(Enrollments!F:F, "SEO Basics") - The ten most recent completions:
=QUERY(Completions!A:G, "select C, F, G order by G desc limit 10", 1)
Share the spreadsheet as view-only, or pull the tab into a separate spreadsheet with IMPORTRANGE, and instructors see the numbers without a WordPress account.
How Do You Track Cohort Completion?
A cohort is everyone who enrolled in a course in the same month. Completion rate for a cohort is finishers divided by cohort size, and it needs one helper column to tell which enrollments were finished.
On the Enrollments tab add a column H headed "completed" with this in H2, filled down: =COUNTIFS(Completions!C:C, C2, Completions!E:E, E2)>0. It is TRUE when the same student has a completion row for the same course.
Cohort size for course 412 in September 2026 is then =COUNTIFS(Enrollments!E:E, 412, Enrollments!G:G, ">="&DATE(2026,9,1), Enrollments!G:G, "<"&DATE(2026,10,1)). Finishers is the same formula with one more pair: Enrollments!H:H, TRUE. Divide one by the other.
Lay the result out with one row per month and three columns: enrolled, completed, rate. Small cohorts swing a long way on one student, so look at the raw rows before reacting to a single low month.
How Long Does the Course Take?
On the Completions tab add a column H headed "days" with this in H2, filled down: =G2-MINIFS(Enrollments!G:G, Enrollments!C:C, C2, Enrollments!E:E, E2). It subtracts the student's first enrollment date for that course from the completion date. Format the column as a number.
A student who enrolled before the rule was switched on has no enrollment row, so their result is not meaningful; filter those out. For everyone else, =MEDIAN(H2:H) gives the typical time to complete, and the same figure per course tells you which courses people finish in a weekend and which they abandon for a month in the middle.
Who Has Stalled?
The helper column from the cohort section also gives a follow-up list: everyone who enrolled more than 30 days ago and has no completion row. =FILTER(Enrollments!C2:G, Enrollments!H2:H=FALSE, Enrollments!G2:G<TODAY()-30) returns their email, course and enrollment date.
That list is a starting point, not a verdict. It cannot see lesson progress, so a student who is one lesson from the end looks the same as one who never opened the course. Use it to decide who gets a personal note.
How Do the Numbers Reach Your Inbox?
A small Apps Script time trigger can read the instructor tab every Monday and email the week's enrollments and completions. The script pattern is the one in our weekly digest walkthrough: swap the lead columns for the course columns and set the trigger.
Start with the enrollment rule, run it for a week, then add completions once the columns look right. The reports worth having all join the two tabs, so the register becomes more useful the longer both have been running.
Frequently Asked Questions
What LearnDash data does SheetLink send to Google Sheets?
Two events: a row when a student is enrolled in a course and a row when a student completes a course. Each row carries the user ID, email and login, the course ID and title, and the date and time of the event.
Are quiz results or lesson completions sent?
No. SheetLink captures course enrollment and course completion only. Quiz attempts and scores, lesson and topic completions and progress percentages are not sent.
What do I need, and what does it cost?
The free SheetLink Forms plugin, the SheetLink Pro plugin and LearnDash. The LearnDash sources are part of SheetLink Pro, which is $79/year or $199 lifetime; they are not in the free plugin.
Can I send only one course?
Yes. Enter that course's ID in the rule's Form ID. The ID is the number after post= in the address bar when you edit the course. Leave Form ID blank and the rule covers every course.
Is a row written when a student is removed from a course?
No. A row is written when access is granted and when a course is completed. Removing a student's access writes nothing.
Can I import students who enrolled before I set this up?
No. The feed is live from the moment the rule is switched on. Earlier enrollments and completions are not imported, so add them by hand if you need them in the same sheet.
How do I calculate course completion rate in Google Sheets?
Add a helper column on the enrollment tab that checks whether the same student has a completion row for the same course, then divide the enrollments where it is TRUE by all enrollments for the course and period. Grouping by enrollment month gives cohort completion rates.
Can instructors see course numbers without WordPress access?
Yes. Share the spreadsheet as view-only, or build a separate spreadsheet fed by IMPORTRANGE. Instructors get the current counts without a WordPress account, and you decide whether they see totals or individual students.
More Automation guides
Send LearnDash Enrollments and Completions to Sheets
SheetLink Pro writes each enrollment and each course completion to your own Google Sheet, straight from your WordPress site.
