About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Home
Search

Replies posted by Danvers

3645 Replies

Newest first

Oldest first

FilipefBeginner

asked in How Do I

Can I find and update specific spreadsheets in Google Sheets based on selected persons in Pipedrive?

Hi @Filipef!There are a few different ways that you can do this and which you go with will depend on: how many different service providers you have, if you update them frequently and whether or not the sheets are formatted in the same way (they have the same columns in the same order). Can I also ask how the information is organized in the Google Sheet? Specifically, are there different worksheets for different things? I want to make sure that we have a full picture of exactly how you’ll need this to work. If the Sheets have different columns, you’ll need to use Paths. Paths allow you to split a Zap and run different actions depending on the input from a previous step. In this case, you would have a different Path for each service provider. You can also ‘nest’ paths (have a path within a path), so that would allow you to select the spreadsheet and worksheet that you need for each service provider. There are a couple of drawbacks with paths, first that you will need to a new path each t

Jason SteeleBeginner

asked in How Do I

How do I send information back to an Interface?

Hi @Jason Steele Thanks for sharing your thoughts with us. Interfaces is very much still in Beta, and the product team is actively working on updating and adding to it. I know that they will be really interested to hear your suggestions!

Morgan.DBeginner

asked in Troubleshooting

Monday.com to Excel Zap only adds first column data in new rows.

Hi @Morgan.D, welcome to the community!To troubleshoot this, looking at the Zap history will be helpful. Find a Zap run for the Zap and look at the Excel step. To start with, check that the information is coming in from Monday - if there are empty values in the trigger step then that tells us that something is happening with the trigger.Then, look at the information for both the Data in and Data out tabs. The screenshot below shows what this looks like in a Zap run, the example in the image is Google Sheets, but it will look similar. Starting with the Data in tab, when you look at those, what do you see in the columns that are missing information? Are they completely empty? Do they have something that looks a bit like {{19238423__name_of_field}} in them? It would be super helpful if you could share a screenshot of the data in tab for the Excel step. Don’t forget to remove or obscure any personal or private information in any screenshot you share in the community (eg full name, email ad

TomtidharBeginner

asked in Troubleshooting

Issues with Triggering a Zap in Salesforce - Can't Find Any Matching Records

Hi @Tomtidhar!To make sure we’re on the same page, can I check that you’re using the Updated Field on Record Salesforce trigger?This could be a tricky one to solve without being able to dig into the Zap logs, but let’s see if we can figure it out. The records where the field has been updated, how was the information updated? Was it updated manually (eg typing something into the field, selecting something from a dropdown, etc) or using a button in Salesforce? Also, was the information in the record changed from one thing and then back to the same thing? eg a check box that said no, was changed to yes and then wasn’t found by the Zap when it was changed back to no. Could you share a screenshot of the set up of the trigger and let us know which records the Zap should be able to find? Don’t forget to remove or obscure any personal or private information in any screenshot you share in the community (eg full name, email address, etc). I hope that's clear, please let us know if you have any

aruza88Beginner

asked in How Do I

Google Sheets add update record to SQL server

Hi @aruza88, welcome to the community!So we can best help you, could you please describe what you’re trying to do in more detail? Could you share a link to the Zap template you’re using? And could you explain what you would like to happen eg when a new row is added to Google Sheets, add the information in the row to SQL. If you’re stuck on a specific part of the Zap, or are seeing an error message, could you share a screenshot of that step in the Zap editor? Don’t forget to remove or obscure any personal or private information in any screenshot you share in the community (eg full name, email address, etc). It sounds like you’re pretty new to Zapier, so I recommend looking at some of these resources, which are helpful for Zapier beginners:Zapier Learn customer onboarding course - some lessons that walk you through the fundamentals of ZapierSend data between steps by mapping fields - a help guide on how to setup Zap steps to send information between apps. I hope that helps, please let

asked in Troubleshooting

ChatGPT is cutting off responses in it's outputs.

Hi everyone!If you’re using the ChatGPT integration (as opposed to the OpenAI one) and are seeing prompt responses cut off due to length, it could be due to the time limit Zapier has for returning a response. If it takes longer than 150 seconds for ChatGPT to provide a response, Zapier will post what there is at that point and cut off the rest. If the response is cut off, the field was_cancelled will say true. We do have a feature request to remove the cutoff for the conversation action for the ChatGPT integration. I’ve added everyone on this post as an interested user for the request. That lets the team know how many users want to see this and also means that you’ll get an email when we have an update. In the meantime, if you check out this post, @pieternmnmn and @REXZ Automations have replied with great suggestions on working around this issue by adding steps into your Zap. If any other members find this thread and are running into the same issue, please add a reply to the post abov

asked in Troubleshooting

The chat GPT conversation app does not allow you to set the max token length

Hi everyone!You’ve hit on the reason for this - if it takes longer than 150 seconds for ChatGPT to provide a response, Zapier will post what there is at that point and cut off the rest. If the response is cut off, the field was_cancelled will say true. We do have a feature request to remove the cutoff for the conversation action for the ChatGPT integration. I’ve added everyone on this post as an interested user for the request. That lets the team know how many users want to see this and also means that you’ll get an email when we have an update. In the meantime, @pieternmnmn and @REXZ Automations have replied here with great suggestions on working around this issue by adding steps into your Zap.

BucketplaceBeginner

asked in How Do I

Need Help with Unzipping Files in Google Drive via Zapier

Hi @Bucketplace!You said that you created a Zap that ‘moves these uploaded images to Google Drive successfully, creating separate zipped folders for each room (multiple-file upload field).’ Do you set up the Zap so that it zipped the files, or do they come from Tally as zip files? I can’t think of a way to do this immediately, but we might be able to find a workaround for you - let’s try!Could you please show us a screenshot of the Google Drive action that adds the files from Tally. Specifically, it would be really helpful to see a) what the files look like when they come from Tally and b) how you have that Google Drive action set up. Don’t forget to remove or obscure any personal or private information in any screenshot you share in the community (eg full name, email address, etc). For reference, Looping runs the same series of actions on a number of items. It’s very useful if you have a variable number of things that you want to automate eg creating a new Google Drive folder for ever

