Find answers to your questions. Ask the Community for help or hire someone to help you.
Hello!I´m having difficulties achieving the automation I want.This is the scenario: I have a google sheets document. One of the sheets are updated hourly with Pipeline API. The data I´m importing is always just a total amount accumulated over time. What I want is to divide this amount in weekly amount accumulated. So I want to know what the total was in each week. I don´t want to know how much the total increased each week, but how much the total was accumulated in each particular week. So say it´s 4 this week and next week it gains 2, then I want the row for next week to show 6 and this week to still show 4. Now I have my sheets document set up like this:Week Number Amount=isoweeknum(today) “Link to the cell in the sheet that is automatically imported” So what I want to do with Zapier is: Every monday at 2 am replace the formula in the bottom row with the actual data. And then at 3 am add new row with the same formulas. The adding new row bit is quite straightf
Hola all. New Zapper here (and unfortunately not a developer )I am wondering if anyone in the community has ever built/used a Zap with a calendar app to allow a web visitor to submit and schedule a (rental) request?I am thinking that I would need to have a sep calendar for each rental item (say a car), which would show if/when it is available, and allow a user to request to rent it for a chosen period (e.g. 1 day).I am not married to any specific calendar app, and am exploring Acuity and Calendly, not sure if there might be better choices, or if Google Calendar might even work for this.TYIA!
Hi there, There is a native API existing between Google Calendar and Zoom (i.e. create a Zoom meeting right from your Google Calendar and it is added to your Zoom account and all meeting details come through). I am trying to create a separate Zap/automation event where the trigger is a new event (meeting/webinar etc.) created on the Zoom platform triggers a calendar event to be scheduled on a specified Google Calendar. Core issue I’m running into is the following. Zoom utilizes Start Time and Duration whereas Google Cal uses Start Time and End Time. How might I be able to reformat/convert the Start Time and Duration details coming from Zoom into and End Time for the New Event addition step in Google Calendar? I’m very much a novice here so I hope that this all makes sense. Thanks for any help you might be able to provide.
Hi, I was recommended by Pipedrive support to contact you about automice invoice information into deals in Pipedrive. My problem: I register a lot of deals in Pipedrive every week. A lot of them are connected to the same customer. My Finance department needs the invoice information for evry dela, to make the invoice. They take this information from Pipedrive manually, and send the invoice to the customer. The problem is that the invoice information doesn't automatically follows from deal to deal for the same customers/accounts, which means if I get 100 sales from one customer in one monte, i need to write in the invoice information 100 (!!) times, the same month! There must be a solution for this? To make Pipedrive fill out this type of information for me automatically, on delas that I already have written in the address so many times before!? We talked about this with Pipedrive, and they dident have a solution, but said that you might have? I so hope that you can help me. Because all
Hello everyone. I had zaps running with Catch Hooks getting data from an automation program which pushed data and then Zapier processed that into Trello. But I had those webhooks running during my 14 days trial and forgot to purchase the premium license when it ended (which caused the zaps to shut down). Question is: if I purchase the premium license now and reactivate the zap will it be able to get all the data that was pushed during the time the zap was deactivated? Thank you.
I am trying to use Formatter>Text>Split Text to split a single field into multiple columns. This works currently with a comma set as the delimiter but later when I tested the parsing with a field with a comma in it, it split that one field into two separate columns in error. Here’s what the originating data looks like when I click to select it in Zapier:And here’s what the output looks using only a comma as the delimiter, once it has been sent to a Google sheet: You can see that the first row of data came over fine but on the second one I filled out the form with a comma in the first two fields (in the source program) and when Zapier captured it then processed in “Split Text”, it split the fields at that comma, resulting in 4 columns where there should only be 2, pushing the rest out to the right. Is there any way to split this out more accurately with a better delimiter or a different function besides Split Text? I tried splitting by “],[“ and also “,” and ‘”,”’ but all of these
Hi there, brand new to zapier. I’m currently trying to find a solution for a project that I’m working on involving running multiple twitter polls. I am trying to take the live and finished results of that poll and put them into a spreadsheet where I am keeping track. I am sourcing polls from other areas of the internet as well so the spreadsheet is sort of the catch-all for results.I’d like to try to avoid using the twitter API and it looks like I can scrape tweets but I am struggling specifically with getting the twitter poll information in there. Any help would be greatly appreciated!
Hello all, I am looking to see how I can send out standard sms auto response for the ones recd in Vonage business (not for the ones recd in Vonage sms (nexmo). I use the same number for receiving voice calls and sms messages (Vonage business and not nexmo)can you please advise ? The one below is actually connecting to nexmo and not to Vonage business https://zapier.com/apps/vonage-business-communications/integrations/vonage-sms-api Thanks in advance for any suggestions or help !!
Hello! This is a question about updating a multi-choice custom field for a subscriber in Campaign Monitor. So I have a multi-choice custom field called “Services”, with choice “Service A”, “Service B”, and “Service C”. Using the templated action step, what does Campaign Monitor’s API need me to encode in the field to jive with their expected request?Here’s what I mean. In this screenshot, you can see I’ve got multiple values I want to assert:The test returns a success message, but these fields are not recognized on CM’s end: So the question is: What do I need to do in the Zapier field action step to match CM’s API endpoint? It access nested JSON requests, according to CM documentation, but how do I translate that using this templated action?Of course, I could construct a HTTP request using Zapier, but I’d rather not go through that trouble if I don’t have to. Zapier’s out of the box CM template should be able to handle ingesting multi-choice inputs for custom fields.Thanks! Tom
I have several dropdown select properties set up in Hubspot and corresponding fields in my Gravity Forms form. The values are the same in both, but when the form is submitted none of the values are showing up in the Hubspot. Any suggestions/help would be appreciated. Thanks...GGus
I am trying to send a follow up Google form that shows questions based on a respondent's previous response. For example, in my 1st form, I have asked the following MCQ question: What role do you want to signup for?- Teacher- Student- GuardI then wish to email the respondents a 2nd follow up form that asks a different question based on the user’s selected signup choice:- Teacher: What subject do you want to teach?- Student: What school do you attend?- Guard: What shift do you want? The 2nd form should not have a conformation question that asks about the respondent's role choice again.Currently, I am exploring the zap that sends gmails when a new response is recorded in Google Form but the zap does not allow me to customise the email so I can send different pre-filled links to the respondents. How can I solve this problem?
Hi there, I am super new in Firestore and Zapier, so I get stuck at writing my query.I want to extract all data from my collection.So I am already connected to my project, selected my collection ‘users’ and then.. What do I write in my query? I want all fields to be connected to Klaviyo. Is there anyone who knows? Thanks!Krizia
Hi there - I’m trying to connect RingCentral into my CRM to show call data. I’m encountering a hiccup testing my connection to RC.Background:We’re a new RC customer. There’s only a few calls in there. My account is a SuperAdmin w/o an extension. I’m trying to take call logs of our two remote salespeople and append that into our CRM. I’m not concerned about connecting via Zap whatsoever, as I’ve connected tons of Zaps. I successfully connected my account to Zapier, and went to test a Zap of a call ending in RC. When I test the Zap, I get this message:We couldn’t find a callCreate a new call in your RingCentral account and test your trigger again.If I click on the call log in RC, I see calls in there. I cannot figure out why it wont detect the call.Is it because I am a SuperAdmin, and it’s only looking for calls on my account? I’ve tried searching for a solution on this and nothing is out there.The only thing I was thinking was to get the credentials of our two sales people and login as
Hi! I’m using Thrive Theme as my site builder. I intend to integrate the opt-in form into kartra. My problem is I cannot choose a specific subscription form as the trigger. How can I see all the forms available (which are already been integrated to zappier) for me to custom gathering of leads and categorize the subscribe clients?Thank you.
I receive several PDF PO’s from the same customer & would like to make the flow work better. The work flow i am looking for goes like this… PDF comes into my email PDF is saved to google drive under PO# Info from PDF is saved to google sheets spread sheet (this is the part I am having trouble with) New google sheets column is added into katana & Sales order is created The linking issue I am running into is extracting the info I need out of the PDF and having it placed into the google sheets doc. Info I want pulled from the PDF iscustomer name delivery date created date part # order id qty total $ job #Ideally I could have the original PDF attached to the newly created google sheets column as a link aswell All the info I want pulled from the PDF is there but Im having trouble setting up ZAPIER to work how i want Any help would be greatly appreciated!! Thanks, Gunnar
Hello!I tried to figure out this on my own, but I am lost and I can not find any tutorial on the internet.I need to take multiple calendars from Google Calendar (for example calendars of events in three different buildings) to one google spreadsheet.Is that possible with Zapier?Thank youFrantiška
Hello Guys!I have to integrated Google sheets to CRM. Now, I want to create a ZAP wherein the Trigger is “When a stage of the lead is changed in google sheet” Action = “ New contact is created in CRM” How do I go about it? Awaiting for the response from the community. Thanks,Santhosh
We create invoices in Zoho and receive payments also in Zoho. There is currently a Zap that will create the invoice in QBO after it’s created in Zoho, but no Zap that records the payment from Zoho into QBO. I’d love to see this functionality created in Zapier - I think there would be TONS of users that would use this.
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.