Show & Tell

TIP: Create unlimited unique task-specific email addresses with Gmail Gmail Article: https://support.google.com/a/users/answer/9308648?hl=en WhatQ: Do you want unique Gmail email addresses without having to create multiple Gmail accounts or aliases for specific tasks?A: Simply add a plus sign (+) and any word before the @ sign in your current email address.Messages will still reach you, and you’ll have an infinite amount of emails for different purposes. ExamplesIf your Google Workspace email address is test@tester.com, then you can:Sign up for newsletters with test

Creating a random string to be used as an order/invoice ID (or anything else for that matter) is something that can be done pretty easily. Here's @nicksimard's approach:Pick a Formatter step and choose Numbers -- Spreadsheet-Style Formula. Then use RANDBETWEEN:The odds of ever having a duplicate are extremely low. If you wanted to, you could create two of these steps then combine the mapped fields, to make it even more unique, but there's probably no need.You could also create a Pick From List, choose random and have some preset options to choose from that you can add to the randomly generated number.Like this:OR, yet another way

Updated: Wednesday 14 May 2025Hi everyone! 🖐Do you have a Facebook Lead Ads Zap no longer triggering, a page not showing up and/or are you not able to pull in sample data? Then this post is for you!Permissions Manage Page access Manage Ad Account Leads Access CRM Access Business Tools

Mod Edit: 03-23-2022Round robins are pretty popular with my clients and I'm sure many others - usually used to assign leads evenly across a team when creating deals/contacts in CRMs like Pipedrive, Salesforce, Hubspot etc.While it's quite easy to create them using a lookup table in your Zap, adding/removing/reordering means editing your Zap each time which isn't ideal.I set out to find an easy solution to this - and managed to build a round robin Zap that can be managed directly from a Google Sheet.It's starts with this template:Round Robin Template Column B and C are obvious, and more could be added as needed.Column A is the start of the magic - it marks that person's position in the RR using the

[GUIDE] How to use ChatGPT for Email Parsing Contribution by Troy TessaloneCertified Zapier Expert at Automation Ace.  PurposeEmail parsing using an email parser is an alternative to automating workflows when app APIs and webhook events are not an available option for sending data.Now with AI (artificial intelligence), ChatGPT can be used as an email parser to do email parsing.

