IssueWhen you try to open a workbook connected to Google Sheets, the following error occurs: The Google Sheets service returned incorrect malformed response. Please report this problem to Tableau.
ResolutionCheck with your IT to ensure that the Google API is active and that access to Google Sheets is not being blocked by a firewall. Check G Suite Status Dashboard to see whether there is a Google Sheets service disruption or outage. If the above steps fail, report the issue to Google Support.
CauseThis error is a Google Sheets error not caused by Tableau, and is caused by either a service disruption or inability to access the Google API.
Did this article resolve the issue? Thank you for providing your feedback on the effectiveness of the article. Click here to return to our Support page. Open new Case Open a new case Continue Searching Click here to go to our Support page. Knowledge Base Get detailed answers and how-to step-by-step instructions for your issues and technical questions. Community Find and share solutions with our active community through forums, user groups and ideas. Product Help Browse a complete list of product manuals and guides. Available online, offline and PDF formats. Training and Tutorials Learn how to master Tableau’s products with our on-demand, live or class room training.