Solved

Lengthy read, I’m happy to clarify anything I haven’t successfully articulated below.All this is happening in with a Zap connected to Smartsheet.I have a base sheet with columns for “Account” (customer name), “Account Number”, “Contact Status”, “Upgrade Status”, “Upgrade Date”, “Project Manager”, “Comments”, (and others not relevant).I added a dropdown column called Upgrade Scheduled for use as a Zap trigger. It has three values: “Unscheduled”, “Scheduled”, “Created”I'm using this base sheet to create project plans from an existing "template" sheet (not an actual Smartsheet template, but a sheet for copying)Template has columns: “Customer”, “Account Number”, “Contact Status”, “Upgrade Status”, “Upgrade Date”, “Project Manager”, “Comments”Trigger: When one or more rows change in the base sheetFilter: When “Upgrade Scheduled” is equal to "Scheduled" NOTE:  From here, I would prefer to create the new project plan from the existing template, then update the data in the new sheet instead of

Hi how do i calculate the time difference, I’m currently creating a out of office zap and our office hours are from 09:00am to 17:00. I’m currently using Woocommerce and i would like to send an email to the customer  if they order outside our operation hours and in that email i like to have a calculated field into how many hours left until we are back in office. How would i go about it, i haven’t found a solution that works yet. email templateWe are currently out of the office, however we will respond to your order as soon as we return in the next (insert calculated field ) hours.

I want to create a reminder, when the lead leaves his information for the second time.Because, if the lead is repeated, it does not enter zoho crm what should I do?

Hi there, I have the following zap set up.> Catch hook (from my shopping cart)> Delay for 30 daysBut then I want to push that customer order via webhook to another zap that will process the order with a create order step in Shopify.So how do I push the webhook data out of the first zap and into the second?Is this a webhook post? Would appreciate any assistance.Many thanksDan 

I am trying to Schedule a Meeting in Google Meet when there is a new submission in jotform. However, if my user selects a specific product in my form, there is no need to trigger the zap. Any way to have a conditional trigger within a new submission? or stop the zap from triggering? TIA! Jen

Hello,I’m a Zap newbie so bear with me. Here’s my use case:How do I send a custom Newsletter via Active Campaign or pass variables to Active Campaign?Here is my scenario:Every time I set up a new event that is approved in my platform (Firebase), I want Zapier to sense it and send an email to my community via Active Campaign to my distro list (and yes, I can call the ActiveCampaign API to do it but I want to Zap it) I have connected my Firebase App to my Zapier and that works and I can retrieve the data that I need from my Firebase platform (i.e. event, event name, date start, max participants, etc,. etc) and that works. Now Once I have the info from Firebase, I connected my Active Campaign account in Zapier but I cannot figure out how to pass the data (i.e. event, event name etc) to Active Campaign and creating a new campaign (or sending out the email) into the body of the email (campaign). note: the connection works because I can send out an email to my list but I do not know how to s

Hi Everyone, I am trying to set up a zap to tag specific Slack users in a weekly Monday meeting reminder based on who will be the meeting facilitator and who will be the meeting notetaker (we have this predetermined every week for the fiscal year in a Google Sheet). I’ve found some related topics I’ve linked here but I cannot find an aggregated explanation of how this might work or how to set it up it simple terms. Ideally what I’d like to achieve looks like this: Every Monday an automated message pops up in a specified channel that says“Happy Monday! Here are this week’s meeting facilitator and notetaker. Please arrange to swap if necessary.Facilitator: @ user Notetaker: @ user” Related Topics: Randomly tag users in weekly Slack messageSending weekly message on Slack with Google Sheets DataAutomating Birthday Messages to SlackAny help is much appreciated, thank you! 

