This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am trying to output some data to Google sheets using the Google Sheets Output tool. I have configured the tool with my User login credentials to Overwrite Sheet (Drop). However, when I try to run the workflow, I receive the following error:
HTTP/1.1 400 Bad Request Content-Type: text/html; charset=UTF-8 X-Robots-Tag: noindex, nofollow, nosnippet Content-Encoding: gzip P3P: CP="This is not a P3P policy! See g.co/p3phelp for more info." P3P: CP="This is not a P3P policy! See g.co/p3phelp for more info." x-chromium-appcache-fallback-override: disallow-fallback Date: Wed, 30 Jan 2019 21:32:10 GMT Expires: Wed, 30 Jan 2019 21:32:10 GMT Cache-Control: private, max-age=0 X-Content-Type-Options: nosniff X-Frame-Options: SAMEORIGIN X-XSS-Protection: 1; mode=block Server: GSE Set-Cookie: NID=156=[redacted];Domain=.google.com;Path=/;Expires=Thu, 01-Aug-2019 21:32:10 GMT;HttpOnly Set-Cookie: NID=156=[redacted];Domain=.google.com;Path=/;Expires=Thu, 01-Aug-2019 21:32:10 GMT;HttpOnly Alt-Svc: quic=":443"; ma=2592000; v="44,43,39" Transfer-Encoding: chunked
I noticed that I receive the error at the time the cookie expires - Set-Cookie: Expires=Thu, 01-Aug-2019 21:32:10 GMT
Is there any way to extend the length of this cookie? My data is about 70,000 rows and currently takes about 9 minutes to upload fully (upload worked previously but is resulting in this error right now).
Does anyone have any insight into how to solve this issue?
To update, the link wasn't able to solve my problem. I ended up having to change my method to copy and paste the output table manually into a Google sheets since I was not able to resolve my Google sheets error