Issues with Google Sheet Tools

Hello all!

I am sometimes receiving the below error when trying to append data to a Google Sheet via the Google Sheets output tool. When I don't receive this error, the Google Sheet Output semi-works. I say semi-works because the information does append, but it does not get appended to the proper column names. I could not find a pattern as to when this occurs.

Any feedback would be greatly appreciated - thank you!

To provide more info:

Alteryx has been updated to the newest version, 2021.3
I downloaded/installed the newest version of the Google Sheets Input Tool and Google Sheets Output Tool. I was previously using Version 1.1 of these tools.
Upon using the Google Sheets output tool, I used the "Optional OAuth2 Overrides" option.
I did receive an authorization granted page when I clicked on Connect.

Error Message.PNG

Publish

Input

Error Message

Output

Connectors

Download

Accepted answers

All comments

TrevorS

Hello @deepashah

Are you still experiencing issues with the Google tools?

If so, can you please provide the full text of the error message (in text format.)

This will help the Community to better troubleshoot what could be causing the issue!

Thanks,

TrevorS

deepashah

Hi Trevor, I hope you are doing well! Thank you for following up.

Yes, I am still experiencing these issues with the Google Sheets Output tool. Upon using other workflows, I noticed the Google Sheet Input tool is working properly, so these issues are only occurring with the Google Sheets Output tool.

Here is the full text of the error message, in a text format:

Error: Google Sheets Output (16): Tool #402: Error trying to publish spreadsheet: HTTP/1.1 400 Bad Request
Vary: Origin
Vary: X-Origin
Vary: Referer
Content-Type: application/json; charset=UTF-8
Content-Encoding: gzip
Date: Mon, 16 Aug 2021 21:00:38 GMT
Server: ESF
Cache-Control: private
X-XSS-Protection: 0
X-Frame-Options: SAMEORIGIN
X-Content-Type-Options: nosniff
Alt-Svc: h3=":443"; ma=2592000,h3-29=":443"; ma=2592000,h3-T051=":443"; ma=2592000,h3-Q050=":443"; ma=2592000,h3-Q046=":443"; ma=2592000,h3-Q043=":443"; ma=2592000,quic=":443"; ma=2592000; v="46,43"
Transfer-Encoding: chunked

Carole_Trudel

I get this error message and I don't understand why. Please help me!

Alteryx error.PNG

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703