Streamline Your Workflows

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

Marketo Anonymous Leads & Attribution

This post sets out to demistify the enigma of Marketo anonymous leads and how they interact with your attribution smart campaigns. Once we have gone through the quirks of tracking attribution for Marketo anonymous leads I will show you how to modify your smart campaigns so that these leads will always get their first and last touch attribution fields set correctly.

Marketo UTM Tracking & Automation

Take the first step towards becoming an attribution master by learning how to set up Marketo UTM tracking programs and smart campaigns to match website visitors to particular ad campaigns, set first and latest touch attribution fields, and track downstream conversions to signup or contact sales forms.

Zapier For Each Loop Quick-Start Guide

Explore all the ways to setup a Zapier for each loop using the 3 native “Looping by Zapier” actions or your own custom definitions within “Code by Zapier” actions and how you can overcome Zapier’s 500 iteration or 10 second timeout limits using nested loops.

Zapier Nested Looping with Code by Zapier

Banging your head against the wall because of the 500 iteration limit on the “Looping by Zapier” action? Well make like Freddie Mercury and break free by using webhooks and Python in Zapier to achieve nested looping so that you can do as many iterations as you need!

Zapier Loop Through Array with Nesting

If you have done any looping within Zapier you have most likely been frustrated by the 500 iteration limit imposed on the Zapier loop array action. Never fear this post will show you how you can loop to your heart’s content using nested looping in Zapier.

Zapier Loop Action

With the amount of data being collected and the number of tasks to be completed for this data increasing, the ability to iterate and perform actions for each row in a dataset is vitally important for the marketing operations lead. This post will show you how to use a Zapier loop action to loop through and update rows of a Google sheet to give you a solid foundation that you can then build upon in your own Zaps.

Zapier Loop Through Array from Google Sheets

Have large amounts of data in Google Sheets that you need to loop through but you’re not sure what is the best way import the data and then act on it? Then you’ve come to the right place! This post will show you how to use Zapier to loop through arrays imported from Google Sheets so that you can carry out actions in bulk for each of the array values.

Zapier Google Sheets Quick-Start Guide

Wondering about the best option for importing your Google Sheets data into Zapier? Or maybe you’re frustrated by the inability of the Zapier Google Sheets actions to import than 20 rows? Well, then you’ve come to the right place! This post will walk you through the best way to import data from Google Sheets into Zapier based on how many rows or how much data you want to import.

How to use Zapier with Google Sheets

Integrating Google Sheets with Zapier will allow you to unlock a whole new array of automation possibilities for the data in your spreadsheets. This post will show you how to use Zapier with Google Sheets by walking through the 3 different options for importing data into Zapier using the Google Sheets app.