Connect Connecteam and Google Sheets to power AI-driven 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 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 user's custom fields

Update an existing shift.

Find a team or channel chat conversation by its name (title). If the name contains emojis, they will be ignored.

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 an existing row is updated in a spreadsheet. New rows do not trigger this; use New or Updated Spreadsheet Row for that.

Create a new column in a specific spreadsheet.

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

Update Google Sheets properties like frozen rows/columns, sheet position, and visibility settings.

Copy data from one range to another within a Google Sheets spreadsheet, with options for what to paste (values, formatting, etc.).

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.

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

Format a row in a specific spreadsheet.

Set data validation rules on a range of cells in Google Sheets to control what data can be entered.

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.

Finds a spreadsheet by name.

Get data from a specific range in a Google Spreadsheet using A1 notation (e.g., "A1:D10", "B2:E5").

Get a specific spreadsheet row by its row number (ID). Row 1 is typically the header row.

Find a specific spreadsheet row based on a column and value. If found, it returns the entire row.

Finds or creates a specific find worksheet.

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.

Create a new time-off request for a user under a specified policy. The time-off request can be either in pending or approved status.

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.

Update or add performance data values for a specific user on a given date. If a value already exists for that date, it will be replaced with the new value. If no value exists, the new value will be added.

Updates the time off balance of a user

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.

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).

Apply conditional formatting to cells in a Google Sheets spreadsheet based on their values.

Creates a new worksheet by copying an existing worksheet.

Creates a new worksheet in a Google Sheet.

Permanently delete a worksheet from a Google Sheets spreadsheet. Warning: This action cannot be undone.

Apply date, number, or style formatting (colors, bold, italic, strikethrough) to a range of cells in a Google Sheets spreadsheet.

Rename a worksheet in a Google Sheets spreadsheet.

Sort data within a specified range in Google Sheets by a chosen column in ascending or descending order.

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

Find up to 500 rows based on a column and value as line items.

Finds a worksheet by title.

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

Get a specific Google Spreadsheet by its ID. Returns the raw spreadsheet data from the Google Sheets API.

Finds a spreadsheet by name, or creates one if none is found.

Finds or creates a specific lookup row.