Google Sheets + Uteach
Create Google Sheets spreadsheets for new Uteach students
Activate this template to create a Google Sheets spreadsheet whenever you have a new Uteach student.
Activate this template to create a Google Sheets spreadsheet whenever you have a new Uteach student.
- When this happens...
New StudentTriggers when a new student is registered.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create SpreadsheetCreates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Bundle Access Removed
Triggers when access to a bundle is removed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Course Access Removed
Triggers when access to a course is removed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Form Submitted
Triggers when a new form is submitted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Membership Access Removed
Triggers when access to a membership is removed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Coach Enrollment
Triggers when a new coach is enrolled.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Live Lesson Enrollment
Triggers when a new live lesson is enrolled.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Product Enrollment
Triggers when a new product is enrolled.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Product Access Removed
Triggers when access to a product is removed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Student EmailRequired
Bundle SlugRequired
Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Student EmailRequired
Course SlugRequired
Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Student EmailRequired
Membership IdRequired
Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Student NameRequired
Student EmailRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Coach Id
Coach Slug
ActionThis is an event a Zap performs.SearchFind existing data in your appLive Lesson Id
Live Lesson Slug
ActionThis is an event a Zap performs.SearchFind existing data in your appProduct IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDont 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
Coach Access Removed
Triggers when access to a coach is removed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Course Completed
Triggers when the student completed a course.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Live Lesson Access Removed
Triggers when access to a live lesson is removed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Bundle Enrollment
Triggers when a new bundle is enrolled.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Course Enrollment
Triggers when a new course is enrolled.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Membership Enrollment
Triggers when a new membership is enrolled.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Student
Triggers when a new student is registered.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Quiz Submitted
Triggers when a new quiz is submitted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Student EmailRequired
Coach SlugRequired
Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Student EmailRequired
Live Lesson SlugRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Student EmailRequired
Product IdRequired
Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Bundle Id
Bundle Slug
ActionThis is an event a Zap performs.SearchFind existing data in your appCourse Id
Course Slug
ActionThis is an event a Zap performs.SearchFind existing data in your appMembership IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appUser Id
User Email
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 Uteach
Related categories
Related Zap Templates
- Create Google Sheets spreadsheets for newly completed Uteach courses
- Create multiple rows in Google Sheets when new courses are completed in Uteach
- Create spreadsheet rows in Google Sheets for new course enrollments in Uteach
- Create spreadsheet rows in Google Sheets for new coach enrollments in Uteach
- Add new Uteach memberships to Google Sheets rows instantly