PRICING
PRODUCT
SOLUTIONS
by use cases
AI Lead ManagementInvoicingSocial MediaProject ManagementData Managementby Industry
learn more
BlogTemplatesVideosYoutubeRESOURCES
COMMUNITIES AND SOCIAL MEDIA
PARTNERS
Hey! Daniel here. These days, I'm intensely playing around with automations, exploring the capabilities and limitations of no-code and low-code platforms in the field. In this article, Iâll share with you the perfect synergy between Zapier and Latenode that helped me slash my automation costs by 89 times and allowed me to extend data processing capabilities.
Let me take a step back and express my unconditional love for Zapier. With more than 6000 ready-to-use connections, it's the most user-friendly platform I've encountered. Therefore, when a new automation need arises, Iâm confident that a few minutes on Zapier is enough to make it a reality.
However, the business processes I assist with often require a massive number of operations in my Zaps. In terms of Zapier âtasksâ - internal credits - this can really hit the pocket.
As you probably know, Zapier charges for each action item in your automation. This becomes especially bothersome when you loop a part of your workflow to run an action or set of actions more than once. For instance, if you have a list of email addresses to add to your contact list, each âAdd Contactâ action adds only one contact. So, you're looping. And if you need to place 1,500 emails at once, be prepared to pay $39 on the Zapier Professional plan.
Luckily, our team built a platform that doesnât consider the number of actions in your automation. So, whenever such an extensive action workflow appears, follow this clever workaround:
Letâs try sending data to Latenode for the heavy lifting, then bringing the results back into Zapier to finish the job. Imagine having Google Sheets with sales data for the past half-month:
We will use Zapier to get data from Google Sheets. We add the âGet Many Spreadsheet Rowsâ action to have a one-line output as a result of this step. Sending data in such a format requires only one task. Letâs focus on cost-efficiency.
As shown in the previous screenshot, we put Latenodeâs webhook URL, and send our output from Google Sheets there. To make it happen, we should:
After that, if your Zapierâs POST webhook is activated, Latenode will receive your data as shown below.
Now, the data is under your total control. To demonstrate Latenode's capability, I'll transform it using a JavaScript module with an in-built AI assistant that will do all the work for me.
As a showcase, letâs ask the AI to make a sum of Sales Figures ($) from our one-line Google Sheet data and see how it figures it out. To make this real, two steps are left:
Our request looks like this:
- Hey! Could you please parse data from the Sales Data object, make a sum of Sales Figures ($), and then return the sum back?
In a moment, your Latenode scenario calculates the sum of the âSales Figuresâ column despite the one-line format this data has been received in.
Moving forward, we can add another JavaScript module and ask:
Please add a script to my code that will convert the sumOfSales from USD to EUR using a free available API
Latenode supports NPM packages, offering great flexibility in data processing.
Overall, our scenario looks like this. Ensure you end it with a webhook response, so the result of two operations will be returned to Zapier:
After that, Zapierâs webhook response receives new data that can be used further in your Zap. Our screenshot below demonstrates how we use the converted sum in a Slack channel.
Thatâs it! I hope this guide gives you a fresh perspective on automations and shows how everything can be optimized for cost-effectiveness and data flexibility with the help of a Zapier and Latenode bundle. By the way, the Latenode Forum community is extremely supportive, so feel free to ask any questions and expect immediate help from the dev team there.