Connect Connecteam and Google Sheets

Connecteam's time clock records when your deskless team starts and ends a shift, and when an admin changes an entry. FlowMattic writes those events to Google Sheets: a timesheet row per shift, a review tab for automatic clock outs and an audit log of edits, ready for whoever runs payroll from a spreadsheet.

Try FlowMattic free See example workflows

21 triggers 19 actions 6 example workflows 2 ready-made templates Unlimited runs

Try a pairing

When this happens in Connecteam15 triggers

Do this in Google Sheets19 actions

1. TriggerClock In

2. ActionAdd New Row

When Connecteam fires Clock In, FlowMattic runs Add New Row in Google Sheets with the data from that event.

You build this in the FlowMattic workflow builder on your own site. See the setup steps

Connecteam and Google Sheets workflows you can build

Each one uses only triggers and actions the two integrations ship today, plus FlowMattic's own tools. Where the library has a ready-made template, import it instead of building from scratch.

Ready-made template

Log every Connecteam clock in to a timesheet

Each clock in adds a row with the employee, job, location and start time, so the site manager can see who is on shift right now from a shared sheet.

Clock InAdd New Row

View the template

Complete the shift row at clock out

Clock Out finds the open row for that employee and writes the end time, so each shift is one row with a start and an end that payroll can total.

Clock OutLookup Row DataUpdate Row

Flag automatic clock outs for a supervisor to check

An automatic clock out usually means someone forgot to clock out. The shift goes to a review tab and the supervisor gets an email to confirm the real end time.

Auto Clock OutAdd New RowEmail (SMTP)

Keep an audit log of admin time edits

Every time an admin edits a time activity, the change is logged with the employee and date. When a worker questions a payslip, the history is there.

Admin EditAdd New Row

Record approved clock outs outside the geofence

Field teams sometimes finish away from the site. Each approved exception is logged, so managers can spot jobs or people where it happens often.

Admin Approved Clock Out Outside Geo Fence RequestAdd New Row

Start a new timesheet tab each pay week

Format the clock in date as a week label and use it as the sheet name, so each pay period has its own tab and nothing needs moving before payroll runs.

Clock InDate/Time FormatterAdd New Row

Set up: clock ins on a timesheet

At the end, every clock in on your Connecteam time clock adds a row to your timesheet sheet.

Prepare the timesheet
Create a sheet with Employee, Job, Location, Clock in and Clock out columns, leaving Clock out for the second workflow.
Trigger on Clock In
Create a workflow with Connecteam and Clock In, and connect the time clock the trigger asks for.
Clock in once
Clock in from the Connecteam app on a test user so FlowMattic captures the event's fields.
Write the row
Connect Google Sheets, add Add New Row, map the employee, job and start time to the columns, test and switch the workflow on.

Import the ready-made template Beginner, about 5 min to set up

From Connecteam	To Google Sheets
User name	Employee
Job	Job
Location	Location
Start time	Clock in

Triggers and actions in this pair

A trigger starts a workflow. An action is something FlowMattic does in the app as a step.

Good to know

To pair a clock out with its clock in, store a value both events share, such as the time activity ID or the user ID with the date, and look that up at clock out.
Automatic clock outs are their own trigger. If you only build the Clock Out workflow, shifts ended automatically stay open in the sheet.
The sheet is a copy for reporting. Editing a time in the sheet does not change the entry in Connecteam.

Connecteam

Integration page

Triggers (15)

Clock InTriggers when the user is clocked in.
Clock OutTriggers when the user is clocked out.
Auto Clock OutTriggers when the user clocked out automatically based on the predefined settings in the time clock configuration
Admin AddTriggers when an admin added a new time activity.
Admin EditTriggers when an admin edited a time activity.
Admin DeleteTriggers when an admin deleted a time activity.
Admin Approved Clock Out Outside Geo Fence RequestTriggers when an admin approved a clock out that occurred outside the geofence.
Admin Approved Add RequestTriggers when an admin approved a time activity that was added by a user.
Admin Approved Edit RequestTriggers when an admin approved changes made by a user to a time activity.
Admin Approved Delete RequestTriggers when an admin approved the deletion of a time activity by a user.
Admin Declined RequestTriggers when an admin declined a time off request that had been previously approved.
Auto Approved Clock Out Outside Geo Fence RequestTriggers automatically approve a time activity submitted by a user.
Auto Approved Add RequestTriggers automatically approve clock-outs that happen outside the designated geofence.
Auto Approved Edit RequestTriggers automatically approve the deletion of a time activity by a user.
Auto Approved Delete RequestTriggers automatically approve changes made by a user to a time activity.

