How to get value, given "text" Column and Column

Status: Closed · Asked by aa_hei on · 0 views

aa_hei — Question ·
Task History ID: IjU3NjcwNTY1MDYzNjA0MzY1MjZkNTUzYzUxMzU1MTYxNTQzOCI_3D_pc

1. I've already gotten the telegram bot massage process to 2 texts to navigate the value
2. I'm stuck in google sheet part
my sample is like this
[TABLE]
[TR]
[TD]itemNo[/TD]
[TD]US[/TD]
[TD]MY[/TD]
[TD]PH[/TD]
[TD]SG[/TD]
[TD]UK[/TD]
[/TR]
[TR]
[TD]73285195[/TD]
[TD]62.97[/TD]
[TD]54.55[/TD]
[TD]57.89[/TD]
[TD]54.05[/TD]
[TD]60.74[/TD]
[/TR]
[TR]
[TD]72412180[/TD]
[TD]59.72[/TD]
[TD]51.29[/TD]
[TD]54.64[/TD]
[TD]50.79[/TD]
[TD]57.48[/TD]
[/TR]
[TR]
[TD]74912195[/TD]
[TD]62.97[/TD]
[TD]54.55[/TD]
[TD]57.89[/TD]
[TD]54.05[/TD]
[TD]60.74[/TD]
[/TR]
[/TABLE]

for example, sent “73285195_US” telegram bot, then telegram bot reply me 62.97
1. telegram bot Webhook Done
2. Text split by separator Done
3. get "73285195"and "US",and match it in google sheet. However, I didn't find that function. Did I miss something?
I only find GoogleSheet--Lookup Spreadsheet row

Pabblymember11 — Reply ·

Hey @aa_hei

We have made a workaround for your use case to find the country values from Google Sheets.

Though you only need to pass the column name in the Lookup Table action step which we have set up for you for all other countries.

So, please do the necessary changes once and try again.

Back to all forum threads · Log in to reply