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.

25271 Topics

J
Jakeb2002New
asked in How Do I

Update GoogleSheet based on user input from Discord

Hello,I would like to make a bot that helps out our treasurer in GTA.Basically, I want it to look at any new message in the deposit log, look for the type of thing, and look for the quantity and then update it by adding or subtracting based on what the user puts. For example, there is a shee with a tools heading and under there is flashlight, and there is a quantity and under there is 5, next to flashlight. I would like to make it so when someone writes a message saying +1 flashlight it would search for the correct rows and change the 5 to a 6, etc. Just curious is this is possible? I’ve been messing around with it a bit but I can’t figure out how to search for specific content i.e. only number or only words? Any help is appreciated

1
jayeshkumarbhatia
2 years ago
M
MarikNew
asked in How Do I

Zoho Contacts to HubSpot Leads Module

Hello, Is it possible to send information that is stored in a drop down field inside of Zoho contacts to a corresponding drop down field in the HubSpot leads module. I tried mapping the fields and the only piece of information that was updated was the city and that is a open text field. None of the drop down values I changed in Zoho changed the correspondence drop down fields in HubSpot. 

5
Troy Tessalone
2 years ago
C
CLABeginner
asked in Code & Webhooks

JS Code Regex to verify Email

Hi,Does anyone have some JavaScript that can verify a valid email address in the code module?I have the following - but I cant find the right way of performing the test, I’m not a programmer but I cant see why this isn't working? Any help much appreciated. At the moment it seems to pass everything through. if(inputData.eMail == null){ return{ rv: ""}}else {  const myEmail = inputData.eMail.replace(/\s+/g, '') // remove all whitespace from string  const RegExpConst =  /(?:[a-z0-9!#$%&\'*+/=?^_`{|}~-]+(?:\.[a-z0-9!#$%&\'*+/=?^_`{|}~-]+)*|"(?:[\x01-\x08\x0b\x0c\x0e-\x1f\x21\x23-\x5b\x5d-\x7f]|\\[\x01-\x09\x0b\x0c\x0e-\x7f])*")@(?:(?:[a-z0-9](?:[a-z0-9-]*[a-z0-9])?\.)+[a-z0-9](?:[a-z0-9-]*[a-z0-9])?|\[(?:(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.){3}(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?|[a-z0-9-]*[a-z0-9]:(?:[\x01-\x08\x0b\x0c\x0e-\x1f\x21-\x5a\x53-\x7f]|\\[\x01-\x09\x0b\x0c\x0e-\x7f])+)\])/  if(myEmail.matchAll(RegExpConst)){     return {rv: myEmail}  }  else return {rv: ""}} 

4
C
2 years ago
J
JuangettyBeginner
asked in How Do I

Whitelisting Amazon US-EAST-1 IP addresses

We are trying to whitelist zapier into our quickbase app. Is there an easier or faster way to whitelist every IP in AWS Service:”Amazon” Region:”Us-east-1” instead of adding them 1 by 1. For example in the list you provided I see there is about 346 Amazon Us-east-1 IPs. Is there any way to bundle these together in order to whitelist them faster or is there a range we can specify? 

4
SamB
Community Manager
2 years ago
P
Panna CRMNew
asked in How Do I

Does Zapier use a single IP address?

