Sheet Director is 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.
Yes, you can use from Gmail account or Google workspace accounts.
Please see Apps Page for supported applications. We are using 2 applications.
Quota refers to the successful execution of a service configured in Sheet Director for a particular pricing plan.
Quota is measured as one successful execution of a service configured in Sheet Director. It encompasses all activities done within a service including notifications. Refer below for records (rows) processed.
Learn more @ pricing
You can check your current usage and remaining quota under Account section in Sheet Director
Open Sheet Director
Click on Menu ☰ (top left corner)
Click on Account menu
You will see your account details like plan, validity
You will also see the usage/quota/balance
☰ Menu > Account ==> You will see the account screen
If you have taken the plan via PayPal, it gets renewed automatically until cancellation.
If you have taken the plan through manual request, it does not get renewed automatically. You need to renew it manually again or can pay via PayPal to get renewed automatically.
Automated emails are the notifications sent from the Sheet Director when the autorun is configured, to stop these notifications, please disable the auto-run from Sheet Director >> Menu >> Automate >> Switch off "Enable Auto run" .
At times, you would want to transfer/migrate Sheet Director usage from one account to another account. (due to employee changes or reorganization in email etc)
Follow the steps below to run Sheet Director from another account.
Ensure that the Google Sheets are transferred to the new email account. There are two ways you can transfer the sheets.
Share and transfer ownership
Steps to be followed
Before sharing the sheet you need to turn off the scheduler Automate setup.
Ensure that the Google Sheet is shared with edit access to the new email account.
Clone/ Duplicate the Spreadsheet
steps to be followed
If the current email account is going to be suspended or deleted, ensure that you share all these files (Google Sheets) to the new email account from Google Drive.
Once you shared, make a copy of the shared spreadsheet from the new account. For the steps visit here
Now you can proceed with using Sheet Director from the copied spreadsheet, you must see all the old services from the old spreadsheet in your newly copied spreadsheet now.
Once you have done with transferring sheet using any of the above methods, you can contact us by raising a ticket request and tell us from which account to which account you want us to transfer the license.
Wait to get the confirmation mail from us (Usually happens within two business days or sooner)
Soon after you get the confirmation email you can open Sheet Director from the new email account.
You can turn on the Automate setup in case you want the scheduler to be run in the background, (otherwise, you can ignore this step).
Then Sheet Director will start running from the new email account.
Note: The new email account shall have active plan
Please check the following
Keep monitoring the execution log. Refer Execution Logs
Check whether master setup is Activated. Refer Scheduler for instructions. Try switching off and on.
The minimum time interval for Scheduling is 1 hour. Less than 1 hour cannot be Scheduled in Sheet Director.
Yes, we can schedule different services at the same time.
No, All the service details are stored in the customer's Google Sheet only. And we don't have any access to the Google Sheet of customer. Sheet Director server stores only id and analytics info such as email ID, quota details, usage, etc and does not store any other configuration or transactional data.
We are using industry-standard authorization types such as OAuth1, OAtuh2, etc. And it is a scope-based authorization so the Sheet Director has only access to the scope which we are asking for while authorization.
No. we cannot access the data until or unless the customer explicitly shares the Google Sheet with us.
Feature Requesting a Field or several fields which is not available in App's List API But available in Get by ID API.
Rate Limit Issue: The API's rate limit will likely be reached quickly.
Retrieving data from an API will be time-consuming: for instance, if there are 100 records, it would require one API call per record, which would extend the total execution time.
Requested Field or Fields is/are not feasible to implement in the requested App's Entity.