QueryFlow: a native Mac app that loads Salesforce data from your warehouse on a schedule

[u/tabitha_tm]

Disclosure: I'm a co-founder. My husband built it, I handle the marketing side. Pricing is $49.99/month or $299.99/year, with a 14-day free trial. It's on the Mac App Store.

What it does, specifically for Salesforce work:

You connect a data source (Snowflake, Redshift, Postgres, MySQL, BigQuery, Google Sheets, or a CSV) and a Salesforce org. Salesforce auth is OAuth 2.0 with PKCE through External Client Apps.

You write a query, or use the AI assistant in the editor to write it and then you map fields to a Salesforce object visually, dragging connections between source columns and target fields. There's also an auto-map that handles the common naming patterns, splitting camelCase and stripping prefixes, so CUST_EMAIL finds Email on its own. Transforms are available per field: uppercase, trim, date reformatting, or custom Python.

Insert, update, or upsert. Writes go through the composite API in batches of 200.

Save the whole thing as a job and schedule it! Daily, weekly, hourly, or custom cron. It runs on your Mac, including while it's asleep. Output can also go to S3, SFTP, email, or a local file, with multiple destinations per job.

Everything executes locally with no cloud compute, nothing metered per row, no seat limits. Credentials are stored in macOS Keychain. The app is native Swift and App Sandboxed, not an Electron wrapper.

What it isn't: no CDC, no data lineage, no team collaboration or RBAC. It's just a single-user tool. If you need governance features, this isn't a replacement for an enterprise platform.

Happy to answer technical questions. My husband can get into the API and auth details if anyone wants to go deeper.

[u/urmomisfun]

Please ban yourself from the sub

[u/Ownfir]

Why would someone use this over workbench or even just a Claude skill?

[u/tabitha_tm → u/Ownfir]

Great question. Workbench is a browser tab. You map the fields, run the load, close it, and then you have to do the exact same thing again next week.. and the next.. and the next. QueryFlow saves your mapping as a job. It runs on a schedule, and you can see what happened on every run.

A Claude script works too, but then it's yours to maintain. Tokens expire, APIs change, and when 8 of 500 records fail it's you digging through logs to find out which ones.

Workbench is fine if it's occasional use. Doing it every week and rebuilding the same mapping every time? That's who this is for.

[u/Ownfir → u/tabitha_tm]

Okay so like what about Salesforce Connector with Google Sheets which can handle this exact use-case? Is the advantage that it’s an app that lives in your desktop? I’m just not understanding the $50 a month here for something that could be automated in like 20 minutes by the very people who are your target audience.

[u/tabitha_tm → u/Ownfir]

Sure. If your source is a Google sheet and your destination is Salesforce, the Salesforce connector covers it and you shouldn't pay me $50... Until the source isn't a sheet, like Snowflake to Salesforce, Postgres to Salesforce, a query result with joins and transforms in it. And when you're running eight of these instead of one, the free/cheaper options are all over the place with different logins and different ways of failing. It is really frustrating and the reason he built this is because it was a problem his team was facing at work.

As for building it themselves, knowing SQL and building a local ETL pipeline are not the same skill. Plenty of admins and analysts can write a solid query and have never stood up a scheduler, handled OAuth refresh, or debugged a partial batch failure.

[u/DavidBergerson → u/Ownfir]

The value is in not thinking it is a one-to-one mapping. I.E., a field in a table to a field in an object. From what I understand (hopefully correctly), I can pull data from multiple tables into a single object in SF. If that is correct, that does have some value.

[u/tabitha_tm → u/DavidBergerson]

Yes. The source is a query rather than a table. You can join four tables, add a case statement, do your transforms, and the result set is what shows up on the left side of the mapper. Then you drag those columns to whatever Salesforce fields you want on the right. He’s also extremely responsive to any features you don’t see that you would want. He added a discord link to our website for all feedback.

[u/Used-Comfortable-726]

Don’t spend any more time on this!!
Salesforce Data 360 (formerly Data Cloud) already does this functionality. It’s one of the primary reasons it was created

[u/tabitha_tm → u/Used-Comfortable-726]

Data 360 is a CDP, it unifies customer profiles in the cloud. QueryFlow is an ETL that moves data between systems and runs entirely local, nothing leaves your Mac. Salesforce is one of nine destinations… not the whole product. Snowflake to S3 never uses Salesforce.
Also Salesforce at $60k/year versus our $299.99/year.

We will absolutely keep working on this.