Need help with Excel Formula Syntax


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
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?



=Dump(Connector("GoogleSearchConsole.SearchAnalytics","","2020-01-01","2020-12-31","query == " & A1

yes, that works. Thanks!