Skip to content
  • There are no suggestions because the search field is empty.

How to Import Data from Google Sheets | MoreApp

Use MoreApp’s flexible Form Builder to easily import data from Google Sheets into your forms. Visit our help center to learn how!

No MoreApp account yet? Sign up here.

1. Google Sheets

In order to have your data imported into your form, you will need to have a Google Spreadsheet. You can create one or use an existing sheet.

Pay attention. You will need to:

  • Name the first column id in lowercase letters. This column needs to have unique numbers.

  • When adjusting the data source, do not change the id of the existing entries. The search function in the App will rely on these values.

  • Give a unique header for each column. You can add as many columns as you like.

Once you have your sheet, you can go to the MoreApp Platform and make a form.

2. Add a Data Source

Once you have logged into the Platform, you can go to the Data Sources tab to add the sheet. By clicking on Add a data source, you can give the source a name. Under Type, click on Google Spreadsheet. Before adding the Google Spreadsheet you will need to authenticate your Google account. Once it's authenticated, you can add the Google Sheet ID. The Sheet ID can be found in the URL of your Google spreadsheet as shown below.

Note:

  • You can also change the interval of the updates from every 15 minutes to weekly when using the Branch, Tree or Forest plan.
  • Do you want the data to be displayed in chronological order in your form? Start with number 111 in the id column of your data source.

Click on Save once you have filled in the fields.

3. Import your Data

After you have added the data source, you will need to import the data by clicking on Schedule Import in the Data Source tab.

Now, add it to your preferred form by selecting the form and clicking on Edit form.

Add the Search field to your form so that the user can search through the data. Edit the Search field by clicking on it. You can name the field under Label, and select the data source you just created.

search-field-data-source-moreapp


4. Congratulations! 

You have successfully imported data from a Google Sheet to your form. Now your users can search for and use the imported data in their forms, even offline! 


Want to stay up to date with our latest tutorials? Go to YouTube and hit the Subscribe button!