You can store up to 2 million cells for spreadsheets that are created in or converted to Google Sheets.
If there are errors in your Google Sheet, such as #DIV/0! or #N/A, Tableau is unable to create an extract and an error message will appear. To resolve this issue, wrap the function with iferror() and have it return a blank, or any value that's appropriate.
For example, the sheet below includes a #DIV/0! error.
The solution is to wrap the calculation in an iferror() calculation.
