---
title: "Tracking Google Sheet Opens with Google Apps Script"
author: "Martin Hawksey"
date: 2021-08-09T21:10:14+00:00
modified: 2021-08-10T09:12:17+00:00
canonical_url: https://pulse.appsscript.info/p/2021/08/tracking-google-sheet-opens-with-google-apps-script/
markdown_url: https://pulse.appsscript.info/p/2021/08/tracking-google-sheet-opens-with-google-apps-script.md
categories:
  - "Beginner"
  - "Sheets"
  - "Solutions"
  - "V8"
  - "Web App"
tags:
  - "@wildhogsm"
  - "dmitry-kostyuk"
  - "Medium"
description: "The basic principle behind tracking Google Sheet opens is the same as the one behind email tracking with a transparent pixel. In a Google Sheet, we will use the IMAGE()function, which will call a deployed Google Apps Script web app URL with some parameters in the query string. The web app will be able to do whatever you need among the following: record to a spreadsheet, create a message via a messenger, or simply send an email."
---

# Tracking Google Sheet Opens with Google Apps Script

> [https://dmitry-kostyuk.medium.com/tracking-google-sheet-opens-with-google-apps-script-edeeb667ad7c](https://dmitry-kostyuk.medium.com/tracking-google-sheet-opens-with-google-apps-script-edeeb667ad7c)
> The basic principle behind tracking Google Sheet opens is the same as the one behind email tracking with a transparent pixel. In a Google Sheet, we will use the IMAGE()function, which will call a deployed Google Apps Script web app URL with some parameters in the query string. The web app will be able to do whatever you need among the following: record to a spreadsheet, create a message via a messenger, or simply send an email.

Source: *[Tracking Google Sheet Opens with Google Apps Script*](https://dmitry-kostyuk.medium.com/tracking-google-sheet-opens-with-google-apps-script-edeeb667ad7c)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2021/08/tracking-google-sheet-opens-with-google-apps-script/](https://pulse.appsscript.info/p/2021/08/tracking-google-sheet-opens-with-google-apps-script/)*
