Google Sheets + Teachworks
Record completed lessons in Teachworks as new rows in Google Sheets
Keep your student progress records up-to-date with this Teachworks to Google Sheets workflow. When a lesson gets completed in Teachworks, corresponding information is directly sent to Google Sheets, creating a new row in your chosen spreadsheet. This seamless connection ensures you have a comprehensive, continually updated spreadsheet of all completed lessons. Save hours you'd typically spend on manual data entry, and instead, focus on improving and creating more engaging lessons.
Keep your student progress records up-to-date with this Teachworks to Google Sheets workflow. When a lesson gets completed in Teachworks, corresponding information is directly sent to Google Sheets, creating a new row in your chosen spreadsheet. This seamless connection ensures you have a comprehensive, continually updated spreadsheet of all completed lessons. Save hours you'd typically spend on manual data entry, and instead, focus on improving and creating more engaging lessons.
- When this happens...
Lesson CompletedTriggers when a teacher is marked as completed by setting the attendance status in Teachworks.
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
New Cost Premium
Triggers when a new cost premium is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Availability
Triggers when a new availability is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Employee
Triggers when a new employee is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Lesson
Triggers when a new lesson is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Location
Triggers when a new location is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Package Balance Alert
Triggers when a low package balance alert is sent.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Refund
Triggers when a new refund is created
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Student
Triggers when a new student is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Wage Payment
Triggers when a new wage payment has been created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Customer IDRequired
First NameRequired
Last NameRequired
Email
Additional Email
Home Phone
Mobile Phone
Status
School
Grade
Additional Notes
Calendar Color
Birth Date
Start Date
Billing MethodRequired
Student Cost
Cost Premium ID
Discount Rate
Lesson Reminder Emails
Lesson Notes Emails
SMS Lesson Reminders
Default Location ID
Default Service IDs
Default Teacher IDs
Unviewed
Send Welcome Email
Enable User Account
Student Groups
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Salutation
First NameRequired
Last NameRequired
Email
Additional Email
Home Phone
Mobile Phone
Work Phone
Address
Address - Line 2
City
State
Zip or Postal Code
Country
Additional Notes
Status
Enable Email Lesson Reminders
Email Lesson Notes
SMS Lesson Reminders
Unviewed
Stripe ID
Send Welcome Email
Enable User Account
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Lesson nameRequired
Description
Teacher IDRequired
Student ID(s)Required
Service IDRequired
Location IDRequired
Number of Student Spaces
Start date of the lessonRequired
Start time of the lessonRequired
End date of the lessonRequired
End time of the lessonRequired
Override Default Cost Calculation
Override Method
Custom Override Price
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer IDRequired
Custom Field IDRequired
Custom Field Value
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First Name
Last Name
Email
Customer ID
Student ID
Sort Direction
ActionThis is an event a Zap performs.SearchFind existing data in your appEmployee ID
First Name
Last Name
Email
Sort Direction
ActionThis is an event a Zap performs.SearchFind existing data in your appFirst Name
Last Name
Email
Sort Direction
ActionThis is an event a Zap performs.SearchFind existing data in your appPayment DateRequired
Customer IDRequired
AmountRequired
Sort Direction
ActionThis is an event a Zap performs.SearchFind existing data in your appFirst NameRequired
Last NameRequired
Email
Sort Direction
Salutation
Additional Email
Home Phone
Mobile Phone
Work Phone
Address
Address - Line 2
City
State
Zip or Postal Code
Country
Additional Notes
Status
Enable Email Lesson Reminders
Email Lesson Notes
SMS Lesson Reminders
Unviewed
Stripe ID
Send Welcome Email
Enable User Account
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDateRequired
Customer IDRequired
AmountRequired
Sort Direction
Description
Payment Method
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNo 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 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
Lesson Completed
Triggers when a teacher is marked as completed by setting the attendance status in Teachworks.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Customer
Triggers when a new customer (family or independent student) is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Invoice
Triggers when a new invoice is approved (ie. created or updated with status set to "Approved")
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Lesson Participant
Triggers when a new lesson participant is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Other Event
Triggers when a new event is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Payment
Triggers when a new payment is created
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Service
Triggers when a new service is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Unavailability
Triggers when a new unavailability is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Wage Tier
Triggers when a new wage tier is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planFirst NameRequired
Last NameRequired
Employee TypeRequired
Include as Teacher
Status
Email
Mobile Phone
Home Phone
Address
Address - Line 2
City
State
Zip
Country
Additional Notes
Birth Date
Hire Date
Position
Bio
Wage Type
Employee Wage
Wage Tier ID
Work Wage Type
Work Wage
Default Calendar View
Calendar Color By
Calendar Color
Subject IDs
Enable Email Lesson Reminders
Enable SMS Lesson Reminders
Unviewed
Send Welcome Email
Enable User Account
Permission - Other Teacher's Lessons
Permission - Student Contact Info
Permission - Calendar Events
Permission - Lesson Cost
Permission - Lesson Duration
Permission - Send Lesson Notes
Permission - Upload Files
Permission - Staff
Permission - Teachers
Permission - Students & Families
Permission - Accounting
Permission - Payroll & Hours
Permission - Services
Permission - Locations & Vehicles
Permission - Lesson Wage (Other's)
Permission - Analytics Reports
Permission - Tasks
Permission - Account Settings
Permission - Subscription
Permission - Integrations Settings
Permission - Send Emails
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Salutation
First NameRequired
Last NameRequired
Email
Additional Email
Home Phone
Mobile Phone
Work Phone
Address
Address - Line 2
City
State
Zip or Postal Code
Country
Status
Unviewed
Stripe ID
Additional Notes
Send Welcome Email
Enable User Account
School
Grade
Calendar Color
Birth Date
Start Date
Billing Method
Student Cost
Cost Premium ID
Discount Rate
Lesson Reminder Emails
SMS Lesson Reminders
Lesson Notes Emails
Default Location ID
Default Service IDs
Default Teacher IDs
Student Groups
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer IDRequired
DateRequired
AmountRequired
Description
Payment Method
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Student IDRequired
Custom Field IDRequired
Custom Field Value
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First Name
Last Name
Email
Customer ID
Sort Direction
ActionThis is an event a Zap performs.SearchFind existing data in your appFirst Name
Last Name
Email
Sort Direction
ActionThis is an event a Zap performs.SearchFind existing data in your appFirst Name
Last Name
Email
Student ID
Sort Direction
ActionThis is an event a Zap performs.SearchFind existing data in your appFirst NameRequired
Last NameRequired
Email
Customer IDRequired
Student ID
Sort Direction
Additional Email
Home Phone
Mobile Phone
Status
School
Grade
Additional Notes
Calendar Color
Birth Date
Start Date
Billing MethodRequired
Student Cost
Cost Premium ID
Discount Rate
Lesson Reminder Emails
Lesson Notes Emails
SMS Lesson Reminders
Default Location ID
Default Service IDs
Default Teacher IDs
Unviewed
Send Welcome Email
Enable User Account
Student Groups
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFirst NameRequired
Last NameRequired
Email
Sort Direction
Salutation
Additional Email
Home Phone
Mobile Phone
Work Phone
Address
Address - Line 2
City
State
Zip or Postal Code
Country
Status
Unviewed
Stripe ID
Additional Notes
Send Welcome Email
Enable User Account
School
Grade
Calendar Color
Birth Date
Start Date
Billing Method
Student Cost
Cost Premium ID
Discount Rate
Lesson Reminder Emails
SMS Lesson Reminders
Lesson Notes Emails
Default Location ID
Default Service IDs
Default Teacher IDs
Student Groups
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier 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.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.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
About Google Sheets
Related categories
