Skip to main content

Home
Learn and Share

Learn and Share

Find and share Zapier tips and tricks, and learn how other people are using Zapier.

676 Topics

Recently active

Most replies Most views Newest first

RonWBeginner

published in Show & Tell

Quirk With Google Sheets Trigger Testing

I just spent the last few hours trying to figure out why updating a cell in a row using a formula did not appear to be triggering my Zap.If you manually update data in a row, the Find Data function in the editor will work just fine.However, if a formula is changing the data in a row, then the Find Data function will not return any data. It just times out after 3 minutes with the "We had trouble finding a sample." error message.At first, I thought it was some kind of limitation with Google Sheets or Zapier. Maybe you couldn't use formulas to trigger your Zap. But that did not make a lot of sense. Several searches did not turn up any information one way or the other.Finally, I tried testing the Zap live. And it worked!Bottom line:If your Sheet is using a formula to update data in a row, and if you are trying to get sample data, it will not work! You have to test by enabling your zap.Not sure if this is a bug or intentionally designed that way, but it sure had me running ar

DanversZapier Staff

published in Show & Tell

What's you favourite way to use Google Sheets and Zapier?

Google Sheets is a surprisingly powerful tool, and is accessible to most people as it’s free!One of the reasons that I use it a lot is because there are a lot of Triggers and Actions for Google Sheets in Zapier. For example, I log Toggl time records there so that I can better analyze how I spend my time, I use it as a lookup table so that I can easily add new lookup items to a Zap and I've helped users who use it as a way of triggering another Zap from individual line items in a list. What Zaps have you built using Google sheets? Share your favourite Google Sheets Zap or workarounds to inspire others!

PaulKortmanZapier Expert

published in Show & Tell

Calling Multiple Zaps via a single webhook call

This was first brought to my attention by @alex in a different post here in the Zapier Community. But I wanted to elaborate on it here as a hack which is even documented by Zapier. (so perhaps it's a tip and not a hack?) Here was the original post where Alex suggested this. Polling quicker than 5 minutes My specific use case is that QuickBooks (intuit Developer) gives only one field for a Webhook URL to call however you can check multiple types of things that will trigger this webhook. (see image below, single endpoint URL, lots of Entities and Actions which will call that endpoint)And since Alex mentioned it and within the system I'm building speed is of utmost importance I dug and found this little gem in the webhook help documentation Webhooks by Zapier - Integration Help & Support | Zapier As it turns out you need to comma separate the IDs from the Webhook URLs for the trigger steps as you see here:That's the tip. Here's more on the practical use-case for me.I

paulminorsZapier Expert

published in Show & Tell

How to use dynamic fields in filters

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!

DanversZapier Staff

published in Show & Tell

How to: adding a Deal in Zoho CRM

When it comes to adding a new Deal to Zoho CRM using Zapier, it’s all in the order of steps: add the Account first, then the Contact, then the Deal. To do that with the updated Zoho CRM integration, you need to select the action ‘Create/Update Module’ for each action in the Zap, so the Zap will look broadly like this: For each step, choose the ‘module’ that you’re creating or updating (Accounts, Contacts or Deals), then select the layout that you’d like to use. It’s important to add the ‘duplicate check field’ as this is the field that Zoho will use to see if there’s an existing entry that needs to be update, or whether it should add a new item. For the Account step, add any details that you need and test the step to move onto the next action. For the action to add the Contact, don’t forget to link the contact to the account by adding the Account name. To do that:1. Use the dropdown to pick ‘Use a Custom Value' 2. For the Custom Value, select the ID of the Account from the previou

AndrewJDavison_LuhhuZapier Expert

posted in Show & Tell

Which zap are you most proud of?

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!

posted in Show & Tell

Recommended combination

Hi zapiers, do you have the combination to recommend just want to do customer care and drive more customers leads, thank you.

AndrewJDavison_LuhhuZapier Expert

published in Show & Tell

Pushcut: Use geofences and iBeacons to trigger Zapier based on location events (iOS only)

I can't claim credit for this, but someone just posted on Reddit - looks pretty cool/useful! r/zapier - Pushcut: Use geofences and iBeacons to trigger Zapier based on location events (iOS only)

AndrewJDavison_LuhhuZapier Expert

published in Show & Tell

Any Apple Music fans out there?

Just found this... looks cool: r/zapier - Apple Music Zapier integration

DanversZapier Staff

published in Show & Tell

Share your fabulous formulas! How have you used the Spreadsheet-style formula function?

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!

DanversZapier Staff

published in Show & Tell

Adding a photo in an email depending on who something's assigned to

This workflow allows you to add an a specific image in an email based on information from the trigger. Let's say you're a small sales team and share an inbox. When you get an new assigned client in your CRM, you want to send them an email from your shared inbox, but you want it to have the signature and headshot of the salesperson that the client has been assigned to. Here's how you can do that...Get your images onlineFirst, you'll need to make sure that you have all of the images stored online. Make sure that they're all the size that you're going to want them in the email. The file will need to end in the file type (eg .jpg, .png, etc). Google Drive isn't great for this kind of thing, because the links that it generates are for viewing or downloading rather than a stored file. In a perfect world, the best place to host the image would be on your own server, if that's not possible then an image hosting service like imgur should do the trick. A g

BlakeBaileyConnector

published in Show & Tell

Testing an Action Zap without Needing a Trigger!

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 what you use in these situations! :)

