ConditionalVisibility

new-products-promo

how-to-use-google-sheets-excel-01

google-sheets-tutorial-image02

google-sheets-tutorial-image03

google-sheets-tutorial-image04

google-sheets-tutorial-image05

google-sheets-tutorial-image06

google-sheets-tutorial-image07

google-sheets-tutorial-image08

google-sheets-tutorial-image09

google-sheets-tutorial-image10

google-sheets-tutorial-image11

google-sheets-tutorial-image12

google-sheets-tutorial-image13

google-sheets-tutorial-image14

google-sheets-tutorial-image15

google-sheets-tutorial-image16

google-sheets-tutorial-image17

google-sheets-tutorial-image18

google-sheets-tutorial-image19

google-sheets-tutorial-image20

google-sheets-tutorial-image21

google-sheets-tutorial-image22

google-sheets-tutorial-image23

google-sheets-tutorial-image24

google-sheets-tutorial-image25

google-sheets-tutorial-image26

google-sheets-tutorial-image27

google-sheets-pivot-table-image5

google-sheets-tutorial-image29

google-sheets-tutorial-image30

App tips

app-tips-google-sheets-00-hero

Google Sheets

In this Google Sheets tutorial for beginners, we cover everything from how to create a Google Sheet to how to use Google Sheets formulas.

How to use Google Sheets: A beginner's guide | Zapier

In this Google Sheets tutorial for beginners, we cover everything from how to create a Google Sheet to how to use Google Sheets formulas. 

How to use Google Sheets: A beginner's guide

Store responses from your forms directly in a spreadsheet! Use Zapier to automatically send those form responses right in a spreadsheet, and never worry about missing any submissions again.

Google Forms is an easy way to collect data from the web with a simple UI and powerful editor. Works hand-in-hand with Google Sheets!

Google Forms

Triggers when a new form response is received.

New Form Response

Triggers when a form response is added or modified.

New or Updated Form Response

Custom Actions (Beta)

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

API Request (Beta)

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

Triggers when a new row is added to the bottom of a Google Team Drive spreadsheet.

New Spreadsheet Row (Team Drive)

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

New Spreadsheet Row

Triggers when a new spreadsheet is created.

New Spreadsheet

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

New or Updated Spreadsheet Row (Team Drive)

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

New or Updated Spreadsheet Row

Triggers when a worksheet is created in a spreadsheet.

New Worksheet

Find up to 500 rows based on a column and value as line items.

Lookup Spreadsheet Rows (Advanced)

Find Worksheet

Return up to 500 rows as a single JSON value or as line items.

Get Many Spreadsheet Rows (Advanced)

Find a specific spreadsheet row based on a column and value. If found, it returns the entire row. Optionally, create a new row if no match is found.

Lookup Spreadsheet Row

Finds or creates a specific find worksheet.

Find or Create Worksheet

Find or Create Row

Create a new column in a specific spreadsheet.

Create Spreadsheet Column

Create a new row in a specific spreadsheet.

Create Spreadsheet Row

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

Create Multiple Spreadsheet Rows

Creates a new worksheet by copying an existing worksheet.

Copy Worksheet

Creates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.

Create Spreadsheet

Creates a new worksheet in a Google Sheet.

Create Worksheet

Clears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.

Clear Spreadsheet Row(s)

Deletes the selected row(s) from the spreadsheet. This action removes the row(s) and all associated data.

Delete Spreadsheet Row(s)

Format Spreadsheet Row

Update Spreadsheet Row

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

Update Spreadsheet Row(s)

Add Google Sheets rows for new Google Forms responses

If you're looking for an efficient way to keep your prospects organized, this integration can help! As soon as a new lead is generated in Google Ads, this Zap automatically adds their details to a row in a specified Google Sheets spreadsheet.

Google Ads (formerly Google AdWords) is an online advertising platform developed by Google, where advertisers pay to display brief advertisements, service offerings, product listings, video content, and generate mobile application installs within the Google ad network to web users.

Google Ads

Triggers whenever a new campaign is created in Google Ads.

New Campaign

Triggers whenever a new lead is created from a Lead Form Extension.

New Lead Form Entry

Finds a Google Ads Campaign whose id matches the provided input.

Find Campaign by Id

Finds a Google Ads Campaign whose names matches the provided input.

Find Campaign by Name

Find Customer List

Finds a customer list by name. Optionally creates a new customer list.

Find or Create Customer List

Adds a contact to a customer list using their email address. Note: It takes 6 to 12 hours for the customer list to be populated with contacts.

Add Contact to Customer List With Email

Adds a contact to a customer list. Note: It takes 6 to 12 hours for the customer list to be populated with contacts.

Add Contact to Customer List

Creates a customer list in Google Ads Audience Manager.

Create Customer List

Creates a report on specified data from your campaigns/ads.

Create Report

Remove Contact From Customer List

Sends events from your customer systems (PoS, CRM, email service provider, etc) to connect Google Ad campaigns to offline activity and business impact.

Send Offline Conversion

Sets the status of a Google Ads campaign.

Set Campaign Status

Create Google Sheets rows for new Google Ads leads

Often it's helpful to store, backup and organize emails matching certain characteristics to a Google Spreadsheet. This Gmail Google Sheets integration makes it a breeze to setup a simple rule (i.e. emails from: 

Gmail

Save new Gmail emails matching certain traits to a Google Spreadsheet

Spreadsheets make it easy to filter and sort through new prospects, but take time to build. Use this Facebook Lead Ads-Google Sheets integration to link your records directly to your ads so you can keep your mind on marketing. After being set up, every new ad lead on Facebook will trigger this Zap, automatically creating a new row on Google Sheets with all those valuable details for you. Learn more in our 

Facebook Lead Ads

Add new Facebook Lead Ads leads to rows on Google Sheets

This integration makes it easy to trigger an email via Gmail for updates in a Google Spreadsheet. You can trigger an email based on any update or specific updates to a certain column. Get step-by-step directions in our 

How to use Google Sheets: A beginner's guide

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.