Connect Connecteam and Google Sheets to unlock the power of automation

Record the start time for the work period of an employee. The start time is automatically captured when the call is executed.

Creates a new shift in a scheduler

Creates a timesheet row for user

Creates a note for a specified user.

Send a message to a specific team or channel within Connecteam's chat app, with the sender field set as a custom publisher. Ensure at least one custom publisher is defined in your account before proceeding.

Update a form submission.

Updates the time off balance of a user

Finds a form submission by its from submission id.

Finds a shift within a specified date range. If multiple shifts match the filters, only the most recently updated one will be returned.

Finds a sub-job by its name. Please note that in the case of two sub-jobs with the same title but under different parent jobs, it will retrieve only the first one matched.

Finds a user in Connecteam by user id, full name, email address or phone number.

Triggers when a new row is added to the bottom of a spreadsheet.

Triggers when a new row is added or an existing row is updated in a spreadsheet. Optimized for Team Drive.

Triggers when a worksheet is created in a spreadsheet.

Create a new row in a specific spreadsheet.

Creates a new spreadsheet row at the top of a spreadsheet (after the header row).

Creates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.

Clears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.

Format a row in a specific spreadsheet.

Update one or more rows in a specific spreadsheet (with line item support).

Finds a worksheet by title.

Find a specific spreadsheet row based on a column and value. If found, it returns the entire row. Optionally, create a new row if no match is found.

Finds or creates a specific lookup row.

Archive a single user in the system. Please note that you can only archive users who have the 'user' user type.

Record the end time for the work period of an employee. The end time is automatically captured when the call is executed. The clock-out will be associated with the current open shift.

Create a new task under a specified board. Currently, only 'one-time' task is supported.

Creates a new user in Connecteam

Deletes a single shift by Shift ID

Send a private message (DM) to a specified user within Connecteam's chat app, with the sender field set as a custom publisher. Ensure at least one custom publisher is defined in your account. If a conversation between the custom publisher and the selected user already exists, it will send the message to the same conversation, if not, it will create a new conversation.

Update an existing shift.

Retrieves a form (if exists) by its name. The form includes details such as all associated questions and manager fields.

Finds a job by name or job ID.

Finds a form submission

Finds a task label by its name under a specified task board. In case of two labels with the same title, it will return the first one.

Triggers when a new row is added to the bottom of a Google Team Drive spreadsheet.

Triggers when a new spreadsheet is created.

Triggers when a new row is added or modified in a spreadsheet.

Create a new column in a specific spreadsheet.

Create one or more new rows in a specific spreadsheet (with line item support).

Creates a new worksheet by copying an existing worksheet.

Creates a new worksheet in a Google Sheet.

Deletes the selected row(s) from the spreadsheet. This action removes the row(s) and all associated data.

Update a row in a specific spreadsheet with optional formatting.

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

Return up to 1,500 rows as a single JSON value or as line items.

Finds or creates a specific find worksheet.