Google Sheets Integrations

Name: Zapier
Availability: InStock

Put Google Sheets to work with AI and enterprise-grade automation

Automate smarter with Google Sheets and scale with confidence. Zapier is built for enterprise-grade security, compliance, and performance.

Start free with email

Continue with Google

Start free with email

Continue with Google

No-code AI automation
Full audit trails and controls
SOC 2 and GDPR compliant
Easy visual workflow builder
9,000+ apps, 450+ AI tools
Free tier available

Or pick an app to pair with

Facebook Lead Ads

Ads & Conversion, Facebook

Gmail

Email, Google

Slack

Team Chat

Google Forms

Forms & Surveys, Google

Google Calendar

Calendar, Google

HubSpot

Marketing Automation

Trello

Project Management

Typeform

Forms & Surveys

Google Drive

File Management & Storage, Google

Facebook Lead Ads

Ads & Conversion, Facebook

Gmail

Email, Google

Slack

Team Chat

Google Forms

Forms & Surveys, Google

Google Calendar

Calendar, Google

HubSpot

Marketing Automation

Facebook Lead Ads

Ads & Conversion, Facebook

Gmail

Email, Google

Slack

Team Chat

Google Forms

Forms & Surveys, Google

Google Calendar

Calendar, Google

HubSpot

Marketing Automation

Trello

Project Management

Typeform

Forms & Surveys

Google Drive

File Management & Storage, Google

Top companies trust Zapier to automate work and free up time

Join millions worldwide who automate their work using Zapier

Launch your first automated workflow

Save new Gmail emails matching certain traits to a Google Spreadsheet
Details
Try it
Gmail + Google Sheets
Create Google Sheets rows for new Google Ads leads
Details
Try it
Google Ads + Google Sheets
Send emails via Gmail when Google Sheets rows are updated
Details
Try it
Google Sheets + Gmail
Add new Facebook Lead Ads leads to rows on Google Sheets
Premium
Details
Try it
Facebook Lead Ads + Google Sheets
Generate rows in Google Sheets for new Unbounce submissions
Details
Try it
Unbounce + Google Sheets
Add new Acuity Scheduling appointments to a Google Sheets spreadsheet
Details
Try it
Acuity Scheduling + Google Sheets

Save new Gmail emails matching certain traits to a Google Spreadsheet

Details

Try it

Gmail + Google Sheets

Create Google Sheets rows for new Google Ads leads

Details

Try it

Google Ads + Google Sheets

Send emails via Gmail when Google Sheets rows are updated

Details

Try it

Google Sheets + Gmail

Add new Facebook Lead Ads leads to rows on Google Sheets

Details

Try it

Facebook Lead Ads + Google Sheets

Generate rows in Google Sheets for new Unbounce submissions

Details

Try it

Unbounce + Google Sheets

Add new Acuity Scheduling appointments to a Google Sheets spreadsheet

Details

Try it

Acuity Scheduling + Google Sheets

Create Google Sheets rows for new Zapier Forms form submissions.

Details

Try it

Zapier Forms + Google Sheets

Create new Google Sheets row from a new Google Calendar event

Details

Try it

Google Calendar + Google Sheets

Add new Stripe sales as rows on Google Sheets

Details

Try it

Stripe + Google Sheets

Send Slack messages whenever Google Sheets rows are updated

Details

Try it

Google Sheets + Slack

Create rows in Google Sheets for new Gravity Forms submissions

Details

Try it

Gravity Forms + Google Sheets

Add new Strava activities to Google Sheets rows

Details

Try it

Strava + Google Sheets

Create Google Sheets rows for new Zapier Forms form submissions.
Details
Try it
Zapier Forms + Google Sheets
Create new Google Sheets row from a new Google Calendar event
Details
Try it
Google Calendar + Google Sheets
Add new Stripe sales as rows on Google Sheets
Details
Try it
Stripe + Google Sheets
Send Slack messages whenever Google Sheets rows are updated
Details
Try it
Google Sheets + Slack
Create rows in Google Sheets for new Gravity Forms submissions
Details
Try it
Gravity Forms + Google Sheets
Add new Strava activities to Google Sheets rows
Details
Try it
Strava + Google Sheets

