Google Sheets + Teachable
Create Google Sheet rows for new Teachable transactions
When you have new transactions from customers, you'll want the details organized in a spreadsheet. This integration helps by automatically creating a row in a Google Sheet when there is a new successful transaction in Teachable. You won't have to copy and paste important transaction details again.
When you have new transactions from customers, you'll want the details organized in a spreadsheet. This integration helps by automatically creating a row in a Google Sheet when there is a new successful transaction in Teachable. You won't have to copy and paste important transaction details again.
- When this happens...
New TransactionTriggers when a student is successfully charged and makes a payment for a sale (including one-time, subscription, or payment plan purchases).
For a subscription or a payment plan, there is a new transaction created for every single payment.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create Spreadsheet RowCreate a new row in a specific spreadsheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Abandoned 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
Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Dont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDont Change Sheet Structure
No 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.Drive
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
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
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
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.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
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
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
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 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 appDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Dont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
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
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
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
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
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
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
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
Row count
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
Row count
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
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
- Create Google Sheet rows for new completed courses in Teachable
- Create Google Sheet rows for new completed lectures in Teachable
- Add new Teachable transactions to Google Sheets as multiple rows
- Log completed Teachable lectures by creating new rows in Google Sheets
- Enroll Teachable users in courses for new Google Sheet rows
- Create Google Sheets rows from newly-cancelled subscriptions in Teachable
- 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
- Create Google Sheets rows for new transactions in Teachable
- Create spreadsheet rows at the top in Google Sheets for new sales in Teachable
- Add new Teachable admissions to Google Sheets rows instantly
Related Zap Templates
- Log new Teachable sales in Google Sheets rows
- Create Google Sheet rows for new completed courses in Teachable
- Log completed Teachable lectures by creating new rows in Google Sheets
- 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
- Create Google Sheets rows for new transactions in Teachable
- Add new Teachable users to rows on Google Sheets
- Create Google Sheet rows for new completed lectures in Teachable
- Enroll Teachable users in courses for new Google Sheet rows
- 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
- Create spreadsheet rows at the top in Google Sheets for new sales in Teachable
- Add new enrollments from Teachable to Google Sheets as new rows
- Add new Teachable transactions to Google Sheets as multiple rows
- Create Google Sheets rows from newly-cancelled subscriptions in Teachable
- 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
- Add new Teachable admissions to Google Sheets rows instantly