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. Write data from server Google Tag Manager to Google Sheets
     2. Read data from Google Sheet to server Google Tag Manager
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 Google Sheet data directly into sGTM! This guide covers 'Read cell,' 'Read Range,' and 'Read Two Columns' variable actions for efficient data enrichment.
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.