3 Ways to Reduce Zapier High Task Use

Zapier high task use spiraling out of control? Take back control by streamlining and optimizing your zaps to not only reduce task usage but also make them easier to maintain

Marketo UTM Tracking & Automation

Marketo UTM tracking program details

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.

How to use Zapier with Google Sheets

Google Sheets data being accessed in a Zap action in Zapier

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.

Zapier Google Sheets Lookup Value

Timestamp being used as the Google Sheets lookup value in Zapier

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.

Zapier Import Multiple Rows from Google Sheets

Button in Google Sheets to trigger a Google Script to send multiple rows to Zapier

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.

Zapier Nested Looping using Webhooks & Python

Zapier nested looping horizontal flow diagram

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 Array with Nesting

Flow diagram of nested looping in Zapier using webhooks

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

Zapier loop action workflow

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 Looping Through Line Items

Zapier loop through line items actions

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!

Zapier Loop Through Array from Google Sheets

Zapier loop through array workflow

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 as shown in the flow diagram below.