---
title: "Google Sheets"
description: "Google Sheets is a built-in integration for Home Assistant. It has 2.8k installs sharing analytics and needs the vendor's cloud."
canonical: "https://vulpo.app/integrations/core/google-sheets"
url: "https://vulpo.app/integrations/core/google-sheets.md"
last-updated: "2026-10-22"
version: "1.4"
---

# Google Sheets

> Google Sheets is a built-in integration for Home Assistant. It has 2.8k installs sharing analytics and needs the vendor's cloud.

Google Sheets is a built-in integration that reads and writes worksheet data in Google Sheets from Home Assistant. It adds two actions: one appends data to a worksheet, and the other gets data from a worksheet. These can be used in automations and scripts, for example to log values to a spreadsheet or to pull stored values back in. The integration depends on Google's cloud, so it needs an internet connection to work. It is set up in the UI, where the sign-in goes through Google's own page using application credentials.

Automatic summary of Home Assistant's source code. Something wrong? [Get in touch](https://vulpo.app/contact)

[Open in My Home Assistant](https://my.home-assistant.io/redirect/config_flow_start/?domain=google_sheets)

## Supports

- **Uses the vendor's cloud**: Needs an internet connection and an account with the vendor.
- **Set up in the UI**: Add it in Settings, Devices and services. Nothing to download.
- **Sign in with the vendor**: Connects through the vendor's own sign-in page.
- **Updated with Home Assistant**: Ships and updates with every Home Assistant release.

## Setting it up

It is added under Settings, Devices and services, with Add integration.

### Pick authentication method

- **Application credentials**: The credentials you want to use to authenticate.

Texts from Home Assistant's source code, [Apache License 2.0](https://www.apache.org/licenses/LICENSE-2.0).

## Actions

- **Append data to Google sheet**: Appends data to a worksheet in Google Sheets.
  Fields: Add created column, Sheet, Data, Worksheet
- **Get data from Google sheet**: Gets data from a worksheet in Google Sheets.
  Fields: Sheet, Rows, Worksheet

## At a glance

- Kind: Built-in integration
- Category: [DIY and makers](https://vulpo.app/integrations/category/diy-and-makers.md), Web and data connectors
- Brand: [Google](https://vulpo.app/integrations/google.md)
- Number: 2.8k installs sharing analytics
- Connection: Needs the vendor's cloud
- Upkeep: Part of Home Assistant
- Needs: Built into Home Assistant
- Domain: `google_sheets`
- Source: <https://www.home-assistant.io/integrations/google_sheets/>

## Other ways in for Google

| Name | Kind | Installs or stars | Connection | Upkeep |
| --- | --- | --- | --- | --- |
| [Google Translate text-to-speech](https://vulpo.app/integrations/core/google-translate.md) | Built-in integration | 524k installs sharing analytics | Needs the vendor's cloud | Part of Home Assistant |
| [Google Cast](https://vulpo.app/integrations/core/cast.md) | Built-in integration | 288k installs sharing analytics | Works locally | Part of Home Assistant |
| [Google Calendar](https://vulpo.app/integrations/core/google.md) | Built-in integration | 42.6k installs sharing analytics | Needs the vendor's cloud | Part of Home Assistant |
| [Google Gemini](https://vulpo.app/integrations/core/google-generative-ai-conversation.md) | Built-in integration | 36.3k installs sharing analytics | Needs the vendor's cloud | Part of Home Assistant |
| [Google Nest](https://vulpo.app/integrations/core/nest.md) | Built-in integration | 21.3k installs sharing analytics | Needs the vendor's cloud | Part of Home Assistant |

Independent directory, made by the developer of Vulpo. Not affiliated with Home Assistant or the Open Home Foundation. [About these numbers](https://vulpo.app/integrations/about)

Last updated 2026-10-22. Source: https://vulpo.app/integrations/core/google-sheets

---

- HTML version of this page: https://vulpo.app/integrations/core/google-sheets
- Site index for agents: https://vulpo.app/llms.txt
- Everything in one document: https://vulpo.app/llms-full.txt
- All pages: https://vulpo.app/sitemap.xml