Firing up something new: Question of the week! โThis week's question is: What is one thing you've built that you feel extremely proud of? It can be an integration, an app, an automation, an agent, a website... whatever!
REPLY to this thread with your answer.
REACT to other replies with an emoji.
Excited to hear from the community on this one (my answer is in thread!) ๐
I'm proud of ai-for-everyone-one.vercel.app ! I built this site for a workshop I held at my local Community Center where I taught people how to use AI.
๐ tagging in a few favorite community members to share your favorite build. Bret B. RussellJ steve.waldron Vinay K. evan.yates Shubham K. praveenpno sreenivas r. Sunny P. Shiva dkuroda Shivam Himanshu jyoti.bansal jack.zhu adiaz Mathew D. gary, Ben H. Totally optional but would love to hear from you!
I'm tempted to talk about using the Workato SDK to build custom connectors, because I'm definitely proud that I have done that. But if we're just sharing personal details, I took a guitar-building workshop some years ago and I'm really proud of the guitar I built there. It's a bit quiet compared to professionally-built guitars, but it has a sweet tone and it's super easy to play.
One thing Iโm extremely proud of is optimizing a Service Appointment integration where I re-engineered the existing logic and reduced task consumption from approximately 18,000 tasks to just 8 tasks per run. This wasnโt just about reducing costs; it was about challenging the existing approach, identifying inefficiencies, and designing a more scalable and reliable solution without compromising business requirements. For me, the most rewarding part of engineering is turning complex problems into simpler, more efficient solutions. I believe true innovation is not always about building something newโitโs about making what already exists work significantly better and sharing that learning to help others grow.
I implemented a similar approach to Shiva, and I believe this is one of my best design approaches, focusing on execution efficiency and Workato optimization. As part of the Salesforce Opportunity Sync migration from MuleSoft to Workato, I leveraged the Salesforce Bulk API to process 367K+ records in under 7 minutes as part of a full-load daily sync using 1 business task. This was a critical integration for the customer, and we successfully migrated and executed it smoothly in Workato. Handling this volume of data within such a short execution window demonstrates the value of choosing the right architecture and optimizing bulk-processing capabilities. The customer was happy with the execution speed and overall performance, especially given the critical nature of this integration. It was a great example of delivering a scalable, efficient, and reliable solution through the MuleSoft-to-Workato migration. Proud to have contributed to this successful migration, with a strong focus on performance, scalability, and reliability.
My company had a runaway issue with Okta service accounts. Accounts made for a purpose and not a human. The ran to 10% of all licenses in Okta. I built an automation to be used as a Quarterly Access Review in Workato for all of these accounts. It uses Workatoโs Web App to generate tasks for all of the known owners to review, certify or update the information associated with the account. It also gets security information about the accounts such as MFA enrollment and password age. First round of using it resulted in just shy of 10% of those accounts getting deleted. Plus the review only has around 50% completion due to bugs I missed during the design phase.
Hi Aaron W., for me, the great example of how the right approach can make a significant difference in automation efficiency. Integrating and consolidating data from 4 different applications and 13 data tables into a single reference table is already a complex requirement. Reducing the recipe from 34 steps to just 1 and optimizing task consumption from 161 tasks to only 1 is a remarkable improvement. This really highlights the power of SQL Transformations in Workato, not just for reducing task consumption but also for improving performance, scalability, and maintainability. It's a good reminder that effective automation is not about adding more steps, but about finding smarter and more efficient ways to achieve the same outcome. for your reference: lnkd.in/p/gHwfej3h
Shiva - WOW. 18k to 8K is incredible. Vinay K. - 367K to records in under 7 minuts is ALSO incrtedible! Bret B. - this is exactly the kind of story I love to tell about how Workato makes magic, thank you for sharing! I'm wondering how much $$$ those accounts clear ups converted to (no need to share here, just thinking!) rajeshjanapati: 13 tables x 34 steps ๐ต 161 tasks ๐ตโ๐ซ - 2 tasks ๐ ๐ Thank you all for sharing, can't wait to hear more from the Community on this!
Most recently, identified and built some fairly easy optimizations on high-consuming recipes that cut 1M credits/month from our baseline consumption. (But don't tell my AE ๐). We had legacy integrations with inefficient triggers, or that repetitively made the same updates even if they weren't needed.
Replacing naive realtime triggers with scheduled (often query-based) triggers often reduces credit consumption by 100x, 1000x or more especially when triggering on systems/objects that are frequently updated, like the Salesforce Account object
Another nice trick is to use SQL Transformations to analyze records in bulk, and spit out only updated records that need to be processed; sort of a custom change data capture (for when Data Pipeline isn't the right solution)
Yet another version of this is using lookup tables or data tables to cache key-value pairs consisting of a key and an md5() hash only of the fields you care about on records with frequent updates posted to other systems. When you get an update trigger, hash the updated values and compare with the cache; if no change, stop processing.
The ultimate point of this is not to be a skinflint, but to get baseline costs down to give us more runway for growth, especially on AI features. Getting more budget for integration costs is always an uphill battle, so showing the ROI of efficient integrations is always a good way to win hearts and minds when you really need that budget ๐
I reduced invoice processing SLA from 72 hours to under 1 hour, automating high-volume workflows and saving the equivalent of 5 full-time employees (~10,000 hours annually), while ensuring 100% compliance across multiple regions. Apps: Coupa, Gdrive, Outlook, Gemini
