Google Sheets
Connect your app to information which you are managing in a Google sheet
Last updated
Was this helpful?
Connect your app to information which you are managing in a Google sheet
Last updated
Was this helpful?
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:
Open your app and open the Data tab in the left side navigation.
After you have connected your Google Sheet to your app, you can add blocks to your app to make the data visible
Open the Content tab of your app
Click the red + block button
Select the Advanced tab
Click Add this block
Select the right data source.
In your app a green List block will be added with a detail page below it.
You can finetune the Detail page in the same way.
Click + New table in the left top corner
Click Google Sheets
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.
Your account is now linked and you can Select Spreadsheet from your Google Drive
Select the right sheet.
Click Next
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.
We asked you to confirm that your sheets looks like this:
The data is now available in a table and ready to be shown in your app
Select the List to show a list of items in a screen. The detail page will be added automatically
On the List block you can Enable or disable information to show in the list using the switches.
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 .
