Show & Tell
Show off your Zaps, workarounds, and tricks. Tell others what you’re building with Zapier.
- 282 Topics
- 632 Replies
I’m a beginner and this is a relatively simple process, but it took me a while to figure out so I thought I would share in case it is helpful. I have URLs from QuestionPro survey responses that I need to be converted to files and uploaded to DropBox automatically. However, I need them to sort into different subfolders based on the answer to a QuestionPro survey question, which is not in the folder name and we do not want it to be. The question asks what county the survey responder is from, and each subfolder needs to contain a subgroup of counties. In addition, there is a limit of 5 URLs that can be added to QuestionPro, but any number from 0-5 may be added, and all of these need to be uploaded to DropBox. I started with the QuestionPro new survey trigger in order to be able to pull the URLs and the county from each response. I then used the Zapier Formatter - Lookup table function under Utilities. I set the county answer as the lookup key, then typed in every possible county that co
So in my other post I described how I set up a zap which creates a Google Doc from a QuestionPro response which includes the image of the signature by using HTML. The next problem I ran into was that 2 questions in the survey were formatted as tables and particularly long. They wasted a lot of space in the survey response document that was created when they were blank. So I needed to figure out a way to exclude or remove these questions from the response document when they were blank so the document was shorter. I am a beginner, but I thought I would include the steps I went through in case they are of any help. They may not be the most efficient way of accomplishing my goals. Try Number 1: The key words here are “exclude” or “remove.” I started by trying to figure out how I might remove that section of the html if the responses to those questions were blank. I intended to use Zapier formatting to find and remove the html for the blank questions after applying a filter that tests whet
For the longest time, I could not figure out a way to have QuestionPro survey responses upload to DropBox automatically as a PDF. I finally figured out a solution so I thought I would share and include my process in case any of the other steps would be helpful. I’m a beginner in Zapier so these are rough stabs at what I was trying to do. The DropBox zap allows you to create custom text files in DropBox. However, our surveys included signatures which needed to be included in the survey response. Try Number 1: QuestionPro has an email notification function which allows you to automatically send responses as they come in to any email you identify. I started by experimenting with this and having the email sent to the Zapier email, then I used Zapier formatting to pull the html and a HTML converter application to convert it to a PDF. Initially, the HTML converter created one long PDF that was difficult to read, so I used the Zapier Formatter to split the HTML into chunks before converting i
Hi Experts, have you noticed our new logo? We're happy to announce that Zapier has a brand new look. If you're interested in our brand updates, you can read the full rebrand story here . We hope you like our new glow-up as much as we do! If you do, feel free to spread the word by retweeting or sharing our news on LinkedIn. What's next: We'll send you an email on July 20 with the link to the rebranded Experts badges so you can update your website and other marketing materials. In the meantime, relax and enjoy Zapier's makeover. FYI: Nothing about the Zapier platform is changing. Your Zaps will keep running like they always have.
As a follow up to the post I want to share my insights.You can integrate your personal Telegram Account and react on messages / group messages by leveraging the Apify platform, which is part of Zapier, and using the Telegram Scraper. Showing the Last Run of the Telegram ScaperShowing the Output in the Zapier previewDisclaimer: I am the developer of this Apify Actor.
If you’ve ever seen this option in a Filter step:… and you’ve wondered what the heck it is, I’m about to tell you :)The More Complex MethodLet’s say you want to see if a field contains one of several possible values. You could use multiple OR operators, but this can quickly become unwieldy and cumbersome.A Much Simpler OptionInstead, you can use (Text) Is In to check whether the value you’ve mapped is in the list of values that you specify. It’s cleaner, faster to create, and easier to maintain :)Hope this helps!
When trying to connect Bullhorn ATS in a Zap, after almost an entire year of a successful integration, it quit working with the error, “Cannot read property of 'args' field.”Thanks to a response from the Bullhorn customer support team and working with Zapier, the solution was updating my Bullhorn password to not include the special characters %, &, £, #, ? or *. After I updated my password, the connection was enabled again and all zaps seem to be firing. Posting in case this tip is useful to anyone else, as it is not self-explanatory and doesn’t seem to be documented.
[GUIDE] How to Trigger a Zap from a Twilio Studio Flow WhatHere’s a guide for how to trigger a Zap from a Twilio Studio Flow. Zap StepsTrigger: Webhook - Catch Hook This is generate the webhook URL to place in the Twilio Studio Flow Action: (up to you) Twilio Studio FlowsAbout Twilio Studio: https://www.twilio.com/docs/studioYou’ll need to first configure your Flow in Twilio Studio.ExampleTo trigger the Zap, you’ll use this Widget: Make HTTP Request Configure the WidgetSet the Widget Name Or leave a default value Set the Request Method to POST Set the Request URL as the webhook URL from the Zap trigger step Set the Content Type as Form URL Encoded You can leave the Request Body empty Add optional HTTP Parameters Screenshot below shows 3 that would come from a Twilio Studio Flow that is triggered by an Incoming Message (aka SMS) To From Message NOTESZaps Make sure to test your Zap Make sure to turn your Zap ON Check your Zap Runs to help you troubleshoot Twilio Studio Flow
Storage API AppStorage by Zapier Zap Triggers/Actions: https://zapier.com/apps/storage/integrations#triggers-and-actionsHelp Articles: https://zapier.com/apps/storage/help REST API DocumentationReference: https://store.zapier.com REST API Endpointhttps://store.zapier.com/api/records REST API MethodsGET POST PATCH DELETE
How to Hydrate a File with a GET Request to get the File Object WhatYou can use a Webhook - Custom Request (GET) method request to hydrate a file in a Zap. AboutDehydration, and its counterpart Hydration, is a tool that can lazily load data that might be otherwise expensive to retrieve aggressively.More Info Related Topic: Dehydration Example Output Variable to Map CreditsTroy Tessalone is a Certified Zapier Expert at Automation Ace.
Hello guys, I saw a post that talks about the same issue that I had, so I tested many stuff to make it work. The issue is that the RSS feed blog post’s image or thumbnail not showing on linked in on the Private profile, the company page it has already an option to show image so we are talking about the private profile here. The steps are: Create your 1st zap’s trigger like this: Trigger RSS > Select your social media > Action > Twitter (its working on twitter without any issue, thumbnails appears) Create a 2nd zap’s trigger: Trigger twitter > action > linked in > set up action: select Entities urls expanded url Basically you are telling zapier to share your blog post on twitter then to take post from twitter and share it to linkedin.
What to do if a Zap app doesn't have the trigger or action you are seeking? Zapier ExpertsOften apps only expose their most popular/useful API endpoints (triggers/actions) and webhook events (triggers) via their Zap app integrations.However, the app trigger or action you are seeking may still be possible to configure by using an app’s API or webhooks.Integrating and automation with app APIs and webhooks is an advanced approach that involves technical concepts.For help configuring, consider contacting a Zapier Expert: https://zapier.com/experts Zapier SupportYou can submit a ticket via Zapier Support for the requested trigger/action to be logged in hopes that it will be included and made available in a future version of the app’s Zap integration.FYI: Most apps on Zapier are built and maintained by the app developers themselves, but Zapier keeps an internal list of app requests. WorkaroundsEmail parsing Parse emails for data points to trigger Zaps CSV files Upload CSV files to trigger Z
Looping by Zapier rocks -- what did I do before I discovered Looping by Zapier?I typically would create an Airtable base with a field called ‘Loop Status’. I’d then build a Zap workflow which started with a hook and ended with a hook that pointed back to the first hook. Then I’d trigger the loop via a call from Postman.Convoluted.Now, I build Zaps using Looping by Zapier and smile.
Zapier is great platform to use to take data from different lead sources and create follow up tasks or contacts in your company’s CRM. When creating these records, you can often assign the contact or task to a specific staff member so that they are in charge of the lead. But what to do if you have multiple employees working on leads in your company and you want to have a way to evenly distribute the leads as they are entered into your CRM or route them by email? This tutorial will walk you through an easy 1 step round robin set up using Storage by Zapier and Code by Zapier. Step 1: Authenticate a storage by Zapier account. Never used storage by Zapier? No problem! It’s a breeze to get set up. Head over to your Zapier App Connections Page: https://zapier.com/app/connections Click on ‘Add Connection’ then search for ‘Storage by Zapier’. A new window will pop up with a prompt to enter your store secret. You can use a UUID generator for this: https://www.uuidgenerator.net/version4. Make no
So read a few people have this problem.I wanted a monday board that everytime it updated to only show the list of ones with the field “ready”. and when that changed to “closed”. delete it.That sheet is then viewed by people. But looks a mess with all the gaps from deletions I wanted to share a work around.I made another sheet using the importrange feature in sheets to pull all the data into this new sheet.Set up a filter on all columns and rows. remove blanks from one of the filters.There you now have a clean list. hope this helps someone in the future
If you run out of inventory for a product, you might want to deactivate any Stripe payment links for that product until you replenish your stock. You can do that automatically by using the Stripe (Beta) app on Zapier. The workflow idea below suggests using a spreadsheet as the starting point. I’d use it to track the inventory automatically for each new order, so that I can know if it reaches zero. Zap 1Set up a Zap to trigger on new payment links on Stripe. Send them to a spreadsheet, alongside product details (so you can search for them later). Zap 2Set up a Zap that triggers on another spreadsheet where you keep track of inventory (or another app that can track inventory, like Shopify). Make sure to have details that can be matched to the spreadsheet on Zap 1! Add a Filter step to check if the inventory has reached 0. The next step will search for the product in the spreadsheet attached to Zap 1 and return a payment link related to it. You can then use the “Deactivate a payment li
How to get the CSV Version of Excel/GSheet (XLS) File using GDrive Did you know GDrive automatically makes a CSV version of an (Excel/GSheet) XLS file available? Simply search for “text/csv” in the returned response data of the GDrive Zap step!
Set Attachment Filename with the Airtable API (PATCH) PURPOSEUse the Airtable API to make a PATCH Request that will set the filename for a new file in an Attachment type field. PREPGet your Airtable API Key: https://support.airtable.com/hc/en-us/articles/219046777-How-do-I-get-my-API-key- Get your Airtable Base ID: https://support.airtable.com/hc/en-us/articles/4405741487383-Understanding-Airtable-IDs Get your Attachment type field name. NOTE: If you change the name of the Attachment field, then the Zap will break. NOTESThis can only be used to create new files in an Attachment type field. Cannot update existing Attachment file names. This will replace existing files in the Attachment field. Review help article with how to send files in Zaps: https://zapier.com/help/create/basics/send-files-in-zaps CONFIGFor the Action step App, use Webhooks: https://zapier.com/apps/webhook/help For the Action step Event, use the Custom Request option Set the Method to PATCH In the URL Replace [APP_I
Mod Edit: 03-29-2023TIP: 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 email@example.com, then you can:Sign up for newsletters with firstname.lastname@example.org. Let prospective clients or customers contact email@example.com. Allow team members to surface urgent issues in your inbox by contacting firstname.lastname@example.org.You can even combine these addresses with filters to automatically label and sort your messages. (read more below)For instance, filters can automatically archive and apply the News label to all incoming newsletters sent to
Hi,I’ve successfully connected my SQL database (new row detected) to create a new row in a gsheet.My SQL Db is updated in batch, so a dozen or so rows are created at once.The zap then run X amount of time to add rows in the sheet. Is there a way to do a batch that would zapp all rows at once and save up on the numbers of task ?Maybe with a utility which would act as a tampon ? Thanks
As far as I can tell, there are scant few QR Code generating apps that integrate with Zapier.I wanted to generate static QR Codes. i.e., I don’t need them to link to a website that can then be redirected later.I wanted to generate LOTS of QR Codes. Which made this model fundamentally incompatible with a service that limits you to a couple hundred codes a month.So I made a really really simple app that uses the “.toString()” function of node-qrcode to generate codes. They work fine as long as it goes into a fixed-width font with zero space between the lines. Perfect for using with a Google Docs template. I’m pretty sure you could get this into an email as well.I don’t really have time to dedicate to supporting this, but here’s the private integration link: https://zapier.com/developer/public-invite/156999/3eedef2f10cb6f2f0f2beeff204733de/Here’s a screencast with Google Slides (I use 8pt Courier in this demo.)
Log in to the Community
Use your Zapier credentialsLog in with Zapier
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.