Google Sheets

Integration page

Triggers (6)

New Spreadsheet RowTrigger when a new row is added to the spreadsheet
New Or Updated Spreadsheet RowTrigger when a row is updated in the spreadsheet
Deleted Spreadsheet RowTrigger when a row is deleted from the spreadsheet
Update Cell DataTrigger when any cell is updated in the spreadsheet
Update Specific Cell DataTrigger when a specific cell is updated in the spreadsheet
Update Specific Column ValueTrigger when a specific column value is updated in the spreadsheet

Actions (19)

Add New RowAdd a new row with mapped data
Update RowUpdate existing row in specific spreadsheet with mapped data
Delete RowDelete row by ID in specific spreadsheet
Clear Row DataClear data or row by ID in specific spreadsheet
Lookup Row DataSearch for data in specific spreadsheet
Get Cell DataGet data for particular cell in specific spreadsheet
Update Cell DataUpdate data for particular cell in specific spreadsheet
Get Row CountGet total number of rows in specific spreadsheet
Get Row DataGet rows data from the sheet based on specified range
Create Spreadsheet ColumnCreate a new column in specific spreadsheet
Create New SheetCreate a new sheet in specific spreadsheet
Import CSV or JSON to Existing SheetImport CSV or JSON data to existing sheet in specific spreadsheet
Copy SheetCopy a sheet to another or within the same spreadsheet
Get RowsRetrieve rows in JSON format for use with Iterator
Export sheet to CSVExport the selected sheet to CSV format and save to WordPress Media Library
Export Sheet to ExcelExport the spreadsheet to Excel (.xlsx) format and save to WordPress Media Library
Export Sheet to PDFExport the spreadsheet to PDF format and save to WordPress Media Library
Export Sheet to OpenDocumentExport the spreadsheet to OpenDocument (.ods) format and save to WordPress Media Library
Export Sheet to TSVExport the selected sheet to TSV format and save to WordPress Media Library

Why run this pair with FlowMattic

Connecteam and Google Sheets connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.

Payroll from a sheet you control

Bookkeepers who already run payroll in a spreadsheet get shift data in it, without exporting a report from Connecteam each period.

Staff data stays on your server

Names, locations and times go from Connecteam through your own WordPress site to Google, not through an outside automation account.

Every shift logged at one price

Runs are unlimited, so a team clocking in and out across several sites costs nothing more to log.

Common questions

Can I build a full timesheet with start and end times?

Yes. Use Clock In to add the row and Clock Out, with Lookup Row Data and Update Row, to fill in the end time. Add Auto Clock Out the same way so no shift is left open.

Can I track changes admins make to time entries?

Yes. Admin Add, Admin Edit and Admin Delete each start a workflow, so you can log every manual change to time activities in an audit tab.

What about requests employees submit for approval?

Triggers such as Admin Approved Add Request, Admin Approved Edit Request and Admin Declined Request let you log the outcome of each request next to the shift it changed.

Can each site or job get its own tab?

Yes. Add a Router on the job or location field and point each path's Add New Row at that site's tab.

Did not find your answer? You can browse the help center or ask us directly.

Start automating Connecteam and Google Sheets

Install FlowMattic, connect both accounts and import a template. Every run stays on your own server.

Try FlowMattic free See pricing

30-day money-back guarantee Unlimited workflows and runs Self-hosted

Reviewed 27 Oct 2026. The example workflows are written with AI from the real triggers and actions of both integrations and checked against them. Connecteam integration 1.0.0, Google Sheets integration 2.2.4.