With SeekWell you can query a Google Sheet using plain SQL (SQLite to be specific) and send the results of the query to another Sheet. You can also Slack or email the results.
https://youtu.be/x2rQoJVmOus?t=62
Select "Sheets / CSV / Block" as the source
Add a Sheet to your from
statement by typing {{NAME}}
. Replace NAME
with a one word short reference to the Sheet / table, e.g. {{users}}
)
In the "Params" section, pick "Sheets" as the type
<aside>
💡 If you're data starts in A1 and the table is the only thing in the sheet, you can use the Sheet name. Otherwise you need to specify the range for your table (e.g. revenue!A:C
)
</aside>
Write the rest of your SQL statement as you normally would
from {{users}} as u
)select r.email, u.channel
from
{{revenue}} as r inner join
{{users}} as u on r.email = u.email
limit 10