I want to connect a google Sheet and a Google Calendar, such that when I add a new Row to the Sheet, it creates a new Event on the calendar using the data from that new row.I set up a Zap that I thought wold do this. “New Sheet Row” triggers “New Calendar Event.” When I was creating the Zap, it asked me to enter data for an event, which I figured was some sort of sample. Every time I add a Row to the Sheet, it pulls that sample data to create an Event. So it is just creating the same Event over an over when new Rows are created, ignoring the actual data from the Sheet.Did I do it wrong? Is this how it is supposed work? Is there a way to accomplish what I want? Thanks!

Hi all, I’m struggling with loading more test data to my zaps. I’m trying to link it to a different purchase. I’ve gone and “made a purchase” and each time I go to “load more”, I still keep seeing the same data. There has been a lot of data come in from my website since the most recent data Zapier is pulling. It’s driving me mad, can anyone please help me :)

Hi, I am trying to attach files to an email I am sending. These files are stored in a folder in google drive. The number of files varies per zap run. And also the name of the folder varies every time. Is there a way to find the folder, and get the files within that folder and send them in the attachments of the email?

Hi community, We are using Capsule as a CRM solution and Mailchimp as our emailing one.  For our nurturing campaign, we want to update Mailchimp contacts’ tags from Capsule. Example: Our commercial team using Capsule adds a tag “New customer” to a contact, we want to have the same tag automatically added on the same contact in Mailchimp. For now, we created a Zap which adds the New customer tag to Mailchimp through the trigger event “New or updated contact” on Capsule.The issue is that it adds the “New customer” tag for any update such as an email address change. How can we have a trigger on Capsule only for a tag update and not a contact update as a whole ?  Thanks a lot, 

Hi, I'm trying to build a Zap that get's a response from an API from Booqable and creates a task in Asana.I have the response as a value that it's something like this: "4x4 Carbon Fiber Matte Box, Subloc filtro x, subloc bbbb"And I would like to pass to the next action only strings between commas that have "Subloc" in it (ignoring case). I've tried many things and got some regular expression: (?<=,)[^,]*((?i)Subloc[^,]*)(?=,)*. In every place it returns correctly, but on zapier I got outputs blanks.I've also tried to "Line-item to text" or "pick from list" inside the format utilities without avail.Is there a better way to get those two items between commas containing "Subloc" (or "subloc") and pass both (separately) to the next action (create task in asana).Thank you very much

Hello Everyone! The idea is to have an employee send the number of hours they worked that day to a phone number power by OpenPhone. The Zapier integration recognizes that the employee has a number and looks up spreadsheet rows for the number. If the number isn’t in the spreadsheet then it is added in as a row. So far so easy. The hard part is placing the entered hour into the right column and row according to the day the message is sent. I tried using OpenPhones creation date, formatting it into a normal date, and looking up that date in Google Sheets but I constantly get the error “There was an error writing to your Google sheet. Unable to parse range” for the date of the column. I also don’t have a lookup value. I’m not entirely sure how to place the employee’s amount of hours in the correct column for the date they sent the message and the correct row beside their name. I’ve included a few pictures to illustrate what I’m trying to create. I know I suck at explaining things. I have a

Hi. I’ve set up a Zap to trigger on new email to my inbox in Outlook. I then have a filter (looking for a keywords in the subject line).This is working, except that the Zap is triggered twice. Not immediately, but after a number of hours. Eg: 3:30am, then 10:00am.Any thoughts as to why this would be? Any filters I could put in place to stop it?Thanks!

Version 2 of the Twitter API is out for the general public - is there a timeline for Zapier to integrate the new API which would allow us (among other things) to save entire threads?

Looking to see if I could connect my Square POS with my Shopify e-commerce store. Specifically, what I’m looking to do is anytime a customer scans their “loyalty card” with a unique barcode using the Square POS system, I want my Shopify Store to reflect added loyalty points or credits that they can spend on the online store. Can this be automated with Zapier?

I would like to delete comments that contain specific keywords from a FB Group, as soon as they are posted.Is that possible with zapier?

