Show & Tell
Show off your Zaps, workarounds, and tricks. Tell others what you’re building with Zapier.
- 279 Topics
- 627 Replies
PostgreSQL Errors for column type "money" - We're having trouble loading 'Primary Key' data
We recently added a column to a PostgreSQL table using the money datatype. This caused our Zaps to stop working and “We’re having trouble …” messages that also state “(Can’t generate DDL for NullType(); did you forget to specify a type on this Column?)” but not the column name.Problem solved by changing the properties of the Columns from Data type “money” to Data type “numeric” (without specifying any Length/Precision).
Announcing Zapier's new logo!
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.
Using loops to update Salesforce records
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.
SQL Server Results (Table) -> JSON -> Google Sheet (multiple line items)
Searched a lot for this but never found the end to end solution, so I’m sharing here. I have a case where I want to send an employee the results from a SQL Server query (table records) on a regular basis, but haven’t been able to piece it together until now. So here’s an overview I hope is useful for someone else out there: Trigger: Schedule by Zapier - running every week. Action: SQL Server - Find row via Custom Query for the results you want(e.g. SELECT * FROM SALESORDER WHERE Employee=”Betty” For JSON AUTO, INCLUDE_NULL_VALUES). - The trick here is to put “FOR JSON AUTO, INCLUDE_NULL_VALUES” at the end of your query. This returns a single JSON field for Zapier as a result and includes Null values (in case you have blanks).- Note: there is a character limit on this JSON field from SQL Server (~for me it was 2000 characters) so beware this won’t work with large tableset results - you’d need to do multiple queries and concat them later in Zapier - the 2000 character limit was enough
Using the "Deactivate Stripe payment link" action for Stripe Beta
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
Odoo plugin date format error
Hi, there are already some topics in the forum dealing with this - and as it seems it is not fixed yet. We did encountered the same problem here - on a odoo self hosted zap with a datetime value we do get object of type 'DateTime' has no len() Part of the payload which is problematic is this one (i think so)<member><name>legal_basis_calculated</name><value><dateTime.iso8601>20220914T08:10:06</dateTime.iso8601></value></member> It seems that a change in the python xmlrpc lib has caused this, because we get this value in the function to_datetime (on odoo side):Got value: 20220914T08:24:05 of type: <class 'xmlrpc.client.DateTime'> And this function does not work with such an object type You can work around on odoo side with this monkey patch import xmlrpc.clientfrom odoo.fields import Datetimefrom datetime import date, datetime, timefrom odoo.tools import DEFAULT_SERVER_DATETIME_FORMAT as DATETIME_FORMAT@staticmethoddef to_datetime(va
Delaying a Zap for a year
Hi Zapier Community,As stated in the title, I’m looking to get an action to trigger after a year. To be accurate, I set up a learning quiz using LearnDash and I’m looking for a way to send an email a year after it gets successfully completed. Because LearnDash works well with Zapier, it would be convenient to find a way to solve my problem using it.Upon reading the documentation from this article, I understand that a delay can only be scheduled for up to a month in Zapier and I should look for another way to do what I want.However, if someone has an idea on how to bypass this or can recommend an alternative solution I would be grateful to hear it.
[GUIDE] How to Troubleshoot Zaps - Top Tips & Tricks
[Guide] How to Troubleshoot Zaps - Top Tips & Tricks To troubleshoot like an expert, try these tips & tricks...Check the Zap is ON. https://zapier.com/app/zaps Check the app authentications/connections. https://zapier.com/app/connections Check the Zap Runs. https://zapier.com/app/history/ Check the Zapier Status page for incidents. https://status.zapier.com/ Check the apps Status pages for incidents. Example: https://status.airtable.com/ View the Zap Details to see the Change History. https://zapier.com/help/manage/history/review-zap-details Does the Zap step have to correct app connection selected? https://zapier.com/help/create/basics/set-up-your-zap-action#connect-your-account Will the Zap NOT turn ON? https://zapier.com/help/manage/organize/manage-your-zaps#understand-zap-statuses Does the Zap auto turn OFF? https://zapier.com/help/manage/organize/manage-your-zaps#understand-zap-statuses Does your Zapier account plan have a valid funding source? https://zapier.com/
How to build a Twitter and Instagram bot
I often find myself exploring faraway places on Google Maps. Sometimes I’ll land on a beautiful natural resource like the Grand Canyon or Half Dome in Yosemite, and I’ll notice a bunch of one-star reviews. Something about people who take the time to leave bad reviews of natural splendor is amusing to me. I thought perhaps others might find it funny as well.So, I decided to find a way to curate these bad reviews and share them with the world. Given I spend most of my social media time on Twitter, I landed on building a Twitter bot that tweets out my favorite of these bad reviews twice per day. I later on decided to throw an Instagram account into the mix since it’s a more visual medium.I am non-technical, so I needed to find a way to do it using low-code/no-code tools. When I dove it, it turned out to be surprisingly easy. Here’s how I did it.Collecting the reviewsThe most manual part of the process is finding and collecting the bad reviews from Google Maps. I created an Airtable spread
Zapier alternative for Coda Upsert
What is Upsert?UpSert is a Coda.io function that permits to OR create a new row OR to update a row if there is a match. I had a working solution for a while based on a Coda Row ID. The logic was like this:A form of Paperform was filled out and via Zapier the data was injected into a Coda table. When the subcriber wanted to update the info (via a link in an email sent via Zapier - > MailJet ) an Upsert took place based on a hidden field in Paperform that I had injected with a Coda Row ID. The creation of the Row ID and how to prefill the Paperform is not the issue here, I guess the reader knows how set this up.Coda and the RowIDWhen a form with a Row ID came back, the uspert took place. The handy thing was that inside Coda we had an automation running that created a duplicate of the RowID column. Due to this automation it was not a formula driven column so we could used it to set up a Match in Zapier. However after a while this solution did not work anymore. I created two solutions
Filters vs Paths vs Lookup Tables: A Visual Guide
Even the most seasoned Zapier user sometimes has a hard time deciding whether to use a filter with multiple Zaps, a single Zap with multiple paths, or a single Zap with a lookup table.We’re trying something a little different and providing a visual guide that hopefully helps to clarify when/why you might choose to use one over the other.Filters Paths Lookup Table Did This Help?FiltersIf you’re trying to have several different outcomes from your workflow, using multiple Zaps with a filter is one way to approach it.Click to enlarge.PathsSimilar to using multiple Zaps with a filter, Paths provide multiple outcomes using only one Zap.Click to enlarge. Lookup TablePerhaps the most misunderstood of all the options, a lookup table is beneficial when you’ve got specific fields that decide an outcome. Click to enlarge.Did This Help?Here in the Zapier community we’re always trying to create resources that are helpful to our members. We’d love to hear whether this helped to make sense of things,
Expert Explains: Scheduled Polling Trigger
Expert Explains: Scheduled Polling Trigger Definition: A scheduled polling trigger frequently fetches data from an origin app for a given event at set intervals. Use in Zaps:With a polling trigger, Zapier will check for new data from your Zap trigger app.The check frequency depends on your depending on your pricing plan, and can range from every 1 to 15 minutes in order to start your Zap.Think of this as Zapier frequently checking to fetch (aka pull) new data from the Zap trigger app for the desired event. (e.g. Contact Created) Example: The Zap will only process if and when new data is found.:00 - Zap checks for new data, but no new data is found, so nothing happens :15 - Zap checks for new data, and yes new data is found, so the Zap triggers and processes :30 - Zap checks for new data, but no new data is found, so nothing happens :45 - Zap checks for new data, but no new data is found, so nothing happens Learn more: https://zapier.com/help/create/basics/set-up-your-zap-trigger#trigge
BEST PRACTICE: Label Zaps with the Unique ID from Webhook Trigger Steps
BEST PRACTICE: Label Zaps with the Unique ID from Webhook Trigger Steps What?If you use the Webhooks (Catch Hook) app event as the Zap trigger step, then this tip is for you! Why?This makes your Zaps searchable by the Unique ID from the Custom Webhook URL. Example
Video | How to Send a Twilio SMS from a Zapier Webhook (+ Twilio Studio Setup for Responses)
Want to use Twilio to send SMS messages / text notifications? In this tutorial, I’ll show you: How to Setup your Twilio Account How to Purchase a Twilio Number How to Connect Your Twilio Account to Zapier How to Trigger & Send a Twilio Message from a Zapier WebhookWhat happens when someone replies to one of your Twilio messages? I’ll also show you how to create a custom Twilio Studio Flow to: Forward inbound messages to your phone number Reply with a custom response to the number that texted you WATCH: How to Send Text Notifications with Twilio and Zapier
How would YOU build a no-code "mad libs" type site using Zaps?
I am aiming to build a no-code site akin to Mad Libs. A user comes in, fills out a form (let’s say name | hair color | city), that data goes into Sheets or Airtable. Then I want to run a job using zaps, where those field entries are sucked up to populate fields in a short story (2-5 pages long). Ideally each generated story would live on it’s own page on my site. Perhaps as HTML, perhaps as an embedded PDF or other doc. How could I do this with Zaps? Would Formstack Docs be best integration? Any clever ideas welcomed, I am learning as I go!
AI: ChatGPT & OpenAI
AI: ChatGPT & OpenAI What: Add AI (artificial intelligence) to your Zaps with ChatGPT and OpenAI. ChatGPTZapier ChatGPT Plugin: https://help.zapier.com/hc/en-us/articles/14058263394573-Use-the-Zapier-plugin-in-ChatGPT-beta- Zap app: https://zapier.com/apps/chatgpt/integrations#triggers-and-actions OpenAIZap app: https://zapier.com/apps/openai/integrations#triggers-and-actions
Bullhorn ATS Zapier Connection - "Cannot read property of 'args' field"
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.
ChatGPT + Levity AI + Zapier: Getting AI to automatically create personalized replies to your interested sales leads
Hey Zapier community! 👋Are you tired of spending countless hours on email outreach campaigns? Well, we have good news for you! With ChatGPT, Levity AI, and Zapier, you can fully automate your email outreach campaigns. 🚀Levity AI is a powerful no-code AI tool that can classify your incoming email responses. Zapier can help you integrate Levity and ChatGPT. And ChatGPT can generate response emails to your prospects based on the prompt you give it through Zapier.Here's how it works:Levity classifies your incoming email responses. Zapier triggers ChatGPT with a prompt. ChatGPT generates a response email to your prospect through Zapier.No more manual email classification or response drafting! With this integration, you can streamline your email outreach campaigns and focus on other important tasks.Check out how Helen Hachtel is taking advantage of this integration to handle email campaigns without lifting a finger and try it yourself! 👉
[GUIDE] How to Trigger a Slack Workflow with a Webhook
[GUIDE] How to Trigger a Slack Workflow with a Webhook CreditsTroy Tessalone is a Certified Zapier Expert at Automation Ace. ResourcesSlack: https://slack.com/help/articles/360041352714-Create-more-advanced-workflows-using-webhooksZapier: https://zapier.com/apps/webhook/help SlackQ: What are Slack Workflows?A: Workflows are automated multi-step tasks or processes that can run right in Slack, or connect with other tools and services. Workflows in Slack can be as simple or as complex as you’d like, and typically don’t require writing any code. How to configure your Slack Workflow trigger... Trigger: Webhook[Advanced]Starts when an app or service sends a web request. Add the desired variables to pass into the Slack Workflow that can be used as dynamic variables in the Slack Workflow steps.Variable type options:Text Slack user email Slack user ID NOTE: Make sure to configure your Slack Workflow actions, and then publish the Slack Workflow. Once you publish the Slack Workflow, a unique webh
Instant Gmail (or Outlook email) Triggers
Triggering Zapier from an email can be an effective way to integrate with systems like Realtor.com, Venmo, Airbnb, or any other app that doesn’t have a Zapier integration yet. Often times, lead response time is critical and all of the Gmail Zapier triggers are scheduled (1-15 minute delay depending on your plan). This walk-though will show you how to set up Gmail forwarding to instantly trigger Zapier (bonus: since this solution uses Zapier Email Parser you may also be able to parse the email content at the same time)*The below guide walks you through how to set up a forwarder in your Gmail account. However, you can set up forwarding rules for all different types of mail clients and the premise of the guide is the same. Here are details on how you can set up forwarding rules with an Outlook account: https://support.microsoft.com/en-us/office/use-rules-to-automatically-forward-messages-45aa9664-4911-4f96-9663-ece42816d746 Step 1: Create Your Parser account and Mailbox- Create a Parser
Active Campaign Trigger off NEW Deals only
Figured this workaround out for anyone that could be struggling with it. Another option would be to set up an automation with a webhook instead of the notification email but AC webhooks only send contact info and not deal information. The below would allow you to set up a notification email that can send deal information which should cover most of the information you could need but if not, you can add a search step in Zapier to pull with the parsed deal title. Feel free to contact with any questions during implementation.***************************Step 1: Set your trigger to Email Parser by Zapier and New Email. Create a Parser account if you haven’t and a new mailbox. Copy the mailbox, should be something like email@example.com. Feel free to rename it if you want. Step 2: Create a new automation in Active Campaign that triggers when a contact enters any pipeline and can run multiple times. This tells AC to run for any pipeline, any time a contact is added. You could filter the
Already have an account? Login
Use your Zapier credentialsLog in with Zapier
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.