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.

25159 Topics

OhYaMarketing
OhYaMarketingNew
asked in How Do I

How can I pull submission date/time data from a SquareSpace form without making the user input it?

Hello. We have a client that switched to SquareSpace. In the transition, they removed Formstack Forms from their website and have decided to use the default SquareSpace forms. On the old website, we had a connection set up with Zapier that pulled the information into a Google sheet. Though it was hidden on the form, we were able to pull down submission date data (including time of submission) and was able to use that for our analytics and tracking. Using the SquareSpace form, we are unable to pull in any submission data it seems. Is there a way to pull down time/date of submission, without making the person do that on the form? 

1
Danvers
10 months ago
Paula B
Paula BNew
asked in How Do I

Can I ignore weekends when calculating a date?

I am making a workflow that tracks milestones before a project due date. The project due date could be any weekday, M-F. For example the input would be the project due date (ex Tuesday) and the task has to happen 3 business days before (ex Thursday). When I do a calculation of -3 days, it gives me Saturday.  Here are the results I want. Anyone have ideas how to make this happen? Project Due Date (input) - MondayTask Due (output) - Wednesday prior Project Due Date (input) - TuesdayTask Due (output) - Thursday prior Project Due Date (input) - WednesdayTask Due (output) - Friday prior Project Due Date (input) - ThursdayTask Due (output) - Monday prior Project Due Date (input) - FridayTask Due (output) - Tuesday prior

1
Troy Tessalone
10 months ago
J
John SmithBeginner
asked in How Do I

How to use Zapier formatter to make lists with each list item as a separate output ( for Trello tasks)

Good day, I am trying to make a zap that takes a conversation from slack, uses chat GPT to make tasks out of the message, than adds those tasks to Trello (for review by a team lead at the end of the day to ensure they make sense but to still save significant time). I am having issues though with formatting the points to make them different items that I can make multiple cards with, at the moment I can only make one card with a list of tasks. Any suggestions would be greatly appreciated.  

6
SamB
Community Manager
7 months ago
yasoja
yasojaBeginner
asked in Troubleshooting

Can't create a Salesforce Campaign (insufficient access rights on cross-reference id)

Hello,I can create Contact objects, CampaignMembers etc.  But Campaigns never work.  I’ve filled out all the required fields Name, Type, RecordType, Status etc.I verified via SOQL I have the correct RecordType by testing with an existing campaign like:Select Id, Name, Type, RecordType.Name from Campaign where Id='701EX0000009ar0YAA'The Salesforce User I’m using is a SysAdmin.  I can create campaigns as that User directly in Salesforce.  I can add CampaignMembers to existing Campaigns via Zaps as well.Keep seeing this rather generic error:Any help much appreciated. PS: I looked at a similar previous post but none of the suggestions apply to my scenario (not attempting any assignments, portal/experience cloud users not involved etc): 

12
Troy Tessalone
8 months ago
F
FJ-DevsBeginner
asked in Code & Webhooks

Zoom to Zapier Webhooks Not Validating

So I’m a little confused on where things lie...I found this thread: Will Zapier provide a solution to enable set up of new Webhooks with Zoom?It made it sound like this was a solved solution. But it’s not working for me. It also wasn’t working for the users in this thread:Zapier Webhook validation with Zoom not workingI have a Catch Raw Web Hook set up in Zapier, and it’s showing data being captured, but the auth URL fails on the Zoom side, stating “URL validation failed. Try again later.”What is anyone else’s current experience with this? Appreciate any and all efforts!

10
F
4 months ago
Jan at MIH
Jan at MIHBeginner
asked in Code & Webhooks

Help with Webhook from Google App Scripts

