How can I make the system to output corresponding data based on the first retrieved data

Help
#1

Thank you for reading my question! Your support is greatly appreciated :pray:

I’m having trouble implementing consecutive random output from the integrated Google sheet.

Usecase: Question and answer session between voice system and user

Step 1: First Google sheet integration block
System asks a question;{varQuestion} randomly selected from the integrated Google sheet

Step 2: Second Google sheet integration block
If the user seems to have trouble giving an answer, the user can request an assistant, and the system will give assisting question; {varQuestion2} corresponding to the 1st question.

To make this scenario works, I have applied as follows but it’s not working :expressionless:

First Google sheet integration block

With setting :arrow_heading_down:

1
1694×258 12.8 KB

Mapping output setting :arrow_heading_down:
Can I place (1)

Second Google sheet integration block

With setting :arrow_heading_down:

3
3699×261 12.6 KB

Mapping output setting :arrow_heading_down:
4

To summarize, I would like to know how can I make the system to output corresponding data based on the first retrieved data.

Thank you for your support!

#2

I’m having trouble implementing consecutive random output from the integrated Google sheet.

but it’s not working.

I think your idea seems work (although I’ve not tried). so I’m not sure about what your real problems you see. not working how?

also how is your data structure of google sheets?

1 Like