Skip to main content
All CollectionsCRM & IntegrationsZapier
Zapier - How to save an answer in Google Sheets?
Zapier - How to save an answer in Google Sheets?

Do you need to keep track of the replies generated by your campaigns or those of your collaborators?

Titouan Decap avatar
Written by Titouan Decap
Updated over 3 months ago

Your campaigns are launched, and now your problem is you have too many answers for your leads. You have to upload them in a spreadsheet, but you're doing it manually and it's taking a lot of time. Why you don't automatize it? With LGM and Zapier, everything is possible. Let's see how LGM is the best partner for your sales automation!

Table of contents

A reminder of how exporting your leads answers

The first possibility is to look at the stat part of the campaigns on LGM.

In the activity tab, you can filter the leads by keeping only those who have responded.

In case you need to keep track of these answers, you will be able to automatically synchronize each reply in Google Sheets.

To do this, you will need to use Zapier to connect LGM to a Google Sheet to list all your replies.

Before creating the zap, you will have to create the sheet that you’ll use to track all the replies on one or more campaigns.

Once created, name the columns you want to use. These columns must correspond to fields present on LGM. You can typically use the following to get a good overview of the activity:

  • First Name

  • Last Name

  • Company Name

  • Email address

  • Linkedin URL

  • Name of your campaign

  • Body of the email reply

How to create a Google sheet row when a lead replies by email

First, on Zapier, you’ll need to choose on which app you want to trigger an action, and which action you want to specifically trigger the workflow. In this case, we’ll choose La Growth Machine (natively integrated into Zapier) and the email replied action. Why? because it is this event you want to trigger the workflow and synchronize it on Google Sheets.

Once you’ve connected your LGM account, you can choose which campaigns you want to be notified of when you’ll get a reply. You can choose all campaigns, a bunch of them, or a specific one. In this example, we’ll trigger the workflow for all campaigns.

Then, test your trigger and you’re free to move on!

Now that you set your trigger, you’ll want to map your fields on your Google sheet.

Choose Google Sheets on the app selection for the action, and select Create a spreadsheet row as an event.

If you haven't already done so, connect your Google account to Zapier, and select the spreadsheet you just created.

Once you've done that, it is time to map all the fields that you want to synchronize. Here, you’ll use LGM’s variables to map this.

It will result like this in your sheet :

Once you’ve done with the set-up, you can test your zap and make it live 🔛 !

It's up to you now!

As you've seen, it's super easy to automate this task. No need to do it manually anymore, you will gain a lot of time with La Growth Machine!

Want to gain a lot of time? Check these other zaps!

Did this answer your question?