Connecteam + Google Sheets

Create Connecteam timesheet rows from new Google Sheets rows

Automate your workflow with this simple process. When a new row is added to your Google Sheets, the information is instantly used to create a timesheet row in Connecteam. This seamless process saves time and reduces potential errors in transferring data. Enhance your productivity and streamline your business operations with this instant data transfer.

When this happens...
New Spreadsheet Row
Triggers when a new row is added to the bottom of a spreadsheet.
TriggerInstant
automatically do this!
Create Timesheet Row
Creates a timesheet row for user
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Drive
Trigger
Scheduled
Try It
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write

- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write

- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
Action
Search or write
- Scheduler IDRequired
Trigger
Scheduled
Try It
- Archive by phone numberRequired
- User ID
- Phone Number
Action
Write
- Time ClockRequired
- Assigned UserRequired
- Timezone
Action
Write
- Associated SchedulerRequired
- TitleRequired
- Code
- Description
- Color
- Address
- Qualified Users or Groups
- TitleRequired
- Code
Action
Write
- Assigned Task BoardRequired
- Assigned Users
- TitleRequired
- Task StatusRequired
- Start TimeRequired
- Due DateRequired
- Description
Action
Write
- First NameRequired
- Last NameRequired
- Phone NumberRequired
- User TypeRequired
- Email Address
- Send activation SMSRequired
Action
Write
- Form IDRequired
- Form Submission IDRequired
- Manager FieldsRequired
Action
Write
- Assigned UserRequired
- Policy NameRequired
- BalanceRequired
Action
Write
- Job Name
- Job ID
Action
Search
- Form IDRequired
- User ID
- Submission Start Date
- Submission End Date
Action
Search

- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
- Row Count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row CountRequired
- First Row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write
- FormRequired
Trigger
Scheduled
Try It
New User
Triggers when a new user is added.
Trigger
Scheduled
Try It
- Time ClockRequired
- Assigned UserRequired
- Timezone
- Associated JobRequired
Action
Write
- TitleRequired
- Description
- Address
- Users or Groups
- Color
- Associated SchedulerRequired
Action
Write
- 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
Action
Write
- Assigned user
- Time ClockRequired
- TimezoneRequired
- Start TimeRequired
- End TimeRequired
- Associated JobRequired
Action
Write
- Schedule IDRequired
- Shift IDRequired
Action
Write
- 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
Action
Write
- Form NameRequired
Action
Search
- Scheduler IDRequired
- Shift StartRequired
- Shift EndRequired
- Shift ID
- Shift Title
- Job ID
Action
Search
- User ID
- Full Name
- Phone Number
- Email Address
Action
Search