We are transferring from using Google sheets to using Synology Office. We are looking to convert our current reports that have been automated with Google Script. I have attached a copy of the format of the existing reports we are using for clarity (Reports 1-6 to be pulled from Trello>Synology, Report 7 is pulled from Synology spreadsheet)
Report 1 Synology spread sheet > pdf
Create an automated weekly report to be emailed to an admin by email. The report will pull data from a spread sheet populated in Synology Office. The data is quite simple and I have attached a copy of how the report will look.
Report 2 - Pull data from Trello > Synology spreadsheet and create pdf report.
This is a more complex report that pulls data from a Trello board, and will record it on a Synology spreadsheet and then a weekly report is emailed to admin.