Hello, I’m new to all this so apologies if this is a stupid question.I have made a very simple app in Adalo. It does not currently require user login. My app has a database of text content which users can view on the app. I also want to send push notifications every day to all my users based from this content. All users should get the same content each day, and the content will change every day. e.g. imagine all users getting a notification on Monday to say “Happy Monday” - this content will come from my app database. Is this possible? Where do I start?Thank you!

Hello, I’m trying to set up a zap but for some reaons it’s not recognizing the Person from the previous step. I set it up to 1. Form Submission in Gravity Forms2. Find Person in Pipedrive3. Create Lead in PipedriveWhen I try to test out step 3 it doesn’t recognized the Person from the field #2. It shows this error: Failed to create a lead in PipedriveNeither an Organization nor a Person were provided. One of them must be provided in order to create a lead.

Background:We have been using Printavo to manage our screen print/embroidery shop.  We have a couple of large customers for jobs completed within the last two weeks. I would like to;Identify jobs for Customer A that are complete Find the URL to the actual invoice.pdf for that job Download the file to a OneDrive folder1 and 2 are not the issue; I’m damned if I can find the easy, straightforward way to accomplish 3.  I have the URL, I have the OneDrive connected.  I need the rough equivalent of  #!/bin/shpdfout = $(uuidgen).pdfcurl -o $pdfout $1where $1 points to the PDF I need. thanks.

Hello Community!Virgin poster, so please be patient.We had been using the ‘free’ version until this issue popped up, so I’ve built several ‘free’ zaps. But we had to JUST sign up for a ‘paid’ plan to fix this.DETAILS:I have a zap that pulls information from Shop-Ware (a vehicle repair order SaaS) and sends it to our Airtable account.The issue we are having is that we don’t know how to separate the data before it gets to Airtable.Here is an example:You can how the data is all bunched up in there, and I don’t know how to sort it out before it hits Airtable. So for now it dumps all of that into one cell.I know it can be sorted by these numbers:...but I don’t know how. PLEASE help!!! Thx! Mr. AUTORRARI.MAIN

I have this zap that looks up some data in a Google sheet.  The data may or may not be present - both situations are valid.In my “Lookup Spreadsheet Row in Google Sheets”, I have set “ Should this step be considered a "success" when nothing is found? “  to false, expecting my zap to stop there when nothing is found.My zap keeps on going happily.The history says the zap was stopped, yet all steps were done.My last step shows the following, and sure enough, the webhook does get called. I am puzzled as my understanding is that the zap would stop when google sheet couldn't return a row.Nicole

I have several zaps that are triggered by a record entering a view on Airtable. This trigger seems to have been deprecated, and now only allows triggers by creating new views and when a record is updated. This causes serious workflow issues for me, is there something I can do to bring back the old trigger?

I plan on selling two different things on my store - mentorship sessions and digital downloads (templates, lightroom presets, etc). When someone specifically purchases a mentorship, I need to automate an email to them as a welcome/onboarding thing with some links and PDFs. Is this possible to do with Zapier and Shopfiy? If not with Shopify, are there online store alternatives that this would work with?Thanks in advance!

Hello Guys, So I was wondering how do I go about this task:I want Zapier to look into new Shopify orders, lookup an SKU, and match it with a google sheet file, I then want to format certain line Items as well as a Product Description from the Google sheet file from that order and place them in a Google Docs file like this:ORDER no: lineitem [] OrderCustomer Information:First Name: lineitem [] First NameLast Name: lineitem [] Last Name Order Details:QTY: lineitems []qtySKU: Line Items [] skuDesc: Line Items [] vendor line Items [] Product Title [description from Google Sheets] This is all good if I only have one item being ordered but if I have multiple items then it does not look great, what I wanted is to have something like this: ORDER no: lineitem [] OrderCustomer Information:First Name: lineitem [] First NameLast Name: lineitem [] Last Name Order Details:QTY: lineitems []qtySKU: Line Items [] skuDesc: Line Items [] vendor line Items [] Product Title [description from Google Sheets]