With Frontly's Google Sheets integration, you can now reference spreadsheets to use as a data source that can be visualized and manipulated with Frontly.
Connecting Your Google Sheets
Integrating with Google Sheets can be done with just a few clicks. To do so, click on Integrations>Google Sheets in the sidebar, and click the connect button. You'll be asked to sign in with Google.
Adding Your Sheets to Frontly
Once you've signed into your Google account with Frontly once, you never have to do it again. In order to use the spreadsheets in your Google account, you'll need to add them to Frontly.
To do this, exit the page builder to the root menu, and scroll down in the sidebar to the Google Sheets tab. Click "Add Spreadsheet", paste in the URL, and give your Spreadsheet a nickname so it's easy to identify.
Once you've added a spreadsheet here, it can be accessed from within any of your Frontly app pages.
Creating a New Sheet From Within Frontly
If you'd like to create a new Sheet, you can create that from within Frontly. Click "Create New Sheet" and label it appropriately. Then, enter your desired heading names, separated by commas. Frontly will create a new Sheet, and add the headings you've provided. You'll be able to use this as a data source within your Frontly apps.
Using Sheets as a Data Source
To access your Google Sheet as data for a module within Frontly, set up your page as normal, and then add a new page load action. Select Google Sheet Request as your action, and then select a spreadsheet from the dropdown menu. You'll be able to access any spreadsheets here that you've added to Frontly in the previous step.
Once you've chosen the Sheet you want to use, enter the tab name you'd like to pull data from, and click Fetch Remote Data. Note that tab names are case sensitive, so copy/paste the tab name directly from your Google Sheet for best results. Give this action a name, and exit the tab back to your page builder.
You can now reference this data using any of Frontly's modules by selecting it as a data source, and mapping your data to a module of your choice. You can learn more about using data sources in Frontly here.