Hi, it’s posible to have a single IP Address (or a short list)?My IT manager wan’t to use a list of IP for the security :(

3
SamB
Community Manager
2 years ago
A
AbasiakanNew
asked in How Do I

Getting an audio file from Descript.com using Zapier?

How can I get the text file (output)  of an audio sent to Descript.com  using Zapier?

1
Troy Tessalone
2 years ago
B
Base Camp AustraliaBeginner
asked in How Do I

Integrating HubSpot Contacts with monday.com deals - Internal server error

We are looking to integrate our Hubspot Contacts with our Monday Deals.This will mean that we can see when we last had activity with said contact on hubspot through our monday dashboard. We have gotten through most of it however we seem to have an issue with an internal server error seen below from monday.Can someone please help with this.Thanks

8
jayeshkumarbhatia
2 years ago
J
Jeff ThornsBeginner
asked in How Do I

Intercom tag added to company?

This is more a feature request but maybe someone knows a work aroundi’m working on a Intercom serie that triggers on certain COMPANY tags and sends a mail based on a a few rules.I'm aware that theres a webhook feature there but we don't have access to it. So that's where I run into the issue that there isnt a tag added to company trigger.I want to create a Zap that sends a simple slack message and if needed it’s moves the associated asana project task  with it.Does anyone know a work around where I still can run the zap after a tag is added to an company.I rather not add the tag with a zap, although it's an easy solution 

2
J
2 years ago
D
dzhu2005Beginner
asked in Code & Webhooks

Zapier changed the way how to parse JSON

I recently notice Zapier changed the way how to parse JSON data, I have JSON data like:{User:{FirstName:’John’,Address:{City:’Toronto’}}}before Zapier flat data to User_Address_City, but now, first level and second level is fine, but city not able to be find as token. Instead change our data model, is there easy way to change settings and make it work. thanks. 

3
SamB
Community Manager
2 years ago
A
Ayoub KBeginner
asked in How Do I

Round Robin - Pipedrive - can't assign the Owner

I’ve created Round-robin via zapier to distribute leads between our sales team.i’ve connected pipedrive with one account of our sales team  assigned the ouner to the round-robin outputwhen i check pipedrive i always find the team member that i’ve connected his email (2.) is the owner of the deal on pipedrive, not the output of the roundrobinCan anyone help me with this issue please ?? 

6
SamB
Community Manager
2 years ago
B
BezufranckBeginner
asked in How Do I

Upload Google Slide template action - how to remove placeholders if no data

Hi everybody,  I need help for my Zap : Trigger : new record in airtable Action : upload a template in google slide I have created {{placeholders}} which are perfectly filled with informations from airtable. The problem is : when an information is not given in Airtable (the trigger), I would like my {{placeholder}} to be deleted from the final google slide. Instead, I got, for example, {{mail}} that remains in the slide. Do you know how could I configure Zapier to delete {{placeholders}} which contains no data. Thanks for your help !  Franck     

3
SamB
Community Manager
2 years ago
C
choppiNew
asked in Code & Webhooks

Problem with GET Webhook

Hi everyone,I have a minor problem with a GET Webhook.  The setup of the step looks like this: I have added the entity from the previous step.But when I test this step, it will loose the entity ID after the URL:  

5
SamB
Community Manager
2 years ago
A
akar5hBeginner
asked in How Do I

Send an email in Gmail to user when they react on a message in Discord

I want to create a Discord Gmail integration that sends the reaction to user when they react on message in discord , I tried out creating a zap with discord , setting up trigger to be on reaction , then capturing their email from discord and send a mail to that email using Gmail, but I seems like I am not able to capture their email with this flow , and cant move on to the gmail step , is there any way I can get the user email ? EdIt (spell) : integration 

2
A
2 years ago
L
LachlanNew
asked in How Do I

Use single Zap to handle multiple different Google Calendars?

Hi all, I'm setting up a tuition platform using Zapier, Airtable and Webflow. When a tutor signs up to the platform, a new Google Calendar is created (a sub-calendar of the platform's calendar).A student or tutor is then able to create recurring lessons via a Webflow form. That's all the easy part.What I'm having difficulty with is managing the different sub-calendars. For example, I can pull in the original Google Calendar event into Airtable (and therefore Webflow's CMS as well), but I don't know how to manage the subsequent recurring events. I'd like to be able to use the Google Calendar event (each lesson) as a trigger event, but it seems like you can only set up a trigger per calendar, for example, I'd have to set up a new trigger per tutor, which isn't ideal.Has anyone dealt with this number of calendars and Zapier before?

1
SamB
Community Manager
2 years ago
Z
ZinZapBeginner
asked in How Do I

Map variable list of values from single text field to multiple fields in CRM

We have a set of data in our source that is only present if it is chosen and is a list of values in a text string.As an example, the customer can choose Add-Ons (Add On 1, Add On 2, Add On 3, etc.). If the user chooses Add on 2, Add On 3), what is shown in the API is the field Id values for those 2 fields in one field (i.e. 4127, 4136). Any values not chosen are not listed.We are trying to map this to our CRM, so if the field is present, mark it TRUE in CRM. So when we see 4127 we know this is Add On 2 and therefore in CRM mark Add On 2 as True.Seems this is probably a multi-step process, but not quite clear on how to do it.Any direction is appreciated.

2
jayeshkumarbhatia
2 years ago
A
A-venturesNew
asked in How Do I

Want to create workflow to create/update organisation and deals in Pipedrive for labelled visitors in Leadinfo

Requirements of workflowEvery visitor that gets that label in Leadinfo, must sent to pipedrive.Checking in pipedrive: Is there already an organisation and an deal -if yes: update organisation and deal with available data from lead info (for example path)- if no: create organisation and deal

1
AndrewJDavison_Luhhu
2 years ago
A
Anonymous
asked in How Do I

Run Zaps on previous triggers

I want to be able to run my zaps on events that happened in the past. This seems like it is possible because Zapier can pull test data from previous triggers when creating the Zap.Anyone know how to do this?

3
jayeshkumarbhatia
2 years ago
G
GiladBeginner
asked in Code & Webhooks

SurveyMonkey to Mongo - Dump the full Survey