ChristianPapaBeginner

asked in Troubleshooting

ChatGPT (2.4.5) error: Failed to create a conversation, the server is currently overloaded with other request.

Hi @ChristianPapa!I’m not sure that I fully understand what you’re trying to do, let’s see if we can figure it out together :) I can see from this midjourney help doc that you can add a /imagine command prompt for Midjourney into Discord. The command will send a prompt from that discord message to Midjourney, which returns an image. Am I right in thinking you have that set up in your Discord?Is that what you want to do:You’re working in chatGPT, working with prompts, etc. When you see a prompt that you want to turn into an image, you want to send that to Discord When the prompt is sent to Discord, it should be sent so that it uses the /imagine Discord command to create the image on your discord server. If that’s what you’d like to do, then that won't be possible, I’m sorry. It’s not currently possible to start a command in Discord using a Zap. We do have a feature request for that addition, if it’s something that you’d like to do let us know and we can add you as someone who is inte

OhYaMarketingNew

asked in How Do I

How can I pull submission date/time data from a SquareSpace form without making the user input it?

Hi @OhYaMarketing, welcome to the community!That’s a great question, and there’s a simple way to do this :) Each time a form is submitted and a new row is created in Google Sheets, you can add a timestamp of when the row was created, effectively adding the date/time of when the form was completed. To add the date/timestamp you add the phrase {{zap_meta_human_now}} to the relevant field in your Zap (ie the corresponding column in Google Sheets). You can learn more about adding the current date/time to your Zaps in this help guide: Insert the time your Zap runs into a fieldOne thing to know about the {{zap_meta_human_now}} stamp is that when you test the Zap, it will insert the date and time using UTC (universal time). When your Zap is turned on, it will use the timezone of your Zapier account (or the Zap if you have set a different timezone for your Zap). So, if the time looks wrong when you test the Zap in the Zap editor, don’t worry. Turn on the Zap and submit a test form to check it.

asked in How Do I

Is it possible to integrate HubSpot with an on-premise Microsoft Dynamics 365 CRM instance?

Hi @Ondrej, welcome to the community!It’s not currently possible to connect an on-premise instance of Microsoft Dynamics to Zapier, I’m sorry. We do have a feature request open for this feature and I've added your vote for this addition. We use these feature lists to prioritise updates to the integrations which we maintain. I don't have an ETA of when or if this will happen, but we will definitely email you if we add it in the future. Thanks!

zapfan1Beginner

asked in How Do I

Setting a value value if a field is great than 0

Awesome! Happy to help 😃

asked in Troubleshooting

New Database Item is the only Option for Notion

