Google Sheets

Connect your app to information which you are managing in a Google sheet

Your data will be synced from Google sheet to AppMachine and vice versa. For this Google sheet integration it is important that you have full editing rights for this sheet. If you didn't create the sheet yourself, make sure your email address is added to the google sheet via the Share button in Google Sheets.

It won't work if someone gave you general access like this:

How to connect a sheet to your app

1. Open your app and open the Data tab in the left side navigation.

2. Click + New table in the left top corner
3. Click Google Sheets
4. Sign in with Google to connect with your Google account. This happens via a new tab in your browser. Choose Allow when asked for permissions.
5. Your account is now linked and you can Select Spreadsheet from your Google Drive
6. Select the right sheet.
7. Click Next
8. Select the worksheets you want to show in your app. You can deselect all of the sheet by clicking in the small square before Select all.
9. We asked you to confirm that your sheets looks like this:
10. The data is now available in a table and ready to be shown in your app

Show Google Sheet data in your app

After you have connected your Google Sheet to your app, you can add blocks to your app to make the data visible

1. Open the Content tab of your app

2. Click the red + block button

3. Select the Advanced tab

4. Select the List to show a list of items in a screen. The detail page will be added automatically
5. Click Add this block

6. Select the right data source.

7. In your app a green List block will be added with a detail page below it.

8. On the List block you can Enable or disable information to show in the list using the switches.
9. For advanced editing, select the Elements tab in the left top corner. This article explains to you how to use the element editor to fine tune the design .
10. You can finetune the Detail page in the same way.