Add or update a row in Google Sheets when a user completes a lesson
When a user completes a lesson
Add or update a row in Google Sheets.
LearnPress → Google SheetsEvents and actions
Use LearnPress events to automate Google Sheets
Choose an event from LearnPress 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.
LearnPress→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
LearnPress events and actions
Courses
4 events · 3 actions
View events and actions
Events
- When a user completes a course
- When a LearnPress course is published
- When a LearnPress course is unpublished
- When a LearnPress course is deleted
Actions
- Enroll a user in a LearnPress course
- Create or update a LearnPress course
- Delete a LearnPress course
Lessons
4 events · 2 actions
View events and actions
Events
- When a user completes a lesson
- When a LearnPress lesson is published
- When a LearnPress lesson is unpublished
- When a LearnPress lesson is deleted
Actions
- Create or update a LearnPress lesson
- Delete a LearnPress lesson
Quizzes
4 events · 2 actions
View events and actions
Events
- When a user completes a quiz
- When a LearnPress quiz is published
- When a LearnPress quiz is unpublished
- When a LearnPress quiz is deleted
Actions
- Create or update a LearnPress quiz
- Delete a LearnPress quiz
About this connection
How the two tools fit together
LearnPress: Connect LearnPress 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 LearnPress 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 LearnPress 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 LearnPress and Google Sheets from Noptin → Extensions. How to activate your license.
- Install and set up LearnPress 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 LearnPress 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 LearnPress and Google Sheets?
Build the automation in your WordPress dashboard with Noptin.
See plans and pricing