Hello,
I feel like this should be so simple but clearly I am missing something / doing something wrong!
I have an API that retrieves a ‘client tag’ from my data source. I want to add that to a Google Sheet as a more simplified tag. If the tag is staff, show staff, if it’s volunteer, show volunteer, if it’s anything else show member.
This is the formula I am trying to use in the ‘Google Sheets - add a row’ module:
This is the type of data the API returns:
In this case, I want the spreadsheet to say “Member” but it returned “Staff”.
Typically there is only one tag, the above is not a great example! If there are multiple tags it would only ever be ones that all mean ‘member’.
I asked the AI assistant and it suggested:
but that just threw and error and stopped the scenario completely:
Any help would be much appreciated.
Many thanks!
Jayne
