Using Zapier to fill in supplementary details

Posted by: Ariel Vertudes Date Posted: January 22, 2025
Back to Case Studies

Issue

  1. Some CRM APIs don’t have bulk or query endpoint options for pulling associated records. (Example: Contacts associated with a Deal)
  2. It is costly in Workato to loop each record and pull the associated record.

Solution

  1. A Workato recipe pulls the record and uploads it to a Google Sheet row.
  2. The Workato recipe will also push the UID of the record to a Zapier Webhook.
  3. The Zapier Webhook will pull the associated record and fill in the supplementary details in the correct Google Sheet row.
  4. Another Workato recipe is scheduled to pull the completed rows from the Google Sheet and push it to RCFX.

Achievement

Minimized Workato usage when pulling associated records if bulk or query endpoint is unavailable.

Note: This solution will just transfer the process to Zapier from Workato and will also cost Zapier tasks. However, Zapier is cheaper than Workato, so I think it’s the best option we have in this case for now.

Snippet/Screenshot/Link

An example of this integration is in Midsouth Construction.

  • Workato Account – https://app.workato.com/users/switch_team?team_id=4612162
  • Zapier Folder – https://zapier.com/app/assets/zaps/folders/2457793