Zapier has a referral benefit for partners who participate in the Zapier Experts Program. About the Zapier Affiliate Program Zapier does have an Affiliate Program for approved Zapier Partners.Zapier does not have an Affiliate Program for regular users. You can sign up for a 14-day free trial to try all of Zapier’s paid features.Info about the Zapier free trial. (

Non-instant trigger Zap workflows poll their respective APIs once every 5 or 15 minutes depending what Zapier plan you're on.When multiple new items are found, this results in multiple Zap runs triggering at the same time.This is often fine, but occasionally other apps in your Zap might not be able to handle being inundated by new data all at the same time, causing Zap errors.This happened with two clients of mine:The first has a Shopify store that at peak times can receive anything from 5 - 15 orders in a 5 minute period. One of their Zap workflows creates Trello cards for each order and at times Trello would not be able to handle creating so many cards at once and would throw errors.The other had a Zap that watches quite a busy RSS feed and sends the articles to Buffer. They found buffer would often throw errors when trying to post multiple articles at once.Auto-replay for failed Zap workflows is a great feature, but not suita

I’ve run into this often and have a decent work around so by posting it here hopefully this can help others. The issue: Zapier steps that “depend” on the output from a previous step will fail if the previous step fails or has an issue. This can happen for a number of reasons, like the webhook step had an error, or (and this has been happening A LOT lately) an app like Google Sheets responds with an error like 500 “Server Error time out”. Or a search step fails and you don’t want to create a record Or the application doesn’t give you that option. I want to make my zaps smarter and to work around these issues. As you’ll see below It takes a number of extra steps and paths to do this, so I only do it on critical zap steps or where failures are common. For example if I try to post to a Google Spreadsheet and I get a time out error I want the zap to take a delay and then make another attempt. Or if there was a failure in finding a row o

Hi, Is there any update on the Zapier Certification Program? Would there be like Zap Automation Architect/Engineer/Developer Associate or Zap Administrator or something?I’ve paid for AWS and Azure certs and I don’t mind paying if Zapier has it too.Bubble.io cert is paid. Other platforms are free. Best,

Let's say you want to send yourself a random motivational message each day, and you have a collection of inspirational quotes in a Google Sheet. We want to build a Zap that will trigger each morning and choose one of the quotes to send to you on Slack. Here's how you can do that.First, create your Google Sheet. For the first column, add the header 'Has quote' and have your quotes in the second column. In the first column, add this formula:=if(ISBLANK(B2),FALSE,TRUE)This will return the Value 'TRUE' if there's a quote in the quote column 'FALSE' if there isn't. You can copy this formula into every row - whether or not there's a quote in there now. Add your quote in the second column, and then add a third column called 'Row ID'. This third column will tell the Zap which Google Sheets Row each quote is on, which we'll need.

I’m posting this as a solution as no one else has (as far as I could tell).My use case is below, but this approach will work for anyone who wants to use Zapier to download a file from a URL in an email, i.e. in the email you receive, the file is NOT an attachment but is available to download via a link in the email. Using the Zapier mail parser you can grab that file and use it in zaps to do what you want with the file (e.g. forward as an attachment in an email, save to Google Drive, etc).The basic overview is this:Auto forward email → Email Parser by Zapier → Zap My problem was with Stripe invoices and receipts – I want to auto-forward the invoice and receipt PDFs on to Dext as attachments in emails (Dext automates the receipts getting to my accounting software, automating much of our bookkeeping). As Stripe doesn’t attach the documents to their receipt emails, I have to manually download them and forward to Dext – which, to me, is not a

This post will outline how to schedule Zapier to loop through *all rows* on a Google Sheet. *Bear in mind that Looping by Zapier currently has a limit of 500 iterations meaning this trick will only work for sheets with up to 500 rows of data. Step 1: Modify Your SheetFirst thing is first, you will need to modify your spreadsheet so Zapier has a way to figure out where your last column is and a way to look up each column while in the loop. Here is where ArrayFormula comes in handy! Add a column to your spreadsheet title ‘Row’. This column will fill itself with its own row number when there is a value in column A. If there is not a value in column A then the value will be “Blank Row”.Formula in C2: =ArrayFormula(IF(ISBLANK(A2:A),"Blank Row",Row(A2:A)))Step 2: Head back t

Hi everyone,I don't know if other people have already discovered this but I learned this today from Zapier support and thought it was worth sharing...Normally, when you set up a filter, you have to manually type the value of the filter i.e. the number or text you'd like the filter to check. This isn't great if the thing you want to filter is dynamic and the value is different every time. Wouldn't it be great if the filter let you pick a field from a dropdown menu (a bit like you do within an action step).Well, apparently you can type in a special variable which will get Zapier to pull the correct variable from the appropriate step.I explained this a bit clearer in this video hopefully: https://www.loom.com/share/7408dca840a24a439baff062ac0a586aAgain, not sure if I'm late to the game here. But I thought this was pretty cool!

When text with a single quote ' is passed in a query to an app using SQL (or a similar query language) it can cause an error. This is because strings in SQL queries are delimited with single quotes. So, if a text string in a query contains a single quote, it will end the query early and result in a "Syntax error" or "MALFORMED_QUERY” error. Like this one from Salesforce:How to prevent these errors? There are a few ways to help prevent these errors: Option 1: Replace any single quotes used with two single quotes ''. Option 2: Escape the single quote using \'. Option 3: Remove the single quote if it's not essential to the meaning of the string. Option 3 isn't ideal by any means so let's just focus o

How do you find a phone number or a username in the middle of a string? Sometimes you can use the Formatter Split text function, if the item will always be in the same place, but it’s not always that straight forward. That’s where the Extract Pattern function for the Formatter app comes in. You can find the Extract Pattern transform under the ‘Text’ functions for the Formatter. What it allows you to do is to find and extract patterns in text. The Extract Pattern function uses Regex to find the text that you need. Regex is short for ‘regular expression’ and it basically means that you’re giving a sample format for the step to find. You can learn more about Regex, including seeing a few examples in our blog post: How to Extract Email Addresses, Phone Numbers, and Links From Text

Hey guys!If you're like me, you find yourself testing new zaps and zap ideas constantly. One common problem though, if you are just trying to test an Action, is that you still need a trigger! If you try and test your Action step without a trigger, you'll be hit with one of these: Instead of going through the hassle of setting up a trigger from an actual integration, simply use the 'Schedule by Zapier' utility as your trigger, and keep moving with your Action!You can set it up with any day and any time, so you don't have to waste any time figuring things out, also the test will always work, so it's a very quick fix. It might seem straightforward, but it can save a lot of time. Let me know w

Zapier Status Page Link: https://status.zapier.comGreen is Good! SectionsSystem Metrics: https://status.zapier.com/#custom-metrics-container   App Status: https://status.zapier.com/#app-status Incident

What's your magnum opus of Zapier? A zap that's really interesting and/or a real time saver.For me it's a zap I've built that taps incoming tweets for mentions of Zapier, filters for a bunch of things (did you know, "zapier" means something in Polish) and then consolidates them into a morning digest spreadsheet for me to look at. For added bonus points I've added a path that alerts me on Slack to any tweets that contain a question mark. The idea being that these are people that might need help with Zapier that I can try and convert into customers.I'm interested to get some inspiration from others!

Hey zapier folk,I had the problem that for a customer a Zap has to be executed every two weeks. I would like to present my solution to you and I'am open to alternative solutions or issues I haven't considered. First I used the trigger "Schedule by Zapier" and selected "Every Week" as the event.In a code block I determine the weeks between the current day and the beginning of time (1970 😀). After that I determine with the modulo operation whether the week is even (0) or odd (1). import datetimedate_delta = datetime.date.today() - datetime.date.fromtimestamp(0)return {"continue" : int(date_delta.days/7)%2}Then I check with a filter if the Zap should be continued in even (0) or odd (1) weeks. 

So, I discovered this one by accident and I'm guessing this is a bug, either with Google Sheet's API or Zapier's integration, but I found a way to post a new row at the top of a Google Sheet instead of the bottom.Say you want a sheet with 4 columns - what you need to do is set up a Google Sheet with 6 columns. Important - the 1st column needs to be left completely blank - no header or anything data at all in that column.For the other columns you intend to use, the header row should be left blank.The final column you don't intend to use should have a header - this is so the other columns appear as mappable in the Zapier editor.You'll then want to put a dummy row in:Now try adding a row to that sheet with Zapier:

Hello!In this tips and inspiration part of the community, I'd like to ask you about inspiration. The problem I have is that I do not know where to introduce automation. I certainly can see some proposals in most popular tasks on Zapier website, but too many of them look like the increasing of entropy in my life.Could you please write here about Zap workflows that indeed made your life better? I guess I and readers of this topic will find the inspiration while reading your stories.🙂Beforehand thank you!

When using this trigger you will see the option is "Liked tweet by a specific user":There is not an option for "triggered when anybody likes one of your tweets", which I would imagine is the more popular use case.Then you get to customization and a specific user is a compulsory field:Quick hack: Just insert "@" into that field and you will get all your liked tweets

One of the functions of the Formatter app is 'Spreadsheet Style formula'. It allows you to run the information from previous steps of a Zap through a formula. If you've not used Spreadsheet style formula in a Zap before, this guide walks you through how to add use them: Use spreadsheet-style formulas in Zap There's a whole bunch of different functions that you can add to the formula (this help guide documents all of them), which means that the possible applications for them are almost endless!Is there a particular function that you find yourself using a lot? Or did you create a nifty IF statement that you're particularly proud of? Share your formula tips and show off your creative calculations!

Hi all, if you're a Copper CRM user then this one's for you! Zapier's built-in integration with Copper doesn't support updating custom multi-select fields at the moment. So here's a post on how to get around that limitation, by using webhooks.https://www.optimi.co.nz/blog/2019/10/11/copper-crm-how-to-update-custom-multi-select-fields-via-zapier This gist of our post is this recipe which does most of the work with the native integration and the rest with web hooks:Set up your zap with a trigger and a Copper action stepGet your custom field definitions from the Copper APIHook up the Copper API to Zapier (via webhooks)Add a code step to format your multi-select data