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. 

1. 1.
   Reads and returns data from one Google Sheet cell.
2. 2.
   Reads any field range within Google Sheet. Variable returns arrays of values.
3. 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.

     1. Write data from server Google Tag Manager to Google Sheets

     2. Read data from Google Sheet to server Google Tag Manager