Trying to add to a cell in a Google spreadsheet

[roadhog]

I need to find a business name in a column using Google Spreadsheet to locate the row it is on and add info to another cell in the same row automatically.

I have already an action to get a particular line at the beginning of the template.

Any help would be appreciated.

 

[roadhog]

Thank you Vlad.
Here is the C# snippet for this task if somebody else needs the same action.

// project variable name where business name is stored
string keywordVarName = "keyword";
// name of the Google Sheet table in project
string gTableName = "gtable";
// column where snippet will look for match.
string columnName = "A";

int rowIndex = -1;
List<string> column = project.GoogleSpreadsheets[gTableName].GetColumn(columnName).ToList();
rowIndex = column.IndexOf(project.Variables[keywordVarName].Value);

return rowIndex;

 

[martianus]

I have a related question:

I can only add up to 14 rows on a table inside ZennoPM... any reason why?

I tried also using google spreadsheet connection but still only maximum 14 rows... and if i click view content then I have all the rows
but it's not only a problem of rows that get shown... they're actually the maximum rows zpm would use!

HERE'S WHAT I MEAN

 

[VladZen]

I have a related question:

I can only add up to 14 rows on a table inside ZennoPM... any reason why?

I tried also using google spreadsheet connection but still only maximum 14 rows... and if i click view content then I have all the rows
but it's not only a problem of rows that get shown... they're actually the maximum rows zpm would use!

HERE'S WHAT I MEAN

This is just preview of a table. Nevermind how many rows in it.