Google Sheets integration

With the Google Sheets integration, every completed quiz adds a row to a spreadsheet in your Google Drive: the date, the customer's email, name and phone, one column per question, the recommended products and a link to their results.

1.1 In Lantern, open Integrations and find Google Sheets under Automations.

1.2 Click Connect Google Sheets. A Google sign-in opens in a new tab.

1.3 Choose the Google account that should own the spreadsheets and allow access.
​1.4. Google's permission screen will ask you to enable the following: "See, edit, create and delete only the specific Google Drive files you use with this app". You must enable this before clicking Continue.
Lantern only asks for permission to see and edit the spreadsheets it creates itself or that you pick for it in your Drive, nothing else.

1.5 You're sent back to Lantern, and the Google Sheets card shows the connected account.

Next, you'll switch on the quizzes you want in a sheet. No data is sent until you do.

2.1 Open a quiz in the editor, go to its More Integrations tab and find Google Sheets
​2.2 Tick Send completed quizzes to Google Sheets. As soon as it's selected, Lantern creates a spreadsheet for that quiz with the column names corresponding to customer details, quiz questions and product recommendations. The app shows the spreadsheet's name with an Open link option.

2.3 Untick this option if you want the quiz data to stop being sent to Google Sheets.

New rows get created from the moment a quiz is switched on. Earlier submissions are not added; use the export on the Submissions page for those.

If you'd rather use an existing spreadsheet:
​2.4 Open a quiz in the editor, go to its More Integrations tab and find Google Sheets
​2.5 Click Use an existing spreadsheet (or Use a different spreadsheet if the quiz already has one connected). Google's file selector opens with the spreadsheets of the connected account.
​2.6 Select your preferred spreadsheet.
​2.7 Lantern adds a new Submissions sheet/tab to it, writes the column names and switches on data sharing from the quiz, and shows the spreadsheet's name in the More Integrations card. Your other sheets/tabs remain the same, and Lantern only writes in the Submissions one.

If Google's file selector doesn't open, Lantern will show a warning message, for example: "The API developer key is invalid". Check these in order:

Each quiz has one spreadsheet, but several quizzes can share the same spreadsheet: their rows all go to its Submissions sheet, and the column names are created and synced up as you select multiple quizzes. If you'd rather keep different quiz data separately, use a different spreadsheet per quiz.

A spreadsheet Lantern creates is named Lantern - [quiz name] and lands under the connected account's My Drive.
​
The Google Sheets card on the Integrations page lists every quiz and its connected spreadsheet name and direct link.
​
The first row in each spreadsheet is frozen so the column names stay visible while you scroll.

Inside each submissions sheet, you'll find the following columns:

By default, each question column name is identical to the question itself, unless you've set up Question Property IDs. In this case, the property IDs become the column titles. We recommend setting up short and clear Question Property IDs like skin_type or budget to help you better manage your data.
​
The column names stay the same even if you later reword the question, and text questions need an answer key to appear in the sheet at all.
​

Multiple choice answers are joined with commas in one cell.
​
Product links are added as one URL per line in a single cell.

You can add columns, formulas, filters and tabs to your spreadsheet. Lantern only adds submission rows to the Submissions tab.
​

When you add or rename a quiz question, Lantern adds a new column at the far right. It never moves or deletes existing columns. If you rename or remove a question, its old column stays in the sheet, but future submissions leave it empty.
​

If you delete the spreadsheet, Lantern creates a new one for that quiz when the next submission comes in.
​

To disconnect your Google account from Lantern, go to the main Integrations tab and click Disconnect on the Google Sheets card. Lantern stops sending submissions to your spreadsheets and no longer has access to your Google account.
​

Your spreadsheets stay in Google Drive. If you reconnect the same Google account later, Lantern uses the same spreadsheets again.
​

If the card shows Reconnect required, Lantern’s access to your Google account has been removed or has expired. This can happen after a password reset. Click Reconnect and sign in again.
​

Submissions received while the account was disconnected are not added to the spreadsheets when you reconnect.

Before Lantern had a direct Google Sheets integration, you could use Zapier to send quiz submissions to a spreadsheet. This option still works if you prefer it. See Use Zapier to send quiz submissions to Google Sheets.