Importing from another source

AppSheet AppSheet Q&A
, , , ,
1

Hi,

I have a big overall app made up of a lot of different modules, a big part of the app is a huge customer database that then feeds into numerous modules. This is manually populated as the customers contact us.

What I would like to be able to do is create a web form for new customer enquiries and feed that basic data into my app database, so that this automates any new enquiries that I can then contact and liaise with. A web for I use outputs to an excel/csv file and I was hoping there would be a way to feed that into my main customer database within the app?

Any suggestions welcome please and thanks in advance!

1 Like
2

For a manual process you should explore the import a CSV file for this view Import a CSV file for this view - AppSheet Help on your customer table.

You could also do a semi-manual process or a complete automated process using Google Apps Script and the Appsheet API.

1 Like
3

Why go through the extra steps?

I assume you already have some web site that you wish to expand? You can embed into a web page iFrame an AppSheet app that will feed the captured data directly into your database. For more details see Run an app in an iframe on a web site

Additionally, you can always launch into the app using the app browser URL. Or if your customers are already using AppSheet apps, you can provide a button that navigates to a separate app to capture enquiries.

Lots of options to prevent the extra steps of exporting and then importing.

I hope this helps!

2 Likes
4

One posdible option is e.g to use Google Forms for this purpose which is connected to your app.

3 Likes