Automatically sync your org chart data to a Google Sheet. Build pivot tables, custom reports, and live dashboards from employee data that stays up to date without any manual effort.
Google Sheets sync requires the Integrations add-on. During your 14-day trial, all workspaces have full access.
The Google Sheets integration creates a live, read-only copy of your org chart data in a Google Sheet. ChartPull writes the data; you read it from Sheets. This gives you the full power of Google Sheets — formulas, pivot tables, charts, conditional formatting — on top of always-current employee data.
The sync runs automatically every 6 hours via a background cron job. You can also trigger a manual sync at any time by clicking “Sync Now” on the integration page. Each sync overwrites the data in the sheet with the latest snapshot, so the sheet always reflects the current state of your organisation.
One-way sync
Data flows from ChartPull to Google Sheets only. Edits you make directly in the Google Sheet will be overwritten on the next sync. If you want to add your own columns or formulas, add them to a separate tab in the same spreadsheet — ChartPull only writes to the “ChartPull Data” tab.Go to Admin › Integrations › Google Sheets
Open ChartPull and navigate to the Google Sheets integration page from the admin sidebar.
Choose a sheet
You have two options: create a brand-new Google Sheet (ChartPull names it "ChartPull — [Your Company] Org Data") or link an existing Google Sheet by pasting its URL. If you link an existing sheet, ChartPull creates a new tab called "ChartPull Data" inside it.
Authorise Google Sheets access
If this is your first time using the integration, Google asks you to grant ChartPull permission to write to your Google Sheets. This is a separate, narrowly scoped permission — ChartPull can only write to sheets you explicitly connect, not all your Google Drive files.
Run the first sync
Click "Sync Now" to populate the sheet immediately. For a 500-person org, the first sync takes about 10 seconds. Once complete, you will see a confirmation with the number of rows written.
Open your sheet
Click the "Open in Google Sheets" link to view your data. The sheet is ready to use — add filters, build pivot tables, or create charts right away.
The “ChartPull Data” tab contains one row per employee with the following columns:
| Column | Description |
|---|---|
| Name | The employee’s full name (first and last). |
| Primary work email address. | |
| Title | Job title from Google Workspace or manually set in ChartPull. |
| Department | Department name. Blank if not set in the directory. |
| Manager | The name of the employee’s direct manager. |
| Location | Office location, if populated in the directory. |
| Phone | Work phone number, if populated in the directory. |
| Custom Fields | Any custom fields you have defined in ChartPull appear as additional columns to the right. |
Custom fields become columns
If you have defined custom fields in ChartPull (like “Employee ID,” “Cost Centre,” or “Start Date”), they automatically appear as additional columns in the Google Sheet. You do not need to configure anything — the sync includes all custom fields by default.ChartPull syncs your data to Google Sheets on two triggers:
The integration page shows the timestamp of the last successful sync, the number of rows written, and the sync status (success, in progress, or error).
Real-world scenario
Brightwave — 300 employees, financial services
Brightwave’s finance team needed to plan quarterly budgets by department. Before ChartPull, they manually exported a headcount list from Google Admin Console, cleaned it up in Excel, and built pivot tables from scratch every quarter. The process took a full day.
With the Google Sheets integration, Brightwave connected their ChartPull data to a master planning spreadsheet. The finance team built pivot tables that break down headcount by department and location, and linked those tables to their budget formulas. Now the data updates automatically every 6 hours.
When the quarterly planning cycle starts, the finance team simply opens the spreadsheet — the numbers are already current. What used to take a full day now takes zero effort.
The key insight: ChartPull handles the org chart and data syncing. Google Sheets handles the analysis. Each tool does what it does best.
Pair with Google Sheets charts
Google Sheets has built-in charting that works beautifully with ChartPull data. Create a pie chart of department distribution or a bar chart of team sizes, and they update automatically every time ChartPull syncs. Great for dashboards that get projected on office screens or shared in Slack.