Google Sheets Errors

Solution

This error occurs when the first row in your google sheet is not present. Integrately uses the first row in the google sheet as the column names.

You need to turn off your automation and add the first row. And change the fields for your automation and turn it back on.

Follow the below steps:-

  1. Deactivate your automation.

  2. Provide the first row for your google sheet.

  3. Activate your automation.

Solution

This error occurs when you have exceeded the limit of google Sheets API rate limit as google sheet API is a shared service they have a quota of 300 requests per minute per project.

Solution

This error occurs when the user has not selected all the scopes of permissions while adding his connection. For Integrately to interact with Google sheet it needs all the permission it has specified. To avoid this, reconnect your account and give all the permissions this time.

To re-connect follow the below steps:-

  1. In Integrately Go to My Automation -> Connected Accounts.

  2. Select your google sheet account and click on reconnect and then click continue.

  3. Choose the account you want to connect with.

  4. Provide all the permissions required and click continue.

Solution

This error occurs when the Google Spreadsheet ID is incorrect.

This happens due to one of the two reasons:
  1. The user has accidentally deleted the selected Google Sheet; or
  2. The user has mapped the wrong Spreadsheet.

To resolve this error, the user needs to re-map the Spreadsheet.

In order to do so,
 1. Deactivate your automation.

 2. Reselect your spreadsheet in the automation from the drop down.

 3. Activate your automation.

Solution

This error occurs if the user has changed the name of the google sheet while the automation was on.

To avoid this simply turn off the automation and reselect the worksheet and then turn on the automation back on.

Follow the below steps:-

  1. Deactivate your automation.

  2. Reselect your worksheet in the automation from the drop done.

  3. Activate your automation.

Solution

This error occurs when there is an authentication issue. To avoid this simply re-connect your google account.

To re-connect follow the below steps:-

  1. In Integrately Go to My Automation -> Connected Accounts.

  2. Select your google sheet account and click on reconnect and then click continue.

  3. Choose the account you want to connect with.

  4. Provide all the permissions required and click continue.

Solution

This error occurs when the google sheet grid has exceeded its limits which is 1000 rows and 34 columns.

Solution

To overcome this error please map values from the dropdown list only.

Solution

This error occurrs in either of the 2 situations -
 1. Server is down or
 2. Temporary network issue.

To resolve this error, try submitting your request again after some time.

Solution

This error occurrs in either of the 2 situations -
 1. Server is down or
 2. Temporary network issue.

To resolve this error, try submitting your request again after some time.

Solution

This error occurred because your connection has expired.

To resolve this error, you can either -
 1.  Add a new account, or
 2.  Reconnect your old account.

In both the cases, you must follow these simple steps -

 1.  Click on Reconnect.
 2.  Provide your credentials again.
 3.  Click on 'continue' to allow Integrately permission to access your account.
 4.  The connection is now re-established with Integrately

Solution

To resolve this error, you must provide a valid value for the the said field, as it’s marked as required.

Solution

This error occurred because the provided connections are either missing, incorrect or have expired.


To resolve this error, you can either -

 1.  Add a new account,     OR

 2.  Reconnect your old account.

In both the cases, you must follow these simple steps -

 1.  Click on Reconnect.
 2.  Provide your credentials again.
 3.  Click on continue to allow Integrately permission to access your account.
 4.  The connection is now re-established with Integrately

Solution

This error occurs in either of the 2 situations -


 1.  Manually entering the value,

    OR

 2.  Mapping an incorrect value.


To resolve this error, you must map a value from the drop-down list only.

Solution

This error occurs in either of the 2 situations -


 1.  Manually entering the value,

    OR

 2.  Mapping an incorrect value.


To resolve this error, you must map a value from the drop-down list only.

Solution

This error occurs in either of the 2 situations -

 1. Server is down,      OR
 2. Temporary network issue.

To resolve this error, try submitting your request again after some time.

Solution

This error occurred because you're trying to make changes to a Google Sheet which is locked.

To resolve this error, you need permission from the owner for editing. Once granted permission, you can make the required changes.

Solution

The maximum permissible limit for a cell in Google Sheets is 50,000 characters.

To resolve this error, you can either reduce the text length to be within the permissible limit or split the text into smaller parts and put them in separate cells.

Solution

This error occurred because something went wrong while working in Google Sheets.


Some reasons and their solutions -

 1.  slow or unstable internet connection -

     The solution is to try submitting your request again after some time.

 2.  If your sheet is very big or complex - The solution is to try simplifying it.

 3.  Try a different web browser or clear your browser's cache.

 4.  Disable any browser extensions that might be causing issues.

 5.  Make sure no one else is editing the sheet at the same time.

 6.  Refresh the page and try again; sometimes, it's a temporary glitch.


 If it still doesn't work, contact Google support for help.

Solution

To resolve this error,follow these simple steps -

   1. Split large data into multiple sheets.

   2. Optimize data by removing unnecessary rows/columns.

Solution

This error occurred because you've made too many read requests to the Google Sheets within a short period.

To resolve this error, send your requests in groups of 50, wait a bit, and then send more in groups of 50.

Solution

This error occurred because you've made too many read requests to the Google Sheets within a short period.

To resolve this error, send your requests in groups of 50, wait a bit, and then send more in groups of 50.

Solution

This error occurred because you trying to access or modify a spreadsheet,but you don't have the required permissions to perform these actions.

To resolve this error, you can either -

 1.  Add a new account,     OR

 2.  Reconnect your old account.


In both the cases, you must follow these simple steps -

 1.  Click on Reconnect.

 2.  Provide your valid credentials again.

 3.  Allow the following permissions:



 4.  Click on continue to allow Integrately permission to access your account.

 5.  The connection is now re-established with Integrately

 6.  Now you can continue your further process.