How Do I
Post here if: you're wondering how to do something, whether it's even possible, or don't know where to start.
- 13,262 Topics
- 45,979 Replies
How do I send data from a new Google Calendar event to Google Sheet?
I have an existing Google Sheet, which I would like to add a new row to every time a Google Calendar event is created, and input the details from the event into the Google Sheet. How do I set up a Zap which will recognise that I need to both create a new row, and add data from Calendar event to that row?
Jira Slack Zap Ticketing System Question
Hi,I am thinking of setting up Zapier for ticketing in slack. We already use Slack and manually log the tickets into Jira.What I am looking for specifically is a read-only channel in Slack where there is a message from a bot saying “Click here to raise a ticket” or “react with (emoji) to raise a ticket” and then upon one of these actions, the user is prompted to fill in a form to open a ticket. Ideally this then goes into Jira.What I don’t want is one of our support staff to have to manually click on reaction emoji to someone’s message in help desk channel in Slack to then log something.This looks like it is possible with Zapier, upon ‘create request in Jira Service Management’ you will see in the image that I am forced to put something in the Summary box and other boxes. I want the user to input this! Not me but I cannot continue without writing something in the box. Essentially I want a Zap where:User clicks on reaction User fills in what the issue is Creates the ticket for us to se
MS SQL Find Multiple Rows on the Same Table
I’m using a Zap to retrieve data from our MS SQL database. I need the zap to retrieve every row that match a certain parameter in a specific column. For instance, I need every row that has invoice # 3511151 in the invoice # column of the table. Is this possible?
How do I split products from a Ninja Form into separate estimates in Zoho Invoice?
I have a Ninja Form for my client to input their services request(eg. Product A, Product B...). All data will be syncd to Zoho Invoice immediately. I do this zap successfully.However, I would like to split products into different new estimate. That’s mean one single input form and create Product A to Estimate A, Product B to Estimate B...Is it possible to do that?Thank you.
How do I maintain lead & company names visible, set right category in HighLevel without re-triggering from Apollo?
I am having an issue sending contacts from Apollo to HighLevel.The trigger I have setup is a contact update from Apollo.Then I have a filter set up for Only continue if... the contact contains ‘replied’.My next action is Add/Update Contact in LeadConnector with all the appropriate information.After that I have two formatter’s set up. The first is to replace the company name with the clients first and last name. *The reason is because the company name shows up in HighLevel leads as the clients name. We want it to show the clients name under prospecting clients, where it says ‘opportunity name’. However, how it’s set up now the name replaces the opportunity name (good) but also deletes the company name and is blank.The second formatter splits the text into the first and last name of the lead.Step 6 is set up to Only continue if… the contact equals replied to email. *Because the other issue is that if the lead is moved from ‘Replied to Email’ under opportunities in HighLevel, to another c
How do I trigger one of my zaps directly in Amazon Alexa routine?
i wish to trigger without saying a phase. I tried the action like “ask Zapier to grigger a Zap”, but then it expects the trigger phase. How do i automate it totally without saying anything?actually i just want to send a discord message when some event happens.thank you
How do I set a reference code in a Bexio invoice when creating a new sales invoice from Google Sheets?
Hello How can I set a reference code in a Bexio Invoice?When I manually create a new sales invoice in Bexio, I can set a reference code (the one with 27 numbers)I do have a reference code allready in the trigger google sheet, where I get all the details for the new sales invoice.But I don’t know, how to set up my zap, that it writes this reference code in the reference line (it’s in the text area right under the titel in Bexio)My goal is, that the bank transactions got matched automatically in Bexio.Any solutions or tips? Kind regardsSilvan
Can I auto-convert Google Docs to PDF and email as attachment when added to a specific Google Drive folder?
Hi everyone, I have a zap that makes google documents from templates, and after that it saves them in a specific folder in google drive. Now, I am looking for an app that can automatically convert those documents into a word or PDF and can send those out as an email attachment. I have some suggestions that people posted here, but they didn’t really work for me! Thanks in advance for your help!
Names from a Google Sheet and adding a Google Contact Label to them
I want to make a Zap where it will take the names (First and Last) from a Google Sheet (or another database free app) I own and auto add a Google Contact Label to the names in my Google Contacts. If I remove the name from the Google Sheet (or another database) it will auto remove the label. Basically I want to add a label to a group of people of my choosing (in a database) and that group can change at any given time based on who is in the database.
New help with New Card in Trello When Square Invoice Paid
We are currently using Zapier to create a new card in Trello when an invoice is paid and It works great, however we would like the Customer’s name, shipping address, and / or at least the invoice number in the Trello. As of now we use it as more of a notification card as we still have to go into Square for the details.Is this even possible with Zapier?Thanks you in advance for any help or direction.
Can I search for specific order tags in Shopify when an order is updated?
Hi all,We often tag orders after an order has been placed. We can do this if the order is on a certain truck for delivery etc. I would like to search for these tags so we can update customers in bulk. Has anyone found a method for triggering Zapier to look for tags after an order has been placed? What is classed as an order update? This is the only possibility I have thought of. Thanks Tom
How do I send a Slack alert when an email is received by a Google Collaboration Group?
I’m trying to set up a zap so that any email sent to a shared google alias (collaboration group) triggers an alert in Slack. It appears that I’m only able to connect my personal email and not the collaboration group. Is there a way to do this? I considered forwarding the emails from the collaboration group to my personal email, but I don’t want there to be a single threaded dependency on me (in case I ever depart the organization).
How to replace separator in Shopify "Line Item Properties Value" from comma
I have a product customisation form in Shopify that customers input their messages in the respective fields in the form:Name: JohnSex: MaleMessage: Hello I then use zapier to extract the shopify inputs from "Line Item Properties Value". The inputs in the respective fields in the form are separated by commas:John,Male,Hello. This is OK but if the customer inputs commas into the fields like the example below, I then run into problems:Name: JohnSex: MaleMessage: Hello, world The Line Item Properties Value then shows: "John,Male,Hello,world" as if I had 4 fields. In reality I have 3 fields. But because of the comma in the message "Hello, world", it recognized "world" as the 4th input. I think the way to resolve this is to change the separator in Shopify to "|" instead of comma. Or is there a workaround in Zapier? How do I do this? Thanks a million!
Attaching URL address to text in body of a Zap, for an e-mail to be sent
Hello, we are creating a Zap to send automatically an e-mail to people downloading our whitepaper from a form on our web site.The “send” button on our form sends data (e-mail address, etc) to a Google Sheet.The Google Sheet thend sends a e-mail to the prospect, thanks to Zapier.We would like to tell : “click here” for example, and then opening the URL adrress after clicking, yet without writing the whole URL in the body.Yet we do not see any text editor enabling this.Is it possible ? How ?Thank you very much !Philippe, Whart
What Filter parameters do I use to auto-reply to Google My Business reviews without comments?
Hey,I’m trying to set up a filter for my Google My Business + Zapier reviews response integration that will only respond to reviews that don’t have a comment.Which of the parameters should I use? 1. Comment does not exist? 2.Comment (text) does not contain? or something else ?
Can I send an automated Flodesk email with a product link 15 days after a Shopify purchase?
Hello! We would like to send automated emails to our customers asking to leave a review on our page 15 days after purchase. The email must include a link of the product they bought. PS: Our store is on shopify and our marketing email app is Flodesk Is there anyway zappier can do this?
How do I create a new Affinity list from Splash event and update profiles with accepted or declined RSVPs?
I’m trying to push data from Splash into our Affinity.These are responses from invites for events sent using Splash and we would like the responses to ideally:Create a new list in Affinity based on the title of the event from SplashUpdate people’s profile’s in Affinity with either a Note or other interaction to say that they accepted or declined the eventI have been working on the workflows but can’t seem to see the options that I need.Any help/advice would be much appreciated.
Date format issue exporting from Bubble to Google Sheets with Zapier plugin
Hi,After triggering a zap from Bubble.io (live database), I received in my Google Sheet a date with the following format: 2023-09-23T03:00:00.000+00:00, which is not recognized as a date format by Google Sheet. I need the new data to be recognized as a date by Google Sheet for pivot table updating.When I tested the action (create spreadsheet row to Google Sheets) within Zapier, Zapier used a date from Bubble development database and created a new row in the Google Sheet with the date being formated correctly: 2021-05-01 13:00:00What can I do to have the 2021-05-01 13:00:00 formating in the live environment?Thanks.
How do I add an attendee to an event made on the team calendar with the creator's email?
I am trying to add attendee to an event made on team google calendar made via pipedrive. it only has info of summary, organizor/creater mail and time. I am try to use trigger: new event in google calendar: select the team calendaraction1: find event: creator: myselfaction2: add attendees to in google calendar: with the one found on above but does not work at all. wish I can get some advise on this.
How do I create an item in monday.com and update it with an email when a warm lead is identified in GoHighLevel?
Hello, so this is what the objective of my zap.Routing from GoHighLevel.Zap 1 : If a customer is a warm lead from gohigherlevel. It is zapped to my zapier, sending data to my Monday.com board, creating an item. And including basic customer information.Zap 2 Goal : When a customer sends their email on GoHigherLevel. I want it to zap back to monday.com again, find the customer information, and send it to the same item to fill out only the email column. I don’t know if I should connect the zaps, or the best way to structure and complete it. I really need help here. Thanks! They are both connected via webhook from gohigherlevel.
How do I transfer HubSpot data to OneDrive into separate columns in Microsoft Excel?
I am looking for a way to transfer my HubSpot data into One Drive via excel automatically. I followed the instruations, set up the Zap but it didnt work as i needed it to.It created one line of data in excell with all the data included.What i need is each peice of data to be in a seperate coloumn, is this possible and if so how.Thanks in advanceNigel
Already have an account? Login
Use your Zapier credentialsLog in with Zapier
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.