I'm trying to use the formula for search console to get clicks, impressions, etc. for bunch of queries in a specific column. I would like drag the formula down and get all the data that way.
However, when I input
=Dump(Connector("GoogleSearchConsole.SearchAnalytics","https://www.mywebiste.com/","2020-01-01","2020-12-31","query=A1
","web",0,"Clicks,Impressions,Ctr,Position",TRUE,1))
it is looking for the query "A1" instead of using the value in the cell A1.
What is the proper syntax so it uses the value in cell A1?