Hi @fotoflo!I did some digging into this and the other triggers were built by a third party and found to have a large number of errors, so we rolled back the code as we didn’t want users to try and use something that would cause them a lot of issues. I don’t have an ETA on when we’ll be able to see those additional triggers again, but I have raised this with the team at Zapier responsible for the app so they know that this is something that a lot of users are waiting for. I’m sorry I don’t have better news for you.

asked in Troubleshooting

Issue Creating a Zap Between Interfaces by Zapier Chatbot and SmartSuite Database

Hi @S.U.!I’m not sure if what you’re looking to do is possible with interfaces, currently. I’ll explain how the button trigger works in interfaces and we’ll see if there’s maybe a workaround. With the Chatbot component of interfaces, if you want to trigger a Zap, you need to add an action to the interface.When you add the action, use the ‘On click’ dropdown box and select ‘Run Zap’ That means that when the button is clicked, the Zap will run. Interfaces will then show a button that allows you to create a Zap using that button click as a trigger. When you click on the Create Zap button, a new tab will open in your browser with the new Zap and all of the relevant information filled in. So, that’s how you add a button and trigger a Zap from it, but as you can see, it wont trigger a Zap on the first submission. It sounds like what you need is a chatbot that will use the information from Smartsuite to create the responses. It’s not currently possible to use external sources of informat

LorneBeginner

asked in Troubleshooting

in testing zap_meta_human_now uses UTC but when running it uses the system timezone

Hi @Lorne!I’m sorry for the frustration on this. I did some digging and testing in my account and you’re right. When you test a Zap action with {{zap_meta_human_now}} it will send the time in UTC, but when you turn the Zap on, it will respect the timezone of your account or the Zap (if you’ve set one for the Zap). I can see that we do have an open bug report on this and we’ll update this Community post when we have an update on that. For any other members who find this post, to be super clear, the issue is a difference between the time when testing a Zap step vs when it’s turned on. If you have turned on your Zap and a timestamp like {{zap_meta_human_now}} is outputting the wrong time in an app, check the timezone settings on your account and on the Zap. Then check the settings of the app that is receiving the information to check that everything lines up. If you’re still having trouble with the time being wrong, please post a new question in the community. Thank you!

asked in Code & Webhooks

Failed to create a http request in Firebase / Firestore: Domain did not match expected domain filter `*.firebaseio.com`.

Hi @lynnchin, welcome to the community!This is a tricky one because the ‘Make an API request’ action is so customizable, and every API is slightly different. If you haven’t already, take a look at the Firebase API (I think this is the one you need) to see if you can figure out the error from there. I can see that you’re also in touch with the Zapier Support team. You could ask them to share an example of the API request log with you, which you then share with firebase to see if they can identify the problem. I hope that helps, please let us know if you have any questions

asked in How Do I

Multiple Rss feeds from blogger to Facebook...Please help...

Hi @Luke2023! Welcome to the community 😊With the Create Page Post Facebook Pages action, you would want to add the content of the post in the “Message” field. The url field is optional, for if you do have a link you’d like to share on your page. If you’re not sure what to put in the message or url field, could I ask you to please share a screenshot of one of the items that you get in the RSS field (eg take a screenshot of a trigger test) and let us know which part you’d like to put in the Page post? One quick tip: If you’d like to add an image post to your Facebook page, you need to use the action Create Page Photo. I hope that helps, please let us know if you have any questions!

Patrick HallNew

asked in How Do I

How can I create a Google Sheet by copying an existing sheet and linking it to monday.com?

Hi @Patrick Hall, welcome to the community!You can use the Create Spreadsheet Google Sheets action to create the sheet (copying an existing sheet). When you use that action, in addition to creating the sheet, the Zap will give you a link to the sheet, which you can use in the following step(s) of your Zap. The output of a “Create Spreadsheet” Google Sheets action. It provides, sheet ID, worksheet ID and the Sheet url I hope that helps, please let us know if you have any questions!

AdamCVBeginner

asked in Troubleshooting

MailerLite: Required field "Email" (email) is missing

Hi @AdamCV, welcome to the community!I can see that you attached a couple of screenshots to help us solve this with you, but they look like they haven’t loaded properly, could you try adding them again for us? Thanks!In addition to uploading those screenshots again, could I ask you to take a look at the Zap history for the Zap? Can you see any Zap runs there? Are there successful runs or runs with errors? If you can’t see any Zap runs, that tells us that the Zap isn’t being triggered properly. If there are runs but the mailerlite step is running into an error, take a look at one of those Zap runs and let us know what the error says. I hope that's clear, please let us know if you have any questions!