I have never created a Webhook in Zapier and I’m not sure what I’m doing wrong. Does anyone have an example of a Webhook that is running from a Google Apps Script?I want to run a function that adds a new row at the top to a sheet . . . when a row is added in a different sheet. I am adding a new row in sheet ‘rawdata’ via Zapier and when that row is added, I want to run the below function to copy that row to the top of another sheet ‘New Order’.I’ve tried get and post . . . I’m not getting errors now . . but it isn’t doing anything either.I’m attaching a copy of the webhook in Zapier.  Any help would be appreciated.Thanks,JanFunction:function rawDataNewRowToNewOrdersSecondRow() {  const targetRow = 2;  let S = SpreadsheetApp.getActiveSpreadsheet();  let R = S.getSheetByName("rawdata")    //.getRange(2,1,S.getSheetByName("rawdata").getLastRow()-1,14).getValues();   let rawDataRange = R.getDataRange();  let rawDataValues = rawDataRange.getValues();  let rawDataLastRow = rawDataRange.getLa

2
Jan at MIH
8 months ago
J
Joseph PeckBeginner
asked in How Do I

Keap “Tag added to contact” not triggering Zap

I use Zaps to enroll Keap customers with a specific tag to a class in Teachable.The Zap I created is supposed to be triggered when a “Zap: Add to [class]” tag is added to a customer in Keap. Zapier is successfully adding the class to my account when I “Retest & review” the Zap. However, it is not being triggered when I add the trigger tag to an account in Keap.I recently created two new Zaps for a campaign I launched last week. Neither of these new Zaps are working. This is odd, because they are set up the same way as my older Zaps, which continue to work correctly.In troubleshooting, I have tried:Applying the Zap trigger tag to multiple contacts in Keap; none of them were found by Zapier, and none of them have showed up under Zap history Creating a new Zap from scratch and double-checking the settingsI have not tried:Removing the Keap Max Classic connection and re-establishing the connection. Would you recommend I try this? Do you think my active Zaps would continue to work once t

3
J
1 year ago
Seaney Shell
Seaney ShellBeginner
asked in How Do I

How to find the root message in a thread in Slack using an @mention in the comments?

Is there a way to find the root message in a thread in slack?functionally I would like to be able to use an @mention in the comments of a thread to grab the top level post of that thread.I have the thread T which is the same as the top level post’s T value so i think I should be able to find the top level post somehow, but I am unsure how to do this.thank you in advance 

3
ken.a
8 months ago
R
RJC
asked in How Do I

Mailchimp Facebook Zap SetUp

I am having trouble indetifying if my zap is set up correctly. I have a Zap set to capture FB Lead Email but when setting up Google Sheet and Mailchimp List to capture email it appears to be only grabbing last know entry as selection. Can I chat with someone at Zapier about this?

2
Danvers
4 years ago
M
mebrandonBeginner
asked in Code & Webhooks

Handling nested response from Stripe with Zapier webhook

I am trying to do a simple function to retrieve Stripe balance on an hourly basis.  The Zapier integration doesn’t have this feature, so I am using a combination of Zapier Schedule and Zapier Webhook.According to stripe, the command is simple: curl https://api.stripe.com/v1/balance \ -u sk_test_your_key:I am successfully querying and authenticating with stripe, but the Zapier error is: Results list {"object": "balance", "available": [{"amount": 0, "currency": "usd", "source_types": {"card": 0}}], is malformed. A results list must hold children that are objects like [{key: value}]. We found "object" though.Obviously, I can see that the nested values amount, currency, and source_types are causing it fits.How do I overcome this error?

2
SamB
Community Manager
2 years ago
Z
zackapBeginner
asked in Troubleshooting

CRM access has been revoked from Lead Access Manager, but nothing works

Hi all I have been dealing with this on and off for nearly a year. The Zap (or even other CRMs) will setup completely fine but it wont ever fire. Do the Lead Ads Testing Tool > Get “CRM access has been revoked from Lead Access Manager” 103 Error Redoing the connection doesn’t fix anythingNow here’s the two major issues I get stuck at. I’ll run into one of these issues.Going to Business Manager > Integrations > Leads Access > Select Page, I don’t have the CRM tab on the account. (see screenshots of an account that is fine, and another account that doesn’t have the CRM tab.) IMPORTANT: We have many accounts that don’t have this CRM tab but work completely fine. Going to Business Manager > Integrations > Leads Access, the page isn’t listed there. IMPORTANT: We have many accounts that aren’t listed here but work completely fine.If anyone has cracked the code here I’d love some help; thank you! 

7
K
5 months ago
H
HiteshNew
asked in How Do I

Unable to detect a board on monday

I have a board on a workspace, it is not getting detected in Zappier. Any idea?

1
Troy Tessalone
3 years ago
I
infoatsenzateaNew
asked in How Do I

Copy Wunderlist task notes into Asana task description

Hi, Since Wunderlist is closing at the beginning of May, I am looking for ways to replace this app and am researching options that take make the migration as easy as possible. I plan to swtich to Asana. Using Zapier, I am already able to copy my tasks easily into new project lists in Asana including the due date, by creating a ‘zap’ that creates new tasks as I complete them in Wunderlist. I built this using the ‘Customize task’ menu. However, I cannot copy the subtasks and notes to Asana’s ‘subtasks and description’. Does any of you know if it’s possible to get this data also copied using Zapier, ór does anyone know another method to migrate my complete Wunderlist set to Asana.   (I am working on Mac OS).   Thanks!

1
andywingrave
4 years ago
N
nikiblakerNew
asked in How Do I

Copying assigned task from one Asana workspace to another

Hi there! I’m new to Zapier and am excited to streamline my workflow between email and Asana.One area where I’m stuck - I’m on three Asana workspaces. One, I consider my “main” that I rely on - the other two belong to clients who assign me tasks.I would like to set up a trigger that if I’m assigned a task in one workspace, it will automate a copy of that tasks in my main workspace.Does anyone know if this is possible? Thanks!Niki

1
Troy Tessalone
3 years ago
S
scoutzNew
asked in How Do I

Google drive : data in shared folder does not work properly

I’m trying to make a Zap which connects Google Drive to AWS S3 the main function i want to make iswhen someone uploads their files into designated shared drive, Zap automatically detect them and upload to S3 but the problem iswhen the file is uploaded into designated shared drive, Zap can find a file but mimeType is not correct (it’s supposed to be MP4 format) and the file has no data when S3 upload step anyone know how to solve this problem? 

1
Troy Tessalone
3 years ago
S
StarlightNew
asked in How Do I

Using Zap to book a buffer time appointment on my outlook calendar when a specific type of Schedule Once booking occurs

I want to use a zap to create a second Outlook appt once a specific type of Schedule Once booking occurs. The SO set up already drops the booking into my Outlook but I want a second appt too which creates a block of time for 60 min after the booked time. (the So setting for buffer time only address both before and after so if I do a 60 min buffer after I have to also have a 60 min buffer bvefore which I don't want so am hoping it's Zapier to the rescue!)

5
nicksimard
4 years ago
F
fernando cordobaNew
asked in Troubleshooting

monday.com error: Zap is likely to be missing a required field, or a field value wasn't in a recognized format: the app may return a 400 error

I am trying to connect Unbounce to a Monday board and Gravity forms to a Monday board. I have all the access in the three of them. Both Unbounce and Gravity forms work on trigger. When I try to test Monday I get error 400, bad requesting:“Your Zap is likely to be missing a required field, or a field value wasn't in a recognized format. For example, if a field in your action step is expecting an email address, but the value given is a name, the app may return a 400 error.”Im trying to create an item everytime a form is submited… It seems to be working with any other board except that one.Whenever I choose the board I only get in display the item name input instead of all the other columns like its supposed to. Definitely its a problem with my board. I have Owner access to the board, I already duplicated it and put it in a personal space and made it sharable and public and it still wont show me the column fields, therefore I get the bad requesting error (I assume).Is there any board conf

5
Reffrigerant Express
1 year ago
A
abuis78New
asked in How Do I

Update a opportunity in Sales Force - CustomField

Hi, in our Salesforce we have certain field like “Next Steps” that will be posted in the “Opportunity Field History” each time I change the content of this field. I would like to use zapier to grab the comment in trello and replace the “Field: Next Steps » value” with the value of the new entered comment in Trello. I can grab the content in trello BUT i dont really understand or finde the right action with the Salesforce App to Update or replace the field value of the Field “Next Steps”. Any suggestion?

1
nicksimard
3 years ago
S
stetsonBeginner
asked in How Do I

Conditional logic to attach multiple links or photos from Airtable to Gmail

Hey all, DATAI’m building a zap that uses airtable data to populate an email.  The airtable data has photos in one of the fields and can have 1 photo (base case) or many photos.   WHAT I NEED TO DOI need some sort of conditional logic to say if (photos.length === 1) {attach just one photo // code here or whatever} else {attach all the photos // code here or whatever}I’ve done this before in sendinblue but they give you access to a “dynamic list” feature where you can provide an array (in my case the photos) and sendinblue will loop through them.Since I get a url from the airtable data, I’m fine either including link(s) to the photos in the email body--or--including the photos as attachments. WHAT I DON’T KNOW HOW TO DOI know how to link to 1 photo or attach 1 photo but I can’t figure out how to get zapier to create multiple links in the email body OR attach multiple photos IF there are multiple photos If anyone has solved this before let me know!  Greatly appreciated!

4
S
2 years ago
lgale
lgaleBeginner
asked in Troubleshooting

Failed to create a lead in Salesforce: Could not create record of the "Lead" object: Please provide Email or Phone

Hi,I am looking to integrate Typeform into Salesforce, so when fields are completed in Typeform e.g. first name, last name, postcode, phone number and email address, these are used to create a new lead in Salesforce, that then enters into a campaign we have set up. I have mapped a phone number and an email address ​​​​​​However I get this messageAny help would be appreciated. Thanks

3
ken.a
10 months ago
C
ChrisGallaniBeginner
asked in How Do I

Set Google Calendar Out of Office

Hi, Does anyone know if it’s possible to create an “Out of Office” booking in Google Calendar, instead of an event?   Thanks,

5
C
3 years ago
G
goncaloNew
posted in How Do I

NoCodery - the no-code job board

I'd like to invite everyone to visit NoCodery.com - the job board dedicated to no-code jobs and gigs.  It's the perfect place to post a job offer if you're looking for some no-code help.  PS.: It's free to post a job offer. If you have any questions or requests feel free to contact me at goncalo@nocodery.com

0
G
3 years ago
ynnklo99
ynnklo99New
asked in Code & Webhooks

help with python code to split data

Hey guys!I really need your help since my programming skills aren't that great and Chat-GPT isn't a great help either.I have the input data, which is basically just a bunch of emails divided by a comma. The goal is to write each email in a separate line, so I can access them in a later step in the Zap. The Split option in the formatter doesn’t work at all so I thought about programming it myself.But I don't know how I have to write the code so python recognizes the email adresses. The adresses aren't static.Can anybody help?  

5
AmiriJrue
9 months ago
mizal
mizalNew
asked in Troubleshooting

Can't access some Firebase collections

I am currently experiencing a problem with my Firebase collections where only a subset of collections are showing, and the "load more" option is grayed out. I am also unable to manually type the name of the collection that I want to access.Has anyone experienced a similar problem before, or do you have any suggestions on how to resolve this issue? I would greatly appreciate any advice or guidance on this matter. Is this related to firebase rules?  Thank you in advance for your help and support. 

6
SamB
Community Manager
29 days ago
X
XmasSteps83Beginner
asked in How Do I

Zap working in test only

Have a gmail set up when a realtime database gets updated. In testing the zap on the site it works and email is sent. But when try to do outside of a test no email gets sent, is there a delay normally in sending emails after a database update? It works when I maunally run it from the dashboardThanks 

3
andywingrave
3 years ago
Terms & Conditions