Unable to input my data of excel into google sheet

Help StudioX
,
1

I’m unable to connect the google sheet with excel i’'m encountering following error while debugging.
Write Range: Invalid data[0]: Unable to parse range: Sheet1!A1 [400]
Main Sequence: Invalid data[0]: Unable to parse range: Sheet1!A1 [400]
23.6.1-beta.13324+Branch.release-v23.6.1.Sha.52787b786620e97cba5555379da6e6bb423b3e6b

Source: Main Sequence

Message: Invalid data[0]: Unable to parse range: Sheet1!A1 [400]

Exception Type: Google.GoogleApiException

2

Hi @Harshit_Rai
Here are a few things you can check to troubleshoot and resolve the issue:

  1. Verify the sheet name: Double-check that the sheet name “Sheet1” is correct. Ensure there are no leading or trailing spaces, and the case matches exactly.
  2. Confirm the range format: Make sure the range is in the correct format. In this case, “Sheet1!A1” refers to cell A1 in Sheet1. Ensure there are no typos or missing characters.
  3. Check access permissions: Ensure that your Google Sheet has the necessary permissions to be accessed by the Google Sheets API. Make sure the account used for the connection has the appropriate access rights to the spreadsheet.
  4. Test with a different range: Try using a different range, such as “Sheet1” (for the entire sheet) or “Sheet1!A1:B10” (for a specific range of cells), to see if the issue persists. This can help identify if the problem is specific to the range you’re using.
  5. Test with a new spreadsheet: Create a new Google Sheet and try connecting it to Excel using the same process. This can help determine if the issue is related to the specific spreadsheet or a broader problem with the connection.

Regards,

3

@Harshit_Rai

Can you please show what you are trying and what data are you pasting and what inputs you configured for the activity

cheers

4

@Anil_G

I have been trying to upload data of Excel sheet using write range activities in UiPath.

5

Main.xlsx (7.2 KB)
I’m adding excel of project @ajitg @lrtetala please see and suggest.

6

Thank you for resolving my query.

Robotmaster.

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.