Convert Google Sheets to Appsheet Databases

[iamliving]

I used Google Forms to create my AppSheet app and I would like to know if I can convert the Google Sheets (refs) to AppSheet databases?

Thanks

[dbaum]

You can make some changes to the spreadsheet that stores Forms responses but it's not possible to change that that storage to a different file.

If helpful, you could create functionality in your app that replicates every row in a table that uses a Forms spreadsheet as its data source to a table that uses an AppSheet table as its data source. One technique is to use the AppSheet API: Example: Copy newly added records - AppSheet Help. 

[Steve]

AppSheet Database is currently a preview feature and under active development. Preview features are not yet suitable for use in important apps. Until it has achieved greater stability, I recommend against using this preview feature except for testing and to help the AppSheet developers in their efforts. To follow the progress of and contribute to the development effort, please visit this dedicated Community topic:

Introducing new AppSheet database feature ...