Learn how to automate workflows using the Marketo API, Zapier, Python, and Google Scripts
Join me on an automation adventure as I share the cool ways to use APIs, programming, and all sorts of tools to make your life easier. Have questions or need help with a project? I'm your man!
Talk to Tyron
When trying to pull a specific row from your Google Sheet into Zapier you can use a lookup value dynamically populated with a variable from a previous step. This is useful but the real power of using the Google Sheets lookup value in Zapier comes when you need to import large amounts of data into your zap.
Anyone who has worked with Google Sheets in Zapier is likely to have run into the issue of needing to import more than the 20-row maximum imposed when using the Google Sheets app. This post will show you how to overcome this limitation and import multiple rows from Google Sheets into Zapier using some JavaScript and webhooks.
The Zapier loop through line items action is a godsend! For those of us who have been duct taping together ways to loop through Google Sheets in Zapier, this action finally simplifies the process of looping through line items. Now you can perform tasks in bulk for each row in your sheet easily and quickly so you can get back to the important stuff!
Have you ever been afraid of automating something in Zapier because you are afraid of the consequences if the zap ran without manual oversight? Now you can put that worry to bed thanks to the Zapier approval action, which will pause your zap until a manual review has been conducted and the zap has been approved to progress. So whether it is automating your social media posting, sending SMS notifications to your customers, or merging leads you can now do this in confidence.
Do you often find yourself repeating the same actions across different zaps in Zapier? Well, then the Sub-Zap by Zapier action was made just for you! You can take all those grouped actions that you use repeatedly across your zaps and put them in a single sub-zap that you can then request from any other zap in Zapier.
There are three options to merge duplicates in Marketo: Manually (read Painfully), Pay-nfully, and Automatically. In the case that you want to avoid pay-nful services like Marketo Easy Merge, the Marketo REST API is a great option to merge your duplicates in bulk, according to custom rules that you specify in your code.
This post will walk you through how to use the Marketo API to merge leads in bulk with Python code that will allow you to set custom rules for how you want to prioritize conflicting values for the same fields on different leads.
Your duplicate list becoming ever more daunting? Stop the rot by learning how to build an “Automatic Marketo Merge” zap in Zapier that will merge duplicate leads as soon as they are created according to custom rules you specify.
Receiving 2FA messages or customer responses to your marketing campaigns that you want to get notified about or distribute to multiple parties? Well I’ve got you covered! This post will show you to forward SMS to Slack, email, and another phone number using the Zapier automation tool and the Telnyx CPaas platform.
This post will walk you through your Marketo SMS integration with Telnyx and how you can use SMS notifications in smart campaigns to thank people for registering for a webinar and then later remind them to attend.
