Find answers to your questions. Ask the Community for help or hire someone to help you.
I’m trying to have outbound messages from email, sms, slack, or some other communication service trigger an action with stores the outbound message to Airtable or Google Sheets?I currently only see the option for inbound messages to trigger an action.Thanks,Sef
I'm using "Delay For" for sending email reminders for different dates in a summit. how can I know the people register after those dates won't get them?
Hello, I want to trigger seven different emails on different dates for a summit, e.g. “April 24th 9am EST” send reminder email. Then delay until “April 26th 9am EST” and send another reminder from Mailchimp. How can I be sure new users in my Mailchimp audience don’t get the reminders for a already past date, but get the next reminders on the queue in zapier? The question below is confusing me as what happens when the date is in the past. What does it mean with continue? Does It means that it will trigger it if it’s within one hour? otherwise it will stop and keep my future task paused? or it will not trigger the next task but will go to the next available delay until and trigger the next reminder? Thanks in advance! Cheers
I have a Google Sheet with four columns: Email address, thing 1, thing 2, and thing 3.The possible values for the “thing” fields are “Yes” and NULL (empty / no data).Is there a way to create a Zap that periodically (say weekly) looks for rows in the table that do NOT have a “Yes” in ALL three “thing” fields and then sends an email to the address in the row(s) with a message about what’s missing? (The message would need to be verbose and not just the column heading.)So the trigger would need to be “time” rather than creation or update of a row.And I’d need something that translates a NULL value in, say, the thing 1 and thing 3 columns to something like, “You’re missing your widget and your doohickey” in the email body.Is this possible via Zapier or too tricky? TIA
I have tried a few times and am getting stuck. I am looking to have a google sheet of data which is generated from a custom SQL query. But I would like the google sheet to update all the data based on the SQL query running. I have found ways to lookup rows and update those rows but I just want the sheet refreshed completely every x time period.Been trying for a while to get this and just getting lost. Appreciate the help
Hello, I would like zapier to trigger an action when a project in honeybook is moved to completed. There is an option to trigger when a project stage is moved just not specifically moved to completed. Has anyone found a way to do this manually, without a multi step zap which only pro accounts can do?
Slack to Google Photos - When photo is posted in slack channel it creates an album with same channel name and uploads to photos
Trying to have all channels watched for new images being posted in slack. Once a new image is posted, its to be uploaded into an album in google photos. The album is to have the same name as the channel. If the album exists already, then the photo is just uploaded into that album. We create new channels for each job we have so it will need to watch all channels and not just be assigned to one. We tried, but haven't been able to make it work. If it helps, I can use google drive for the same function instead of google photos, but google photos would be better.
Trying to have all channels watched for new images being posted in slack. Once a new image is posted, its to be uploaded into an album in google photos. The album is to have the same name as the channel. If the album exists already, then the photo is just uploaded into that album. We create new channels for each job we have so it will need to watch all channels and not just be assigned to one. We tried, but havent been able to make it work. If it helps, I can use google drive for the same function instead of google photos, but google photos would be better.
I need to integrate performance marketing platforms to fetch costs and conversions. But as far I can see Zapier does not have an integration with FB or google ads (NOT LEADS but Ads).Is there any variable integration component which i can use to connect google sheets with these performance marketing platforms
I need to avoid sending lead duplicates to Pipedrive. I’ve tried using filters and conditions but it didn’t work. I’ve even tried the Pipedrive's native solution such as “find or create a deal/organization/person”.If people send their data twice or more, I must not send the redundant ones to Pipedrive. I need to send just the first one.Can anyone help me?
Hi,I want to send data from one tool to another one with zapier integration. In my API I have a method which requires a few parameters one of them is LASTID and my question is: can a zapier select data from a previous response and pass it to the input of the next request, in an automatic mode?
Our invoices are sent via a URL link and I would like to convert the url link into a PDF and save within Google drive. I used Google Print to print a URL to pdf and then saved it within a folder but Google Print has shut down. Does anyone have a work around or solution for me?
Nonprofit: Sending unique values or sheets and marking them as used (past get multiple rows feature)
Hi! I work for a nonprofit organization and am trying to analyze if a professional Zapier program would be the right fit for our needs. I’ve figured out the initial steps, but now I’m hitting a wall. So, we have a data set that is comprised pretty much of very soft potential leads. Usually 3 rows of info that matter: a name, email, and phone number or address. Volunteers can request a certain amount of leads via a google form (open to other types of online forms or actions for doing this) in which they say the number of leads that they want and their name and email. This step makes sense.Then: a middle action for data splitting and some type of marking of whether that data was used. This is where I’m uncertain.Followed by attaching the data in some form to an email and sending it to the volunteer. This part also makes sense. Basically, I want to find the most simple way to piece off a spreadsheet. All values are of equal weight/importance, so it doesn’t matter what leads the volunteer
Need some help with an automation project.My stock system exports a csv daily to a Dropbox folder at 5:45am showing data for a particular distribution centre. I need to use this to create a KPI email showing total orders, number of orders over 3 days old, number of orders over 5 days old and the oldest order on the list. So far I have a zap which does the following:Trigger: New file in Dropbox folder (the automated csv file) Formatter to import the csv Update rows in Google sheetThe rows are added to a worksheet in Google sheets. The second tab in the same sheet does a bunch of calculations based on the data updated into the first tab and then the third tab in the same sheet updates a single row with all the KPIs referred to above, based on the data imported from the csv.Next I have a second Zap which sends the email, as follows: Trigger: Updated row in Google sheets Send email using gmail (recipients, subject line and the body of the email all populated automatically.All of this works
Hello,I am trying to figure out why anew row didn’t trigger the ZAP. I have it set to New ROW(Custom Query). It test’s out just fine.This is the code:SELECT order_id, order_extra_val_1, order_extra_val_2, order_extra_val_3, order_extra_val_4, order_extra_val_5, order_notes, order_total FROM ms_orders LEFT OUTER JOIN ms_cartON ms_orders.order_id = ms_cart.cart_orderWHERE ms_cart.cart_pic_date_org = '2021 Level 3-4-5 State Meet' AND ms_orders.order_extra_val_4 = 'Friday Session 1: Level 5 Junior A & B Senior A'
My Hubspot form contains several multiple choice questions where more than one answer can be selected (e.g. “What fruit do you like to eat? Select all that apply.”) If multiple answers are indeed selected, these then get transferred to Zapier as a comma-separated list (e.g. “bananas, apples, oranges”). I’d like to split these line item answers back into the individual answer categories (e.g. “bananas”, “apples”, and “oranges”) so that I can use them individually later to auto-fill a Google Sheet. This Google Sheet has each of those answer categories as individual columns (e.g. “bananas” = A, “apples” = B). I’ve tried multiple Formatter actions and can’t get them to do exactly this. Is it possible on Zapier?
Hello everyone, everything good?I am looking for a way to update Deals in the Hubspot if there is one with the same name, or create a Deal if there is none with the same name so that there are no duplicate Deals.But I have a problem, I believe that for lack of knowledge here of the tool. But when I'm going to add a record that already exists in the Hubspot, instead of updating it, it creates a new duplicate Deal. And when I’m going to add a record that doesn’t exist in the Hubspot, it crashes on validation and doesn’t add the Deal
Hi,I’m trying to set up a Zap that posts to a channel with a custom name or create that channel first, if it doesn’t yet exist.You can create a channel and post to that channel with no problem once. Next time, however, creating the channel will return the error message “name_taken”. So, I would either have to be able to check if the channel already exists before trying to create it or just ignore that error and continue posting to the already existing channel.As Slack doesn’t offer a channel search, I can’t do the first and Zapier doesn’t seem to allow the latter.Is that really just not possible?
Hello,Is it possible to send data to a specific sheet in a google spreadsheet based on a variable in the data SELECT(ed)? In the example below would it be possible have the zap place the data in a sheet based on what order_extra_val_4 is. For example: if order_extra_val_4=Session_1 the zap would either place the data in the sheet labeled Game_1 or would create a sheet named Game_1 and place the data in that sheet? On top of that would it be possible to make the 'Friday Session 1: Level 5 Junior A & B Senior A' dynamic? Right now I am having to create as many zaps as there is sessions(sheets) and changing the code based on the session(ms_orders.order_extra_val_4 = 'Friday Session 1: Level 5 Junior A & B Senior A') SELECT order_id, order_extra_val_1, order_extra_val_2, order_extra_val_3, order_extra_val_4, order_extra_val_5, order_notes, order_total FROM ms_orders LEFT OUTER JOIN ms_cartON ms_orders.order_id = ms_cart.cart_orderWHERE ms_cart.cart_pic_date_org = '2021 Level 3-
Hi I am having trouble with the One Drive integration when its trying to find a file. Even though I can actually see and open then file in my one drive, the find action will not return the file. The file name to search for is coming from a previous step so i know it is being typed correctly. The strange thing is when I and edit the step and run the test, it eventually finds the file after several times Does anyone know if I am doing something wrong or how to stop it from happening I have even tried putting a delay in for 5 mins to see if it was an issue with the file uploading
I am trying to a create a zap to push the responses of Microsoft forms to Google form through the POST method of Webhook.So the trigger is on Microsoft excel for web in which all the responses are stored in real-time. And then the Action has to be Google form response submission. I have another script linked in the Google form which will be triggered only when the Form is submitted. And the Zapier Action for this does not actually submit the form response but rather directly adds the response as a new row in the response sheet.So I thought so trying out webhook to do achieve this, but sadly I don't know how to use Webhooks. I found a solution online where I can automatically submit a form response with the help of a prefilled URL:Eg: https://docs.google.com/forms/d/e/1FAIpQLSdDCmmHjGT8NlztYek5Tfr9_BYysakwg7l-fIawCSf2IDLu2g/formResponsefirstname.lastname@example.org&entry.1434046471=Task+ID-100&entry.1039880062=Approved&entry.1725448845=No+comments&s
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.