Using Zapier + Salesforce, I am trying to return a list of all users created within the last 60 days, every time the Zap is run.

I attempted to use the “Find Record(s)” Event for the Salesforce Action:

I proceeded to appropriately configure the Action to reference the “User” object, and set the “Field to Search By” to “CreatedDate”:

However, I want my “Search value” to be any date that is greater than today minus 60 days. From the looks of this, is seems that the “Search value” field is restricted to only a single value. Well, it does mention that it supports line-items and comma-separated, but as you can see the actual value for that field in Salesforce is a timestamp down to the second. Obviously, it makes no sense to load in a list of values that represent every separate second between {{zap_menta_human_now}} and that minus 60 days.

A very simple SOQL query would solve for this beautifully. BUT, of course, it looks like when you use Zapier’s “Find Record by Query” Search Event, it does not support line-items (it only returns the first result in the response). 

My other attempt was to maybe somehow skip the predefined drop-down list within the “Field to Search By” box:

… and somehow write a custom field in a way that would pass into the request passing into Salesforce. 

… Or perhaps the same idea, but using the Custom option in “Search Results” Zapier field (for where you otherwise choose from the drop-down: “first” or “all” results).

… and no luck.

My backup method is to run a Google Sheets extension that is able to automatically pull rows into the sheet on a schedule, defined by a SOQL query. Then, I’m able to have Zapier “Get Many Spreadsheet Rows,” which is all just incredible sloppy. It seems to just completely defeat the purpose of Zapier for our business (at least for how I pitched to our stakeholders the benefits of incorporating Zapier into our corporate stack).

Anything else I am missing? Would love any help that the community here has to offer.

For what it’s worth, it is completely unfeasible to instead run a query that simply retrieves ALL salesforce users, and then filter the results in Zapier based on each record’s CreatedDate. That is a very simple worst practice re: payload issues.

Thanks in advance to everyone who took the time to read through this!