What are the best and secure add-ons available for reporting in?
There are a few reporting and data synchronization solutions for google sheets, each with their own strengths and weaknesses. Ill tell you why I think Kloudio is the best solution for your use case - were the only reporting tool that generates reports from right within Excel and Google Sheets (and these reports can be scheduled to run automatically every week, day, or even minute for a live spreadsheet!). Kloudio is simple enough for non-technical users while also powerful enough for SQL wizards. This means that business users and other data-oriented workers can query and analyze any databases such as Mysql, Postgres, Redshift, BigQuery/cloud applications such as salesforce, facebook, google etc without ever leaving their preferred work environment - a spreadsheet. Our customers have reported huge increases in productivity since their business users can do powerful data work where they are most effective - Microsoft Excel. Were also the only software that supports bi-directional exchange of data - you can persist changes and push edits from spreadsheets back to Salesforce (with powerful data validation tools to eliminate manual data-entry errors). As a data-warehousing solution, Kloudio easily syncs any cloud application data to any data-warehouse of your choice. Obviously the process is fully automated once set up. Please let me know if you have any further questions about our software! Disclaimer: Iam the Founder/CTO of Kloudio