Combining multiple tables into xls file for emailing

[ZADORE]

Hi everyone, not sure if this is possible.

I'm looking to create an automation that would email one xlsx containing multiple tables (data sources) as tabs.

So if my app has Data1, Data2, Data3 (all driven from one Google Sheet file with multiple tabs), it would generate a Data.xsls file with three tabs for each data set (containing only data filtered by date range). Note that each data set has different structure.

Thanks!

[AleksiAlkio · Accepted solution]

Yes it's possible if your XLSX template contains sheet/tab for each tables and of course different START: & END formulas.

[ZADORE]

Amazing! Yes, it worked. I was caught up on the fact that you must select ONE table when creating automation.

Thank you so much, Aleksi!

[AleksiAlkio]

You're welcome!