Stape created a Google Sheet tag for the server Google Tag Manager container that helps write data from sGTM to Google Sheet. With the help of this tag, you can add raw or update cell inside Google Spreadsheet. To set up a Google sheet tag, you need to have a Firestore account and set up Google Authorization.
     1. Write data from server Google Tag Manager to Google Sheets
     2. How to connect Google Service Account to stape
     3. Google Sheet tag.
Learn how to create a Google Service Account and connect it to your Stape container in this step-by-step tutorial. Doing so will allow you to integrate server Google Tag Manager with BigQuery and Firestore.
In this blog post, I will show you how to write data from a server-side Google Tag Manager container to a Google Sheets.
How to read data from a Google Sheet and use it inside your server-side Google Tag Manager setup.