Post here if: you've run into an error, have found a bug, are experiencing problems, and/or things are generally not working properly.
- 3,852 Topics
- 17,630 Replies
Microsoft Excel error: The app returned "The argument is invalid or missing or has an incorrect format."
Hi everyone,I have a simple thing but Zapier runs into an error. A litte bit more context: I have a Pipedrive list with deals that are closed by partner. I want to calculate the commission automatically and added some fields in Pipedrive for it. This all works fine.Now, for convenience reasons, I simply want to add the Deal Link in the Excel spreadsheet aswell to quickly navigate to the corresponding deal in Pipedrive right from Excel. If I add the link in the table like below, the link is posted in the Excel file but its not “clickable”. You have to manually enter the cell and press enter to activate the deal link. So I looked up the =HYPERLINK function and changed the Deal Link accordingly: But now the zap runs into an error: I did a test: If a add a blank space before the equals sign, the zap works and pastes the formular in the cell but it is not working because of the blank space, obviously :-). So I guess it has something to do with the equals sign. But I can’t figure out how to
Hi community,I got an error from trying to create a database item in Notion. Here is the error:body failed validation: body.children.code.language should be `"abap"`, `"agda"`, `"arduino"`, `"assembly"`, `"bash"`, `"basic"`, `"bnf"`, `"c"`, `"c#"`, `"c++"`, `"clojure"`, `"coffeescript"`, `"coq"`, `"css"`, `"dart"`, `"dhall"`, `"diff"`, `"do... Couldn’t figure out what’s going on - anyone knows what might be wrong? Thank you!
The Zap was working prior to yesterday but has since quit working. The path is pretty simple as its just Webhook → Google SheetI can see the data saying in the Data out of the Google Sheet action but not seeing it show up in the sheet itself. Does anyone have the same issue?
This is about submitting a Google Form, and then it sends response email to firstname.lastname@example.org, and then forwarding it to another email email@example.com, and setting Reply-to to Google Form’s respondent email(firstname.lastname@example.org) Ex: https://zapier.com/editor/182467301/published/182467302 As per the above Zap, the email is sent with Reply-to (Google Form sender's email), but the final email (email@example.com) doesn't contain the Reply-to email (field/value, firstname.lastname@example.org)
Hello, What causes Zapier to see a ticket in ConnectWise Manage as “New”? When I have a ticket as “New” status, it does not trigger. Otherwise, changing the trigger to “Update” will work if any change is made to the ticket but this is not preferable for my use-case. I’m using the built-in status of “New”, but the below ticket was not triggered. ConnectWise Ticket Status and BoardZapier Trigger
I have my Zapier setup that everyone who calls or messages me on open phone gets added to my OpenPhone Contacts. I made sure to setup the unique ID on the Action Part however whenever a person messages/calls me, instead of updating their existing number/contact - it creates a completely new contact entry on openphone instead. TL;DR Openphone creates a new contact everytime irregardless if a unique ID has been filled in.
I cannot get a zap to add a row to the bottom of our jobs sheet, the trigger is when an esign document is completed. this was working for a while but now it keeps adding it to the top throwing off many other dependencies built in. Yes i have modified the sheet while the zap was on, but now i just created a new zap and have not modified the sheet and its still adding a row at the top…..please help many automations and triggers are based on this and this should be a simple zap.
This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.Hi everyone! I am trying to use the “New Row in Microsoft Excel” to trigger “Creating a Card Widget in Miro”.I completed the connectivity steps, and I tested the “find a row”. However, when I test Sending a Card to Miro, the test says a card was sent but there’s nothing showing up in the Miro Frame that I’ve designated it to go. I’ve attached two screenshots of my setup details for the actions.Any help you could provide would be great, thank you!
Hello everyone! I’m trying to publish instagram posts from a google spreadsheet and am having trouble with the image. I’ve tried both inserting the image into the spreadsheet and adding a public google drive link. In both situations, I get this error: Any advice?
Failed to create a file in Dropbox RequestId: c19eb0ff-2244-4b02-8322-c279b440a036 Error: Runtime exited with error: signal: killed
Hi! I’d like to upload a new video recording file from my Zoom account to our Dropbox account. The zap I’m using is actually from Zapier’s pre-made zaps and I just connected it to our Zoom account. The tests worked fine but today, it seems the video recording can’t be uploaded to Dropbox. I have no problem with the audio file, though… and the steps for video upload and audio upload are the same, it’s just the file to upload that I’ve changed accordingly. This is the error I get when I tested the video file upload step today:Failed to create a file in DropboxRequestId: c19eb0ff-2244-4b02-8322-c279b440a036 Error: Runtime exited with error: signal: killed I hope I’m making sense. Can someone help me? Thanks in advance.
Authentication failed: The app returned "API key is invalid, please get a new one from your user dashboard at writesonic.com
I am getting the following error message. We hit an error adding your new accountauthentication failed: The app returned "API key is invalid, please get a new one from your user dashboard at writesonic.com".Make sure you click "Allow" or "Accept" on the permission popup Double check your Account has the correct permissions Check out our help docs for more information I copied the API key directly from my Writesonic account.
Hi!How can I create a Zap where it connects Apollo.io and Salesmate by updating contacts in Salesmate when a contact is updated in Apollo? I’ve tried though the following steps:Trigger: “Contact updated in Apollo” Action: “Search or Create a Contact in Salesmate” Action: “Update Contact in Salesmate”The one I’m having issues while testing is the 2nd action; “Search or Create a Contact in Salesmate”. Thanks!
well, bookfunnel has both an epub and a “kindle epub” inline and locked and loaded. Is this a naming convention issue? The book is “I, Woman” that I’m trying to download to the reader, but the SKU is “woman - digital - 1” Just a wild guess but should I be using the SKU as the variable?
This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.Hi together! Yesterday, I booked a starter package on my wrong email-adress: email@example.com - with a dot between the names. It should have been in firstname.lastname@example.org - without the dot.My marketing agency did a lot of work before with the address without the dot. How can I fix it?Thank you for your help!Inka
I have selected "Any Form" for Facebook Lead Acquisition Ads, but some form data is not being transferred.
When implementing Facebook lead acquisition advertising, we would like to transfer all form lead data for any Facebook page.I have selected "Any Form" to transfer all data, but only some forms are not being transferred.Is there some procedure I am missing?
I have a pretty easy zap setup. It reads fields from Survey Monkey then writes them to Salesforce.Everything is working fine, except it sets the owner to group: UnassignedAnother post said that their zap was triggering the case assignment rule, so I set our assignment rule to not trigger with my account (The one the zap is using). This did stop the case from being set to NEW, but it is still setting the owner to Unassigned. Anyone else experience this issue? I was very excited to have zappier take away this manual task, but it takes just as much time to go in and change the owner back.
My goal is for Zapier to find a Notion item based on a date field called “Expiration date”.Within the Zap, I am given 2 options that are pertinent to the step: Expiration date filter (of which I can choose from the following options: before, after, equals, on_or_before, etc) - set to “equals” Expiration date (actual value of the field) - populated as today’s date.Each item in my Notion database has a unique value in its “Expiration date” field, so ideally, this step will search for the item who’s date is today. I’ve already setup steps earlier within the zap to determine today’s date and format it as YYYY-MM-DD, and it outputs correctly. The problem is that when the step tries to find the the item with a date matching today’s it returns no results even though there is most definitely an item that exists and matches. Does anyone know why this isn’t working? When I set the date filter to “on_or_after”, it pulls up the item for tomorrow, but it doesn’t find the item for today, but it find
I’m trying to create a Zap where a person completes their survey in survey monkey and that marks them as “passed” in the course registration in Arlo so that their certificate for completion is automatically sent when they are marked passed. (second image) The Zap works if I create a new Zap for every single survey, but that’s not feasible. I was told that I had to use the same survey for each course, which I did, but each course still has a separate “web collector” for each course (image below) which sets me up to still have to create a new Zap for each web collector. I’m just wondering if there is any workaround for this?