Dokumentation durchsuchen

How to use Wascer to save information to Google Sheets

On your Wascer screen, authorize the Google services and the use of Sheets. After authorizing Google through Wascer, go to your GTM Server Side and click on Templates in the left sidebar. In the Tag Templates section, click New. On the screen that opens, click Import and import the google-sheets-tem

1 Min. LesezeitAktualisiert am 6. November 2026

On your Wascer screen, authorize the Google services and the use of Sheets.

After authorizing Google through Wascer, go to your GTM Server Side and click on Templates in the left sidebar.

image-126.png

In the Tag Templates section, click New.

image-127.png

On the screen that opens, click Import and import the google-sheets-template.tpl file. Save.

Back on the GTM screen, navigate to Tags and create a new Tag.

image-128.png

Find the template we just imported: Google Sheets Wascer

image-129.png

Now we’ll configure the tag:

image-130.png

Spreadsheet Name is the name of the file that will be created in your drive. It is not possible to use an existing spreadsheet. Sheet Name is the name that appears at the bottom of your spreadsheet. It’s usually Sheet1.

In Data, select what you want to add on each tag trigger.

For example: if you want us to record the current date and the value of the purchase every time the tag is fired, we’ll type something like {{date}} in the first field, click Add cell, and type something like {{data.purchase.value}} in the second field.

Configure the trigger according to your operation’s flow. After this setup, the tag will already be working and adding new rows to your spreadsheet!