Google Sheet "Read Range: Cannot find column [x]" -- error only appears in one version of project

Help Studio
, , , ,
1

Hello, I am attempting to create a sequence that reads a google sheet in as a data table, identifies the first empty row in a specific column, then populates that row with information.

I have solutioned this successfully, and it works in its own standalone project file. However, I tried to copy this code over to my main project and now Read Range throws an error every time it runs.

In both the “test” project and my main project, I am trying to run the isolated Google Sheet sequence, as reading the sheet is not dependent on any of my other code. With my setup as it is in the screenshots, the error I get is “Cannot find column 9”.

The column it claims it can’t find seems to be dependent on where the highlighted 2x4 block exists in my sheet. Deleting that just has me throw a different error. This also proves that my Read Range activity is pointing to the correct Sheet.

Edit: I just tried to create a fresh project and make a new Read Range just to see if it would work. I am still getting the Column 9 error in that project. I am now even more confused as to why this solution is working in that one test project at all.

![The image shows a Google Sheets spreadsheet titled “Test Bot status report” with columns for ServiceNow Ticket No., Username, UserID, First Name, Last Name, Application, Status, and Exceptions, containing some cells highlighted in yellow with exception details.

The image shows an open Google Sheets document titled "Test Bot status report" with columns for tracking ServiceNow tickets, username, user ID, user details, application, status, exceptions, and business exceptions, with some exception cells highlighted in yellow. (Captioned by AI)
The image shows an open Google Sheets document titled "Test Bot status report" with columns for tracking ServiceNow tickets, username, user ID, user details, application, status, exceptions, and business exceptions, with some exception cells highlighted in yellow. (Captioned by AI)1710×854 45.9 KB

2

@louiemed

are the package versions same in both?

also instead of copy try to recreate just to make sure of no issues

cheers

3

Hi @Anil_G

I spent all day troubleshooting this issue in various ways. I did end up solving the problem although I’m not very confident in my solution. I did have to update my Google Workspace package but the problem was not immediately solved after that so I don’t know if it is related.

When recreating a new “Read Range” activity, the activity by default would take a variable of type DataTable. However, upon selecting my specific sheet to the activity, or selecting the range, the DataTable type would update with a number appended to it. This happened so many times I have up to variable type DataTable19 existing in my project.

I kept testing the code and kept getting the “cannot find Column 9” error. Eventually, when the Read Range activity was searching for DataTable19 and I set my output dt variable to be DataTable19 as well, the code successfully executed. I tried this many different times so I don’t know what changed that it suddenly worked.

I had a hard time troubleshooting this issue as there is very little documentation about this online, so I don’t know what the significance of these custom types are.

1 Like
4

@louiemed

Are you on version 23.x . If so there are few identified bugs like this…better to move to 24.x

Cheers