What is Sheet Director?
Sheet Director is a Google Workspace add-on that helps to manage and control bi-directional data flow between Google Sheets and several other applications like Google Calendar, Tasks, Contacts, Sheets, QuickBooks, FreshBooks, Zoho etc.
Key Service types
Query - pulls data from the applications and presents into Google Sheets
Post - pushes data from Google Sheets into applications
► Connect with Applications, through various authentication mechanism (key, oAuth1, oAuth2 etc).
► Manage Services - Store configuration as services that can be listed, edited, executed and deleted.
► Bi directional data flow - Query (pull) and Post (push) service types
► Manual and automatic (scheduled) execution of services
► Success & Failure Notification of service execution with templated emails and Google Sheets content
► Execution Logs to monitor automated executions