Unfortunately both Salesforce and Google impose some limitations on us, and as result, not every scenario will work correctly for you. Here’s what you need to keep in mind:
- The total run time of one google script execution cannot exceed 6 minutes for free Gmail users and 30 minutes for G Suite users.
If it takes more than that to pull/push all the data in your document – THE AUTOMATED DATA OPERATIONS WILL NOT SUCCEED. NO ERROR NOTIFICATIONS WILL BE SENT either, since this limit happens in the Google Script engine and there is no way for us to catch it. Enabling logging of automatic operations to a separate sheet will help you see at which point your operations stop. Try splitting your automatic data operations into different documents if you run into this limit. Another way to address this is to have multiple schedules running at different times (e.g. odd and even hours), each working with only a part of your sheets.
If you have a really long running report that is heavy on relational fields and has to plough through a lot of data – you may get a “Timeout” error or no error at all if the total runtime of the report is over 30 minutes.
- The most frequently we can run the auto-refresh function for you is once an hour. This should be enough resolution for most of the use cases. A workaround to this is available by using Web Hooks. A web hook will allow to run any G-Connector operation on demand.
- For free GMail users, the total run time of all automatic triggers is 90 minutes/day. If you have multiple schedules running hourly, their total run time can quickly add up to exceed that. In that case you will notice that the schedules will skip some of the hours, most commonly in the morning. We recommend that you use your Google Workspace account if you are constantly running into this limit. Google Workspace accounts have a total trigger run time of 6 hours per user per day.
- You cannot keep more than 5 Salesforce accounts logged in via G-Connector under the same Google account. As soon as you log in to the 6th Salesforce account – the first account will lose access and need to re-login, but then the second account will lose access and so on. The limitation has to do with only 5 refresh tokens that can be used concurrently by each Salesforce user.
- You are only allowed to have up to 10,000,000 cells in a single Google Spreadsheet document. Seems like a lot, but when you start putting multiple reports in it – you can hit that limit. You will see this error if your data pull from salesforce will increase the total number of used cells to more than 5 million.
- If you are NOT using Instant Sync mode in any of your documents, the maximum number of automatic schedules we allow you to create is 20 according to Google AppsScript Limits since Google doesn’t support more than 20 automatic triggers per user.
- If you are using Instant Sync, you will be able to use much less automated schedules. The number of available automated schedules in the case can be calculated as follows: 20 – (minus) number of documents with an Instant Sync push template. This is due to Google limits on the number of triggers that can be created per Google user (see link below for all Google limits).
The good news is that all these limitations tend to become less restrictive with time, as technology advances and cloud providers figure out ways of doing things faster.