BambooHR

BambooHR is an HR management platform that centralizes employee data, time off tracking, timesheets, and workforce analytics. It's widely used by small and mid-sized businesses to manage their people operations in one place.

Connecting BambooHR to Coupler.io lets you pull your HR data into the tools and destinations you already use — without manual exports or CSV juggling.

Why connect BambooHR to Coupler.io?

• Sync employee directory data to spreadsheets or dashboards for headcount reporting

• Centralize time off requests and timesheet entries for payroll or workforce planning

• Combine HR data with data from other sources (e.g., project tools, finance systems) using Join or Append

• Send HR metrics to AI destinations like ChatGPT or Claude for summaries and workforce analysis

Prerequisites

Before you connect, make sure you have:

• A BambooHR account with admin access (required to generate an API key)

• Your BambooHR company subdomain (the part before .bamboohr.com in your URL)

• An API key generated from your BambooHR account settings

To generate an API key in BambooHR: go to your profile icon → API Keys → Add New Key.

Quick start

Start with the Employees directory entity to get a full snapshot of your workforce — it's the most commonly used entity and a great foundation for headcount dashboards.

How to connect

1

Create a new data flow in Coupler.io. From your Coupler.io dashboard, click Add data flow and search for BambooHR as your source.

2

Enter your BambooHR credentials. You'll be asked for your API key and your company subdomain. Paste both into the fields provided.

3

Select an entity. Choose what data you want to pull — for example, Employees directory streams, Time off requests streams, or Timesheet entries. You can add more entities to the same data flow later.

4

Choose a destination. Select where you want your data to land — Google Sheets, Excel, BigQuery, Looker Studio, or an AI destination like ChatGPT, Claude, or Gemini.

5

Run the data flow. Click Run to execute your first manual sync and confirm that data is flowing correctly.

Entities overview

Entity	What it contains
Custom reports streams	Configurable reports using BambooHR field names you specify
Employees directory streams	Active employee profiles — names, departments, job titles, locations
Meta fields streams	Available fields and metadata in your BambooHR account
Time off requests streams	Approved, pending, and denied time off requests
Timesheet entries	Clock-in/out records and hours worked per employee