ConditionalVisibility

new-products-promo

google-sheets-pivot-table-image1

google-sheets-pivot-table-image2

google-sheets-pivot-table-image3

google-sheets-pivot-table-image4

google-sheets-pivot-table-image5

google-sheets-pivot-table-image6

google-sheets-pivot-table-image7

google-sheets-pivot-table-image8

google-sheets-pivot-table-image9

google-sheets-pivot-table-image10

google-sheets-pivot-table-image11

google-sheets-pivot-table-image12

google-sheets-pivot-table-image13

google-sheets-pivot-table-image14

google-sheets-pivot-table-image15

google-sheets-pivot-table-image16

Google-sheets-pivot-table-image17

App tutorials

app-tips-google-sheets-00-hero

Google Sheets

When you're working with massive amounts of data, pivot tables in Google Sheets make it easy to get the insights you need.

How to create and use pivot tables in Google Sheets

Forms are great at capturing user information, but exporting their results takes time. Zapier can help you analyze those entries in a spreadsheet automatically with this integration. Once you set it up, it will catch every new entry you receive on a Typeform, saving the results to a new row on Google Sheets so you don't have to do it yourself.

Typeform helps you ask awesomely online! If you ever need to run a survey, questionnaire, form, contest etc. Typeform will help you achieve it beautifully across all devices, every time, using its next generation platform.

Typeform

New Entry

Retrieves ALL file(s) of a given form that are uploaded as part of form submission.

Retrieve ALL Files

Lookup Responses

Create an Empty Form

Duplicates an Existing Form

Update Dropdown, Multiple Choice or Ranking Question Options

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)

Collect new Typeform responses as rows on Google Sheets

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

Forget manual exports. Automation can keep a log of all your form responses while you're busy with work that matters. After you turn on this integration, it will trigger with every new form submission you get on Unbounce, automatically adding a new row on Google Sheets for each one. You'll never have to worry about copy/pasting again.

Unbounce is a landing page platform that helps you convert more visitors into leads, sales, and customers. Unbounce Conversion Intelligence™ is AI powered-functionality that works with your marketing intuition to ensure the best campaign performance every time.

Unbounce

Triggers when a new Form Submission is received on a Landing Page, Overlay or Sticky Bar.

How to create and use pivot tables in Google Sheets

Related articles

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