Troubleshooting: Google Sheets destination

Most common issues with Google Sheets destination 

Error "The service is currently unavailable."

Error "This action would increase the number of cells in the workbook above the limit of 10000000 cells."

"Internal error encountered" - Google API 500 error

Error "Timeout: we could not import your data within 9 minutes"

Google 400 error. The server cannot process the request because it is malformed. Sign in is required.

Error "The service is currently unavailable."

This error is returned by Google Sheets API when Coupler.io tries to save your data to the destination file.

This error may appear due to the following reasons: 

• Google Sheets API may be unavailable for short periods due to planned maintenance (deployments);
• The destination file is not accessible for the API or broken;
• Other issues with the GSheets API.

Troubleshooting steps: 

1. Try re-running the failed data flow a bit later. In case the reason was a temporary unavailability of GSheets API, this error will be gone. If the error persists >>
2. Check if your destination spreadsheet shows proper content without visual warnings or errors.
3. For a test, try using a different destination spreadsheet for the failed data flow.
4. If you run multiple data flows to the same destination spreadsheet, try and space out the times between your data flows' runs. Google Sheets API for your spreadsheet may become less loaded when fewer data flows write data to it at the same time. 

Error "This action would increase the number of cells in the workbook above the limit of 10000000 cells."

This error means that when you try to pull data to your spreadsheet, it reaches the 10M cells limit  on the Google Sheets side, and Coupler.io is unable to add more data to your spreadsheet because of that.

Here are a few recommendations that may help:

1. Reduce the amount of data you're pulling: in this case, there might be enough space in your spreadsheet for the new data:

• Review the contents in your data source and clean it up, if possible
• Filter data that will be imported using date ranges/ other filters in Coupelr.io

2. Review the spreadsheet you're importing data into. Maybe it contains some unneeded sheets or sheets with empty cells (empty cells in a spreadsheet also count towards this limit). If that's the case - clean them up as it'll free up some space in your spreadsheet and make space for new data to come in.

3. Create a new spreadsheet to import data into.

Google API 500 error "Internal error encountered"

This error can happen on the source or on the destination side. #Google-API-500-error-Internal-error-encountered--QDTBA

By its nature, this error is not permanent and can occur when Google Sheets API is on maintenance / not available. Other reasons it may occur:

• a spreadsheet is too heavy/ overloaded
• a spreadsheet is using many formulas, and it hangs
• a spreadsheet contains formulas or views with errors

The error happens on the source side (when you try pulling data from a spreadsheet)

• To validate it happens on the source side, try to import a different spreadsheet with Coupler.io (can be a new empty spreadsheet) to see if the error persists.
• Check the source spreadsheet used for the import and see if there are any visible issues with it - e.g., it has a slow loading time, hangs, shows error formulas. Try to clean it up by deleting unneeded sheets/data, removing or fixing broken formulas.
• Try to copy your source spreadsheet and set up a data flow from scratch with this source file.
• Try to copy the source file, remove all NOT needed sheets from it, and leave 1 sheet that is needed for import. Set up data import from the needed sheet.

The error happens on the destination side (when you try pulling data into a spreadsheet)

• Check the destination spreadsheet used for the import and see if there are any visible issues with it - e.g., it has a slow loading time, hangs, shows error formulas. Try to clean it up by deleting unneeded sheet/data, removing or fixing broken formulas.
• Try to set up a fresh destination spreadsheet (not just a data flow in Coupler.io) >> import data to it, and check if the error persists.

Timeout: we could not import your data within 9 minutes

Please follow our dedicated troubleshooting article: Timeout for Google Sheets destination

Google 400 error. The server cannot process the request because it is malformed. Sign in is required.

Please find the troubleshooting steps here:

Troubleshooting: Google 400 error. The server cannot process the request because it is malformed. Sign in is required.

To see the most common issues with Google Sheets source, please visit the article Troubleshooting: Google Sheets source.