Skip to main content

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.

LL Sheet
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.

​
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.
1

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.
2

Select Google Sheets

In the integration list, find Google Sheets and click + Add.
Add Google Sheet
3

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.
4

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.
LanderLab only requests access to files you explicitly select. It does not have access to your entire Google Drive.
5

Name the Integration and Select a Spreadsheet

The integration wizard opens at Step 1 with two fields:
FieldDescription
NameA label to identify this integration (auto-filled with your Google account email). You can change it to something descriptive like “Lead Sheet - Campaign A”.
SpreadsheetClick 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.
6

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:
ColumnWhat It Does
Form FieldThe data captured from your landing page (form inputs and LanderLab system fields).
Sheet ColumnThe 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 FieldDescription
LL Lander URLThe full URL of the landing page the visitor was on.
LL Visitor IPThe IP address of the visitor.
LL Visitor User AgentThe browser and device information of the visitor.
LL Submission Time UTCThe date and time the lead was submitted (in UTC).
LL Variant IDThe 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.
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.
Click Continue to finish the setup.
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.