Connect Hibob and Google Sheets

Hibob is where HR keeps employee records, start dates and leave dates. IT, facilities and finance often work from a Google Sheet instead of Bob itself. FlowMattic writes new employees into that sheet and keeps each row current when profiles change, people join, leave or are inactivated, all from your own WordPress site.

Try FlowMattic free See example workflows

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

Try a pairing

When this happens in Hibob7 triggers

Do this in Google Sheets19 actions

1. TriggerNew Employee Created

2. ActionAdd New Row

When Hibob fires New Employee Created, 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

Hibob 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

Add each new Hibob employee to a staff sheet

When HR creates an employee in Bob, a row is added with name, work email, department, site and start date, so IT can plan accounts and equipment.

New Employee CreatedAdd New Row

View the template

Update the row when an employee profile changes

Employe Updated finds the person's row by employee ID and overwrites department, title or manager, so other teams do not work from old details.

Employe UpdatedLookup Row DataUpdate Row

Start an onboarding checklist on the first day

Employee Joined runs on the start date. A row goes onto an Onboarding tab with laptop, access and badge columns, and Email (SMTP) tells IT who started.

Employee JoinedAdd New RowEmail (SMTP)

Mark leavers on the staff sheet

Employee Left runs once the termination date has passed. The row is found and its status set to Left with the date, which is the cue to recover equipment and close accounts.

Employee LeftLookup Row DataUpdate Row

Track inactive and reactivated employees

Employee Inactivated sets the row's status to Inactive, for example during long leave, and a matching Employee Activated workflow sets it back.

Employee InactivatedLookup Row DataUpdate Row

Delete the row when an employee is removed from Bob

If HR deletes a record created by mistake, Employee Deleted finds the row and removes it, so the sheet does not keep personal data Bob no longer holds.

Employee DeletedLookup Row DataDelete Row

Set up: new employees in a sheet

At the end, every employee created in Hibob is added as a row to your staff sheet.

Lay out the staff sheet
Create headers such as Employee ID, Name, Work email, Department, Site, Manager, Start date and Status.
Connect Hibob and Google
Under Connects, add your Hibob account with access to the employee fields you need, and a Google account that can edit the sheet.
Trigger on New Employee Created
Start a workflow with the Hibob New Employee Created trigger and add a test employee so FlowMattic captures the fields.
Map and switch on
Add Google Sheets Add New Row, map the employee fields, test the step and turn the workflow on.

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

Hibob app icon — Built on the FlowMattic canvas. Test each step with real data, then switch the workflow on.

From Hibob	To Google Sheets
Employee ID	Employee ID
Display name	Name
Work email	Work email
Department	Department
Site	Site
Start date	Start date

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

Employee Joined and Employee Left run on the start and termination dates, not when the record is created, so they suit first-day and last-day tasks.
The fields FlowMattic receives depend on what your Hibob connection can read. Check the captured test employee before mapping.
Store the Hibob employee ID in the sheet; every update, leaver and delete example finds the row by it.
Employee records are personal data. Share the sheet only with teams that need it and map only the fields they use.

Hibob

Integration page

Triggers (7)

New Employee CreatedTriggers when a new employee is created.
Employee JoinedTriggers when employee start date has occurred.
Employee LeftTriggers when employee termination date has occurred.
Employee DeletedTriggers when an employee is removed from Bob.
Employe UpdatedTriggers when an existing employee is updated.
Employee InactivatedTriggers when employee is inactivated in bob.
Employee ActivatedTriggers when an employee is activated in bob.

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

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

Other teams get what they need

IT and facilities work from a sheet with the fields they need, without being given access to Bob.

Dates handled for you

Joiner and leaver tasks start on the actual dates in Bob, so nothing depends on someone remembering a calendar entry.

HR data through your own server

Employee details pass through your own WordPress site into your sheet, with unlimited runs and no outside automation account.

Common questions

Can I sync Hibob employees to Google Sheets?

Yes. New Employee Created adds each new hire as a row, and Employe Updated looks up the row by employee ID and updates it. Add the joiner, leaver and status triggers to keep the list complete.

Can IT get a list of people starting this week?

Yes. New Employee Created writes the start date when the hire is entered, so a filter on that column shows upcoming starters. Employee Joined can also add them to an Onboarding tab on the day.

What happens when someone leaves?

Employee Left runs after the termination date. The workflow finds their row and sets the status, which the IT team can use as the signal to close accounts.

Should deleted employees be removed from the sheet?

For records deleted from Bob, usually yes. The Employee Deleted example looks up the row and removes it with Delete Row.

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

Start automating Hibob 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. Hibob integration 1.0.0, Google Sheets integration 2.2.4.