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.

25370 Topics

M
Marty21New
asked in Troubleshooting

400 error when pulling from a Glide excel page into ConvertKit to start an email sequence

HI Everyone, I am getting an error message 400 when trying to pull from a glide excel page into convert kit to start an email sequence. Essentially I cannot figure out how to pull from the correct column “name” / “email” Any help would be greatly appreciated

1
Danvers
1 year ago
Z
zakNew
asked in How Do I

How do I add customer details to Acuity when they register to my audience in Mailchimp?

HelloI want to integrate Mailchimp and Acuity appointments so when a new customer register to my audience in Mail chimp His/ Her details are used as add customer in Acuity appointments so can easily do the appointment scheduling.  Thanks

1
Danvers
1 year ago
I
ish haiNew
asked in How Do I

eBay + Zapier Interagation

Hi Zapier CommunityIs it possible to Listing product to eBay using Zapier? I know that Zapier able to get info from eBay, I was curioust if Zapier to do the opposite.

1
Danvers
1 year ago
T
TornadoThunderBeginner
asked in How Do I

How do I record the date a Trello card was added in Google Sheets?

Zap process:New card added to trello list Zapier records date the card was added using formatter. (However I do not know which data value to use from trello to acquire the date the card was added. See photo reference #1) The date is added to a column in google sheets. (Photo reference #2)

2
T
1 year ago
T
telmanphBeginner
asked in Code & Webhooks

Webhooks - Add to cart trigger

Hello, I am trying to get the data from the third party app to trigger an “Add to cart” event in Klaviyo. For that purpose, I am using Webhooks by Zapier. The third party app I need to pull the data from has only an option to setup an Order placed webhook that passes the data once the payment is made. Is there any way I could make the trigger work once add to cart button is hit? I am not a developer, therefore, would greatly appreciate any help! 

2
Satya09
1 year ago
A
afenosNew
asked in Code & Webhooks

Shopify order brought into Salesforce, with Zapier, but line item price is divided by quantity ordered in item price

I have an active Zap that brings a Shopify order into salesforce, creates an opportunity and adds line items, found in pricebook, to the newly created opportunity.  The issue is that the item price brought into the opportunity is divided by the quantity of items ordered in shopify. Example, buy 4 units at $3.49 each on shopify - in salesforce it is entered as correct item but price is $.87 ($3.49/4). I want the items ordered in shopify store (quantity and price) to match in salesforce opportunity.  Here is the code i have, where i think the error may be: import restring = input['string']sku = re.findall('\[".*?",\s".*?",\s"(.*?)",\s".*?",\s".*?",\s".*?",\s".*?",\s".*?",\s".*?",\s".*?",\s".*?",\s".*?",\s".*?"\]', string) quantity = re.findall('\[".*?",\s".*?",\s".*?",\s"(.*?)",\s".*?",\s".*?",\s".*?",\s".*?",\s".*?",\s".*?",\s".*?",\s".*?",\s".*?"\]', string) price = re.findall('\[".*?",\s".*?",\s".*?",\s".*?",\s"(.*?)",\s".*?",\s".*?",\s".*?",\s".*?",\s".*?",\s".*?",\s".*?",\s".*?"\]',

2
Satya09
1 year ago
Raoni
RaoniBeginner
asked in Code & Webhooks

How do I set up the conditional logic to assign lockers with bookings within Google Sheets?

Hi all, 👋I’m Raoni, an Airbnb host, and the Zapier Community already helped me a lot with my automations ! 😊 Today i’m back because i need to build a zap that will allocate a locker (for luggage deposit) to my guests. As usual, sorry for my english... Context :I have 2 lockers with code lock.Before their stay, my guests fill an online check-in form and indicate if they’ll need luggage deposit on arrival, departure or both.Guests might fill the online check-in form several times.Guests might fill the online check-in form in non-chronological order (IE : guest 3 fills the form before guest 1, and guest 1 does it before guest 2) What is my workflow :When new booking is made a zap fills my Gsheet data base with all the booking informations (booking number, name, dates, phone, etc...) When guests fill the online check-in form another zap updates the Gsheet data base with the informations provided by the guests (beds needed, arrival time, departure time and if they’ll need luggage deposit)

3
Raoni
1 year ago
B
Bounty27New
asked in Code & Webhooks

Postman pre-request scripts - equivalent in Zapier?

I am trying to emulate a pre-request script in Postman, in Zapier. What is the best route to look at for these, would it be using CODE as the step before the webhook?

0
B
1 year ago
A
Alex11111111Beginner
asked in How Do I

How to find holidays events in Google Calendar ?

Hi,What I’m trying to do :1 - Find an holiday event in Google Calendar the 11/01/2022 (1st of november). I’ve tried every format of date and every search term but I can’t seem to make it work, could someone help me to configure the action ? Ty very much.   

4
christina.d
1 year ago
V
VservignaNew
asked in How Do I

Merging Zapier Accounts

Hello, Because of my messiness, I ended up creating 3 different Zapier accounts with each having between 3 and 6 Zaps. I have decided to get a Professional plan and put all my Zaps in one account. Is there a way of merging the accounts or even transferring all the Zaps to one? 

2
christina.d
1 year ago
A
AndreaLaneNew
asked in How Do I

Create appointment from ChatBot using Square Appointments

Hello Zapiers, I am trying to figure out if this is possible:My client uses LiveChat and ChatBot, and receives numerous inquiries about (square) appointments through the chat. I am wondering if I can use Zapier to trigger a query to the Square appointment system that can help customers make appointments directly through the chat...or even see the Square Appt availability from within the chat. I’m trying to increase the helpfulness and value of the ChatBot as much as possible.Many thanks,Andie

2
christina.d
1 year ago
E
egodorNew
asked in Troubleshooting

Unable to map Privacy Policy field in a Facebook Kajabi Zap

I get the error that the field is not mapped correctly, however no Privacy Policy option comes up. I see all kinds of otehr options, name, disclaimers, IDs but not the privacy policy field.

4
christina.d
1 year ago
U
utahbikerdudeNew
asked in Troubleshooting

Clockify wont pull time entries for other users except the user logged into the zapier

Zapier wont pull any time entires from any other users expect the user that is logged into zapier as the integration user.  Any way around this? In Clockify we are just using the Kiosk Feature.

3
christina.d
1 year ago
A
AlmuniforumsNew
asked in Troubleshooting

Memberstack error: Failed to create a member in Memberstack (1.2.0). There was a problem with the data from this step.

Please can you assist.I am trying to update a member in Memberstack when a change to a board is made in Monday. I am having a problem in that zapier is asking for item_name: which I am unable to find in the feed from Monday.

4
christina.d
1 year ago
F
fwpBeginner
asked in Troubleshooting

Get Asana Task by ID – custom fields returned accessible easily / are not flat

Hi,Not sure if anyone has encountered this. Task AffectedFind Task in Project in Asana Find Task by ID GET Asana Task by IDWhat I’m trying to do:Get the values of specific custom fields. ProblemCustom Fields are returned in an Array (not a problem) However, Zapier is grouping custom fields within the Array by the same key, e.g. an array of GUIDs. [See screenshot 1 and 2] Expected ResultExpect it to group custom fields by GUID instead.  E.g. being able to use the custom field value for each specific GUID. I believe the way I can get around this at the moment is to format / map each to their respective field, but that seems counter-intuitive Options?Is there anyway to play around with the array itself; and format this myself? I know with Asana Zapier Triggers, the custom fields are their own item to select in Zapier. So I do not know why this is differentiated with tasks. Any help would be greatly appreciated!

9
christina.d
1 year ago
Z
ZapinCompanyNew
asked in Troubleshooting

Ping slack user group

Hello all, I followed the instructions found here on how to ping a user group. However, when I tested it, it did not result in a ping. What I inputted<@S043CN1F9BJ>What resulted Any help in troubleshoot is appreciated 

1
Troy Tessalone
1 year ago
K
kpoehlsNew
asked in How Do I

Use Zap to add file to Mailchimp file manager

I’m needing to create a Zap to put an image file (.jpg) into my Mailchimp file manager, triggered by a new file in Dropbox. Mailchimp supports this https://mailchimp.com/developer/marketing/api/file-manager-files/add-file/ but I can't figure out how it’s done in Zapier. 

2
christina.d
1 year ago
J
Julie GUS CHATNew
asked in Troubleshooting

HubSpot error: Failed to create a ticket in HubSpot, status code 400 bad request

Hi, I’m working on a Zap to create a new ticket in hubspot, but the set up action don’t appear and i cannot do my zap, It happens to someone else? We have some solutions?   

2
christina.d
1 year ago
K
Kevin1180New
asked in How Do I

How to have Google Calendar change events to busy

My work has a system set up to automatically create events on my Google calendar and I have a Calendly account that lets clients know when I can take calls. The problem is that the new calendar events that are generated are marked as “free” but I want them marked as “busy” so that Calendly tells clients I’m unavailable at that time.  I’ve tried multiple times but I can’t figure out how to set the Zap “action” to either 1) change the event that was just created to “busy” or even 2) change ALL my events on my calendar to “busy.” Either one would solve my problem and I don’t mind if all my events are set to “busy.” Anyone know how to do this?