Google Sheets integration details

Being able to collect, track, and analyze your data is essential for any business. Using Google Sheets with Zapier, you can automatically create and edit spreadsheets with data from other apps you use. Zapier can monitor changes in your Google Sheets and quickly share your important data with stakeholders. When you put Zapier to work with Google Sheets, you can connect Google Sheets to other apps, automating all of your spreadsheet tasks to save you time.

Connect Google Sheets to 9,000+ apps

Supported triggers and actions

Zapier helps you create workflows that connect your apps to automate repetitive tasks. A trigger is an event that starts a workflow, and an action is an event a Zap performs.

- Dont_change_sheet_structure
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Trigger
Polling
Try It
- Drive
Trigger
Polling
Try It
- Dont_change_sheet_structure
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger column
Trigger
Instant
Try It
- Drive
- Spreadsheet
  Required
Trigger
Polling
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Use Timezone set up on the spreadsheet to format date values?
Action
Write

- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Condition Type
  Required
- Background Color
- Text Color
- Bold Text
- Italic Text
Action
Write

- Drive
- Spreadsheet Containing the Worksheet to Copy
  Required
- Worksheet to Copy
  Required
- Copy Worksheet Destination
Action
Write
- Drive
- Spreadsheet
  Required
- Title
  Required
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Confirm Deletion
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Format Type
  Required
Action
Write
- Spreadsheet
  Required
- Worksheet
  Required
- New Sheet Name
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Sort by Column
  Required
- Sort Order
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- First row
- Row count
Action
Search
- Drive
- Spreadsheet
  Required
- Title
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Columns
  Required
- Row count
  Required
- Output format
- First row
Action
Search
- Spreadsheet ID
  Required
- Include Grid Data
Action
Search
- Drive
- Spreadsheet Name
  Required
- Search Type
- Spreadsheet to Copy
- Headers
Action
Search or write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search or write

- Dont_change_sheet_structure
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
Trigger
Instant
Try It
- Dont_change_sheet_structure
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger column
Trigger
Polling
Try It
- Dont_change_sheet_structure
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger column
Trigger
Instant
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Column_name
  Required
- Index
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Frozen Rows Count
- Frozen Columns Count
- Sheet Position
- Hide Sheet
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Source Range
  Required
- Destination Range
  Required
- Paste Type
Action
Write
- Drive
- Title
  Required
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row(s)
  Required
Action
Write
- Info
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row(s)
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Validation Type
  Required
- Input Message
- Strict Validation
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
- Overwrite All Columns
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Api_docs_info
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- Spreadsheet Name
  Required
- Search Type
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- A1 Range
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row ID
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- Spreadsheet
  Required
- Title
  Required
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write

For builders

Let your AI safely access Google Sheets

Go beyond Zap workflows. Install Zapier in your AI to call Google Sheets actions directly from your agents—with governance built in. Authenticate once. Revoke access anytime.

No code

Call actions in natural language with Zapier MCP

Act in Google Sheets from your AI—no exposed credentials, and you control which actions your AI can touch. One install covers 9,000+ other apps.

Example actions on this page

Create Spreadsheet Column
Create Spreadsheet Row

Works with

Claude · ChatGPT · Cursor · Any MCP-compatible AI

Install Zapier MCP

Code

Work in code with the Zapier SDK

Expose Google Sheets actions from backend services, scripts, or agent code. Zapier handles the OAuth and scoped permissions. Access 9,000+ apps, plus thousands more with .fetch().

Install

npm install @zapier/zapier-sdk
npm install -D @zapier/zapier-sdk-cli
zapier-sdk login
# create a Google Sheets connection @ https://zapier.com/app/assets/connections

Run an action

// Typescript
import { createZapierSdk } from "@zapier/zapier-sdk";

const zapier = createZapierSdk();

const { data: connection } = await zapier.findFirstConnection({ app: "google-sheets", owner: "me" });

