I'm using Data connector for Salesforce Google Sheets add-on to pull Salesforce information into a sheet via SOQL queries.
I'd like to use a cell reference from my sheet inside one of those queries, but have not found proper documentation on how to do so. Here's examples of what I've tried thus far:
SELECT AccountOwner FROM Account WHERE AccountName = '[Sheet1!A1]'
This returns 0 query results, even though the data in cell A1 is a valid
SELECT AccountOwner FROM Account WHERE AccountName = '"&Sheet1!A1&"'
Again same results as before.
Would anyone be able to provide more insight on how to utilize a cell reference here? Thank you!