4
K
1 year ago
K
Kevin90HDBeginner
asked in Troubleshooting

Images do not come across when transferring webclipper-like notes from Evernote to OneNote

Hi there ,I'm new to zapier and trying to transfer a webclipper-like note from evernote to a new note in OneNote.The transfer is done I select HTML content but when I open it in OneNote the text appears well but the images are marked unavailable with the cross.Do you have some advice for me?

3
Danvers
1 year ago
A
ABABABBeginner
asked in How Do I

Attaching a file to emails, generated earlier in the zap GOOGLE DOCS

HiMy zap generates a file from template in google docs then puts it in a drive folder I then wish to email that document to a contact But I am having trouble attaching the generated file to the email How do I do this? Thank you in advance

4
A
1 year ago
A
Antoine59Beginner
asked in How Do I

Update Database Item Notion (few items)

HelloAs soon as a new user is created on Mailchimp, he arrives on a notion record.On the other hand, I would like the "rating" column to update as soon as a subscriber's score is modified automatically. How to do this ?Regards  

4
Danvers
1 year ago
T
TimDBeginner
asked in How Do I

Connection Zapier & OTYS

Hello, Our ATS, OTYS said to us that there is a connection between Zapier and OTYS. I found a webinar on YouTube also. But when I want to make a Zap between Zapier and OTYS, I Can't find OTYS in the connections. How?

