Show & Tell
Show off your Zaps, workarounds, and tricks. Tell others what you’re building with Zapier.
- 253 Topics
- 594 Replies
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
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 to Zapier and start setting up your zapIn this example, we will have Zapier run once a month on a scheduler (shown below)Once you’ve got your scheduler set up, step 2 of your zapier integration will be to look up the first
If you are using Airtable and integrating it with Zapier, then you always had the Line Items support problem! In this quick guide I will show you some cool tips and tricks on how to use the Line Items with Looping by Zapier. Previous Issue: A lead comes over from another app (or even from Airtable) and you want to send a text message to 5 of your Sales team so they can process this lead. There was no way to do that in the past (specially before the Looping by Zapier). Current Solution: Setup your Trigger to get the new lead from Airtable (or any other app you are using) Create step “Find Many Records (With Line Item Support) in Airtable” (Finally!!!) to find all Sales people in your Airtable. You will then get all the records that matches your search criteria (you can even use a formula to add more than 1 criteria) Create step “Create Loop From Line Items in Looping by Zapier” . In the “Values to Loop” part, add whatever values you will need from Step 2, such as Name, Phone Number,
GUIDE: Use Google Mail API to Create personnalized email to cleaning lady on Airbnb, Booking.com, HomeAway RESOURCESGoogle Mail Integrations :https://zapier.com/apps/gmail/integrationsZapier formatter :https://zapier.com/apps/formatter/integrationsZapier filters :https://zapier.com/help/create/customize/add-conditions-to-zaps-with-filters CONFIGUse the Gmail app in the search way in the email received fro your OTA Action Event: Custom Request in order get the information about the date of guest in the mail Method: In the Body plain field, get the several data about the arrival and departure date of the guest with the function Truncate Filter the zap with the function Only continue if with a filter on the date of the day and the date of the departure of the guest Send an automatic and personalised email to the cleaning lady with the information of the date of the departure of a guest
GUIDE: Use Google Mail API to Create personnalized email to Guests on Airbnb, Booking.com, HomeAway RESOURCESGoogle Mail Integrations :https://zapier.com/apps/gmail/integrationsZapier formatter :https://zapier.com/apps/formatter/integrations CONFIGUse the Gmail app in the search way in the email received fro your OTA Action Event: Custom Request in order get the information about the guest in the mail Method: In the Body plain field, get the several data about email and name of the guest with the function Find, Sub numbers and Truncate Formatting the data with the function Lowercase and Capitalize Send an automatic and personalised email to the guest with the data information
GUIDE: Use Calendly API to Create Single-Use Scheduling Links RESOURCESCalendly API Personal Access Token: https://developer.calendly.com/how-to-authenticate-with-personal-access-tokensCalendly API Endpoint: https://calendly.stoplight.io/docs/api-docs/b3A6MzQyNTM0OQ-create-single-use-scheduling-linkWebhooks: https://zapier.com/apps/webhook/help CONFIGUse the Webhooks app Action Event: Custom Request Method: POST In the Data field, replace the [uuid] with your Calendly Event UUID NOTE: You can find this by testing the Calendly Zap trigger for Invitee Created In the Authorization Header, replace with your [PERSONAL ACCESS TOKEN] Tips and Inspiration contributed by: Troy Tessalone - Automation Ace
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.
Hey everyone! Shane here from Zapier Support. If turning off the Alerts isn't practical when you receive a duplicate error for your Salesforce setup, you can set up a custom condition to bypass the duplication rule. First, ask your Salesforce Administrator to create a custom field on the object(s) that you would need to send to Salesforce. We suggest calling this field Zapier Submission as a Boolean type. From Salesforce Setup, use the Quick Find box to find Duplicate Rules. Click on the rule name for the object you'd like to edit (for example, Standard Lead Duplicate Rule). Click Edit. Under Conditions, select the newly created field and set up the operator to not equal to a value of “True”. Repeat for both the lead and contact object. (view larger)Set the value for the “Zapier Submission” field in your Zap to “True.” (view larger)Any lead or contact sent to Salesforce will now be excluded from the duplication rule and allow you to keep the alert turned on.
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
We can now have up to five Paths in a Zap but, there are cases where five isn’t enough. And the thought of having to set up duplicated Zaps to handle more than five Paths isn’t ideal. It would be much easier to handle everything in a single Zap, right? That’s where the magic of using nested Paths comes in. Why use Paths and not a lookup table or Filter? Creating the Main Paths Adding the Nested Paths Name your Paths Further Reading Wrapping up!Why use Paths and not a lookup table or Filter?Well, let's say we want to trigger whenever someone enters a different stage in HubSpot. And we want to carry out different actions depending on the stage they're in. It's a simple enough workflow, but we’ve got a custom Lifecycle Stage set up with 10 different stages. Using a lookup table wouldn’t work here as different actions need to run for each stage. And we don’t want to use Filters as we'd have to set up 10 Zaps, one for each stage. We want a single Zap to handle it all. Paths is great for h
Hi everyone,I have recently answered a question about finding a zap that is associated with a webhook URL without having to open every single zap to look for which one contains the webhook URL. So I wrote a script that can actually scan all the zaps and then outputs the zap URL that is associated with webhook URL provided by the user.This obviously requires the user to open the Browser dev tools then paste the script and replace the webhook URL before executing the script. I thought this had to be simpler, so I went ahead and built an open source Chrome extension for it.I hope this can be helpful for anybody who might need it.LinksThe script: https://gist.github.com/ikbelkirasan/601dd8a51f458bf09d5ce44a102b9fd0The extension repository: https://github.com/ikbelkirasan/zapier-utils
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.
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
On more than one occasion, I needed to delete the data in a single Google Sheet cell. But as noted Common Problems with Sheets article, this is not possible. The only option is to enter some sort of visible character or delete the entire row.However, I found a simple solution. Just go to emptycharacter.com and click on the Copy To Clipboard in Method 1 and then paste the invisible character into the column of Update Spreadsheet Row action for the cell that you want to blank out. A small red dot should appear, indicating that there is a character there. (The dot may not always appear, but there is a character there.)Run the zap, and the cell should be empty.
How to Hydrate a File with a GET Request 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 Example Output Variable to Map
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.
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.
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.