Troubleshooting: Google Sheets destination

Most common issues with Google Sheets destination 

1. Error "The service is currently unavailable."
2. Error "This action would increase the number of cells in the workbook above the limit of 10000000 cells."

1. 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 importer 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 importer;
4. If you run multiple importers to the same destination spreadsheet - try and space out the times between your importers' runs. Google Sheets API for your spreadsheet may become less loaded than when multiple importers write data to it at the same time. 

2. 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 not able to add more data to your spreadsheet because of that.

Note: that this limit is not related to the rows count or the data amount your importer pulls. Instead, it's about the existing number of cells in your destination spreadsheet.

Check more about Google Sheets limitations here: https://gsuitetips.com/tips/sheets/google-spreadsheet-limitations/

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 to. 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 to