<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=1822615684631785&amp;ev=PageView&amp;noscript=1"/>

Update a Google Sheet with campaign data (opens, clicks, replies)

Update Google Sheet

You can now set your Google Sheet to automatically update as your campaign sends. Opens, clicks, replies, and bounces will update columns in your Google Sheet so that you can easily see how each person has engaged with your mail merge or cold email campaign.

Go ahead and stare!

A Google Sheet updating live with campaign data.

You can use this data to further refine follow-up campaigns by filtering on the columns that have values equal to X.

Activating this feature

In order for your Sheet to be updated, there are two basic steps you must follow:

  1. Check the box to update your Sheet at the time you connect to your Google Sheet inside Gmail.
  2. Grant GMass permission to write to your Google Sheet. When you first sign up for an account, GMass does not ask for the permissions necessary to write to your Sheet; at sign-up it only asks for permission to read from your Sheet. The first time you check the above-shown box, a popup will ask you to grant GMass the additional permissions:

    The first time you check the box to update a Sheet, you’ll get this popup.

If you don’t grant the necessary permissions before you launch your campaign, you will hear from us! You will eventually get an email notification requesting permission, but this will be after GMass has already tried and failed to update at least one cell in your Sheet. That email notification will look like this:

Make sure there are blank columns

If your Sheet looks like this and doesn’t have any available columns, the reporting metrics won’t be written to your Sheet.

This Sheet needs more columns for updating to work.

If your Sheet does look like this, just right-click on the right-most column to add a few more columns. You should have at least four empty columns after your last column of data. To future-proof your spreadsheet, in case we add more data to this feature (like “blocks” for example), add even more blank columns. By default, when you first create a new Sheet, columns A-Z exist, giving you a total of 26 columns. Generally, the only reason you would need to eliminate some columns entirely is to reduce the overall size of your Sheet, but that only becomes necessary if you have more than 100,000 rows of data.

GMass will write the column headings to the first row as soon as the first event takes place. For example, on the first “open,” GMass will label the column “OPENED” and mark the appropriate row with an X to indicate the open. You do not need to add the column headings; you just need to ensure there are blank columns available for use.

Once reporting events start to register on your Sheet, do not move or delete the reporting columns. Doing so could cause your other columns of data to get overwritten by Xs if GMass thinks that a column containing your actual merge data is a reporting column that we created automatically. That’s because GMass caches the structure of your Sheet and “memorizes” which columns are where in order to optimize computing resources, so if you suddenly alter the columns while it’s updating your Sheet, that will throw the process off until it caches your Sheet again during the next hour.

Troubleshooting

If your Sheet isn’t updating the way you expect:

  1. Make sure you’ve given GMass permission to edit your Google Sheets (see above).
  2. If the Sheet has been shared with your Google account by someone else, do you have EDIT permissions? If you only have READ permissions, then GMass won’t be able to update it, even if you’ve given GMass permission to update your Sheets, because the read-only permission on the shared Sheet takes precedence.
  3. Make sure you have enough blank columns to the right of your data.
  4. Make sure you checked the “Update Sheet with reporting data…” box when connecting to the Sheet. If you forget to to this and then launch a campaign, there’s currently no way to change it.
  5. Make sure you’re waiting long enough. Some events, like opens and clicks, will trigger the update to your Sheet within a few seconds of their occurrence. Other events, like replies, can take longer (up to a few hours). This is because GMass only checks your account for replies periodically, a process that happens once every couple of hours.

Other ways to get reports on your campaigns

Seeing the reporting data back in your Sheet is just one way to gain insight into how your mail merge campaigns are performing. You can also:

  1. Look at the real-time, web-based report for your campaign. The link can be found in any notification under GMass Reports –> [CAMPAIGNS] or any “sending complete” notification.
  2. Look at the campaign report under GMass Reports –> [CAMPAIGNS].
  3. Download a complete CSV file that will include your recipient list, all merged columns from the source Google Sheet, along with opens, clicks, replies, bounces, blocks, and more. This download link can also be found in either the web-based report or the report placed in the GMass Reports –> [CAMPAIGNS] label.
22 Comments
    1. Yes. Look at your main campaign report, found under GMass Reports –> [CAMPAIGNS] in your Gmail account, and you’ll see all campaign stats and the detail behind them and you can download CSV files for each metric.

      From the Google Sheet, if you SORT by the “OPENED” column, you can also figure out how many opens you have.

    1. You could just watch the Google Sheet live on your computer. You can also access the campaign’s reports.

      1. Tried the set up, should be no conflicts, when will the column titles that gmass adds appear for the tracking, should it be expects as immediate or within a couple hours. Not seeing them in the first hour so just seeing if its working, thanks!

    1. Hi Kevin,

      Unfortunately, no. This is because the option to do this is done when you initially connect the Google Sheet so must be enabled prior to beginning to send emails.

  1. Hi Ajay – The data in my sheets is only partially updating ( even after 24 hours) I see on the campaign report a number of opens 24 hours ago that are not pulling through to the Gsheet. Others however have pulled through… its not consistent for some reason – can you help with a troubleshoot please?

    1. Hi Andrew,

      Please contact our support team so we can assist you directly. Please include the campaign ID of the campaign connected to the Google Sheet that you’ve referenced isn’t updating all the way through. Please see gmass.co/g/support.

  2. Hello Ajay,

    Nice feature!

    If the same list is used for several campaigns, how will the data be represented for each campaign?

    Thanks

  3. Hi Ajay, in the campaign report we notice replies are recorded , but actual users are actually experiencing a much higher rate of replies that what is shown in report.

    Why does the report fail to register most of the actual replies?’

  4. This is amazing. However, I can’t seem to update my sheets to use this feature. Is there a link or a way I can?

    Thanks a bunch

  5. It there a way for gmass to delete our unsubscribes automatically from the sheet?
    That way this feature could be used for automation thru Zapier.
    Otherwise, we would continue to market to people that opened but unsubscribed.
    What would be the best way for this?

  6. Same question as what was asked above. How does this feature manage multiple campaigns using the same sheet. Also, if I want to stop updating after a particular time period, what should I do?

    1. Hi Roger,

      When using this new feature, please make sure to only have 1 campaign per associated sheet. This means if you need to run multiple campaigns using the same Google Sheet, you would first need to duplicate the sheet and make sure to use unique sheets (even if they have the same content/cells) for each campaign as GMass will need a separate sheet for each campaign’s live data to be updated.

Leave a Reply

Your email address will not be published. Required fields are marked *

Try GMass today

It only takes 30 seconds to install it!

Install Now GMass requires Chrome
Share This