---
title: "How to automatically add new Unbounce submissions to Google Sheets"
description: "You can track your form submissions in Unbounce. But if you need to easily share it or add it to an archive, you might want to store it in Google Sheets instead."
image: "https://images.ctfassets.net/lzny33ho1g45/3L1KbKoBkH4Dk5ilqOP9uL/e4c4f7728dfe6b49c295499f50f92fb3/add-unbounce-submissions-to-google-sheets-00-hero.jpg"
---

# How to automatically add new Unbounce submissions to Google Sheets

You can track your form submissions in Unbounce. But if you need to easily share it or add it to an archive, you might want to store it in Google Sheets instead.

With [Unbounce](https://zapier.com/apps/unbounce/integrations), you can whip up a landing page for, well, anything in just a couple of minutes. And with its variety of easy-to-use features, it's a great resource for advertising a product or business. 

Unbounce also does a good job of cataloging all your form submissions on a leads page. But if you need to easily share that information with other team members or add it to an archive of other leads' data, you might want to store it in Google Sheets instead.

With Zaps—Zapier's automated workflows—you can automatically send new Unbounce submissions to Google Sheets, making it easy to manage leads at scale.

## Before you begin

First, set up your Unbounce landing page or decide which landing page you want to use. Then, create a new spreadsheet in Google Sheets. In order for the Zap to work correctly, you'll need to make sure to add headers in your first row. 

What headers you use will depend on your landing page. In this example, we're creating a landing page for a sales callback, so we'll create two column headings: **Name** and **Phone Number**.

## How to track Unbounce submissions in a Google Sheet

Zapier lets you create automated workflows called Zaps, which send your information from one app to another. You can create your own Zap from scratch without any coding knowledge, but we also offer quick templates to get you started. 

If you'd like to start with a template, click the template below, and you'll be taken to the Zap editor. You'll need to create a Zapier account if you don't already have one. Then, follow the directions below to set up your Zap.

### Set up your Unbounce trigger

Let's start with the trigger—the event that starts your Zap. If you're using the Zap template, this will be selected for you. Otherwise, search for and select **Unbounce** as the trigger app and **New Form Submission** as the trigger event, then click **Continue**.

Next, connect your Unbounce account, if you haven't already, then click **Continue**.

Next, select the _Client_ and the _Landing Page_ form in their respective fields. Then click **Continue**. 

Now it's time to test your trigger step. This will gather information from Unbounce that will be used to set up the rest of your Zap. Before clicking **Test trigger**, make sure there's at least one submission in the form (you can add fake testing data if you don't have any submissions). 

Zapier will show you the most recent data from the landing page form. 

Click **Continue with selected record** to move on to setting up your action step.

### Set up your Google Sheets action

Now it's time to set up the action—the event your Zap will perform once it's triggered. If you're using the Zap template, these will already be selected for you. Otherwise, search for and select **Google Sheets** as your action app and **Create Spreadsheet Row** as your action event. Click **Continue**.

Next, connect your Google Sheets account, if you haven't already. Then click **Continue**.

Now we get to the fun part. First, choose the appropriate drive in the _Drive _field where your Google Sheet is stored. Then select the _Spreadsheet_ you created for the landing page, then choose the appropriate _Worksheet_ (by default, it's "Sheet1").

Once you do that, Zapier will automatically pull in the column headings you added to your sheet. 

What's left now is to map our columns with the data from Unbounce. To add data from your previous Unbounce step, simply click in a field and select the data you'd like to use from the _Insert Data _dropdown.

For our example, we'll add **Form Data Name Field** to the _Name_ field and **Form Data Phone Field** to the _Phone Number_ field. Your mapping will depend on your landing page, but Zapier shows the data preview from the test, so it's quite easy to match the fields that you want. 

Once that's done, click **Continue**.

Click **Test action**, and Zapier will send the test data to the spreadsheet in Google Sheets. Check the results to make sure the right data is mapped to the appropriate columns.

If you'd like, you can go to your Google Sheets spreadsheet to double-check. Here's what the successful test results look like for us.

And there you have it! Now, every time someone fills up the form on your landing page, all the data will show up in your spreadsheet instantly!