Possible to save attachments in OneDrive data source when app owner is Gmail?

[GreenFlux]

I know you can connect multiple data sources and use sheets from different providers, but what about mixing up the attachment archive folder?

The Workflow/Report attachment path is relative to the default app folder, so you can only work within that root directory.

And the app’s default app folder seems to also be limited to the data source that app owner uses to log in.

My app owner logs in with Gmail, but I want to save attachments in a OneDrive folder. The OneDrive account has been added as a data source, but it seems that feature is limited to where sheets and email templates are stored-- but not the actual PDFs produced by the templates!

Does anyone know if this is possible using native AppSheet features? I have some other ideas involving GAS, Microsoft Flow or Zappier. Just want to make sure I’m not missing some built-in way to do this in AppSheet.

@Aleksi, @Steve, @LeventK, @MultiTech_Visions, @Fabian, any ideas?