1 - Create a new Google Sheet
To create a new Google Sheet you need to go to your Google Drive, click on New and then Google Sheets.
2 - Spreadsheet Structure
To have an Awesome Table compatible spreadsheet it is important to have the first two rows set as the following :
- The first row will have headers
- The second row will have filters and parameters
3 - Insert data in your spreadsheet
We will now need to fill our spreadsheet with data. For our example, we will insert dummy classes with informations like date, name of the class, teacher... (get dummy data).
4 - Share your spreadsheet publicly
The only people that have access to your Awesome Table are people that can view your spreadsheet in the first place. In this example, we would like to make sure that our spreadsheet is shared with "Anyone with the link" so every user is able to see the table.
In the next article of this tutorial we will discover Awesome Table web app and create our very first Awesome Table view.