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.

25507 Topics

A
alexadagostinoBeginner
asked in Code & Webhooks

Issue with Monday Get Item by Column Value in monday.com

Has anyone experienced this before. I am trying to pull in Monday data into Zapier so that I can update fields in Monday when someone reschedules. So to break it down:I have the Monday Reschedule function. I then have 3 checks using Get Item by Column Value in monday.com (three different databases) to see if the person exists in any of these databases.  What I am finding is, for some reason, even though I am clicking a specific reschedule appointment In the “get Item by Column Value” it’s actually pulling the completely wrong person making it so I cannot do proper checks to get my zapier to actually launch.What I DO find though is if I get it to launch, it WILL run right but just not during the test. Anyone else experience this? ​​​​​​​ 

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

Line Break between two fields in Zap

Hi there,  How do I insert a line break or next line break in between these two fields? I’ve used formatters, but it doesn't seem to work at all. It's currently importing like this:It should be imported like this:Billing Address 1Billing Address 2  Please assist, and thank you in advance.  This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.  

1
Troy Tessalone
2 years ago
E
EDLOHNew
asked in How Do I

How do we add Zapier as a remote connection in MYSQL?

Hi there, I have an issue as below where i do not know where/what to enter as the Zapier ‘Remote Sql’. Does anyone face the same issue as me, and if so can I know what should be the correct entry? Thanks in advance!   

1
Danvers
2 years ago
J
JackprostNew
asked in How Do I

Can Zapier connect to and edit CUSTOM campaign member fields? Marketo >> SFDC

We currently use campaign members to track a lot of the activity they are doing either on the web or at specific events. Out of the box, Marketo can only add leads/contacts to campaigns and update their member status.Can Zapier connect to the campaign member object and update all of the custom fields in the object? We have these fields in the Programs in Marketo, just no way to connect to the CM object in SFDC.

1
Danvers
2 years ago
I
IngeNew
asked in Troubleshooting

SMSAPI account expired can't reconnect it and getting error message.

I've connected my SMSAPI account (the account is live and working), but i'll get the message that i have to reconnect (but it doesn't work. In the Zap i'll get this message. How can i fix it? 

1
Danvers
2 years ago
Z
ZapianzeNew
asked in How Do I

Sending Zoom videos to Google Drive, but it won't send videos more than 1GB

my zap for sending zoom videos to google drive does not work for videos larger than 1gb, or videos whose sum of files is greater than 1gb. Is there an upload limit per action?

1
Troy Tessalone
2 years ago
D
dane78Beginner
asked in Code & Webhooks

Zap not triggering for new webhooks sent

h teamI have created a ZAP which should run a triggert by a webhook. after subscription i got the hook urlas i run the following code (same from postman) i can see the hook in the monitor but nothing actually happned in the zap (emai/goolge sheet) am i missing something? await fetch("https://hooks.zapier.com/hooks/standard/5461766/f82abd556c744950bb4804b049a13eda",     { method: "POST",       body: '[{"id":20829875,"name":"M","firstname":"m","lastname":"w","company":"S","phone":"","title":"d","location":"usa","email":"xxx"}]',      headers: { "Content-Type": "application/json", Accept: "application/json", } });   

4
T
2 years ago
R
Rocio LandivarBeginner
asked in Troubleshooting

Issue creating item on monday.com "Cannot read property 'map' or undefined" error

Hello! I’m having trouble to set my zap. I actually set this zap before and it worked I don’t understand why it’s not working now: When a PandaDoc document is completed, create an item on monday.com and fill that item columns with information from the document completed in Panda. I tested the trigger on Panda an it worked good, the problem is when I set the action in monday.com:I’m not able to fill the item columns with information as they are not shown on the action set up When I test the action it says: "Cannot read property 'map' or undefined" and it shows Board ID, Group and Item ID empty as if I wasn’t filled that up before which I did   I set this zap before, and when I go and edit the zap that is already created it does not let me edit the item columns   Did somebody has this issue too?

20
JammerS
2 years ago
B
Ben123New
asked in How Do I

How to send an email (Gmail) when a specific lead status on HubSpot has changed?

I would like to send an email from Gmail when a lead status has been changed on a Hubspot contact, but when I try to do it, it only do it for all the status. The email I would like to send is different from every lead status.I would like to choose a specific status, does someone knows how to do it? Thank you 

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

Creating a link in a Google Doc from a template and Airtable

Hi there, I am using Zapier to create custom google docs for clients from a google doc template (with data pulled from Airtable, each client has a record). Everything is working just fine. But I have a question. One of the Airtable fields is an attachment. I’m guessing I cannot add the attachment to the google doc through Zapier. However, I am able to add the link to the attachment. (That is, I can add the relevant link to each client’s google doc.)However, right now the link is just text-- it’s not a functional link. Is there any way to make that text into a link?Would I do this with the template?Thanks, 

6
Troy Tessalone
2 years ago
L
litechBeginner
asked in Code & Webhooks

Need help extracting data from webhook

Hello all, I am trying to figure out how to extract regular data from a webhook through Zapier. Here’s a snip of the payload as it comes in:message:    type: message    text:*Order-Form* submission from <user> *Item * Server Warranty Renewal *Company * Test Company I started messing around in Code but can’t get the js to run and do what I need. Normally, I’d just be able to pull the values or pick off a child key, but it seems like I’ll need some sort of coding with this since my two items I need are nested under “text”. The text after “item” and the text after “company” are going to be different every time. I would need to extract those values every time. This is where I am completely stuck. Any help would be greatly appreciated! :) 

