Skip to main content

Zapier – How to log email replies into Google Sheets

Automate reply logging to Google Sheets in just a few minutes.

Marion Regimbeau avatar
Written by Marion Regimbeau
Updated today

Overview

This article explains how to automatically record your leads’ email replies into Google Sheets using LGM and Zapier. No more manual copy-paste, every reply flows neatly into your spreadsheet, organized and ready to analyze.

Key benefits

  • Time savings by eliminating manual data entry

  • Centralization of all replies in a single Google Sheet

  • Simplified tracking across multiple campaigns


Manually exporting your leads’ replies

Listing leads who replied

In your LGM campaign overview, you can filter leads using the Replied filter to display only the ones who answered you:

You can then click Select all → Export to download a .CSV file containing all responses collected in your campaign.

If you want all email replies from every campaign to be automatically filed in Google Sheets, you can choose to sync them with Zapier before launching your campaign.

Using Zapier to log email replies in Google Sheets

Preparing your Google Sheet

Before building your Zap, create a new spreadsheet dedicated to tracking replies.

Name your columns according to the information you want to track. These columns must match fields available in LGM.

You can include:

  • First name

  • Last name

  • Company

  • Email

  • LinkedIn URL

  • Campaign name

  • Email body

Tip: The clearer your columns are, the easier your data will be to analyze later.

How to automatically create a new row in Google Sheets when a lead replies

Connecting LGM to Zapier

You’ll use Zapier to connect LGM to Google Sheets and automatically add a new row every time a lead replies.

Here's our tutorial to configure your Zap step by step and reproduce the automation in just a few minutes:

Checking the result in your Sheet

Once your Zap is active, each new reply will appear automatically in your spreadsheet:

And that’s it! Now you can test your Zap and turn it on 🔛


FAQs

How can I filter only the leads who replied in LGM?

Use the Replied filter in your campaign overview to display only the leads who sent you a response.

Can I track several campaigns in a single Sheet?

Yes — just add a Campaign name column and send all replies to the same Sheet. This gives you a centralized view. You can also create multiple Zaps to separate replies into different tabs (one per campaign, for example).

How long does it take to set up the Zap?

Just a few minutes. Once it’s configured, it runs automatically with no manual work required.

Is it possible to export replies retroactively with Zapier?

No. To export replies already received, go to your campaign overview, apply the Replied filter, then click Select all → Export.

Did this answer your question?