Create the Google Spreadsheet data source
Open Google Sheets then select Blank.
Alternatively, you can go to your Google Drive, click on New.
Then, click on Google Sheets and Blank spreadsheet.
Apply a name for your spreadsheet.
Configure the data source properly
We need to follow a prescribed procedure on how to configure the data source properly for Awesome Table to work:
- The first row is reserved for your columns headers. We recommend using short but descriptive titles because this will serve as filter-titles and chart headers in your view.
- The second row must always concern filters and keywords. If a cell requires 2 or more elements, separate them with a dash "-".
Share the data source
The display or accessibility of your Awesome Table view depends on the sharing settings you chose in the Google Sheets data source.
To share your Awesome table view, click on "SHARE" in your spreadsheet.
Then, you can share your data for specific people (1) and choose the sharing modes (2) or access the advanced sharing settings (3).
If you select the advanced sharing settings, you can share your Google Spreadsheet data source in different ways.
It is still possible to share your Google Spreadsheet data source for specific people (1) and the sharing mode (2).
Otherwise, you can choose to share your data for a specific domain or everyone in the world (3).
After clicking "Change", you will be able to share your Google Sheets data source to Anyone on the internet or restrict it only to your corporate GSuite users.
If your view is on a publicly accessible website, we recommend using the sharing setting "Anyone with the link" (1) because if you choose "Public on the web" (2), there is a chance that your Google Spreadsheet data source is indexed by Google Search.
If you only intend to share the view or data source only to your internal GSuite users, we recommend using "Anyone at YourDomain with the link" (3) rather than "YourDomain" (4). If "YourDomain" is selected, your Google Spreadsheet data source will be indexed by Google Search via Google Drive.
Finally, select sharing mode (5) and click Save.