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.

  • 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.

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 spreadsheet. Click on Add data source and select Google Sheets as the type. Give the data source a name.

Before adding the Google Spreadsheet, you will need to authenticate your Google account. Select one of your service accounts or connect a new account. Once it's authenticated, you can add the Sheet ID. The sheet ID can be found in the URL of your Google spreadsheet, as shown below.

You can also change the interval of the updates from every 15 minutes to weekly when using the Branch, Tree or Forest plans.

Activate the option ‘Offline access in the App’ if you also want to use the data source when working offline.

Click on Add once you have completed the configuration.


import-gsheets-data-sources

3. Import the data into the form

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.


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!