Jump to content

Google Sheets Integration

Recommended Posts

We have found that if we set up a node to pass information to the sheet it marks the response as a success regardless if it actually wrote something the sheet or not.

So we cannot use the metric 'Call Success' so we have to make a decision based on whether a row was updated or not. Just wondering if this expected behaviour?

Link to comment
Share on other sites

@Steve G doesn't appear to be, we get a success returned for the integration working regardless of whether it put any data in the sheet. Seems to be a success of the node (I did a thing) rather than a return from sheet saying I was updated. If that makes sense....

Link to comment
Share on other sites

Hi @Jeremy,

I've made some changes to the Update and Append operations, so that they will now populate success with a boolean false in the event that the operation fails for something other than an authentication issue. Authentication/token issues are still handled by a hard-fail of the operation. I've also included a new output parameter called errors, which will be populated with the error returned from Google if success equals false.

Let me know how you get on with these.




  • Thanks 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...