Insert data from sheet into your queries with parametrized queries.
You can reference sheet data in SQL. Use {{}} notation for references. You can only reference single cells at a time.
SELECT * FROM {{A1}} WHERE salary > {{A4}}
Note in the following example where the query output changes based on what table is selected in cell B1.
select abc from def where ghi="{{'Sheet_name'!H3}}"
Last updated 1 year ago
Was this helpful?