await zapier.runAction({
  app: 'google-sheets',
  action: 'add_column',
  connection: connection.id,
  input: {
    {inputKeyValuePairs}
  },
});

Open the SDK docs

Direct API calls to raw endpoints through fetch are not yet subject to org-level app and action restrictions.

Google Sheets Help & Support

Common issues

How to get started with Google Sheets on Zapier

Work with Google Sheets in Zap workflows

Find and update spreadsheet rows in Google Sheets on Zapier

Google Sheets error: Zap not triggering

Google Sheets error: Required field "Row" (row) is missing

Google Sheets error: Required field "Lookup Value" (lookup_value) is missing

Google Sheets error: Unable to get a value when looking for "responses". Is it empty or missing?

Google Sheets error: Nothing could be found for the search

Google Sheets error: “the app returned” “the caller does not have permission”

Google Sheets error: There was an error writing to your Google Sheets, unable to parse range

Google Sheets Tutorials

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn moreLearn moreHelpHelp

Related categories

Google

Spreadsheets

Similar apps

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

Quip

Documents

Google Sheets Integrations

Put Google Sheets to work with AI and enterprise-grade automation

Top companies trust Zapier to automate work and free up time

Join millions worldwide who automate their work using Zapier

Save new Gmail emails matching certain traits to a Google Spreadsheet

Create Google Sheets rows for new Google Ads leads

Send emails via Gmail when Google Sheets rows are updated

Add new Facebook Lead Ads leads to rows on Google Sheets

Generate rows in Google Sheets for new Unbounce submissions

Add new Acuity Scheduling appointments to a Google Sheets spreadsheet

Save new Gmail emails matching certain traits to a Google Spreadsheet

Create Google Sheets rows for new Google Ads leads

Send emails via Gmail when Google Sheets rows are updated

Add new Facebook Lead Ads leads to rows on Google Sheets

Generate rows in Google Sheets for new Unbounce submissions

Add new Acuity Scheduling appointments to a Google Sheets spreadsheet

Create Google Sheets rows for new Zapier Forms form submissions.

Create new Google Sheets row from a new Google Calendar event

Add new Stripe sales as rows on Google Sheets

Send Slack messages whenever Google Sheets rows are updated

Create rows in Google Sheets for new Gravity Forms submissions

Add new Strava activities to Google Sheets rows

Create Google Sheets rows for new Zapier Forms form submissions.

Create new Google Sheets row from a new Google Calendar event

Add new Stripe sales as rows on Google Sheets

Send Slack messages whenever Google Sheets rows are updated

Create rows in Google Sheets for new Gravity Forms submissions

Add new Strava activities to Google Sheets rows

Google Sheets integration details

Let your AI safely access Google Sheets

Call actions in natural language with Zapier MCP

Work in code with the Zapier SDK

Google Sheets Help & Support

Common issues

.css-ojnz7r{font:500 1.125rem/1.5rem Inter,var(--zds-typography-base, Helvetica),Helvetica,arial,sans-serif;color:#695be8;margin-bottom:0;transition-property:all;transition-timing-function:ease-in-out;transition-duration:300ms;}How to get started with Google Sheets on Zapier

Work with Google Sheets in Zap workflows

Find and update spreadsheet rows in Google Sheets on Zapier

Google Sheets error: Zap not triggering

Google Sheets error: Required field "Row" (row) is missing

Google Sheets error: Required field "Lookup Value" (lookup_value) is missing

Google Sheets error: Unable to get a value when looking for "responses". Is it empty or missing?

Google Sheets error: Nothing could be found for the search

Google Sheets error: “the app returned” “the caller does not have permission”

Google Sheets error: There was an error writing to your Google Sheets, unable to parse range

Google Sheets Tutorials

Automatically send a Slack message for new Google Sheets activity

How to analyze form responses with AI

How to track LeadConnector deals in Google Sheets

Popular Google Sheets Integrations

Popular Google Sheets Integrations

How to get started with Google Sheets on Zapier