Stape
SearchTry for free
FreeGTM variables

Spreadsheet Reader variable

Stape created a Spreadsheet Reader variable with which you can read values from cells or ranges in your sheet and use it as an input into Server GTM. The ability to read data from Google sheet to server Google Tag Manager gives an excellent opportunity to enrich sGTM data. 

Benefits of Stape's Spreadsheet Reader variable:

  1. Reads and returns data from one Google Sheet cell.
  2. Reads any field range within Google Sheet. Variable returns arrays of values.
  3. You can add a range that includes two columns. Variable returns an object that consists of these two columns. The first column is used as a name, and the second - correspondent value.

Related to this solution

Write data from server Google Tag Manager to Google Sheets
Apr 16, 2022

Blog

Write data from server Google Tag Manager to Google Sheets

Write data to Google Sheets from server GTM. Track leads, sales, and more directly in spreadsheets. This guide explains the setup and benefits for marketers.

Read data from Google Sheet to server Google Tag Manager
Apr 23, 2022

Blog

Read data from Google Sheet to server Google Tag Manager

Read Google Sheet data directly into sGTM! This guide covers 'Read cell,' 'Read Range,' and 'Read Two Columns' variable actions for efficient data enrichment.

What is Google Tag Assistant and how to use it
May 29, 2023

Blog

What is Google Tag Assistant and how to use it

In this article you will find out what is Google Tag Assistant, what are the benefits and key features of this extension and how to start using it.

We have more than 100 000 happy clients

Try Stape for all things server-sideright now!