Google Sheets + Teachable
Enroll Teachable users in courses for new Google Sheet rows
If you add course enrollment info to a spreadsheet, you'll want it added to your course management tool. This integration helps by automatically enrolling a user in a course in Teachable from info in a new row in a Google Sheet. You won't have manually enroll users in courses again.
If you add course enrollment info to a spreadsheet, you'll want it added to your course management tool. This integration helps by automatically enrolling a user in a course in Teachable from info in a new row in a Google Sheet. You won't have manually enroll users in courses again.
- When this happens...
New Spreadsheet RowTriggers when a new row is added to the bottom of a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Enroll User in CourseEnroll a user in a course on your Teachable school. (If the person does not have an account, one will be created and they will then be enrolled.)
This action is only available to schools on the Professional plans and higher.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
New Admission
Triggers when a new admission record is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Comment
Triggers when a user leaves a comment in your school.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Enrollment
Triggers when a user enrolls in a course. (Note: User's will need to confirm enrollment before the trigger fires if you manually add them to a course).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Lecture Completed
Triggers whenever a user completes a lecture on your school.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Graded Quiz Result
Triggers when a user completes a graded quiz in one of your courses.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Sale
Triggers whenever a user enrolls themselves in a course regardless of whether it is a free or paid course. If you add them as an admin, this does not trigger.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Subscription Cancelled
Triggers whenever a user cancels a subscription on your school.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Tag Removed From User
Triggers when a tag is removed from a user. The "Tags" feature is only available to schools on the Professional plan or above.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Transaction Refunded
Triggers when a transaction has been refunded
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Student Unsubscribes From Marketing Emails
Triggers when a student opts out of marketing emails.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.CourseRequired
EmailRequired
Name
Password
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
Course
Pricing Plan
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
Row Count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row CountRequired
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundAbandoned Cart
Triggers when a user does not complete an order during checkout
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Admission Disabled
Triggers when an admission in Coaching is disabled.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Email Lead Created
Triggers when a user has confirmed their email for lead capture.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Course Completed
Triggers when a user completes 100% of a course.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New User
Triggers whenever a new user signs up for your school.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Student Resubscribes to Marketing Emails
Triggers when a student opts in to marketing emails.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Profile Updated
Triggers whenever a user updates their profile on your school.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Tag Added to User
Triggers when a tag is added to a user. The "Tags" feature is only available to schools on the Professional plan or above.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Unenrollment
Triggers when a user unenrolls in a course. (Note: Users who are unenrolled by admins will also be triggered).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.EmailRequired
NameRequired
Password
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.StudentRequired
Course
Pricing Plan
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
About Google Sheets
Related categories
About Teachable
Related categories
Related Zap Templates
- Log new Teachable sales in Google Sheets rows
- Add new Teachable users to rows on Google Sheets
- Add new enrollments from Teachable to Google Sheets as new rows
- Add new Teachable transactions to Google Sheets as multiple rows
- Create Google Sheet rows for new completed courses in Teachable
- Log completed Teachable lectures by creating new rows in Google Sheets
- Create Google Sheet rows for new completed lectures in Teachable
- Create Google Sheets rows from newly-cancelled subscriptions in Teachable
- Create Google Sheet rows for new Teachable transactions
- Enroll users in Teachable courses from new or updated Google Sheets rows
- Add new Teachable email leads to Google Sheets as rows
- Add new Teachable enrollments to Google Sheets as rows
- Add new Teachable enrollments to Google Sheets rows automatically
- Update Google Sheets rows when new Teachable enrollments occur
- Update Google Sheets rows with new Teachable enrollments for seamless data tracking
- Update Google Sheets rows with new Teachable transactions
- Update Google Sheets rows when new Teachable courses are completed
- Create new Teachable users from new Google Sheets rows
- Unenroll students from Teachable courses when Google Sheets rows are updated
- Create Teachable users from new or updated Google Sheets rows
- Create multiple spreadsheet rows in Google Sheets for new Teachable transactions
- Update Google Sheets rows when new Teachable courses are completed
- Capture abandoned carts in Teachable and create new rows in Google Sheets
- Enroll users in Teachable courses from new rows in Google Sheets
- Enroll users in Teachable courses for every new or updated row in Google Sheets
- Create spreadsheet rows in Google Sheets for new graded quiz results in Teachable
- Record Teachable completed courses in Google Sheets by creating new rows
- Enroll users in Teachable courses when new rows are added to a Google Sheets team drive
- Create multiple rows in Google Sheets for new enrollments in Teachable
- Create spreadsheet rows in Google Sheets for every new comment in Teachable
- Create spreadsheet rows in Google Sheets for new unenrollments in Teachable
- Create multiple spreadsheet rows in Google Sheets for new sales in Teachable
- Unenroll students from Teachable courses when new rows are added in Google Sheets
- Update Google Sheets rows when subscriptions are cancelled in Teachable
- Enroll users in Teachable courses for every new or updated row in Google Sheets team drive
- Create multiple spreadsheet rows in Google Sheets when subscriptions are cancelled in Teachable
Related Zap Templates
- Log new Teachable sales in Google Sheets rows
- Add new Teachable transactions to Google Sheets as multiple rows
- Create Google Sheet rows for new completed lectures in Teachable
- Enroll users in Teachable courses from new or updated Google Sheets rows
- Add new Teachable enrollments to Google Sheets rows automatically
- Update Google Sheets rows with new Teachable transactions
- Unenroll students from Teachable courses when Google Sheets rows are updated
- Update Google Sheets rows when new Teachable courses are completed
- Enroll users in Teachable courses for every new or updated row in Google Sheets
- Enroll users in Teachable courses when new rows are added to a Google Sheets team drive
- Create spreadsheet rows in Google Sheets for new unenrollments in Teachable
- Update Google Sheets rows when subscriptions are cancelled in Teachable
- Add new Teachable users to rows on Google Sheets
- Create Google Sheet rows for new completed courses in Teachable
- Create Google Sheets rows from newly-cancelled subscriptions in Teachable
- Add new Teachable email leads to Google Sheets as rows
- Update Google Sheets rows when new Teachable enrollments occur
- Update Google Sheets rows when new Teachable courses are completed
- Create Teachable users from new or updated Google Sheets rows
- Capture abandoned carts in Teachable and create new rows in Google Sheets
- Create spreadsheet rows in Google Sheets for new graded quiz results in Teachable
- Create multiple rows in Google Sheets for new enrollments in Teachable
- Create multiple spreadsheet rows in Google Sheets for new sales in Teachable
- Enroll users in Teachable courses for every new or updated row in Google Sheets team drive
- Add new enrollments from Teachable to Google Sheets as new rows
- Log completed Teachable lectures by creating new rows in Google Sheets
- Create Google Sheet rows for new Teachable transactions
- Add new Teachable enrollments to Google Sheets as rows
- Update Google Sheets rows with new Teachable enrollments for seamless data tracking
- Create new Teachable users from new Google Sheets rows
- Create multiple spreadsheet rows in Google Sheets for new Teachable transactions
- Enroll users in Teachable courses from new rows in Google Sheets
- Record Teachable completed courses in Google Sheets by creating new rows
- Create spreadsheet rows in Google Sheets for every new comment in Teachable
- Unenroll students from Teachable courses when new rows are added in Google Sheets
- Create multiple spreadsheet rows in Google Sheets when subscriptions are cancelled in Teachable