Connecteam + Google Sheets
Create jobs in Connecteam from new rows in Google Sheets
Turn your Google Sheets updates into actionable tasks with this automation. When you add a new row to your spreadsheet, a job will be created in Connecteam. This workflow offers an efficient way to organize your projects, saving time and ensuring tasks are promptly attended to.
Turn your Google Sheets updates into actionable tasks with this automation. When you add a new row to your spreadsheet, a job will be created in Connecteam. This workflow offers an efficient way to organize your projects, saving time and ensuring tasks are promptly attended to.
- When this happens...
New Spreadsheet RowTriggers when a new row is added to the bottom of a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create JobCreates a new job in the app.
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 ZapScheduledZapier 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.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.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
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
ColumnsRequired
Row countRequired
First row
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
User Updated
Triggers when a user field was edited (real-time trigger).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Time ClockRequired
Assigned UserRequired
Timezone
Associated JobRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Scheduler
Time Clock
TitleRequired
Description
Address
Users or Groups
Color
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SchedulerRequired
Shift titleRequired
Color
Shift StartRequired
Shift EndRequired
Timezone
Is this an Open Shift?
Does this shift require admin approval?
Do you want to create the shift as a published shift?
Associated Job
Assigned Users
Location Address
Notes
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Assigned user
Time ClockRequired
TimezoneRequired
Start TimeRequired
End TimeRequired
Associated JobRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Schedule IDRequired
Shift IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Recipient UserRequired
Sender (publisher)Required
TextRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SchedulerRequired
Shift IDRequired
Shift Title
Shift Start
Shift End
TimeZone
Is this an Open Shift?
Does this shift require admin approval?
Do you what to create the shift as a published shift?
Associated Job
Assigned Users
Location Address
Notes
Color
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Form NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appScheduler IDRequired
Shift StartRequired
Shift EndRequired
Shift ID
Shift Title
Job ID
ActionThis is an event a Zap performs.SearchFind existing data in your appSub-Job TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appUser ID
Full Name
Phone Number
Email Address
ActionThis is an event a Zap performs.SearchFind existing data in your app
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 ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
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.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Apply standard error handling?Required
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
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
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
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 User
Triggers when a new user is added (real time trigger)
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Archive by phone numberRequired
User ID
Phone Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Time ClockRequired
Assigned UserRequired
Timezone
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Scheduler
Time Clock
TitleRequired
Code
Description
Color
Address
Qualified Users or Groups
TitleRequired
Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Assigned Task BoardRequired
Assigned Users
TitleRequired
Task Labels
Task StatusRequired
Start TimeRequired
Due DateRequired
Description
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First NameRequired
Last NameRequired
Phone NumberRequired
User TypeRequired
Email Address
Send activation SMSRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Conversation (Team/Channel)Required
Sender (publisher)Required
TextRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Form IDRequired
Form Submission IDRequired
Manager FieldsRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Assigned UserRequired
Policy NameRequired
BalanceRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Job Name
Job ID
ActionThis is an event a Zap performs.SearchFind existing data in your appForm IDRequired
User ID
Submission Start Date
Submission End Date
ActionThis is an event a Zap performs.SearchFind existing data in your appTask BoardRequired
Label TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app
About Connecteam
Related categories
About Google Sheets
Related categories
Related Zap Templates
- Update Google Sheets rows with new Connecteam form submissions
- Create spreadsheet rows in Google Sheets for new schedule shifts in Connecteam
- Create multiple rows in Google Sheets with each new form submission in Connecteam
- Create new Connecteam shifts from new rows in Google Sheets
- Create shifts in Connecteam from new or updated rows in Google Sheets
- Add Google Sheets rows for new Connecteam users
- Add rows in Google Sheets when new shifts are created in Connecteam
- Create Connecteam jobs from new or updated rows in Google Sheets
- Add new Connecteam users to Google Sheets as spreadsheet rows
- Create new Google Sheets rows from new Connecteam form submissions
- Create new Google Sheets columns for each new shift added in Connecteam schedule
- Create worksheets in Google Sheets from new shifts in Connecteam schedule
- Update Google Sheets rows with new shifts in Connecteam schedule
- Create Connecteam users from new or updated rows in Google Sheets
- Create Connecteam shifts from new or updated Google Sheets rows
- Create Connecteam timesheet rows from new Google Sheets rows
- Create Connecteam timesheet rows from new Google Sheets spreadsheet rows
- Create timesheet rows in Connecteam for new spreadsheet rows in Google Sheets team drive
Related Zap Templates
- Update Google Sheets rows with new Connecteam form submissions
- Create new Connecteam shifts from new rows in Google Sheets
- Add rows in Google Sheets when new shifts are created in Connecteam
- Create new Google Sheets rows from new Connecteam form submissions
- Update Google Sheets rows with new shifts in Connecteam schedule
- Create spreadsheet rows in Google Sheets for new schedule shifts in Connecteam
- Create shifts in Connecteam from new or updated rows in Google Sheets
- Create Connecteam jobs from new or updated rows in Google Sheets
- Create new Google Sheets columns for each new shift added in Connecteam schedule
- Create Connecteam users from new or updated rows in Google Sheets
- Create multiple rows in Google Sheets with each new form submission in Connecteam
- Add Google Sheets rows for new Connecteam users
- Add new Connecteam users to Google Sheets as spreadsheet rows
- Create worksheets in Google Sheets from new shifts in Connecteam schedule
- Create Connecteam shifts from new or updated Google Sheets rows