6
Troy Tessalone
2 years ago
O
OmnicellarDoorNew
asked in How Do I

How do I send Facebook comments to Slack Channel?

Is there any way to send Facebook comments on a business page to a Slack channel? I want to be notified whenever someone leaves a comment on post, and have that comment posted in a Slack channel I’ve set up for that purpose. I’m new to Zapier, and I’ve noticed that you can send posts on your page’s timeline to a Slack channel, but I haven’t seen anything about doing so specifically for comments. Can anyone help?

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

What will the user interface be like for a first-time user of Zapier?

I am looking at Zapier to connect my clients using Insightly and Square. If they use Zapier, what is their user experience like in terms of a screen. In other words, would they still use Insightly and Square with the same screens and navigation as they do now without Zapier? Or would they be working a new type of screen? Does Zapier work in the background or change their screen use? Thank you.Andy

1
Troy Tessalone
2 years ago
I
IshootparNew
asked in How Do I

Automating blood pressure, weight, caloric intake, and liquids

I find myself struggling to find a way to automate import of blood pressure data from an (Omron Bluetooth monitor) and nutritional data from (my fitness pal)and weight measurements from Bluetooth (Body+ Scale) …To a custom spreadsheet that I have created to monitor pleural drainage data My wife has an implanted catheter (PleurX BD)… we can’t do the drainage procedure unless several conditions are met on a daily basis… I am currently entering the information manually… I’ve attached a copy of my spreadsheet for your review… Treat only as data as it is private information… it is a work in progress, I plan on Adding charts and graphs and averages and all that fun stuff when I get the data portion finalized…Any assistance on the automation from the 3rd party apps would be appreciatedTim P.This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.  

1
Danvers
2 years ago
D
DimNew
asked in Code & Webhooks

Adding user info to a new row when a new member joins my Discord server. How do I send messages to a Discord channel when the Zap runs?

Hello I use zapier to add the users info to a new row every time someone joins my discord server! The problem is that its kind of a hassle to come back to the website to make sure it runs. Now for the question, Is it possible to send a message to a discord channel I set every time the zapier process runs?

1
Danvers
2 years ago
J
joyNew
asked in Troubleshooting

The app returned "Mime type text/html is not supported".

hey, i tried sendng an  NEW SPREADSHEET TO BASE54.AI, THE ZAP BRINGS AN ERROR,The app returned "Mime type text/html is not supported". TRIED PUTTING IN A LINK , FOR EXPORT IN XLXS,CSV,PDF FORMAT , STILL bring the erroe, not sent

1
Danvers
2 years ago
N
NarcoisNew
asked in How Do I

Add a tracking category to new xero invoice

Hello,We get new invoices coming in from gettimely to Xero via gettimely’s Xero integration. The problem is that the integration between gettimely and Xero does not have the ability to populate tracking categories set up in Xero.We have a tracking category in Xero called “locations”. The location is populated by Timely, but in the description field. I can create a filter that looks at the description field of the item and extracts the location.What I’m wondering is if there is a way to update an existing line item in a Xero invoice to add the location in the location tracking category. I don’t see an ‘action’ option in Zapier to update an existing invoice. Thank you,Narcois