Hi there, I’d like to dump the full SurveyMonkey responses that I’m getting (a filled survey) into a MongoDB as-is (almost as-is).The issue is that my survey has 30+ questions and I don’t want to structure them item by item but rather take the entire payload that Zapier got from SM and forward it to my Mongo-Instance “as-is”.Any thoughts?GB 

5
jayeshkumarbhatia
2 years ago
W
WPMonkeyNew
asked in How Do I

Create a project in Asana after an estimate is approved in Freshbooks?

I would like to setup a zap that creates a new project in Asana when an estimate is approved in Freshbooks (new Online, not Classic), filling in the estimate line items and detail as tasks in Asana.So here’s where I’m bumping into issues:I don’t see a trigger specific for when the Freshbooks estimate is approved, only new and updated. When I try to setup the project to be created in Asana, I can get the overview information in but hitting barriers trying to convert each line item in the FB estimate into individual tasks within Asana. It’s also important that each new task in Asana has the item name and item description converted into task name and description. I’d also like to pull over the per line cost information into an estimated time effort within Asana. So line item quantity (hours) is pulled into a task budget that I could time against. This may be beyond Zapier and need a third party timer?Any input would be appreciated.

3
jayeshkumarbhatia
2 years ago
A
AnthonyG_44New
asked in How Do I

FB Lead Ads - 'Unable to get fbe business info.' error

Hello everyone, I was wondering if anyone got this error when trying to connect fb ads premium to their zapier account. I go through the process of linking facebook to zapier but it doesn’t allow access. Thanks.“Unable to get fbe business info. (#33) An FBE installation does not exist for the business with ID”

1
christina.d
2 years ago
B
blickwinklerNew
asked in How Do I

How do I attach at specific file to a Shopify order from Google Drive

Hello Zapier´s,for the following workflow we looking for a solution / zap.We like to use google drive and shopify. For example, a person orders the following items in a shopify store.1x ADFED3x HATEF7x DJHUZnow the following pdf, jpg or svg files should be copied from the folder xy into the folder orders.1x ADFED.pdf3x HATEF.jpg7x DJHUZ.svgThe files in the folder xy are always the same and should only be copied to the folder orders.Best regardsPatrick

1
Troy Tessalone
2 years ago
S
SteveskiNew
asked in How Do I

How do I parse Jotform fields into smaller subfields?

Hello, is it possible to specify certain parts of the Jotform Field to go into a corresponding filed in a Zap?For example, I have a Full Name field in JotForm that gets the First Middle Last of a submitter. When I map that field to say create a contact in Xero to First Name, the entire name will populate there. Is it possible to specify that I only want the first name part of the Full Name field in Jotform to be inserted into the Xero first name field. The same happens with the address field, where Xero asks for Address Line 1, 2, city, state and it comes from Jotform as one long piece of info. I know if I made each field item its own Short Text field in Jotform this would work, but it then ruins the user experience and other setups I have in Jotform. 

1
Troy Tessalone
2 years ago
A
Anonymous
asked in How Do I

Using Zapier to export all my existing and past Google Calendar events to Google Sheets?

Hello! I need to export this entire year’s events (past and present and future) from my Google Calendar to Google Sheets.  Has anyone successfully accomplished this? Thanks!! 

2
GetUWired
2 years ago
E
ekurutzBeginner
asked in How Do I

Missing fields from Airtable New/Updated Record trigger when setting up Google Sheets action

Hello, I am trying to configure a zap that will update a google spreadsheet each time a record is created/updated in Airtable. The Trigger I am using is “new or updated record in airtable” and the action “Find or Create a Row in Google Sheets”.  When I get to the Step of mapping the Google Sheet Fields to the corresponding fields in Airtable, there are a number of fields that are not appearing in the dropdown menu. Does anyone know what may be causing this and how to remedy it? I’ve included a screenshot below (note: the fields that do not have the airtable icon next to the field name are those that I manually keyed in)   

3
Troy Tessalone
2 years ago
M
ModashBeginner
asked in How Do I

Avoiding duplicates with Pipedrive instant zaps

I’m trying to set up a workflow where certain Pipedrive(CRM) attributes would be shared to ChartMogul and Intercom. The issue I am facing right now is that I am using deal updated as a trigger and it’s an instant one. Whenever the deal is updated, the zap is triggered and it consumes several tasks even if none of the fields that are shared to other platforms are updated. I’d like to found a solution where tasks are only triggered when the attributes have been updated. Here are the solutions I have tried so far:“Only continue if” filter to make sure the data fields exist, but it doesn’t solve the issue when data fields are there but not updated “Delay for” filter in the hope of avoiding updates that have made in a short timeframe - this didn’t work because the tasks were just triggered within a delay, not merging them and using the latest one as I had hoped to

3
SamB
Community Manager
2 years ago
Terms & Conditions