Question:
I tried to make a flow about Auto Chatbot flow. I also created the Google Sheets and added the URL to Bot Sheets Utilities. I used BotSheetsApi to get data from my Google Sheet and after I "Test Request," the Map Response doesn't have any data from my Google Sheet. How can I solve this issue?
Answer:
This is because the custom variable you are using don't have any value yet. Try to add “Fallback” value on your Custom variables.
There are 2 ways you can do this:
1. You can enter the fallback value when you edit your custom variable. Go to Utilities → Custom Variables → Edit your custom variable → Enter the fallback value.
2. You can also manually enter the fallback value on your custom variable. Example, if your custom variable is {{search_entry}} and you want to fallback the entry to “Cabinet", what you can do is enter this {{search_entry|cabinet}}
The system will use the fallback value when the custom variable don't have any value yet from user input.