1
Danvers
2 years ago
G
GCarterNew
asked in How Do I

How to set up automated monthly Quickbooks invoicing based on Google Ads account ad spend?

Hi, I’m trying to setup automated billing for my Google Ads/Facebook Ads agency. I bill based on actual ad spend at the end of each month. So, I bill for March in the beginning of April based on the previous month’s spend for each clients ad account(s). Is there a way to use zapier to automate Quickbooks invoicing while referencing unique ad spend from Google Ads for each client so that the amount of each invoice is updated to the exact amount spent in the Google/Facebook Ad account? Thank you!

1
Danvers
2 years ago
M
MattiBeginner
asked in How Do I

Create a new lead into the Leads Inbox in Pipedrive from SharpSpring when a contact has a lead score > 50

Hi,I am trying create a new lead into Leads Inbox in Pipedrive from Sharpsring when a contact has a lead score > 50. However, I have not been able to figure how.

6
Troy Tessalone
2 years ago
C
Contessa_StoreNew
asked in Troubleshooting

Getting error when creating a new Zap : "Lost race to unpause the Zap"

Hi, I got this error after creating a new zap: “Lost race to unpause the Zap” What’s meaning? & how to fix?

1
Troy Tessalone
2 years ago
K
KnowbodyNew
asked in Troubleshooting

Google Sheets - Error: Nothing could be found for the search.

I am Trying to create a Zap which will update an existing Google Sheet Row when a new Google Calendar event is created.The trigger seems to be set and the first update tests well. However, the function needs to update subsequent rows each time the Zap runs. I have built the Lookup Spreadsheet step but apparently missing something as I am getting this notification:  The search is set up as such so that if the date column on the spreadsheet is not yet populated the update should execute.What am I missing? I am about as green as they come so surely it is something simple.

1
Troy Tessalone
2 years ago
bubba198
bubba198Tinkerer
asked in How Do I

How do I trigger a Zap after each time a contact is sent an email via MailChimp?

Hi everyone,I need to trigger a Zap when MailChimp sends an e-mail to a contact in an audience. My MailChimp campaign is super simple; on-going type of campaign which fires once a week. When it does fire it sends an e-mail to each contact from an audience. I need my Zap to fire for each e-mail sent. I can’t find that as an available trigger in the existing Zapier App integration with MailChimp.Anyone has an idea or suggestion for me how to go around solving this? Oh the reason I need the Zap to fire for each e-mail is so that the record of the person is notated in our CRM via an API call (that’s the easy part; I just need the Zap triggered)ThanksBoyan 

5
Troy Tessalone
2 years ago
H
HaslanNew
asked in How Do I

How to split leads from Zoho Forms into 2 Google Sheets?

Hi.. May I know if there’s a way to split leads from zoho form into 2 different sheets by rotation.exfirst lead to A sheet2nd lead to B sheet3rd lead to A sheet and so on…Thank you in advance..  

1
Troy Tessalone
2 years ago
L
LlewNew
asked in How Do I

Text to Line-item without comma separator

Hi, I am trying to perform text to line-item conversion using data from several google sheet cells. The issue I’m running into is that the text within the cells may have comma’s in them and are being split as new lines. Is there anyway to change how the separator character? Otherwise, has anyone come across a workaround for this issue?  Blank test is below. Any descriptions that contain  commas are split into additional lines when I don’t want that. I saw a previous article from 1 year ago but it doesn’t seem to have any answer other than “you can’t do it”Previous Article:  

1
Troy Tessalone
2 years ago
A
Anonymous
asked in Troubleshooting

GUID Error: "Guid should contain 32 digits"

So I have a Zap that when a new row is created in our SQL, a credit note is sent to Xero. However I have this error message about Guid should contain 32 digits with 4 dashesThis is linked to the “Contact Field”.If I choose a random contact from Xero (from the dropdown list) the Zap works.However, if I choose the field called “contact” from the new row that has been created in the SQL, I get this GUID error“Guid should contain 32 digits with 4 dashes”I appreciate that contacts in Xero have a G~UID number, but I don’t know what that number is in the SQL table.Anyone any thoughts or ideas? many thanks ian

1
christina.d
2 years ago
Terms & Conditions