1
jesse
1 year ago
C
CNVCNew
asked in How Do I

Return the next March 1st date

I am trying to return a date of March 1 of the next year unless today is earlier in the year than March15.So if today is 09/01/2022 then I would return 03/01/2023.If today is 02/01/2023 then I would also return 03/01/2023That means I can’t just increment the year by one year in all cases.I extracted the current month and current year in previous steps, then tried this spreadsheet formula:if(<current month> >= 3, "03/15/" &  <current year> + 1, "03/15/" & <current year>)The problem is, the formula blows up when concatenating a string and a number, and there seems to be no function to cast a number to a string (and it won’t do it automatically). And since spreadsheet formulas have no date functions, there seems to be no reasonable way to combine simple logic and date transformations.Questions:Is there some simpler way of approaching this (without code)? Is there some way in a spreadsheet formula to combine a string and a number? Why didn’t they include any da

3
GetUWired
1 year ago
O
OllyW81Beginner
asked in How Do I

How to update an existing Todoist task when Google Calendar event is updated?

Hi everyone, I’m looking for some brilliant minds to help me with my challenge :-)What I’d like to achieve is when someone adds a new event OR updates an event in my google calendar, it creates a task in Todoist OR updates an existing task. Now, I’ve managed to achieve this first part relatively easily but I can’t seem to get the second part to work which is searching for an existing task and updating it with the new information. I’m getting an error message that it can’t find it. I’ve tried using a custom field of ‘Summary’ which is the event title. I can achieve it if I look for a specific existing event but that’s a bit pointless. I’ve also tried this from a slightly different direction and duplicating a new event from my main google calendar into a specific todoist google calendar (this allows me to toggle my todoist tasks on/off and there’s a pretty good integration directly). But then I come up with the exact same problem...I can’t seem to find existing events and then update the

3
Danvers
1 year ago
Terms & Conditions