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 Zapier University 101

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

How Do I...? Troubleshooting Popular Apps Q&A 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 Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell

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

Interest Areas User Groups

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

Zapier University 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.

15217 Topics

davidweiss
davidweissBeginner
asked in How Do I

Google Sheets IMPORTXML is still "Loading..." when my Zap reads the cell. Need the values tho.

Hi everyoneso, following up on a recent discussion on how to scrape data from web to GSheets via IMPORTXML (THANKS A LOT! 😊) (or, better, some third party GSheet addon for importing XML since IMPORTXML doesn't always work for me somehow, *have you encountered the same?*) https://community.zapier.com/discussion/152/does-anyone-know-of-any-other-smart-ways-to-scrape-data-from-websites#latest)I now have the issue that the IMPORTXML is still Loading data when my Zap runs and wants to extract the data from the IMPORTXML, so it is sometimes returning "Loading...". How would you go about this? I can insert a WAIT step of course and only use one row for data extraction and then append the values-only to a second worksheet containing raw data. Is that what you would do? Somehow it doesn't look that sexy to me.

1
PaulKortman
3 years ago
M
MartintNew
asked in How Do I

authentication failed: Got 401 calling GET https://www.exemple.com/wp-json/wc-zapier/v1/ping, triggering auth refresh.

Hi everyone, I receive this error message when i try to make a Zap for Woocommerce. Someone have the solution at this problem? authentication failed: Got 401 calling GET https://www.exemple.com/wp-json/wc-zapier/v1/ping, triggering auth refresh.  

34
R
1 month ago
codetycon
codetyconBeginner
asked in Code & Webhooks

How to convert custom fields array into the key value pair?

I have a trigger, which returning ar array of custom fields. each element of the array have a two keys FIELD_VALUE and FIELD_NAME.When I am mapping these fields in an action there are only two field available :FIELD VALUES ==> comma(,) separated values of all custom fields key FIELD_VALUE, similarlyFIELD NAMES ==> comma(,) separated values of all custom fields key FIELD_NAMESI want to convert all of the fields in a key:value pair. So the value of FIELD_NAME will be a key and value of FIELD_VALUE will be a value.I have tried to use code by zapier but it is not working as expected:Here is my JS code:var names = (inputData.names).split(',');var values = ((inputData.values).toString()).split(',');var obj = names.reduce((obj, key, index) => ({ ...obj, [key]: values[index] }), {});The problem is null values, Zapier removing null values from comma (,) separated string.

13
cooksey
3 years ago
K
Kuba from HiPetsNew
asked in Code & Webhooks

How to post data to my API without building custom app?

Hey guys, I'm new here although I been using Zapier in the past, it were always very simple automations which were based on available apps by a default. Today I have such a challenge to create an integration with my own app. I think that I can use Zapier in a few different ways, depending on what I need to do. But in this case I would like to do a Zap by posting data through our API.To do so, do I need to go through developers platform and publish my app as I was going to offer a possibility to integrate with my app for the others even, if it's not my plan at the moment? I can imagine that if I do so and my app will be available in Zapier's marketplace I'll be able to use it for my own needs.Is there perhaps a different way, to achieve the same result without going through developers platform? Is this possible to choose while building Zap an action 'POST to my API'? Could you please direct me to where I can discover more about this subject?Have a good day everyone

2
Paolo
1 year ago
C
ChampBeginner
asked in How Do I

Google Sheets - "The caller does not have permission" error

Hi there,I’m looking for some pointers on working with Google Sheets, let me outline the scenario..I’m trying to update an attribute in my CRM (Sendinblue) for new contacts.​​​​​​ I’m taking these steps:Trigger - new contact created in Sendinblue Get a ‘code’ from a Google Sheet row (through Get many Spreadseat Rows) Update the contact attribute ‘XYZ’ with the code from Google SheetsThis connection seems to be working, however, on the Google Sheets step I’m getting the error ‘app returned “the caller does not have permission”. So it seems to me that Zapier can read the file, but somehow cannot return the information from the Google Sheet...My Google Drive is connected to Zapier and to be sure I’ve set my Google Sheet to Public, but I’m still receiving the error and the attribute is not updating correctly. Do you guys have any suggestions what to do here?

3
SamB
Community Manager
1 year ago
M
Martin
asked in How Do I

Parsing or Saving CSV Email Attachment into Google Sheets

Hi everyone, I'm hoping the community can help me with setting up my zap...I get a daily email from one of our vendors with an attached csv. I download & port the contents of this CSV over to a google sheet for records keeping / processing every day (mega repetitive). My ideal scenario would be: gets daily email > zap creates new row in google sheet from each row in attached CSV.I would also settle for a scenario where zap simply creates a new google sheet from attached CSV in a designated folder. Thus far, I've tried using the email parser, but haven't been able to get it to recognize the attachment.

8
V
2 years ago
R
rikmarisBeginner
asked in Code & Webhooks

How to remove ctrl-char code 13

Hi everyone,   I have an issue to make an post api call to HubSpot. The value that i want to send gives this Invalid input JSON on line 16, column 17: Illegal unquoted character ((CTRL-CHAR, code 13)): has to be escaped using backslash to be included in string value Does anyone have any idea or tips or scripts to remove all these?

11
R
2 years ago
N
NTYogaBeginner
asked in How Do I

How to select a file as an attachment for Gmail

I want to setup a zap where a new user in Thinkific triggers an email from Gmail with an attached document. I can’t seem to figure out how to add the attachment though. Please help!

3
Danvers
Community Manager
2 years ago
L
LVzapsBeginner
asked in How Do I

to create a dynamic table is to integrate it in an email

Dear all It's been several hours that I've been trying to retrieve my items, number of items, and prices from my CRM in order to automate the order confirmations, but I can't manage to create 3 columns and go to the line at all. I took care to automate the separation of data in google sheet, I tried to format ... but I can not do it. Could you please give me a tip?  thank you very much take care

3
Danvers
Community Manager
2 years ago
Danvers
Community Manager
DanversCommunity Manager
published in Code & Webhooks

How to define segments when splitting a string of 2+ words using code

For example: Someone uses their full name in one field instead of first and last in separate fields. If you then want to split it and define the first word (name) as the first name and any other words in that field as the last name, you can do that using some JavaScript code.Option 1First name’s the same no matter what, so we can define it herevar firstname = nameArr[0]var lastnameCheck if there’s more than 2 elements in the array (i.e. a middle or multi-stage name)if(nameArr.length > 2){Remove the first item in the arraynameArr.shift()Then join that modified array up with a space in between the elementslastname = nameArr.join(" ")} else {But if there’s less than two (i.e normal name) then return the last name as you werelastname = nameArr[nameArr.length - 1]}output = [{firstname, lastname}];Option 2Here is another alternative:var fullName = input.name.split(' ');var firstName = fullName.shift();var lastName = fullName.join(' ');output = [{firstname: fi

39732
BowTieBots
3 years ago
A
Anonymous
asked in How Do I

"@" mentioning roles in Discord

I’ve been testing things on Zapier for about an hour now and I can’t seem to be able to ping a specific role, although @everyone works but not other roles.

5
jesse
Community Manager
8 months ago
M
moonBeginner
asked in How Do I

Facebook Groups - keeps asking me to Reconnect account

no matter i reconnect again and again it always said expired can u guys fix it?

54
J
2 years ago
J
Jack FernleyNew
asked in How Do I

Instagram to discord embed

Hey all!I’m relatively new to all of this, but I want to create a bot that sends a message out to my discord; however, every time I try do this it’s a ugly mess. How do I embed my actual Instagram post within the bots message? I wanna have a clickable link with my post as the thumbnail

3
christina.d
Community Manager
6 months ago
A
Anonymous
asked in How Do I

Someone help me create a zap please :) Dave Ramsey Lead --> KVCORE.... Happy to pay.

Pretty self explanatory :) I need someone to help me create a simple zap that adds Dave Ramsey Real Estate Leads to my CRM (KVCORE). Dave Ramsey Leads to no come in on a major platform. So I have no clue how to go about creating this! 

3
AndrewJDavison_Luhhu
2 years ago
Bob
BobBeginner
asked in How Do I

Does anyone have experience with Email Validation and/or USAEpay integration with Zapier?

Hello Zapier Community!Some quick context- the past decade I have owned and operated a debt collection agency. I've been in the process of shutting it down for over a month now in order to pursue a career in automation.I still have thousands of accounts that require follow ups and I'm trying to leverage Zapier to run an email campaign on all of the people who had promised to pay (and then weren't followed up with).Because debt collections uses high risk payment processing (and Stripe isn't a fan of that industry) I have to use USAEpay which has no native integration with Zapier so I think this is the perfect time to jump into webhooks. I was wondering if anybody has experience specifically with USAEpay?Another potential issue is invalid email addresses. Between data entry errors and verbal miscommunications- we would bounce enough emails to be flagged as spam if we didn't pre-screen the email addresses first.This is a one time campaign (with consent of course)

6
Danvers
Community Manager
3 years ago
R
randyNew
asked in How Do I

Discord Bot unverified

When I try to add the bot to my discord, it says it hasn’t been verified. Admins, is this something you can pass along?

27
Danvers
Community Manager
2 years ago
J
JuangettyBeginner
asked in How Do I

IP address whitelist

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 together faster or is there a range we can specify? 

1
steph.n
2 years ago
S
Stewart_GARealtorNew
asked in How Do I

Editing Gmail message in Zapier

Hi. I’m new to Zapier and I don’t do HTML code!  Or very little.  I have a zap set up to tie a FB Lead Ad Form to email me a notice of a new lead, and it’s also linked to send a Gmail message back to the respondent.  Now, I’ve created a video with the information and I want to replace most of the email text with a video thumbnail and link that to the YouTube video.  But I’m not seeing any sort of Editor palette to be able to do that, or any sort of format editing.  Heck, I can even do that here in this message! Is plain text, and HTML my only options to be able to do that and send an email back?  I haven’t tried yet, but if possible, I could insert a bitly link to the video, but I’d like to format some text and put in a thumbnail photo instead.  Or, can I possibly lay it out in Word first and then get the HTML code for that somehow, but I’d have no idea how to do that either!I appreciate any input.  Thanks in advance. Stewart

2
AndrewJDavison_Luhhu
2 years ago
V
vitalynNew
asked in How Do I

How come Zapier uses the wrong timezone when using a zap?

I have set my timezone in my profile correctly (UTC+2, “Europe/Amsterdam”). I proceed to create a test zap for my application and enter a date into a datetime field, for example, “01-01-1992”. For some reason Zapier converts this date into the following datetime string: “1992-01-01T00:00:00+01:00” This is UTC+1, not UTC+2, meaning this would actually an hour earlier and thus the date becomes: “31-12-1991”. Has anyone else experienced this issue or am I missing something here?

3
Liz_Roberts
Community Manager
2 years ago
StuartJLans
StuartJLans
asked in How Do I

Running a Webhook with Line Items

Hey everyone, Just wanted to know if anyone else has come across this. I am getting data from one webhook with a GET request and it returns it as JSON. I am then trying to run a webhook based on this return of data but it is taking the data like field1,field2 and providing it and not sending field1 and then trigger again with field2. I have tried using the Formatter step to make line items of the fields and it still feeds into the webhook like the above example. Has anyone got a clean solution for this? The dirty way that I would do it is to make rows on a google sheet with the line item support and then trigger based on that but wondering if there is a cleaner way?Thanks!

6
Danvers
Community Manager
3 years ago
P
Putra
asked in How Do I

Multiple Triggers for one Zap workflow?

Hi,First of all, I'm sorry if this question has been asked before.I want to know if we can set multiple triggers for one Zap?Here's the flow of my current Zap:[trigger] New row created in Google Sheets --> Create new task in AsanaHere's what I want to achieve:[trigger] New row created in Google Sheets --> Create new task in Asana --> Send email on Gmail --> [trigger] When the Asana task is completed --> Reply the Gmail threadI know i can set up 2 Zaps, however by doing so, I'll won't be able to use data from the Google Sheets.Thanks!

1
Liz_Roberts
Community Manager
3 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
1 year ago
arlindojr
arlindojrBeginner
asked in How Do I

WordPress Create New post - no custom fields

Still not working. I'm trying the same, looking for advanced custom field that I've added to my post. Here it is: I think the slin.partner field should showing up when zapier refresh the fields, right?     

110
jammer.solijon
1 month ago
E
epeteNew
asked in How Do I

Discord SMS alert when specific user and/or text string is found

Discord and SMS Alert already seem to be integrated.  Can it go further and only send SMS Alerts when a specific user posts, or it finds a specific text string.  Would be especially helpful for when a specific user posts a message containing a “key alert” text string?  i.e., send me SMS Alert whenever the administrator sends a message containing “Overnight Ideas” or “Overnight Idea”.

1
steph.n
2 years ago
R
redearmedia
asked in How Do I

Extract column data from Monday.com field

My goal: Zap data from Monday.com to a Google Sheet when a new entry is added to a specific board on Monday.My problem: Although I have identical columns in Google Sheet as I do on the Monday board (and data seems to be flowing between them), the columnular data from Monday seems to be arriving as a key:value pair (almost like JSON). Is there any way to extract this into separate fields for the Sheet? In the screenshot (which I've tried to remove any identifiable info from), you can see that the Name field maps well, but as soon as we get to the next Sheet field ("Google Ads ID"), I basically get all of the rest of the data as one field called "Column Values". Is this just an issue with Monday.com's API or is there something I can do to further extract that data?Thanks in advance!

17
J
2 years ago
Terms & Conditions