App Script integration: What is really necessary?

[Posacho]

Hi everyone,

I'm developing a small app for internal use only in my company.  We're still exploring so we're still with the free plan. I'm trying to figure out how to integrate App Scripts whit App Sheet in a consistent way through automations.

By now, the app uses AppSheet Database as datasource, but I had trouble fetching data using theSpreadsheetApp interface. Since i had no trouble using a classic excel-like sheet, and I can see the error Data provider 'google_tables' not allowed with the FREE plan in the AppInfo page, do i have trouble fetching data from AppSheet Database with SpreadsheetApp due to my subscription plan? If not, is there another way? Will upgrading to appsheet core solve this problem or it's not related at all?

And since i can do that with classic sheets, can i fetch data from multiple AppSheet Database in a single App script function?

thanks