Using Custom Formulas to Dynamically Pull Data From Salesforce
G-Connector has a built-in formula that you can use to run SOQL queries to populate cell-level data. Here’s an example of one:
=RUNQUERY(“SELECT sum(amount) FROM opportunity WHERE stagename ='”&B1&”‘”)
This custom formula run any SOQL query for a single cell. Please, keep in mind that only the value in the first row of the first column will be returned as the result of this formula.
Here’s a video showing how to make such formulas recalculate on demand: