KNOWLEDGE BASE

Error "The Google Sheets service returned incorrect malformed response. Please report this problem to Tableau" Opening Workbook


Published: 18 Jan 2017
Last Modified Date: 18 May 2017

Issue

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

Environment

Tableau Desktop

Resolution

  • Check 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

Cause

This 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?