Google Sheets + QuickSchools.com
Create spreadsheet rows in Google Sheets for new and updated parent records in QuickSchools.com
Stay on top of changes in your QuickSchools.com records by using this workflow. Every time there's a new or updated parent record on QuickSchools.com, it will create a corresponding row in your Google Sheets document. This workflow makes it easy to track and record updates, ensuring you always have the most current information at hand.
Stay on top of changes in your QuickSchools.com records by using this workflow. Every time there's a new or updated parent record on QuickSchools.com, it will create a corresponding row in your Google Sheets document. This workflow makes it easy to track and record updates, ensuring you always have the most current information at hand.
- When this happens...
New and Updated Parent RecordsTriggers when a new parent record is created and when a parent record is updated.
TriggerPollingZapier checks for new data every 15 min on the Free plan - 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 Parent Record
Triggers when a new parent record is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Parent Record
Triggers when a parent record is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Student Custom Fields
Triggers when a student custom field is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Teacher Record
Triggers when a new teacher record is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Teacher Record
Triggers when a teacher record is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Subdomain (GROUP SCHOOLS ONLY)
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planSubdomain (GROUP SCHOOLS ONLY)
Include Students that Have Left?
Include Deleted Students?
Additional Fields (Optional)
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planSubdomain (GROUP SCHOOLS ONLY)
Applicant Full NameRequired
Preferred NameRequired
BirthdateRequired
GenderRequired
Application RemarksRequired
Contact NumberRequired
Contact Email AddressRequired
Current SchoolRequired
Current Grade LevelRequired
Enrollment DateRequired
Student Residential Address
City
State
Zip Code
Home Phone
Cell Phone
Fax
Email Address
Medical Problems
Medication Needs
Medication Allergies
Food Allergies
Other Allergies
Special Dietary Needs
Other Medical Information
Custom Field(s)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Subdomain (GROUP SCHOOLS ONLY)
Parent IDRequired
Custom Field(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Subdomain (GROUP SCHOOLS ONLY)
Class (Grade Level) IDRequired
Section (Course) NameRequired
Section (Course) CodeRequired
Credit HoursRequired
Teacher ID(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Subdomain (GROUP SCHOOLS ONLY)
Section (Course) IDRequired
Student ID(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Subdomain (GROUP SCHOOLS ONLY)
Name FormatRequired
Preferred Name
Student Number
Birthdate
Gender
Nationality
Class (Grade Level)
Advisor (Homeroom Teacher)
Homeroom Name (Optional)
Enrollment Date
Address
City
State
Zip Code
Country
Home Phone
Cell Phone
Fax
Email Address
Medical Problems
Medication Needs
Medication Allergies
Food Allergies
Other Allergies
Special Dietary Needs
Other Medical Information
Additional Fields (Optional)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Subdomain (GROUP SCHOOLS ONLY)
Student IDRequired
Change TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Subdomain (GROUP SCHOOLS ONLY)
Student NumberRequired
Additional Fields (Optional)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Subdomain (GROUP SCHOOLS ONLY)
Student NumberRequired
Name FormatRequired
Preferred Name
Birthdate
Gender
Nationality
Class (Grade Level)
Advisor (Homeroom Teacher)
Homeroom Name (Optional)
Enrollment Date
Address
City
State
Zip Code
Country
Home Phone
Cell Phone
Fax
Email Address
Medical Problems
Medication Needs
Medication Allergies
Food Allergies
Other Allergies
Special Dietary Needs
Other Medical Information
Check Pre-Enrolled Student Records (Optional)
Additional Fields (Optional)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Subdomain (GROUP SCHOOLS ONLY)
Employee NumberRequired
Employment Date
Name FormatRequired
Initials
Preferred Name
Title
Birthdate
Gender
Marital Status
Spouse Full Name
Nationality
Social Security
Room
Home Address
City
State
Zip Code
Home Phone
Cell Phone
Email Address
Degree
Certification
Experience
Additional Fields (Optional)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Subdomain (GROUP SCHOOLS ONLY)
Search TypeRequired
Include Students that Have Left?
Include Deleted Students?
Additional Fields (Optional)
ActionThis is an event a Zap performs.SearchFind existing data in your appSubdomain (GROUP SCHOOLS ONLY)
Search TypeRequired
Include Deleted Parents?
Additional Fields (Optional)
Student NumberRequired
Parent/Guardian NameRequired
Parent/Guardian RelationshipRequired
Parent/Guardian Address
Parent/Guardian City
Parent/Guardian State
Parent/Guardian Zip Code
Parent/Guardian District
Parent/Guardian Country
Parent/Guardian Home Phone
Parent/Guardian Cell Phone
Parent/Guardian Business Phone
Parent/Guardian Email Address
Parent/Guardian Occupation
Parent/Guardian Other Information
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSubdomain (GROUP SCHOOLS ONLY)
Search TypeRequired
Include Teachers that Have Resigned?
Include Deleted Teachers?
Additional Fields (Optional)
Student NumberRequired
Parent/Guardian NameRequired
Parent/Guardian RelationshipRequired
Parent/Guardian Address
Parent/Guardian City
Parent/Guardian State
Parent/Guardian Zip Code
Parent/Guardian District
Parent/Guardian Country
Parent/Guardian Home Phone
Parent/Guardian Cell Phone
Parent/Guardian Business Phone
Parent/Guardian Email Address
Parent/Guardian Occupation
Parent/Guardian Other Information
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
Updated Parent Custom Fields
Triggers when a parent custom field is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Student Record
Triggers when a new student record is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Student Record
Triggers when a student record is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Teacher Custom Fields
Triggers when a teacher custom field is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Subdomain (GROUP SCHOOLS ONLY)
Include Deleted Parents?
Additional Fields (Optional)
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planSubdomain (GROUP SCHOOLS ONLY)
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planSubdomain (GROUP SCHOOLS ONLY)
Include Teachers that Have Resigned?
Include Deleted Teachers?
Additional Fields (Optional)
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planSubdomain (GROUP SCHOOLS ONLY)
Student NumberRequired
Parent/Guardian NameRequired
Parent/Guardian RelationshipRequired
Parent/Guardian Address
Parent/Guardian City
Parent/Guardian State
Parent/Guardian Zip Code
Parent/Guardian District
Parent/Guardian Country
Parent/Guardian Home Phone
Parent/Guardian Cell Phone
Parent/Guardian Business Phone
Parent/Guardian Email Address
Parent/Guardian Occupation
Parent/Guardian Other Information
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Subdomain (GROUP SCHOOLS ONLY)
Parent IDRequired
Full Name
Home Phone
Cell Phone
Business Phone
Email Address
Address
City
State
Zip Code
Country
Additional Fields (Optional)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Subdomain (GROUP SCHOOLS ONLY)
Section (Course) ID(s)Required
Student ID(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Subdomain (GROUP SCHOOLS ONLY)
Section (Course) IDRequired
Section (Course) Name
Section (Course) Code
Credit Hours
Teacher ID(s)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Subdomain (GROUP SCHOOLS ONLY)
Student NumberRequired
Custom Field(s)Required
Check Pre-Enrolled Student Records (Optional)
Additional Fields (Optional)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Subdomain (GROUP SCHOOLS ONLY)
Student NumberRequired
Sibling Student Number(s)Required
Additional Fields (Optional)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Subdomain (GROUP SCHOOLS ONLY)
Student NumberRequired
Change TypeRequired
Additional Fields (Optional)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Subdomain (GROUP SCHOOLS ONLY)
Student IDRequired
FilenameRequired
FileRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Subdomain (GROUP SCHOOLS ONLY)
Search TypeRequired
Include Deleted Parents?
Additional Fields (Optional)
ActionThis is an event a Zap performs.SearchFind existing data in your appSubdomain (GROUP SCHOOLS ONLY)
Search TypeRequired
Include Teachers that Have Resigned?
Include Deleted Teachers?
Additional Fields (Optional)
ActionThis is an event a Zap performs.SearchFind existing data in your appSubdomain (GROUP SCHOOLS ONLY)
Search TypeRequired
Include Students that Have Left?
Include Deleted Students?
Additional Fields (Optional)
Name FormatRequired
Preferred Name
Student Number
Birthdate
Gender
Nationality
Class (Grade Level)
Advisor (Homeroom Teacher)
Homeroom Name (Optional)
Enrollment Date
Address
City
State
Zip Code
Country
Home Phone
Cell Phone
Fax
Email Address
Medical Problems
Medication Needs
Medication Allergies
Food Allergies
Other Allergies
Special Dietary Needs
Other Medical Information
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