terbiyBeginner

published in Show & Tell

What Zaps made your life better?

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 Zaps 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!

DanversZapier Staff

published in Show & Tell

Happy Halloween - let's automate some scares!

It's Halloween and we all know what that means! Halloween GIF - Find & Share on GIPHY Well, yes, but that's not what I meant. What I was going to say is that Halloween means that you can't get away from all things spooky, creepy and downright silly. I'm afraid that the Zapier community is no exception: let's hear your ideas for some spooky Zaps!Remember all those times when Dracula has been foiled by an unforeseen sunrise! Not anymore with this handy combination of the Zapier Weather app, a delay step and SMS by Zapier! Every day the weather forecast (including sunset and sunrise times) are generated and then, half an hour behalf sunrise, Dracula gets a text warning him of the impending doom of dawn's light. What alarming automations can you come up with? A workflows for the discerning witch, perhaps? A spooky time-saver for the modern monster?

AndrewJDavison_LuhhuZapier Expert

published in Show & Tell

Good Zapier tutorials (video or blog posts)

Hi all!I'm putting together some blog posts - a roundup of decent Zapier tutorials out in the wild. I already keep a spreadsheet with links to good ones I find, but I'm sure I've missed a few (and maybe some of you want to plug yours).What I'm looking for:Either video tutorials or well-written, good-length blog post guides (with screenshots).Can be beginner, intermediate or advanced level (I'll do a few different posts).Can be focussed on just Zapier or "How to use Zapier + X app to do Y thing".Excited to see what people have! 😀

AndrewJDavison_LuhhuZapier Expert

published in Show & Tell

Easy edit round robins using a Google Sheet

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 formula "=ROW()-1"Notice what happens if you move someone from below the black bar into the RR - the positions remain correct:You'll also notice the count changes - this is achieved using another formula: "=COUNT(A2:A6)"The extra blank black row acts a buffer - when you move rows up into that

DanversZapier Staff

published in Show & Tell

Triggering a Zap from existing items in an RSS feed

It's easy to trigger a Zap from new items in an RSS feed using the RSS by Zapier app, but did you know that it's also pretty simple to trigger a Zap from existing items?This workaround uses a really useful function in Google Sheets called IMPORTFEED, which will import existing items from an RSS feed into your Google Sheet. Here's how you can use it trigger a Zap:Import get the RSS feed link. In this case, I grabbed the one for Zapier's blog: Open a fresh sheet in Google Sheets and in the first cell type =IMPORTFEED("url-of-RSSfeed")Look at the information in from the feed to figure out what column headers you'll need for your Zap. In a new sheet, add the headers. Set up your Zap using the Google Sheets New Row in Spreadsheet trigger, make sure that it's triggering from your new sheet with the header row. Add whatever action you'd like (eg sending the information to a social media scheduling app).Go to your sheet with the RSS feed, make sure

ChrisPConnector

published in Show & Tell

Things NOT to do on Google Sheets that are involved in live zaps

Google Sheets is an AWESOME app, that I use loads. However those of you who use it a lot may have experienced your zaps breaking after someone (maybe a team member or customer) edits the sheet in certain ways.Here is what I do when I set up Google Sheets for customers:I always create a Worksheet at the very beginning titled "Instructions":This is the standard text I use:This may seem a bit draconian, but unfortunately I have run into issues with these with so many different permutations that it's difficult to narrow them down. One of the permutations, for example, related to whether the connected Google account was a standard account or part of G Suite. The devs in charge of the G Sheets zap are clearly trying to limit these issues. I have noticed a shift lately from "named" sheets to ID'd sheets, which I'm sure is part of the process. However, when I am working with clients - prevention is better than cure. I make sure to tell clients that it is tot

AndrewJDavison_LuhhuZapier Expert

published in Show & Tell

Weird hack (or bug?!) that allows you to post a new GSheet row at the top instead of the bottom

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:I have no idea why, but if you test it, you'll end up with this:Test again with different data and it will still add the row at the top:The only possible use case I had for this is if you wanted to have all the rows on a Google Sheet trigger a zap at

AndrewJDavison_LuhhuZapier Expert

published in Show & Tell

Zapier... the backbone of no many no-code business ideas

Interesting Twitter thread going on: twitter Zapier gets a mention in most ideas.Ben Tossell, for those unaware, runs https://www.makerpad.co/ which is a fast growing resource for people that want to build businesses without using code. There are dozens of tutorials and real life case studies on there, many involving Zapier in someway.Anyone here used Zapier to build stuff that isn't for clients/job/core business... i.e a side hustle?

published in Show & Tell

Building a marketplace for backyard, modular homes

This is one of those awesome products that really makes you think about what's possible without code. @calebarclay built this and shared his story on Makerpad on how he did it: https://www.makerpad.co/stories/caleb-barclay-building-a-marketplace-for-backyard-homesTools used: Webflow, Google Sheets, Zapier, AirtableLeads: 3,761 sale leads generatedBuild time: 40-60 hoursI used to have a shipping container for an office so I love the modular homes/studios 😍

DanversZapier Staff

published in Show & Tell

Trigger on rows added to your Google Sheet when your Zap was turned off

If you have a Zap that triggers from a new or updated row in a Google Sheet, and the Zap is off while rows are added to the sheet then it wont trigger from the changes when it's turned back on. Luckily, there's a really easy way to make the Zap 'see' the changes by using the version history of the sheet. Turn your Zap OFFGo to your Sheet. Click file > Version History > See Version History. Choose a version from before the changes were made and click 'Restore this Version'.Turn the Zap back ONGo back to the version history and restore the most recent version of the sheetWhen you do this the Zap will 'see' the changes made to the sheet and will trigger from any rows that were added/updated between the two versions!

nicksimardZapier Staff

published in Show & Tell

Format Multiple Fields in a Single Step (e.g. upper case, lower case, proper case)

Let's say you need to format multiple fields from a step, like the output of an email parser trigger, for example.So you have this coming from your Zap step:Name: NICK SIMARDCountry: UNITED STATESEmployer: ZAPIERAnd you don't want to use a bunch of steps just to get those to be: Nick Simard, United States, Zapier. You can use Formatter to make those into line items, process them all using the formatting option you need, then make them back into text. But that's 3 steps each time, and there's an easier way :)Google Sheets to the rescue! 1) Set Up a Google Sheet You'll need one column per field you want to format.2) Set Up Your ZapIn this example we'll use proper to capitalize the first letter of each word.Notice that the formula goes directly into the field in your Zap, then you map the words that you want to format.3) Use the Output of the Google Sheets StepNow you can use your formatted text in whichever step(s) you need.This is not limited to just forma

AndrewJDavison_LuhhuZapier Expert

published in Show & Tell

Resource: Find invite-only apps on Zapier

(this is a repost from the old Zapier Experts community, so some of your may recognise)Hi everyoneI’ve been playing around with a great tool - https://table2site.com/ - which allows you to instantly create list-based websites using an Airtable as a CMS. I know there are plenty of Airtable fans on here that might find it useful.As you probably all know, not all apps make it public on Zapier and some stay in invite-only mode for various reasons, but are still promoted publically by the apps on their blog and in their help docs.I’ve been collecting details and invite links for these as I find them in a Google Sheet (97 and counting), but I figured a public list might be something that other people would find useful:So, here goes: https://betazaps.luhhu.com

WemakefutureZapier Expert

published in Show & Tell

Run a Zap every 2 Weeks

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. I hope the description is sufficient.

1
...
24
25
26
27
28

Page 27 / 28

Powered by Gainsight

Terms & Conditions

Sign up

Already have an account? Login

Use your Zapier credentials

Log in with Zapier

Log in to the Community

Use your Zapier credentials

Log in with Zapier

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK