After installing the add-on you will find it under add-ons in the navbar
Once opened you can enter a name for the new comments sheet you’d like to create, leaving it blank will let Google Sheets name it for you
The new sheet will have 5 columns, number, commentary, data source and commentator. If you add a comment under the header row it will automatically update columns Number and Date with relevant number and the date the current date. These can be changed manually, if you needed to back date comments for example.
Now you can go to Google data Studio and create a new data source.
Once in the new data source screen choose Google sheets, all items, the spreadsheet and the relevant work sheet
You will then see the columns that were in the work sheet and you can add it to the report
Then select the table option, Google Data Studio will use the new data source, and you will see your comments! You can add the other elements, data source commentator by adding them as dimensions
By using the number column to order the comments you can remove the row numbers from the table. You can find this under STYLE. Once unchecked you will get only the comments and the number.
Once you include the date range, you or anyone else can filter by date and find the commentary relevant to that period