About Zapier Community New to our Community? Get to know more about our space and how to make the most of your time here.
Get Started With Zapier New to Zapier? We have got you covered with our Zapier 101 Resources.
Get Support Have a question? Let's get you an answer!
Other Help Resources Wait, there's more! Check out these Community sourced spaces for additional resources.
Zapier Reading All of our best learning resources can be found here.
Learning Groups Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.
Other Learning Resources Some of our favorite additional ways to upskill your Zapier knowledge.
Product Updates Check out what is new and upcoming with Zapier with our regular product updates.
Early Access Program Want to join Early Access? Learn more here.
Hi, All steps that involve Excel are currently erroring in all my Zaps. It's giving the error: The app returned "You do not have permissions to open this file in the browser.". I've 'Tested' and 'Reconnected' Excel in Apps. I've tried creating a new Zap with an Excel step (using both the existing and a newly added Excel connection) and it doesn't produce anything at the 'Worksheet' stage (having successfully selected a 'Spreadsheet'). It seems to be the same error detailed at https://community.zapier.com/troubleshooting-99/connecting-to-excel-is-giving-you-do-not-have-permissions-to-open-this-file-in-the-browser-32095 I've been in contact with Zapier help and they have only been able to suggest that I check the Share setting in Excel but all that seems to do is add an email got shared access or generate a share link a I don't see how that would help. Any help with what to do to get this working would be appreciated :) Jon
Install QuickBooks Enterprise 2024 easily through our step-by-step guide. From downloading the software to setting up company files, we’ll guide you through the process to ensure you design a smooth experience for your business needs you can also contact our experts by dialing us at +1(800) 780-3064 and we will provide you with instant technical assistance.
Intermediate Dev here. I understand the difference between Chatgpt/gpt-4 api’s etc.. I’ve been using GPT-4-Turbo-0409 through zaps but I want to test the leading GPT-4 model. This one costs more according to open ai’s pricing. However when I select it (vs turbo 0409), it does not take the context into account. Context = Formatted Text via Formatting or even a reply from a previous gpt output within the same automationLooking for answers.
i have a zap with a Find Record step in Airtable. the step is set up to create the record if one is not found. for creating the record, i have text in a multi-select field that corresponds to one of the multi-select field options. however, when the zap actually creates the record, it adds both that option as well as a new blank option. i have double checked to make sure i don't have spaces before or after the option i entered. any ideas about how to prevent this from happening? thanks!! (below is a screenshot of my zap)
I have a problem when transferring data from the 'Meeting Ended' trigger in Cal.com to another function, such as sending an email or creating a row in a Spreadsheet. For some reason that I can't understand, the information I want to transfer (in this case, 'RUT') is detected in the Data Out of the first step, but it is not taken in the Data In. However, if I edit the Zapier without making any changes, only having the Zapier run a test with the same Data In, it does manage to transfer the information. In summary: when the Zapier runs automatically, it does not transfer the information; when I run it again from the history, it does not transfer the information; but when I access editing mode and without changing anything, I proceed to test the Zapier, it does transfer the information.Captures from Zapier history: However, when I edit the Zapier, it does manage to retrieve the information and transfer it to the Spreadsheet:
Hello Zapier Support Team,I've been working on setting up a ZAP that involves interactions between two GPT-based assistants followed by updating a Google Sheet. However, I've encountered a couple of issues that I'm hoping to get assistance with.First Issue: Reusing Answer from the First GPT Interaction in the Second InteractionMy workflow involves two separate interactions with GPT-based assistants. The first interaction generates an answer that I need to use as input for the second interaction. I'm having trouble figuring out how to pass the answer from the first GPT assistant to the second one within the same ZAP. Could you provide guidance or steps on how to set this up?Specifically, I'm looking for how to:Capture the response from the first GPT assistant effectively. Pass that response as an input to the second GPT assistant.Second Issue: Specifying Google Sheets Filling to Start from the Third RowAdditionally, I need to update a Google Sheet with data resulting from the interactio
Hello kind forum users, I wanted to ask whether this monstrosity would work.I’m trying to send/save quotations and invoices from our software to specific folders in G-drive, I would like for the zap to create the parent folder (year) and then sub folder (month), based on the timestamp of the file creation.I managed to format the timestamp into YYYY and MM, and I created different paths, based on filename, that contains “quote” or “Invoice”. Then I created a G-drive step, “find folder action, create folder if not found” for the year, YYYY.I Added another G-drive step in a similar way for the month MM, and changed the “parent folder” with the G-drive folder ID of the previous step.AND final step is to add the file to the MM sub folder, based on MM G-Drive ID.The question is would G-drive/Zap be able to dynamically change the ID of the secondary or tertiary step based on the previous step? for example, if it is a new month. Will it just explode?
I have already connected my live Stripe account.But when I go to connect my test account, I can’t find an option to add my test keys. I even accidentally created a NEW Stripe account entirely in my attempt.When I get to the “Select the account you'd like to connect to Zapier” step, I’m given only one account option.Connecting it anyway, I have verified this is my LIVE account.I have even tried connecting while logged into Stripe with “test mode” toggled.How do I get to a step that lets me add my test keys?
Hi,I have a dynamic security group in Azure that is populated with a list of all my current employees. We often need to send out emails to all members of this group, but we need to use MailChimp for that. The problem is that if a member joins/leave this group MailChimp needs to be manually updated, this creates huge discrepancies. I would like to know if anyone has an idea on how to/if it is possible to build this integration. As of now I am able to pull ALL members from of my Azure AD (not a specific group) to Mailchimp. Is there a way to specify which group I want to collect the data from? Also, is there a way to automatically remove members of the list in Mailchimp if they no longer exist in that group? Thank you so much!Victor
Hi Team, I would like to know if it's possible to extract all questions from users who have interacted with the chatbot for the purpose of analyzing the text and creating visualizations in programs like Tableau or Google Data Studio.If you have experience with this, please let me know.Best regards.
Hello team, I am experiencing an issue with loading old messages in my chatbot. I have around 3,000 messages on my chatbot under an advanced plan. When I click the icon to load more messages, the process starts but ultimately fails, resulting in an Error 500 as shown in the image below.Please help me resolve this.
HelloI have this message error. I looked over the forum to find help : Zapier has the permissions to manage webhooks, to send message, to manage roles …. i show you all my tasks. do you have any idea on this troubleshoot error ? Thanks in advance :)
Hello everyone,I currently have the problem that I cannot find the leads using the lead ID. I always get the error that the Lead Id should be a two-digit number, which, according to the answer in Step, can't be the case, can it? Do you have any ideas or suggestions that might help me?Best regardsDennisFind Lead by Lead-IDResponse of Find Lead by ID
Can someone help me with the above errorthe spreadsheet is properly connected -all the rows are properly named and mapped accordingly to the properties in hubspot, but still this shows an errori do have some custom properties in hubspot -which i added as a row in gsheet, is this the reason
Hello Everyone,We are used two tools one is monday.com and second is bill.com(https://www.bill.com/). I need to integrate monday.com and bill.com. If anyone create item in monday boards then trigger to the data insert in bill.com. Can you please help on that or provide best way for that.
Hello,I send myself the completed form from Google Ads via GMail to the customer's inbox. Unfortunately, only the fixed fields from Google (first name, surname and email) are included in the dispatch email. But not the questions about arrival and departure. Where could the error lie?
I have a simple Zap set up:When a new order is created in BigCartel,it creates a form submission in Kajabibasically adds the person to my mailing list.It has been working fine for months, but from yesterday I have been receiving emails advising me there is an error with it.this is the error message:"Trigger partner failure: key.match is not a function"Has something changed somewhere that I need to fix please? Thanks for your help
We are trying to use Zapiers new Tables and Interfaces to create a CRM. We want to automatically bring information in using a ZAP from our lead finding channel. The issue I am having is with getting the phone number to transfer through. Our numbers hear in Australia are always preceded with a “0” i.e. 0448 xxx xxx The format of the phone numbers that are bing passed to us are in this format 0448 xxx xxx but when I send them through to the Table in Zapier it deletes the proceeding “0” and only send through 448 xxx xxx But this then means if we want to use the information out of the tables we are not able to automate anything because we are missing the initial digit in the phone number. I have tried all the Zapier formatting tools but cant seem to get anything to work. Any assistance would be great. p.s. I have alos attempted to use the + symbol and the country code which would work for us but also cant get the + symbol to carry through to Zapier Tables
I will soon be working with someone that wants to set up a Zap using Constant Contact. They have a few mailing lists that need contacts to be added or removed depending on the flow of data.My ‘how to’ question is, can we remove and add contacts from lists using the provided action “Update Contact”? According to the integration page empty values will be cleared so that could also apply to lists. https://zapier.com/apps/constant-contact/integration
Good day community members , I have a table on zapier , which has question “No Of Meetings you want in a month “ , if the number in the table is 4 it should create 4 meetings like (sprint 1 , sprint 2 , sprint 3 and sprint 4) spread across the month. If the number is 5 then it should create 5 meetings like (sprint 1 , sprint 2 , sprint 3 and sprint 4 , sprint 5 ) . What I am doing right now is taking the record from the table , passing it in a loop and creating a event. The issue is that it creates 4 meetings on the same day .
Hello we are trying to upload our zoom recordings onto google drive.But we are having trouble testing the step as the trigger is having trouble collecting the zoom recordings. Zapier is already added into our zoom marketplace and the setups that were prementioned are done.ex. Allow cloud recording sharing” must be set to ON “Only authenticated users can view cloud recordings” must be set to OFF. “Require password to access shared cloud recordings” must be set to OFF.Does anyone have a workaround around this? Or should we put a delay before setting up the trigger? Thank you in advance!
My Instagram to YouTube zap keeps getting throttled, specifically the second step where the video should be uploaded to YouTube. This is my first zap, so I don’t think it could be a rate limit issue right?Would appreciate any help!
I am confused by the way the pricing of the Add-ons is presented. I have asked Live chat support for clarification but they are equally confused.The way the pricing look is the to add-on Interfaces cost $20 /month + Tables cost $20 /month + Chatbot cost $20/month.That is just not competitive in the AI workflow builder landscape!Am I misunderstanding this?
Hi,I have my Airtable connected, running code by Zapier and Detrack account connected to my Zap. All works fine on a single line do_number. However, with a multi-line do_number, only one line uploads. The other lines do not because “Validation Failed: Field do_number is already taken”. The do_number is basically a order number. See screenshots below and any help is greatly appreciated.Each step shows success… This is by Zapier code This is the halt
I believe there was a regression introduced in a recent bug fix for the WordPress action.See this thread: Yesterday, @SamB said that this bug has finally been quashed.However the timing is suspicious as I and others have noticed that since Friday, we were no longer receiving new post actions/triggers with our zaps.https://wordpress.org/support/topic/stopped-sharing-after-update/Could a regression have been introduced in this bug fix?
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
