The following script allows us to convert a Google Sheet file to Obsidian markdown including dataview
/dataviewjs
syntax to query files and plot charts and tables.
It needs the configuration of gspread module and to set the path of the .json
key in /src/helpers/check.py
in giveServicePath()
function.
python3 /path/to/folder/main.py
Or filtering data with the starting date:
python3 /path/to/folder/main.py dd/mm/yyyy
For a complete description see Google Sheets and Obsidian integration.
It create an Obsidian markdown note for each training exercise and then another notes for the overall training day. The training day contains also charts and summary table.
For the different notes the templates are defined into the template.py
module.