Destinations & scheduled pushes

1. 1Build a query in Explore and open the Send panel.
2. 2Pick a destination and fill its target — a spreadsheet ID and tab for Sheets, dataset & table for BigQuery, a connection string & table for PostgreSQL.
3. 3Click Send. Tables are created automatically when they don't exist, with columns matching your query.

Click Save on a configured target to keep it as a saved destination — reusable in one click, without re-typing IDs or connection strings.

On the Destinations page, pair a saved query with a saved destination and choose a frequency — every hour, every 6 hours, or daily. SpendMix runs the push server-side and emails you if a push fails (at most once a day per schedule).

• Google Sheets — writes into the tab you name, replacing the previous push's rows.
• BigQuery — streams rows into a dataset/table. Pushes are append-only (dedupe downstream if you schedule them), and you first grant the SpendMix service account access to the dataset (BigQuery Data Editor).
• PostgreSQL — you supply the connection string; the source IP is dynamic, so the database must be reachable from the internet.
• Snowflake — rolling out; shows up in the Send panel once enabled for your workspace.
• CSV / REST API — any query is also a download (format=csv) or an authenticated URL (see the API guide).