Get Data from Google Sheet

This article explains the Get Data from Google Sheet block that can be used to design an app.

‍Use this feature to pull data from your existing Google Sheets into your Clappia apps. You can then use workflows to automate apps based on the pulled data, create live dashboards, and even send automated reports.

Help Video

Editing the Block

Click on the ‘Get Data from Google Sheet’ block and start editing on the panel that appears on the right side.

Label

This is what appears as the label for the dropdown that shows the list of the items from the Google Sheet to be selected. Usually admins provide labels like "Select the customer/project/item".

Description

This is used to give a short description for the field, usually as a help reference for input for users. The description appears at the bottom of the field.

Select Google Account

If you do not have any Google Accounts synced in your Clappia workplace, then click on Connect with Google Drive. Only Workplace admins will be able to connect to a Google Account.

On clicking the ‘Connect with Google Drive’ button, a window will appear where you can select the Google account to connect to Clappia with. It will then show the type of access Clappia will have to the Google Account, click on Allow.

Once you have connected a Google Account, click on the Select Google Account dropdown, where you can select the connected account that appears.

You can also select this option immediately if you already have existing Google accounts synced with Clappia and skip the option ‘Connect with Google Drive’.

Enter Sheet URL or Sheet ID

Once you have selected the Google account, a new option appears called Enter Sheet URL or Sheet ID. You can link a specific Google Sheet by entering its URL or Sheet ID. To do this:

• Open the desired Google Sheet.
• Copy the URL from the browser's address bar.
• In Clappia, paste this URL into the "Enter Sheet URL or Sheet ID" field.

This action will establish a connection between your app and the selected Google Sheet.

Once the Spreadsheet link is entered in the Clappia app, additional options will appear to configure.

‍

Select Columns

The columns listed are from the connected spreadsheet. Select the columns in which users can type in data from to search and select data.

In this example, ‘Sales Rep’ and ‘Contacted’ columns are selected.

Pulled columns based on the selection

Based on the searched criteria by the user, select columns from the spreadsheet whose data need to appear in the Clappia app.

In this example, all the columns are selected to fetch information from the spreadsheet.

Once the columns are selected, the fields representing the columns will automatically appear in the app.

Required

Enable this option if the user has to mandatorily use this field before submission. By enabling this option, users will not be able to make submissions without entering the data of the required field.

No Record Message

Enter a text in this option to display it when no data is available to fetch from the spreadsheet based on the search criteria of the user. By default, it will say ‘No data found’.

Advanced Options

Display this field if

Use this option if you want to show or hide a field under certain conditions. It accepts the standard Clappia Formulae, similar to conditional sections.

Retain Value if Hidden

This option appears once a condition is set in the "Display this field if" option. Enable this setting if you want the field's value to be retained even when the field is hidden. This is useful for preserving user input in cases where the field may temporarily disappear based on conditions.

Example: If the field is hidden based on user selection but you still need to keep any hidden values for future reference or calculations, enable this option to ensure the data is retained.

Allow value to be changed after initial submission

Enable this to allow the field value to be changed after submission.

In the App Home, where the app is live and ready to use, the user will now be able to fetch data from Google Sheets.

Simply click on the field to get a dropdown list or type in the data to be fetched based on Search criteria configured.

The pulled fields will automatically pull data from the Google sheet.

Note: Once a submission has been made with the data from Google sheet, any changes made later to the sheet will not be reflected in the submission. If changes are to be made, they can be done in the Submissions tab. Click on a submission, and on the right panel, click the refresh button of the ‘Get data from Google Sheet’ field.