Jump to content

Google Sheets Integration


Recommended Posts

Is there a way once a spreadsheet has been updated that you can add further data to the end of a row?

e.g. if we add data to a sheet from column A to E on one row as part of the BPM and then later want to add more data to column F & G later in the same row as part of the BPM...Is this possible?

Link to comment
Share on other sites

Hi @Jeremy,

As long as you know the row number, and the column you want to start stiring from, then this is possible with the Google > Sheets > Update operation. See ther Row and Starting Column input parameters here: 

image.png 

Cheers,

Steve

Link to comment
Share on other sites

@Steve G this is the issue, we do not know the row number. The only information that is the same is the job reference number that we include in the sheet, is there a way to return in the first integration call the row that was created?

Then we can reference this as a variable in the update Row parameter?

Link to comment
Share on other sites

@Jeremy Yeah that makes sense, I've added a new output parameter to both the Sheets operations that will contain the row number that has been updated/appended. I've just released them to live, so your instance should have the updates in the next 5 minutes.

Let me know how you get on with this.

Cheers,

Steve

  • Like 1
  • 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
 Share

×
×
  • Create New...