omarbortolatoBeginner

asked in Troubleshooting

date.equals should be defined, instead was `undefined`

Hi @omarbortolato, welcome to the community!It’s a little tricky to troubleshoot without more information but one thing did stand out in the data that you shared - this one:If you see the name of a field in double brackets like that, it means that the Zap wasn’t able to find the field it was supposed to. To fix that, go to this step of the Zap, delete the existing information in that field and re-add it. The field above is related to a note though, so it doesn’t sound like what’s causing the issue here. So we can take a look at this with you, please could you share:An outline of the Zap (what trigger/actions are there). Which Zap action is running into the error A screenshot of how that action is set up in the Zap editor (Don’t forget to remove or obscure any personal or private information in any screenshot you share in the community (eg full name, email address, etc).I hope that's clear, please let us know if you have any questions! Thanks :)

TLR CoworkingNew

asked in Troubleshooting

Cannot enable Zap: Required field "Profile Image"(member.member.profileImage) is missing

Hi @TLR Coworking, welcome to the community!Let’s see if we can find where this error message is coming from. When you say “The image it is referring to translates perfectly fine into PassKit when doing the test” can I double check that you mean when testing the Zap action it worked? Or do you mean when testing it directly in PassKit (ie not in the Zap)?Could I also ask if the link to the image in the Profile image field is a publicly accessible link? ie can you see the image without having to log in somewhere? Where is the image coming from? Is it from your CRM? And could I ask what trigger or action the image is coming from? I know that’s a lot of questions, but this is one of those situations where a few different things could cause the same error message and we want to help you get up and running as quickly as possible. Thanks!

asked in Troubleshooting

New Database Item is the only Option for Notion

Hey @fotoflo, welcome to the community!There isn’t currently a Notion trigger for an updated database item. I’m sorry about that. The triggers shown in the screenshot were briefly made available and then removed. I’ve reached out to the team responsible for the Notion integration to try and get some more information about why and to see if there’s an ETA on any new triggers. In the meantime, I’ve added you to the open feature request that we have asking for an updated database item trigger. This lets the team know how many users are interested in the feature and also means that we’ll send you an email if we have an update on this.

asked in How Do I

I want to copy information from a multiple selection column from a Notion Item to Category in Microsoft To Do

Hi @handraqui, welcome to the community!Thanks for explaining your question so clearly. The Categories field isn’t currently available in the Create Task action for the Microsoft ToDo Zapier integration, I’m sorry about that. We do have a feature request open for adding categories to the Create Task action. I've added your email address as another vote for this addition - we use these feature lists to prioritise updates to the integrations which we maintain. I don't have an ETA of when or if this will happen, but we will definitely email you if we add it in the future. :)Thanks!

AlexDLMBeginner

asked in How Do I

Text-davinci-003 Prompting Issue

From a Zapier point of view, we’re currently restricted by the models that are available at the different OpenAI endpoints, so I’m not sure if/when that will change. You could ask OpenAI if they are planning to add the different models to different endpoints? I’m sorry I can’t be of more help on that one.

AlexDLMBeginner

asked in How Do I

Text-davinci-003 Prompting Issue

Hi @AlexDLM!You beat me to it - I just found the endpoint compatibility doc. For clarity/in case someone else has a similar question:ChatGPT is a product within the OpenAI suit of tools and it uses the /v1/chat/completions API endpoint, which is a subset (a part of) the entire API that OpenAI provides to access its tools. As you found, different API endpoints have access to different AI models (as shown on the Endpoint model Compatibility page) The Zapier OpenAI integration uses a different endpoint to the Zapier ChatGPT integration because it does more than just chat (you can see the full list of actions available for the OpenAI integration here) which is why different models are available for them. The ChatGPT integration doesn’t currently have the API request action. You can use Webhooks by Zapier to send and receive information from the ChatGPT API, but it requires more work/understanding of thing like sending authorization in webhooks. If you’d like to use the Make an API request

1
2
3
4
...
146

Page 1 / 146

Powered by Gainsight

Terms & Conditions

Sign up

Already have an account? Login

Use your Zapier credentials

Log in with Zapier

Log in to the Community

Use your Zapier credentials

Log in with Zapier

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK

Pricing
Help
Developer Platform
Press
Jobs
Zapier for Companies
Templates

Follow us

Zapier

© 2024 Zapier Inc.

Legal
Privacy