In order for Frontly to read the data from your Google Sheet we require headings for each column you'd like to display in Frontly.
It's helpful to set these up before you attempt to bring any data into your Frontly app, as any changes such as adding a new column or changing a heading name will lead to a mapping error in Frontly, and you'll have to reload the Sheet data. This will prompt our system to re-fetch the headings in your Google Sheet, and you can map the headings again within Frontly to match your source data properly.
If you don't add any headings at all, or don't add a heading to a column within your Google Sheet, Frontly won't be able to see that column, or display that data in your app.
Showing a Google Sheet with a Blank Heading
Untitled Column Does NOT Show in Frontly
Frontly can only read spreadsheets in a Google Sheets format. Attempting to upload a file in any other format will result in error codes, and your data will not be read by Frontly.
To upload a spreadsheet to Google Sheets format, select File>New>Spreadsheet within the Google Sheets navigation bar, or select Open to choose an existing file from your Google Drive. You can also Upload a spreadsheet here.
Setting Up Your Spreadsheet
Best practice for laying out your Google Sheet in Frontly is to structure your Sheet with headings at the top of each row, with data in rows beneath. Setting up a page with multiple tables, or with large gaps between rows or columns will work as well, but may prove more difficult to work with, and may lead to less visually appealing results.
Example of a Difficult Spreadsheet Layout
Better Spreadsheet Layout
This will work fine with Frontly. Each row has one heading, and other data in the rows beneath.
Best Spreadsheet Layout
This is the easiest spreadsheet layout. Each row has one heading, and each page only has data of one type. This will be very easy to work with in Frontly!
If you require multiple tables, place them side by side, with each column containing data for only one table. Tables can also be placed on separate sheets for better organizational clarity.
Frontly reads data from your cells, and writes whatever data back you've set up in Frontly. This means that cells should be set up in Sheets as standard field such as text, number, date, or currency. More complex cell formatting such as dropdown menus or locked cells may not function correctly with Frontly, as the returned values will be in text, number, date, or currency format from Frontly.
If your spreadsheet has complex cell formats, please contact our support team so they can help you properly connect your data with Frontly.
You can set up formulas within Sheets to perform a variety of equations, cell references, look up data, and much more. All of these functions can be set up in Sheets, and the outputs can be read by Frontly.
Remember if your Frontly app performs an Update Cell Action that any cells you've asked Frontly to update will be overwritten with the new value. This may erase existing data, including formulas.
Because Frontly references specific rows of data by examining the Frontly ID column, and reading the associated row, it will be easiest to structure your data with any related information in the same row or column.
Frontly requires this ID column to identify which cells to update, and checks the row headings to ensure any data is sent to the correct cell.
Google Sheet showing the output row we want to see in Frontly
Making a Google Sheets Request Action with a Row ID of the row we want to visualize in Frontly
Only the data contained in this row is available as a data source. We can display these sums in Frontly.
If you'd like to visualize an entire sheet instead of a specific row or column, you can do that too. Just set up a Page Load action to your Google Sheet without inputting a specific Row ID.