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.
LifterLMS → Google SheetsEvents and actions
Use LifterLMS events to automate Google Sheets
Choose an event from LifterLMS 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.
LifterLMS→Google Sheets
Noptin is installed on 15,000+ websitesSee what users say
Automations
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
LifterLMS events and actions
Courses
6 events · 4 actions
View events and actions
Events
- When a user is enrolled in a course
- When a user is removed from a course
- When a user completes a course
- When a course is published
- When a course is unpublished
- When a course is deleted
Actions
- Enroll a user in a course
- Remove a user from a course
- Create or update a course
- Delete a course
Sections
4 events · 2 actions
View events and actions
Events
- When a user completes a course section
- When a section is published
- When a section is unpublished
- When a section is deleted
Actions
- Create or update a section
- Delete a section
Lessons
4 events · 2 actions
View events and actions
Events
- When a user completes a lesson
- When a lesson is published
- When a lesson is unpublished
- When a lesson is deleted
Actions
- Create or update a lesson
- Delete a lesson
Quizzes
7 events · 2 actions
View events and actions
Events
- When a user completes a quiz attempt
- When a user passes a quiz
- When a user fails a quiz
- When a quiz attempt requires review
- When a quiz is published
- When a quiz is unpublished
- When a quiz is deleted
Actions
- Create or update a quiz
- Delete a quiz
Memberships
5 events · 4 actions
View events and actions
Events
- When a user is enrolled in a membership
- When a user is removed from a membership
- When a membership is published
- When a membership is unpublished
- When a membership is deleted
Actions
- Enroll a user in a membership
- Remove a user from a membership
- Create or update a membership
- Delete a membership
About this connection
How the two tools fit together
LifterLMS: Connect LifterLMS courses, sections, 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 LifterLMS 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 LifterLMS 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 LifterLMS and Google Sheets from Noptin → Extensions. How to activate your license.
- Install and set up LifterLMS 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 an event from LifterLMS 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 LifterLMS and Google Sheets?
Build the automation in your WordPress dashboard with Noptin.
See plans and pricing