Some examples

You can edit the data directly in the sheet itself, but for analysis purposes, we recommend that you create a new sheet, in this way, in case of an update of the application or if you have the intention to delete your sheet to recreate a new one, you will be able to move your formulas from the old sheet to the new one.

Here are some samples with VLOOKUP formula and pivot tables;

https://docs.google.com/spreadsheets/d/182mO42ySYhZnrRpLw8Xl8_D1WGSuzIMtWizwoHUxZ_M/edit?usp=sharing

How to create a new Google Sheet sheet and import the data dynamically linked to the sheet created by the App:

Create a new sheet on Google Sheets
Import the data into the tab with IMPORTRANGE:



Then create a new sheet to display consolidated data;



https://docs.google.com/spreadsheets/d/1QoDtMTvhilIvuIQTNrKP4qEa4M2QEgGH1V-vbH5ax88/edit#gid=931443235

Every time the app updates its sheet, the external sheet will also be automatically updated!

Updated on: 29/04/2025