About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Get Help

Find answers to your questions. Ask the Community for help or hire someone to help you.

25319 Topics

M
maor356Beginner
asked in How Do I

Get all google drive files under a folder, and send via SMTP email

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?

6
christina.d
1 year ago
L
Lucas MichelBeginner
asked in How Do I

How can I trigger on Capsule for a tag update and not for a contact update overall?

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, 

4
christina.d
1 year ago
B
Bogdan G.New
asked in How Do I

MailChimp/Pardot - Existing prospect is not added to new list

Hello, I am linking Mailchimp and Pardot. I want to add existing Pardot prospects to a different list in Pardot, based on their actions in Mailchimp. Everything is working as it should, but somehow the lead is not sent to the new created list. I need to mention that I don’t have any errors when testing trigger or action. Should I contact the Pardot team? Have you seen this before? 

3
christina.d
1 year ago
L
Lucas SaldanhaBeginner
asked in Code & Webhooks

Extracting text using REGEX (or other method)

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

11
L
1 year ago
J
jkrocks47New
asked in How Do I

Creating an Automatic Hour Tracker Via Google Spreadsheets and OpenPhone

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

5
J
1 year ago
A
AetosNew
posted in How Do I

Drop Cowboy to CINC Integration

Has anyone successfully created a Zap from lists provided to Drop Cowboy to realtor CRM CINC? I know Drop Cowboy is in Beta & I’m having dififculty

1
christina.d
1 year ago
J
jtaylor_gxNew
asked in How Do I

New Outlook email triggers twice

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!

2
J
1 year ago
F
frankfBeginner
asked in How Do I

Saving Twitter Threads?

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?

5
Danvers
1 year ago
S
statementxNew
asked in How Do I

How do I set up my Zap with Square so that loyalty points are added to my Shopify store when a customer scans a loyalty card?

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?

3
Danvers
1 year ago
E
elemolotivNew
asked in How Do I

Facebook Group Comment Automation

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?

1
Troy Tessalone
1 year ago
M
MaxterNew
asked in How Do I

Is it possible to dynamically send daily push notifications to users from a database of content in Adalo?

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!

3
Troy Tessalone
1 year ago
G
graham_coxNew
posted in How Do I

Updating Pipedrive deal from Typeform

I’ve created a typeform to collect further information from an existing pipedrive person.  I ask the person to enter in the typeform the same email that is associated with them as a pipedrive person. But I want the typeform data to update their pipedrive deal.  My problem is I can’t seem to find a Deal ID field.  In the zap, I have a step to find the PD person using the email address, and I thought that would be sufficient to find and update the deal on the next step.  If anyone can advise me I’d be very grateful.  Thanks Graham

2
G
1 year ago
P
progreshionNew
asked in How Do I

Gravity Forms & Pipedrive

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.

7
christina.d
1 year ago
S
spectrumNew
asked in How Do I

How do I download PDF files to a OneDrive folder?

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.

18
christina.d
1 year ago
Mr. AUTORRARI.MAIN
Mr. AUTORRARI.MAINBeginner
asked in How Do I

How to separate data before it gets to Airtable

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

12
christina.d
1 year ago
M
ModRoboticsBeginner
asked in Troubleshooting

Lookup Spreadsheet Row in Google Sheets - Zap doesn't stop on failure

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

3
christina.d
1 year ago
P
ProdCrewNew
asked in How Do I

How do I trigger on a record entering a view on Airtable when the old trigger is deprecated?

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?

3
christina.d
1 year ago
W
whimandwillowphotoNew
asked in How Do I

Sending automated email after a SPECIFIC shopify product has been purchased

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!

5
christina.d
1 year ago
K
KWFBeginner
asked in How Do I

How to look up Shopify orders by SKU and format line items/descriptions in Google Docs?

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]

12
christina.d
1 year ago
R
RoskoBeginner
asked in How Do I

How to parse HTML email to Google Sheets?

Hi, Hoping I can please ask a quick question to know whether this is possible to achieve in Zapier. I'm looking into connecting Gmail and Google Sheets.We receive a ton of sales enquiry emails and a major problem is manually inputting key details from every email into google sheets. So, I would like to transfer the relevant information into google sheets.The sales enquiry emails are in HTML format. When inspecting the source code, I believe each email has a standard setup, however with a unique user reference.Such as:m_1200445894070286815consumerm_3632404488982992166consumerm_2679513591627079049consumerI would like to parse and transfer only relevant lead details from the email and not the whole email contents into google sheets. Please find below a sample of how this email is setup in the HTML email.For example, I want to extract value from span tags with ID [m_'userref'-fieldname]Would anybody be able to confirm that this is possible with Zapier and point me in the right direction of

2
christina.d
1 year ago
W
wethemoodeBeginner
asked in Code & Webhooks

I’m having trouble with Klaviyo recognizing any email other than the email address used in my test.

I’m trying to link Klaviyo to Linktree and have created a zap between Catch Hook in Webhooks by Zapier and Klaviyo.I have followed all steps and have successfully linked my Klaviyo account to the zap. When testing, I can see the email address added to the selected Klaviyo list (Action, Set Up Action, Email). But I’m having trouble with Klaviyo recognising any email other than the email address used in my test.Any ideas on how to have this zap recognise all new emails submitted on linktree? 

5
christina.d
1 year ago
O
Ozzie GNew
asked in How Do I

Is there a way I can add an action to delete or avoid duplicated Google Sheet rows in my Zap?

Hi,I have a zap to move reports our CRM send me regularly to a single Google Sheet. The problem is that each new report contains old data, plus new data. So every time a new reports come, all the old data that is on the spreadsheet is duplicated on the table. I want to know if there’s a way I can add to the zap an action to delete duplicates, or just to avoid adding duplicates rows.

2
jesse
1 year ago
B
BaruchNew
asked in How Do I

Bookingsync: Retreiving commission information from AirbnB bookings

Hi Everyone,For a rental agency I am currently trying to automate some accounting things for the owners. In bookingsync, I am trying to retreive information from Booking.com and Airbnb in order to show the owners of the rentals how much money they receive from each booking. I need to retreive the rental price and commission from these platforms in order to get to the payback to owners. Unfortunately, the app can read the ‘commission’ from bookings originating from booking.com, but not from Airbnb. I can't seem to find the reason for this. Anyone maybe has experience with this and could help me out?Thank you in advance!Best regards,Baruch

2
christina.d
1 year ago
M
Michael_CalmStormBeginner
asked in Troubleshooting

My Zap is not letting me choose the office email as a field, just the company name and domain.

Hello, I am using an integration between Affinity and Zapier.I want to send emails after the status of a certain company in the Dealflow changes in Affinity.The problem is that Zapier is not letting the office email as a field to be chosen, just the company name and domain.If the company comes through our submission in Typeform, it is ok, I can make a lookup in typeform and I find the email. If the company comer from adding manually and they only input the email in the office email field. I can’t get the email.Is there any other way to solve this? Thank you.

8
christina.d
1 year ago
D
DrillZ 2 SkillZBeginner
asked in How Do I

Phone number wont integrate from Wordpress/Modern Events Calendar

I am not able to add phone number field so i can Zap a phone number to Text P2P

8
christina.d
1 year ago
Terms & Conditions