Hi @Jan, I didn’t have that issue yet. But I guess what’s happening is the following:
You are mapping the Spreadsheet with a variable and then try to select the Sheet. The Module is therefore trying to load the sheets in the Spreadsheet you chose. But because you put in a variable, the module is not able to load the Sheets. You need to map the Sheet as well, I guess.
Okay, sadly I don’t really understand where you need help.
You are using the Module “Search Rows” to search specific rows from a Google Sheets based on conditions. Within this filter section you can just specify your condition.
Do you want to get all “deliveries” which are not “delivered” yet? All customers who are “in acquisition” phase?..
[Uploading: Bildschirmfoto 2022-07-04 um 09.41.31.png…]
I have created a scenario with several google sheets modules. (see appendix 1)
it has several filters in the different google sheets modules. and the scenario works as it should.
If I now open a google sheets module, the error message ‘Failed to load data!’ is displayed for ‘Sheet’. So I can’t see how the filters are set.(see attachment 2)
If I now also map the sheet, the filters are empty. (see appendix 3)
I can’t remember how I set the filters in the 25 Google Sheets modules. So now if I want to change something or there is an error, I have a problem.
So my goal is to get rid of the error message ‘Failed to load data!’ and see again how I set the filters.
Hi @Jan,
thanks for summarising!
But if the workflow works as it should and you have filters in place → you already have filter in place? Just look which filter you set for this specific module and put it into the module again?