Google Drive Output - "Please make sure to close the file"

[NikBarter]

I am unable to write results via the Google Drive Output tool. I can read in.

It's communicating to Google Drive, but comes up with an error:

"please make sure to close the file. Hence skipping file ....."

File Format is set to "GSHEET", file closed, just don't know what the error means!

Any suggestions?

I'm using Google Drive Tools v1.3.3 with Designer 2024.1 (have already rolled back from 2024.2 the version to see if that was issue)

 

[CailinS]

@NikBarter I don't know the specific cause of this but one question that came to mind was if this tool / process had worked previously for you? You mention rolling back, and I was curious if you had ever had success with this on another version?

Either way, I think this might make sense to report through the Mission Control Case process (my.alteryx.com) since this is a supported tool https://help.alteryx.com/current/en/designer/tools/connectors/google-drive-output-tool.html#google-d... .

I searched the Knowledge Base that is available once you log into Mission Control and found this article: https://knowledge.alteryx.com/index/s/article/Google-Drive-Output-tool-error--Please-make-sure-to-cl... 

This error message is a temporary catchall for most API error returned by the API, therefore the message itself should be ignored.  To determine the actual error you will need to

• install Fidder
• enable Tools > Option > Decrypt HTTPS traffic
• cause the error
• Review the error's Response > JSON

Cause 1 -- Sheet name is invalid 

Cause 2 -- Google Sheets API is not enabled

Resolution 1 -- Ensure sheet name matches the document

Resolution 2 -- Enable the Google Sheets API

You can find a link to the page to enable your Sheets API by running a Fiddler trace and viewing the Response JSON for the 403 error.  This will include a link to the page to enable your Google Sheets API. 

https://help.alteryx.com/current/en/designer/data-sources/set-up-custom-api-application/set-up-googl...