***Consider this article as a more advanced version of Magic Formula to Solve Complex Problems in Make*** Have your ever faced a situation where outputs of preceding module were not consistent in Make? For example, an item within an array would come as an array, but the next item with the same array would come […]
Magic Formula to Solve Complex Problems in Make/Integromat
Have you ever wondered if it’s possible to use coding approaches in Make to solve complex problems? It is! In the video below, I am showing how to use Set/Get Variables modules along with Router. If you master this combo, you’ll be able to build super powerful scenarios to solve really difficult problems. The sample […]
New BigQuery UI is Just Bad!
I would never believe I’d say something like this but Snowflake’s UI is terrible but Google is now far worse. Well done, Google! Here are several reasons why I think the new UI is just bad: It’s slow. Far slower than the previous UI. There is like 0.1s lag when you are typing your query. […]
Make/Integromat Case Study: Connecting GoFlow with QuickBooks via BigQuery
Problem A client has approached me with a seemingly simple problem – he wanted to connect GoFlow (on order management software) with QuickBooks (an accounting software). While a native integration between the systems already exists, it offers almost no customization and was simply not a fit for my client. I was tasked to: Build an […]
Make/Integromat Case Study: Automating Checkout Process on This Site
Problem In some of my articles, I offer content as a free download OR as a paid download – it’s a process which can be technically called as checkout. The challenge is to deliver the right files to the right customers no matter if they go via the free or the paid route. I had […]
Working with Arrays and Aggregations in Make/Integromat
In today’s video we’ll look at a real life example where you need to process an array and possibly do an aggregation of the iterated data. The sample data is an order from WooCommerce with multiple line items. The goal is to pass the line item data to a Google Sheets spreadsheet. Why this topic? […]
Yes, You Can Replace Google Ads Scripts with Make/Integromat
***Please note that Integromat evolved into Make in February 2022. All content for Integromat is also valid for Make.*** The problem I am solving today is replicating this 3 years old script Free Google Ads Script for Building Negative Keyword List to Negate Bad Search Terms entirely in Integromat. You might be wondering why I […]
Make/Integromat in Performance Marketing World
***Please note that Integromat evolved into Make in February 2022. All content for Integromat is also valid for Make.*** Integromat is a super powerful tool for automating your marketing workflows. However, the term “marketing” can mean many things. In the generic form, “marketing automation” with Integromat is usually about pushing contacts from a source system […]
Make/Integromat Case Study: Connecting Pipedrive with lexoffice
***Please note that Integromat evolved into Make in February 2022. All content for Integromat is also valid for Make.*** The Problem A client needed to automate his business operations – mainly his lead management workflow. The client has recently started using Pipedrive to manage influx of leads from their site. The problem was that client’s […]
Google Ads Keyword Planner Data to Google Sheets
***Please note that Integromat evolved into Make in February 2022. All content for Integromat is also valid for Make.*** I’ve always wanted to be able to easily get Google Ads Keyword Planner data to Google Sheets. The best case scenario was to provide inputs in a Google Sheet and then have “some magic” download the […]