Hi - I have a google sheet that receives results from a Typeform quiz. I am using the Query function to bring over the answers into a second worksheet, because I need to use the results to further calculate other scores and lookup images.
I am trying to use a Zap that picks up data in the rows created by the Query function, but when I run the “Find Data” step, it finds the rows but there is no data in any of the columns.
Is there some reason why Zapier cannot see the data that’s been brought through using the Query function? If I replicate the sheet and just paste the data in then it seems to work.