Google Sheets + LearningSuite
Create new LearningSuite members from new Google Sheets spreadsheets
Normalize your process with this efficient Google Sheets to LearningSuite workflow. Each time a new spreadsheet is crafted in Google Sheets, an accompanying member is immediately created in LearningSuite, ensuring your educational records are consistently updated and effectively organized. An easy solution for meticulous record management, this workflow guarantees that no significant detail goes unnoticed.
Normalize your process with this efficient Google Sheets to LearningSuite workflow. Each time a new spreadsheet is crafted in Google Sheets, an accompanying member is immediately created in LearningSuite, ensuring your educational records are consistently updated and effectively organized. An easy solution for meticulous record management, this workflow guarantees that no significant detail goes unnoticed.
- When this happens...
New SpreadsheetTriggers when a new spreadsheet is created.
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Create MemberCreates a Member with Email, Firstname and Lastname and sends out the Login information to the Member
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 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
Bundle Created
Triggers when a new Bundle has been created
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planArea ID
Forum ID
Approved
Test User ID
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Custom Popup Created
Triggers when a new Custom Popup has been added to the platform
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planGroup Created
Triggers when a new Group has been created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planCourse
Module
Lesson
Test User
Test Course
Test Module
Test Lesson
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Feedback
Triggers when a user submits a new feedback
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Not Logged in for DaysRequired
Include users who have not logged in yetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planGroupRequired
BundlesRequired
Disable Course Access Notification Email
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.UserRequired
CoursesRequired
Access Date (Default = now)
Disable Course Access Notification Email
Login Link in Course Email
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.UsersRequired
GroupsRequired
Disable Course Access Notification Email
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.User IDRequired
Date for access check
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Hub TitleRequired
Internal NameRequired
TemplateRequired
Sort IndexRequired
PublishRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CourseRequired
Immediately Publish Course
Lesson sorting position
NameRequired
Video Url
HTML content
Thumbnail URL
Timestamp in Seconds to Generate the thumbnail
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.GroupRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.PopupRequired
MemberRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Offset
Limit
Area ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Offset
Limit
Include Progress
CourseRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Member IDRequired
Course IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.User IDRequired
Include Groups
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.UserRequired
BundlesRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.HubRequired
Members
Groups
Bundles
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.MemberRequired
PopupRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First name
Last name
Phone
About
Position
City
Enabled
UserRequired
Email
Locale
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
Include Groups
ActionThis is an event a Zap performs.SearchFind existing data in your appGroup NameRequired
Include Users
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
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 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 foundNew Community Area
Triggers when a new community area is created
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planArea ID
Forum ID
Publish Status
Test User ID
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Course Progress AboveRequired
Course
Test Course
Test User
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Custom Popup ID
Test User ID
Interaction Type
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Group ID
Test User ID
Action
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.User Created
Triggers when a new user has been added to the platform
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planMemberRequired
ActionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.User Id
Bundles
Access Given Override
Access Until Override
Unlimited Access
Disable Course Access Notification Email
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.GroupRequired
CoursesRequired
Disable Course Access Notification Email
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.User IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Group NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.HubRequired
Members
Groups
Bundles
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
First NameRequired
Last NameRequired
Phone
City
About
Do not send welcome email
Do not require password change
Language
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.UserRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Offset
Limit
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Include never logged in members
Limit
Include Groups
Days not logged in
Offset
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Course IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Get Published Courses
Get all published courses
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.MemberRequired
CourseRequired
Date for access check
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.UserRequired
CoursesRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.UsersRequired
GroupsRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CourseRequired
UserRequired
New Module AccessRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Group NameRequired
Include Users
ActionThis is an event a Zap performs.SearchFind existing data in your appUser IDRequired
Include Groups
ActionThis is an event a Zap performs.SearchFind existing data in your appEmailRequired
Include Groups
First NameRequired
Last NameRequired
Phone
City
About
Do not send welcome email
Do not require password change
Language
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
Related Zap Templates
- Add new LearningSuite access requests to Google Sheets rows
- Update Google Sheets rows when course progress changes in LearningSuite
- Add new LearningSuite submissions to a Google Sheets spreadsheet row instantly
- Track completed LearningSuite lessons by creating new rows in Google Sheets
- Create spreadsheet rows in Google Sheets for new logins in LearningSuite