---
title: "Google Sheets"
canonical: https://harmony.io/integrations/google-sheets
---

# Google Sheets

**Categories:** SaaS Application

Read and write Google Sheets rows from workflows

Google Sheets is a cloud-based spreadsheet application that lets teams create, edit, and collaborate on data in real time. Integrating Google Sheets with Harmony allows automated workflows to read from and write to spreadsheets without manual effort. This keeps your operational data, reports, and tracking logs in sync with IT service management processes.

## Capabilities

- **Read Rows**: Retrieve data from a specified Google Sheets spreadsheet to drive workflow logic and decisions.
- **Write Rows**: Automatically append or update rows in a spreadsheet when a workflow event or ticket action occurs.
- **Sync Structured Data**: Map spreadsheet columns to Harmony fields to keep service records and reports consistently up to date.

## What Harmony does with Google Sheets

Harmony connects to Google Sheets so your teams can surface, update, and act on spreadsheet data without ever leaving Slack or Microsoft Teams. Whether you maintain an asset register, an onboarding checklist, or a software license tracker in Sheets, Harmony treats those rows as live, actionable records. Automations can read current values, append new entries, and update cells as part of larger IT or HR workflows, keeping your spreadsheets in sync with what's actually happening across the business.

## Data synced

- Sheet row contents and cell values
- Column headers and sheet structure
- Named ranges and their current values
- Spreadsheet metadata including title and last-modified timestamp

## Actions available

- Append a new row to a specified sheet when a workflow event occurs
- Update one or more cells in an existing row based on workflow conditions
- Read matching rows from a sheet to populate a Harmony workflow with live data

## Real-world use cases

**Asset checkout logged instantly**: When an employee requests a laptop through Slack, Harmony appends a new row to the IT asset register in Google Sheets automatically, capturing the employee name, device, and checkout date without any manual entry.

**Onboarding checklist kept current**: As each onboarding task is completed in a Harmony workflow, it updates the corresponding cell in the HR team's onboarding tracker in Google Sheets, giving managers a real-time view without chasing updates.

**Licence count checked before provisioning**: Before a Harmony automation grants a new software licence, it reads the available-seat count from the licence tracker in Google Sheets and blocks the request in Slack if no seats remain, preventing over-allocation.

## Related integrations

- [Salesforce](https://harmony.io/integrations/salesforce)

- [Microsoft 365](https://harmony.io/integrations/microsoft-365)

- [Zoom](https://harmony.io/integrations/zoom)

## FAQ

### What is Google Sheets?

Google Sheets is a cloud-based spreadsheet application used by teams across IT, HR, finance, and operations to track, analyse, and collaborate on structured data. Connecting Google Sheets gives Harmony the ability to read and write rows in real time, turning everyday spreadsheets into dynamic data sources and targets for automated service workflows.

### What data does Harmony sync from Google Sheets?

Harmony's Google Sheets integration syncs the following into a single agent inventory: sheet row contents and cell values; column headers and sheet structure; named ranges and their current values; and spreadsheet metadata including title and last-modified timestamp.

### What can I do with Google Sheets through Harmony?

Through the Google Sheets integration, Harmony can append a new row to a specified sheet when a workflow event occurs; update one or more cells in an existing row based on workflow conditions; and read matching rows from a sheet to populate a Harmony workflow with live data.

### How does the Google Sheets integration help IT teams?

When an employee requests a laptop through Slack, Harmony appends a new row to the IT asset register in Google Sheets automatically, capturing the employee name, device, and checkout date without any manual entry.

### What other integrations pair with Google Sheets in Harmony?

Google Sheets is commonly paired with Salesforce (SaaS Application), Microsoft 365 (SaaS Application), and Zoom (SaaS Application) inside Harmony, giving IT one unified view across related systems.