Hi!
I’m creating a bot that looks up data in a google sheets based on the user responses. I want to cross reference a particular cell based on values I’m storing in attributes - let’s call them ‘rowval’ and ‘colval’.
I can dynamically select the row using this attribute, but once I GET the ROW I have no way of using the ‘colval’ value to point to the correct cell in that row.
Is there a way to use attributes to point to specific google sheets cells in the way I want to?
Thanks!
Hi there, 
What are you trying to do once you have the correct cell?
Really it depends on the number of columns you have in your sheet as to the best way of handling this. If you don’t have too many columns then you may be able to duplicate the following actions with different filters stating “if Get_A_Row_Results.columnA equals colval”.
Alternatively you would be best looking at using the code service to run through the values in the row until you get a match for colval and then return the column name.