TestProject Forum

I want to put data in the 2nd sheet of Google Sheet

I used the Update Value in Column and Row (Google Sheets) addon to put the results in a Google Spreadsheet.
I checked that the data was entered correctly on the first sheet. But I want to put data in the second sheet.
I want to know how.

Hi @jy_test ,

The easiest way to do this scenario is to add a new step with the same value you entered in the screenshot above but change the SheetID to the new SheetID of the second spreadsheet. It should work well.
Let me know if you managed :slight_smile:

The Google Sheet ID of the first sheet and the second sheet are the same.

(Below is an example.)
https://docs.google.com/spreadsheets/d/1GRjMsn1f8Xv_Kfz9aikRgPDPl4CjdjMYQS_f89gNa/edit#gid=0

https://docs.google.com/spreadsheets/d/1GRjMsn1f8Xv_Kfz9aikRgPDPl4CjdjMYQS_f89gNa/edit#gid=172125754

Both sheet ids are the same, only the gid at the back is different, but in the addon, I can’t enter the gids separately.