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!
I created a zap very similar to yours (twitter mentions to digest sent by email daily) just the day before yesterday and in 1 day it consumed over 600 tasks. I had to disable it.
@Martinewski, it took some trial or error to get the right filters in place to trim it down.
Care to share how did you filter that? Using the twitter query or Zapier Filters?
I'm currently looking after 100+ zaps which can be very difficult unless you are very organised. So I created an Airtable base for every zap with various fields one of which is is the Zap URL so I can quickly click on it to get to the zap.
One of the problems I've had is that I have lots of emails going back and forwards to Zapier support regarding specific zap issues, and searching for the right email for the right zap is a pain.
So very recently I have started putting the Zapier Zap ID No. (in the case above "88888") into the subject line of support emails (can be anywhere in the subject line)
Then I have a field in Airtable "Latest email".
I also have a label set up in Gmail "ToAirtableZaps"
If I label a support email with this it triggers a zap that first goes to a formatter\text step to strip out the numbers in the subject line. It then uses these numbers to search the "Zapier Task URL" field in Airtable (big shout out to
@Openside for helping me with the advanced airtable search syntax) When it finds the row, it updates the "Latest email" field with the URL of the latest support email.
So now when I'm in my Airtable Zap base and quickly need to reference the latest support email on any zap I just click the URL and... automagically.... 😊
Hey folks - just an FYI, I'm going to move this discussion to Tips and Inspiration as I'd love to see it continue to be a source of inspiration for folks! There will be a link to it in Ask the Community, so you'll still be able to find it!
One of My Zaps that i'm proud of is with Pandadoc
It's not the greatest but i liked the idea when it poped up in my mind, so for the ones who don't know what are statuses of Panda documents are (Draft, Sent, Viewed, Completed) there're more, but these are the basics.
So we needed to send 200 Partnership contracts in bulk (through Zapier) and i needed to know the status of each contract but that's not the issue, because you can create a simple zap to change the status in a google sheet with all details for each contract.
The issue was to create a new status which is (SIGNED BY CLIENT)😅, this was a request by the head of Sales department, here i used Zapier webhooks to grab raw data from Pandadoc whenever a receipent complete a contract and i filter it by Template id.
Long story short, i've created a tracker sheet so they can know if this contract is singed by a client ( with contract link), in addition a slack notification will be sent to the sales channel to notify them that this contract was singed by the client so its our turn to sign 😁
I have another Zap between Trello and Pipedrive but this one is a long long story i can tell later
feels great to have a space for all Zapier fans :D
Pretty epic stuff
Awesome examples! I had a hard time choosing, so I'm going to include a few: