In-app Google Sheets integration

Last updated: May 17, 2022 Written by: Avatar Marta Szeliga
share
Table of contents
share
Table of contents

Integration with Google Sheets enables you to easily collect data from leads obtained from forms on landing pages or pop-ups, and save them directly in your Google Sheets.

This integration is not available on White Label accounts due to its connection with our brand and Landingi editor's URL – Landingi's logo is visible during the integration process.

IMPORTANT: Once you connect form fields with columns in a Google sheet the field attribute names will be renamed to the column names in the sheet. If you are using field attributes in an integration with another tool, keep in mind that this integration may not work when connected with Google Sheets.

Connect your form with Google Sheets

1. Log in to your Landingi account, then go to the editor of your landing page or pop-up.

2. Go to the form Settings and click on the Integrations tab. Choose Google Sheets.

google sheets integration

3. In the new window, click the Connect Google Sheets button. You will be prompted to log in with your Google account. Allow the integration to access your Google account.

connect with google sheets

4. Choose file and sheet:

(1) In the Select file field, select the file from the list to which you want to send lead data from your form or create a new file by clicking the Create new file button (the created file will have the same name as the landing page).

(2) In the Select sheet field, select the sheet on which the lead data from the form should be saved or create a new sheet in the selected file by clicking the Create new sheet button. The sheet name can not consist of any special characters or numbers.

select google sheet

5. Connect fields from your form with columns in your Google sheet. Save and close.

Important: Remember to name all the columns to which form field should be connected. Connect all columns with fields and do not leave them as "none" – then the leads will not be registered.

connect fields with columns

6. Publish your landing page and check if the data from the form is sent to your Google sheet correctly.

NOTE: Keep in mind that Google Sheets are a third-party solution and are continually being developed. We do our best to keep this guide updated, but if you come across any changes in the set-up process, let us know.

share

Was this manual helpful?