Find answers to your questions. Ask the Community for help or hire someone to help you.
HI, I'm really struggling to send the result of a formula in a gsheet into a gslide. It seems that zappier doesn't know how to read the result of a formula in a gsheet. Writing the formula in the zap is quite impossble cause I've a lot of formulas with reference to several sheets (vlookup) etc.. Is there a quicker way to let zappier take the result of the formula in my slide ?
I am trying to get my Zap to execute a stored procedure on a remote SQL Server. The stored procedure stores a new row in a table using a list of parameters. Everything works fine - except that I can’t get to commit the transaction. I can execute the SP using the “Find Row via Custom Query in SQL Server” function in my Zap, but it doesn’t commit. It connects, and works, since I get a return value that has the correct new row ID, but the transaction is never committed. The query in my zap looks like this: BEGIN TRAN EXEC MyStoredProc Param1, Param2…… COMMIT TRAN but it never commits. Is this perhaps because the whole Zap function is a read-only transaction? - wouldn’t I get an error message then? Is there any other way of achieving what I’m trying to do?
Is there anyway to do this, without using paths, because I don’t want to have to recreate and duplicate all the steps beyond this point. Over simplifying here: App 1 has 3 fields, A, B, C App 2 has 1 field D Field D is filled with the contents of A or B or C depending on certain conditions. Sort of like a spreadsheet equation. =if(A=apple, then D=Apple) & if(B=Banana, then D=Banana) & if (C=coconut, then D=Coconut) I don’t want to use a filter because I want it to continue no matter what, even if A was blank Thanks!
[Salesforce App] Could not create record of the "OpportunityLineItem" object: We're not able to use this object type
I am using Salesforce app (não the Legacy version) to add an Oportunity with products associated. While testing i got this error: Could not create record of the "OpportunityLineItem" object: We're not able to use this object type. Please use the help link below to contact Zapier support for more information / assistance. I cant understand if there's a real error or that functionality is not implemented.
I can not connect my wordpress account, it was working untill this morning. When the authentication runs, it appears the message: not well-formed (invalid token): line 1, column 1 I checked the remote publishing checkbox in Wordpress and deactivated all WP plugins and still not functinioning. My blog is out of air, since yesterday since i can´t load any new zaps that capture news from other sources. This matter is urgent, if someone came across this issue, please help me out!
Pretty self explanatory :) I need someone to help me create a simple zap that adds Dave Ramsey Real Estate Leads to my CRM (KVCORE). Dave Ramsey Leads to no come in on a major platform. So I have no clue how to go about creating this!
Hi all, I have been looking on the community for a while, but couldn't find what i need. So may'be someone knows the answer for me. The case is: I run an query on an API request. That's working fine. But sometimes i have 1 result, sometimes multiple results. What is good. (For your perception: i make an call to the APIv3 of HubSpot and i am looking for deals what are 20 days in the past are set to an certain dealstage) Someday i find 2 deals, sometimes i find 8 deals. Now i want to send to the deal id's that i find the same e-mail. How do i run this? Because if i have 1 results than it’s easy for me. But by multiple?? Do have first store them in google sheets? I need some pointers to use, i am on the 50k zap plan of zapiers so anything is possible. The result of the query is data field with al deal id's in one line the a comma between it. So i need for every deal id a zap send an email as a single starter. ( the deal id is the only thing i need, with other API calls i make my emai
Aloha, When a new user is added to a Wordpress site a record is created in a Knack database. This record is accessed by an APP to verify the user. In the field for password I do not see the field to add the password field to Knack. All other fields are available.
Discussion: Does anyone know of a functional CRM that can handle a sales pipeline AND project management? It seems that only one or the other exists. All of our sales turn into projects, and the projects take anywhere between 6 months to a year. I need a CRM where I can manage both. Robust reporting would be ideal, as well. Am I asking for too much?
I am trying to set up a paid section in my discord channel. I am looking to add a reoccurring subscription button linked to paypal. When the customer signs up for the subscription service and competes a successful sale in paypal then zapier would assign them a premium role.Any help would be greatly appreciated.
Hey there, I was wondering how can I make zapier to automatically push google sheet row values to the pinterest? I did the integration, but for some reason the zap isn’t working unless I do the manual retest & continue. Am I missing something? Do I need to set up scheduler or any sort of webhooks? Thanks
Is there any way for a user who is reading a multi-paragraph text in Chrome to select parts of that text - ie. Name, Comment, Location - and send them to Zapier as fields? Input text would not be in a uniform format, so parsing rules are not an option. Presumably, it would need to be something in Chrome that allows me to point at different parts of the text and then send it off. Or maybe it’s an extension that lets me create a CSV out of the pointed-at fields, which I can then send to XZapier.
Hi I create a Zap that when I received an email from gmail with an specific Subject it create a Quick event in Google Calendar with an specific name. It was working great for a month and now sometimes it work and most of the time Im getting this error : Google Calendar: The app returned "Required parameter: text". Any idea what could be the problem? Thanks for your Help!
I have created a Zap to connect QB and Salesforce. In the organization, QBs, the donations are added as deposits. There is only an event for payments in Zapier. The created Zap did fire but no opportunity was created (although the contact record shows a modification) Has anyone experienced this before? If so, were you able to workaround this issue? Thank you.
I’m attempting to create a new Zap which creates a new Deal in ActiveCampaign when an order has been placed on an ecommerce site hosted by BigCommerce. However, I can’t get past the test stage and keep getting error 422. The full error message states the following: “The app returned "Invalid currency provided. The length must be 3. e.g. usd, gbp, aud or cny.". This can occur if the information entered into a field is not in the correct format. Double-check that you are using the correct format for entering values into a field. We made a request to zapier.app-us1.com and received (422) Nginx/1.16.1.” The values I has tested are “USD” and “usd”, but both are rejected as invalid. Any ideas?
Hi, My zap should trigger when I make a sale with JVzoo and it creates a goal in Google Analytics. This used to work well, until about a month ago. Google Analytics doesn’t display anything, not even if I make a test. My other GA goals made without Zapier works well. Once I got this error via email, very likely this is the issue: Google Analytics: Quota Error: You have exceeded the maximum number of writes/day for this project. Task history recorded my tests as success, but GA goals displays nothing. Thanks
When my google slide presentation is generated, the custom fields are not being populated correctly. My Airtable formula populates it with a ‘.’ if the field is empty, however this is not happening as you can see in the attachment. I know the Google Doc zap has the ‘remove’ feature, but that doesn’t work (instead it replaces the custom field with the word ‘remove’?) . The Google Slides zap doesn’t have this feature at all? This is why i am resorting to populating empty fields with a fullstop.
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.