---
title: "Google Sheets connector"
description: "Connect Google Sheets to OpenEmail. The assistant looks things up in Google Sheets and acts there when you say so. Free to start."
url: "https://openemail.uk/connectors/googlesheets"
---

# OpenEmail + Google Sheets

Connect Google Sheets once. Then ask the assistant in OpenEmail to look things up in it, or to do things there for you.

[Open mail](https://openemail.uk/mail/inbox) [Get Started](https://openemail.uk/signup.md)[All connectors](https://openemail.uk/connectors.md) Free to start Asks before it changes anything

Spreadsheets

## About Google Sheets

Google Sheets is a cloud-based spreadsheet tool enabling real-time collaboration, data analysis, and integration with other Google Workspace apps

Actions: 50

## What the assistant can do in Google Sheets

A few of the things it can do once Google Sheets is connected.

### Look things up

These run as soon as you ask.

- Batch get spreadsheet
  
  Retrieves data from specific cell ranges in a Google Spreadsheet
- Export Drive Spreadsheet
  
  Export an entire native spreadsheet as XLSX, ODS, PDF, ZIP, CSV, or TSV
- Export Sheet as PDF
  
  Exports one Google Sheets tab, optionally limited to a rectangular range
- Get Drive File Metadata
  
  Get JSON metadata for one Drive file, optionally using any valid Google partial-response fields projection
- Get sheet names
  
  Retrieves the names of all sheets in a specified Google Spreadsheet

### Make changes

It shows you what it is about to do and waits for your OK.

- Add Sheet to Existing Spreadsheet
  
  Creates a GRID worksheet with rows and columns in an existing Google Sheets spreadsheet
- Append Dimension
  
  Appends new rows or columns to a specified sheet in a Google Spreadsheet
- Batch Clear Values By Data Filter
  
  Clears cell values from a Google Sheet based on data filters
- Clear Basic Filter
  
  Clears any existing basic filter from the specified sheet of a Google Spreadsheet
- Create a Google Sheet
  
  Creates a new Google Spreadsheet in your Google Drive

How it works

## Three steps

Connect Google Sheets

Sign in to Google Sheets from the Connectors page. There is nothing to install.

Ask in plain words

Ask the assistant in OpenEmail. It finds the right action in Google Sheets and runs it.

Stay in control

Lookups run at once. Anything that changes Google Sheets waits for your OK.

Price

## Free to start

The Free plan includes 2 connected apps and 10 AI actions a day. You can pause or disconnect Google Sheets whenever you like.

More apps

## Works with these too

### Airtable

Airtable merges spreadsheet functionality with database power, enabling teams to organize projects, track tasks, and collaborate through customizable views, automation, and integrations for data management

Productivity · Actions: 25

### Google Super

Google Super App combines all Google services including Drive, Calendar, Gmail, Sheets, Analytics, Ads, and more, providing a unified platform for seamless integration and management of your digital life.

File management & storage · Actions: 470

### Excel

Microsoft Excel is a powerful spreadsheet application for data analysis, calculations, and visualization, enabling users to organize and process data with formulas, charts, and pivot tables

Spreadsheets · Actions: 56

Start free

## Connect your first app in a minute.

Create an account, connect an app and ask the assistant about it.

[Open mail](https://openemail.uk/mail/inbox) [Get Started](https://openemail.uk/signup.md)[How connectors work](https://openemail.uk/docs/knowledge/ai/connectors.md)