New bug with v2.x of Google Workspace Package

Help Studio
, ,
1

After updating from v1.16.2 to v2.x of the Official UiPath Google Workspace package, the Append Row to Google Sheet activity stops working. It reports that tabs that exist in the worksheet do not exist.

image
image2722×1284 195 KB

This is a screenshot showing the array of tabs that exist in the worksheet and the error log complaining that one of the tabs that clearly exists does not exist when attempting to append a row to it.

When downgrading back to v1.16.2, this problem goes away.

image
image2284×1572 392 KB

I tried to use the formal bug reporting tool to report this, but it’s not working for me. I’ve started a different thread for that: Send Feedback button not working

2

Hi @kevinpscott,

arrTabnames - from where it takes the value, is retrieving sheet names from Google sheet OR is it hardcoded?

you should check the following:

  1. Make sure that the sheet name is spelled correctly: Check the spelling of the sheet name in the activity properties. If the sheet name is incorrect, update it to the correct value.
  2. Check if the sheet has been deleted: Open the Google Sheets file in your Google Drive and verify if the sheet named “Projects processed” exists. If it has been deleted, you can create a new sheet with the same name and continue with your workflow.
  3. Verify the ID of the spreadsheet: Check that the ID of the spreadsheet you’re trying to append the row to is correct. You can find the ID of the spreadsheet in the URL of the Google Sheets file. Make sure that you have copied the ID correctly.
3

@ABHIMANYU_THITE1

arrTabNames is an array of the tab names of the Google Sheet that was generated at run time by querying the sheet for its tab names. Not hard coded.

  1. The sheet name is spelled correctly. If it wasn’t spelled correctly the procedure wouldn’t work in v1.16.2 of the Google Workspace package. Remember, the ONLY difference is there is a package update.

  2. The sheet has not been deleted. If it had been deleted the procedure wouldn’t work in v1.16.2 of the Google Workspace package. Remember, the ONLY difference is there is a package update.

  3. The ID of the spreadsheet is correct. If it were not correct the procedure wouldn’t work in v1.16.2 of the Google Workspace package. Remember, the ONLY difference is there is a package update.