> ## Documentation Index
> Fetch the complete documentation index at: https://docs.landerlab.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Set Up Google Sheets Integration

> Learn how to connect Google Sheets to your landing pages in LanderLab so every lead is automatically added as a new row in your spreadsheet.

<Frame>
  <img src="https://mintcdn.com/landerlab-babdc23f/b7I27OCOp06ppZUT/images/LL-Sheet.png?fit=max&auto=format&n=b7I27OCOp06ppZUT&q=85&s=a7cedd30c4728d03ffdc63d3d76f3fff" alt="LL Sheet" width="1200" height="600" data-path="images/LL-Sheet.png" />
</Frame>

<Note>
  Connect Google Sheets to your landing pages in LanderLab to automatically send every lead to a spreadsheet. Each form submission adds a new row with the fields you choose, so your lead data is always up to date and ready to use.
</Note>

## What is the Google Sheets Integration?

The Google Sheets integration lets you push lead data from your landing pages directly into a Google Sheets spreadsheet. Every time a visitor submits a form on your page, LanderLab appends a new row to the sheet you select. You can map each form field to a specific column, so the data lands exactly where you need it.

This is useful when you want a simple, shareable place to collect and review leads without setting up a CRM or building a custom API endpoint. Your team can access the spreadsheet in real time, apply filters, create charts, or export the data for use in other tools.

Once you connect a Google account, it is saved **globally** in your LanderLab account. You can reuse the same account across multiple landing pages without authenticating again.

## How to Add Google Sheets

The setup walks you through authentication, spreadsheet selection, and field mapping in a single flow.

<Steps>
  <Step title="Open the Integrations Panel">
    Navigate to **Landing Pages**, then click the **name of the landing page** where you want to add the integration. Click **Add Integration** to open the integrations panel.
  </Step>

  <Step title="Select Google Sheets">
    In the integration list, find **Google Sheets**  and click **+ Add**.

    <Frame>
      <img src="https://mintcdn.com/landerlab-babdc23f/b7I27OCOp06ppZUT/images/add-google-sheet.png?fit=max&auto=format&n=b7I27OCOp06ppZUT&q=85&s=37cc568da3cf8191040196c0105b0515" alt="Add Google Sheet" width="1470" height="834" data-path="images/add-google-sheet.png" />
    </Frame>
  </Step>

  <Step title="Authenticate with Google">
    A Google sign-in window will open. Choose the Google account that owns (or has access to) the spreadsheet you want to use. If you are signed into multiple Google accounts, select the correct one from the list.
  </Step>

  <Step title="Grant Permissions">
    Google will ask you to confirm that LanderLab can access your Google Drive files. This permission is limited to the specific files you use with the app. Check the box to allow access, then click **Continue**.

    <Tip>
      LanderLab only requests access to files you explicitly select. It does not have access to your entire Google Drive.
    </Tip>
  </Step>

  <Step title="Name the Integration and Select a Spreadsheet">
    The integration wizard opens at **Step 1** with two fields:

    | Field           | Description                                                                                                                                                                                         |
    | --------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
    | **Name**        | A label to identify this integration (auto-filled with your Google account email). You can change it to something descriptive like "Lead Sheet - Campaign A".                                       |
    | **Spreadsheet** | Click **Select Spreadsheet** to open the Google Sheets file picker. Browse your folders or use the search bar to find the spreadsheet you want. Click the file to select it, then click **Select**. |

    Once the spreadsheet is selected, a **Sheet** dropdown appears. Choose the specific sheet (tab) within the spreadsheet where leads should be written.

    Click **Continue** to proceed to field mapping.
  </Step>

  <Step title="Map Form Fields to Sheet Columns">
    In this step, you control which data gets written to your spreadsheet and where it goes. LanderLab displays two columns side by side:

    | Column           | What It Does                                                                                                                                                          |
    | ---------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
    | **Form Field**   | The data captured from your landing page (form inputs and LanderLab system fields).                                                                                   |
    | **Sheet Column** | The column in your spreadsheet where the data will be written. Select from the dropdown or choose **Auto Generate** to let LanderLab create the column automatically. |

    Each field has a checkbox on the left. Uncheck any field you do not want to send to the spreadsheet.

    Your form fields (such as name, email, phone, or any custom inputs) appear at the top. Below them, you will see the default LanderLab system fields:

    | System Field               | Description                                          |
    | -------------------------- | ---------------------------------------------------- |
    | **LL Lander URL**          | The full URL of the landing page the visitor was on. |
    | **LL Visitor IP**          | The IP address of the visitor.                       |
    | **LL Visitor User Agent**  | The browser and device information of the visitor.   |
    | **LL Submission Time UTC** | The date and time the lead was submitted (in UTC).   |
    | **LL Variant ID**          | The A/B test variant ID the visitor was shown.       |

    Use the **Sheet Column** dropdown next to each field to pick the matching column header from your spreadsheet. If you select **Auto Generate**, LanderLab will create a new column using the form field name.

    <Tip>
      If your spreadsheet already has column headers set up, match each form field to the correct column. This keeps your data organized and avoids blank or mismatched columns.
    </Tip>

    Click **Continue** to finish the setup.
  </Step>
</Steps>

Your Google Sheets integration is now active. Every time a visitor submits a form on this landing page, a new row will be added to your selected spreadsheet with the mapped field values.

## Using the Same Account on Other Landing Pages

Because your Google account is saved globally, you do not need to authenticate again when adding Google Sheets to another landing page. Open the integrations panel on any landing page, expand **Google Sheets**, and you will see your connected account listed. Click **Connect to page** to start the spreadsheet and field mapping setup using that same account.

## Tips for Getting the Best Results

**Prepare your spreadsheet first.** Create your spreadsheet and add column headers before setting up the integration. This makes the field mapping step faster and ensures your data is organized from the start.

**Use descriptive column names.** Headers like "First Name," "Email," and "Phone" are easier to work with than generic labels like "Column A" or "Field 1."

**Keep one sheet per landing page.** If you run multiple campaigns, use separate sheets or separate spreadsheets to prevent mixed data and make filtering easier.

**Check the Sheet dropdown.** If your spreadsheet has multiple tabs, make sure you select the correct one. Leads will only be written to the sheet you choose during setup.