Add or update a row in Google Sheets when a user completes a course
When a user completes a course
Add or update a row in Google Sheets.
Sensei LMS → Google SheetsEvents and actions
Use Sensei LMS events to automate Google Sheets
Choose a Sensei LMS event to start an automation, then add or update a row in Google Sheets. The action settings show what information you need to provide.
Already using Noptin? Learn how to create an automation rule.
Noptin is installed on 15,000+ websitesSee what users say
Automation ideas
Ways to connect these tools
These are examples. Available fields depend on the event and the choices on your site or connected account.
Available in Noptin
Google Sheets actions
Rows
1 action
- Add or update a row in Google Sheets.
Available in Noptin
Sensei LMS events and actions
Courses
5 events · 4 actions
View events and actions
Events
- When a user starts a course
- When a user completes a course
- When a Sensei LMS course is published
- When a Sensei LMS course is unpublished
- When a Sensei LMS course is deleted
Actions
- Enroll a user in a course
- Remove a user from a course and delete their progress
- Create or update a Sensei LMS course
- Delete a Sensei LMS course
Lessons
4 events · 2 actions
View events and actions
Events
- When a user completes a lesson
- When a Sensei LMS lesson is published
- When a Sensei LMS lesson is unpublished
- When a Sensei LMS lesson is deleted
Actions
- Create or update a Sensei LMS lesson
- Delete a Sensei LMS lesson
Quizzes
5 events · 2 actions
View events and actions
Events
- When a user passes a quiz
- When a user fails a quiz
- When a Sensei LMS quiz is published
- When a Sensei LMS quiz is unpublished
- When a Sensei LMS quiz is deleted
Actions
- Create or update a Sensei LMS quiz
- Delete a Sensei LMS quiz
About this connection
How the two tools fit together
Sensei LMS: Connect Sensei LMS courses, lessons, and quizzes to Noptin.
Google Sheets: Google Sheets is a web-based spreadsheet application that enables you to create, edit and share spreadsheets online. With this integration, you can automatically add and update data in your Google Sheets when certain events occur in WordPress.
What information can you send?
Choose a spreadsheet and worksheet. Noptin shows its column headings so you can decide what goes in each column.
Available details depend on the Sensei LMS event or action you choose and any fields configured on your site. Available columns come from the header row of the worksheet selected in the connected Google account.
Before you begin
Have these details ready
For Add or Update Row, you will need:
- Connected Google account
- Spreadsheet and worksheet
- Values for the worksheet columns
Start here
Set up Sensei LMS and Google Sheets with Noptin
- Install the free Noptin plugin on your WordPress site.
- Activate your Noptin license, then install the Noptin add-on for Sensei LMS and Google Sheets from Noptin → Extensions. How to activate your license.
- Install and set up Sensei LMS on your WordPress site. Connect Google Sheets in Noptin using the account or server details requested in its settings.
How to install the Noptin newsletter plugin
Put it together
Set up the automation in WordPress
- Choose a Sensei LMS event to start the automation.
- Select the Google account, spreadsheet, and worksheet that should receive the row.
- Match the details from the first step to the fields in the second. Run a test, then turn on the rule.
Follow the automation rules guide if you need help creating the rule.
Ready to connect Sensei LMS and Google Sheets?
Build the automation in your WordPress dashboard with Noptin.
See plans and pricing