If you still need to use filters, formulas, and so on, create two sheets in the table:
- "Technical" first sheet — Albato sends data to it.
- In the second sheet, use the formula =IMPORTRANGE.
Thus, you will have one simple sheet where data is transmitted, and a second sheet where all information is duplicated in real time, where you can also configure formulas, filters, and so on. On the second sheet, write this formula under each column in the 1st row. The formula is filled in like this =IMPORTRANGE ("table reference"; "sheet name!cell range").
Example:
=IMPORTRANGE(«https://docs.google.com/spreadsheets/d/1ZKUZNg6OjJOKeAqBLVLc5m-nV6-rJ7″;»Sheet1!A1:A999»)