---
title: "Build A Lookup Table Generator For Google Tag Manager with Google Sheets and Apps Script"
author: "Martin Hawksey"
date: 2020-08-04T19:20:53+00:00
canonical_url: https://pulse.appsscript.info/p/2020/08/build-a-lookup-table-generator-for-google-tag-manager-with-google-sheets-and-apps-script/
markdown_url: https://pulse.appsscript.info/p/2020/08/build-a-lookup-table-generator-for-google-tag-manager-with-google-sheets-and-apps-script.md
categories:
  - "Sheets"
  - "Solutions"
  - "V8"
tags:
  - "@SimoAhava"
  - "simoahava.com"
featured_image: https://pulse.appsscript.info/files/2020/08/lookup-table-generator.jpg
description: "The purpose of the Lookup Table generator is to automate the often tedious task of adding many, many rows to a Lookup Table within the Google Tag Manager UI. There are other solutions for this,..."
---

# Build A Lookup Table Generator For Google Tag Manager with Google Sheets and Apps Script

![Build A Lookup Table Generator For Google Tag Manager with Google Sheets and Apps Script](https://pulse.appsscript.info/files/2020/08/lookup-table-generator.jpg)

> [https://www.simoahava.com/analytics/lookup-table-generator-google-tag-manager/?linkId=96028281](https://www.simoahava.com/analytics/lookup-table-generator-google-tag-manager/?linkId=96028281)
> The purpose of the Lookup Table generator is to automate the often tedious task of adding many, many rows to a Lookup Table within the Google Tag Manager UI. There are other solutions for this, but none (as far as I know) that uses the Google Tag Manager API.

Within the Google Apps Script community there is a strong representation from those working in analytics and SEO. Simo Ahava has shared a comprehensive tutorial which shows how you can interact with the [Google Tag Manager API**](https://developers.google.com/tag-manager/api/v2) in Google Sheets. Click through to the source for more details and all the code you need.

Source: *[Build A Lookup Table Generator For Google Tag Manager | Simo Ahava’s blog*](https://www.simoahava.com/analytics/lookup-table-generator-google-tag-manager/?linkId=96028281)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2020/08/build-a-lookup-table-generator-for-google-tag-manager-with-google-sheets-and-apps-script/](https://pulse.appsscript.info/p/2020/08/build-a-lookup-table-generator-for-google-tag-manager-with-google-sheets-and-apps-script/)*