Google Sheets

Google Sheets Integrations

Why Zapier?

Free

Get started for free—14 day trial of premium features and apps.

Easy

No coding required—automate any of 1,500+ apps in minutes.

Secure

Enterprise-level security—connect mission-critical apps.

Google Sheets Integration Details

Launched on Zapier March 30, 2017

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.

Here are some creative ways to use Google Sheets with Zapier:

  • Quickly share customer inquiries from your web forms with your sales team through Google Sheets. Use Zapier to save new entries you receive from Wufoo forms, SurveyMonkey questionnaires, and other forms right to Google Sheets.
  • Streamline how your team logs and reports bugs. Send an email to your dev team when you create a new row with error info in a Google Sheets spreadsheet.
  • Keep your team in the loop by posting a message in Slack when a Google Sheets spreadsheet is updated.

Zapier combines Triggers (like "New Spreadsheet Row") and Actions (like "Create Spreadsheet Row") to complete an action in one app when a trigger occurs in another app. These combos—called "Zaps"—complete your tasks automatically.

The following Google Sheets Triggers, Searches, and Actions are supported by Zapier:

Create Spreadsheet Row

Create a new row in a specific spreadsheet.

Create Worksheet

Create a blank worksheet with a title. Optionally, provide headers.

Update Spreadsheet Row

Update a row in a specific spreadsheet.

Create Spreadsheet Column

Create a new column in a specific spreadsheet.

Create Spreadsheet Row(s)

Create one or more new rows in a specific spreadsheet (with line item support).

Create Spreadsheet

Create a blank spreadsheet with a title. Optionally, provide headers.

Delete Spreadsheet Row

Deletes the content of a row in a specific spreadsheet. Deleted rows will appear as blank rows in your spreadsheet. Please use with caution.

New Spreadsheet Row

Triggered when a new row is added to the bottom of a spreadsheet.

New or Updated Spreadsheet Row

Triggered when a new row is added or modified in a spreadsheet.

New Spreadsheet Row (Team Drive)

Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.

New Spreadsheet

Triggered when you create a new spreadsheet.

New or Updated Spreadsheet Row (Team Drive)

Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.

New Worksheet

Triggered when you create a new worksheet in a spreadsheet.

Lookup Spreadsheet Row

Finds a row by a column and value. Returns the entire row if one is found.

Find Many Spreadsheet Rows (With Line Item Support)

Finds many matched rows (10 max.) by a column and value.

Get Many Spreadsheet Rows (Advanced, With Line Item Support)

Returns many rows (20 max.) as a single JSON value and flat rows (line items).

Use our free platform to build a single Zapier integration and instantly connect your app with 1,500+ others.

Become a Zapier Integration Partner

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

Learn More