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.

25141 Topics

berprado
berpradoNew
asked in Troubleshooting

ID value from MySQL doesn't match the row value from Google Sheets.

Hi, can anyone give me a hint on this issue. my trigger: NEW OR UPDATED ROW IN MYSQLmy action: UPDATE SPREADSHEET ROW(S) IN GOOGLE SHEETSmy zap: UPDTAES THE ROW OBTAINED FROM THE TRIGGER  BUT THE UPDATE TAKES PLACE ONE ROW BELOW. I mean.. placing the data on row (n) rather than placing it on row (n+1) See screenshotsAs you can see… id 1 is pointing to row 2. I need id 1 to match row 1. My first row on the worksheet is a header row and it was formated according to zapiers advice.There is a video explaining How to set up your Google spreadsheet to work with Zapier. My trigger gets this result after testing: Everything is fine except that row has to be 153 NOT 152 because id 152 points to row 153.The result i get with id 152, row 152 and COL$A 152 is this: bye bye id 151  hello double id152 😭If there was no header row everything would be smooth but i need the header row.Where is my mistake?any hint?Thanks in advance

3
christina.d
1 year ago
C
cloakBeginner
asked in How Do I

Auto populate Hubspot Contact Notes

I have a virtual assistant type service where if I don’t pick up my phone, the call is re-directed to the virtual assistance. The VA then sends an email to me with the call details which is simply a template that is populated by the VA with the unique information of the caller. I have set up Zapier email parse and have the following process implemented: Email from VA -->Forwarded to Zapier Email Parse -->Zapier Zap pushes the information into Hubspot and creates a new contact. The only bit i’m missing is populating the Hubspot Contact Notes (Hubspot Contact > Activities > Notes section). What field should I be selecting for my Zap to populate this in Hubspot? I’ve tried a few and none of them work. Following fields working:Name Email address Telephone number Postcode Just need the Notes sections to be working and then this process would work perfectly for me.

3
C
1 year ago
V
Volz Method Piano LessonsBeginner
asked in How Do I

Use AI to summarize the purpose of a Zap?

have you ever gone back to a zap that you made a while back to check on an error and have no idea what you were thinking when you made it?Wouldn’t it be nice to use ai to summarize how a zap works and the purpose of it? Is there anyway to use AI to do this? I wasn’t thinking of using it in a zap really, but I can’t think of a way to show an ai everything in a zap and prompt the ai to summarize it...

3
Troy Tessalone
1 year ago
NoodleNoob
NoodleNoobNew
asked in How Do I

Notion Multi Select

I have a typeform that I am reformatting into entries in a notion database. I have tags (for each typeform response) that I want to add into a multi-select column in Notion. I can’t figure out what format Notion wants these in, in order for the tags to be generated. My first attempt ended up creating one big blob (one tag in Notion using all the words in my input value)My other attempts triggered the “No commas” error that other folks have. To be clear, I can’t pre-populate options in Notion, because the tags can be a little different every time. I want distinct tags generated (for new tags) or used (for tags that have been added in notion before) for each row. 

1
Danvers
1 year ago
Excellerater
ExcelleraterNew
asked in Troubleshooting

Need Help with Adding a New Contact as a Row in Microsoft Excel

We’re trying to build a task that will automatically add a new contact to a row in Excel. The Trigger tests perfectly, but the Action is driving me nuts! All of the connections work, there are no anomalies at all, but when I hit Test, the result is an acknowledgement that something should have happened in Row xx (it steps one row with each test) in column A, but that’s all.Suggestions are most welcome. Real help is worth payment. I’m just wasting time working it myself.  

11
christina.d
1 year ago
jason00169
jason00169Beginner
asked in How Do I

Create Weekly Meeting Post in Notion

We are trying to automatically create weekly meeting reminder in notion via zapier but it looks like it is not available. Is it possible? Here’s the explanation video:  

1
christina.d
1 year ago
Thiago Polati
Thiago PolatiBeginner
asked in Troubleshooting

Bringing information from monday.com to GSheet using 2 different boards and a Zap filter in between

Hey guys, I’m trying to bring information from monday.com to a Google sheet that is not working as I want it to.This is the zaps steps:Trigger: an specific column change in monday.com Action: Filter by Zapier - only continues if the value of the column is an exact value I have tried using the action: Get item by column value in monday.com too Action: This is where I’m have a problem I need to use the filter in step 2 as a key to get the column values from another monday.com board Action: Send the data from the board in the action above to GSheets.Let me create an example to make it easier to understand:The value of a status column on board “1. Clients” changed Filter by Zapier will check if the value in the column that changed is “Complete” If the column value is “Complete”, it needs to use the “Client name” as the key to send all column values from board “2. Client Information” to a Google sheet.This, however, is not happening. Can anyone help me? Cheers,TP

5
SamB
Community Manager
1 year ago
KC2023
KC2023Beginner
asked in Troubleshooting

No workflow shows when the "Adding Contact to Workflow" action is in HubSpot.

I’m trying to send emails via Hubspot as orders move through various deal stages on Airtable. I’m thinking the best way to trigger the emails would be to automate adding contacts to a Hubspot workflow but our published workflows aren't populating in the 'Workflow Name' drop down. Is anyone aware of a common issue that might be causing this or do you know of another method to automate sending deal stage emails like 'Order Placed' 'Order Shipped' through Hubspot?

3
Brem
1 year ago
K
KrystalxSxPBBeginner
asked in How Do I

Is it possible to have a yes/no response on whether a survey monkey had a file uploaded?

We have a survey monkey response sheet that has the option to add a file when needed. Not all of our participants need to upload a file, and I know that there wasn’t (last I looked) a way to import uploads from the surveys, but is there a way to get a “file upload is true/false?” We have a parser that brings in all the other data and I typically don’t need to check the survey now except to export the data every so often, and grab those uploads. If I knew which surveys to check for uploads, it would save a lot of time!

3
Brem
1 year ago
effectivesite
effectivesiteBeginner
asked in How Do I

How do I have Zoho leads entered into approval queue?

I’m making a zap to have new leads submitted via gravity forms, go into zoho. The leads are going through without issue, but the problem is we need them in the “Approval” page (/Leads/actions/approvals) of Leads and they’re instead going into the general lead queue. What can I set to have it go to approval? With zoho’s webforms there’s an option “Request for Approval” which can be toggled on, but I don’t see any equivalent in the fields zapier is displaying. Thanks for any help/suggestions!

7
Brem
1 year ago
Jciszek
JciszekBeginner
asked in How Do I

ConnectWise Manage Ticket > Jira. No Discussion Option?

Hello, I am trying to set up a new ticket trigger from ConnectWise Manage to a Jira Software board. When a ticket is created in ConnectWise Manage, the description goes into a field called “Initial Description”. This field is available in Zapier, however it does not show any data when it is moved over. Below is the Jira Software Issue without the data. 

3
Brem
1 year ago
AhmedAbid
AhmedAbidNew
asked in Troubleshooting

Need help setting up a Zap that automatically fetches my Shopify orders and creates rows in Google Sheets daily.

I basically want for Zapier to go to shopify every day and get all the new orders in the last 24 hours and paste them in google sheet below the old orders. I am currently stuck after making the schedule and filter Now stuck here how to get orders from shopify to google sheets 

1
Brem
1 year ago
zapete
zapeteNew
asked in How Do I

Setting Google Calendar event with Microsoft To Do Due Date - only half working for me

Hello All,I saw a breakdown of how to set this up from @Aremde and also saw a very recent question from @mironk.I ALMOST have it working.I have used @Aremde helpful PDF setup sheets and the advice from @SamB. My Due date END TIME is correctly posted in google calendar at 17 April 10am, according to my modifier and the Due date set in the task in MS to do.But the Start Date and time field - which contain the Due Date begin time 17 April 9am is not posted correctly, according to my modifier.The Start date in google calendar is simply being taken as the time at which the zap is being executed it seems (+the 10 hour modifier). Screenshots to illustrate below.My ZAP field entries to get START: due date/time +10h,  and END: Due date/time + 11h What shows in google calendar when I ran the test at 18: 44 Uk time. It is showing START as April 14th at 4:44am (Zap execution time plus 10h) Do you have any thoughts about why this may be happening? Hope you can help. thanks in advance. This was the

3
Brem
1 year ago
M
Mitchell ZezimaBeginner
asked in How Do I

Find & Format Google Sheets Data

Hello, I am using the “Find Spreadsheet Rows in Google Sheets” function, to see if there are duplicate entries in separate rows of a spreadsheet. As you can see from the screenshot the output is showing 3 rows containing the same number.  I want to add a filter step so that the zap will only continue if there is more than 1 row in the spreadsheet with the same data in it.  How would I achieve this? I have been trying using a format step with no luck   Thank you 

4
chanelle
1 year ago
wellretail
wellretailNew
posted in How Do I

How do I update inventory and pricing in bulk

This post was split from How to update dropship supplier inventory quantities, pricing, etc. in Shift4Shop? Hi I have a shop on shopify and would like to update inventory and pricing in bulk. Since zap has integration with shopify please help me how can i update inventory, add new products and manage pricing automatically based on csv file that is provided by vendor.  Thanks

1
Charie
1 year ago
carolineM
carolineMBeginner
asked in Troubleshooting

Authentication failed: WordPress ran into an issue. Error code 500: There has been a critical error on this website.

Hi There I am getting this error when trying to connect zapier to wordpress: authentication failed: WordPress ran into an issue. Error code 500: <p>There has been a critical error on this website.</p><p><a href="https://wordpress.org/documentation/article/faq-troubleshooting/">Learn more about troubleshooting WordPress.</a></p> I have got the right plugin installed.

9
E
6 months ago
Mercatus
MercatusBeginner
asked in How Do I

Search for multiple emails before adding a new Salesforce Contact

Is there a way to make a Zap which searches two email fields in Salesforce before adding a new contact. We have an alternate email field that we would like to search on in addition to our primary one, but I’m not sure how to do this/if it’s possible.Many thanks for any help!

3
Troy Tessalone
1 year ago
QueryMate
QueryMateBeginner
asked in How Do I

Can I duplicate my facebook lead ads if I already send them to Hubspot and then I create a zap (this time sending the facebook lead id)

Hi everyone,We are currently receiving facebook lead ads into our CRM (Hubspot) but without the facebook lead id, that is why I want to create a zap to create a contact in Hubspot when new lead in Facebook lead ads (this time including the Facebook lead id) but I am wondering if there is a chance to duplicate my contacts.Can you please help me to clarify this doubt?and what do you recommend to do?

9
SamB
Community Manager
1 year ago
Pascu Dragos
Pascu DragosBeginner
asked in Troubleshooting

Failed to create an opportunity in Close: The request to /opportunity/ failed because of the following error: {"field-errrors":{"lead":"Object does not exist.".},"errror":[]}

Hey, so I’m trying to setup a Zap between Calendly and Close.io  The principle is simple → I want every booked call event to be turned into an ‘Opportunity’ within Close.io.  After connecting both through API, I run in the following error:  “The request to /opportunity/ failed because of the following errors: {"field-errors":{"lead":"Object does not exist."},"errors":[]}” I’ve tried to create a new ‘Lead’ name by booking a test name within Calendly, see below I just don’t know whether it’s Calendly or Close.io that’s causing this error? Thanks in advance!    

9
ken.a
1 year ago
pdmonks
pdmonksNew
asked in How Do I

How do I map a sale in my booking platform to a specific account in Xero and and pass it as a UDF to FareHarbor?

HiCan anyone give me some tips on how to get this App/zap working.In order to map a sale in my booking platform to a specific account in Xero, I assume I will either need to pass the account number or Xero product SKU as part of the zap and that these would therefore need to be stored and passed as a UDF in Farharbour.Also it seems to be passing pence as pounds so that invoice amounts are 100 x what they should be - is there a setting I am missing?cheersPeter

5
Charie
1 year ago
Piotr Derecki
Piotr DereckiNew
asked in How Do I

Is there an integration between Copy.ai and Zapier?

Could anyone help me and tell me if there is an integration between Zapier and Copy AI?

2
SamB
Community Manager
8 months ago
João Andrade
João AndradeNew
asked in How Do I

How to remove a letter in a specific position?

Hello guys!I Have a poblem here. I have a number that has 13 letters. The format is like that “5514925563223”.Whats I need to do is remove the 5 letters, in this case, the number 9, to look like “551425563223”.How can I do so?

5
Charie
1 year ago
laelelait
laelelaitBeginner
asked in Troubleshooting

HubSpot error: Property values were not valid.

Hello :)I was trying to integrate Lemlist and Hubspot for the automation : create or update a contact in Hubspot when new activity in Lemlist. I’ve added every field I needed for that but I got this error message :  It’s written if have an issue with the Hubspot owner ID but there is no field in the Zap to put it… How do I solve that?  I have registered in Lemlist & Hubspot for my company account !Thank you !

7
ken.a
1 year ago
j1358
j1358Beginner
asked in How Do I

Extracting info from Clio Grow quick intake to Clio Calendar for Deadlines

Hello, I'm new to Zapier and was wondering if there is a way to transfer Custom field data from an Quick Intake Form into Clio Manage Calendar. Explaining: Clio (outside the U.S) doesn't provide a possibility to create court rules automatically, Im in Europe and my team is loosing time creating deadlines on each calendar. would it be a possibilty to automate this process maybe webhooks? any info is well appreciated

1
ken.a
1 year ago
B
Bob Le BobBeginner
asked in How Do I

How do I filter webstore orders with incorrect postcodes?

Hi, I’ve seen a previous question where the solution was to run something before the filter - however I don’t want to do that.  I am using the fillter so we don’t burn through actions as the rule will run on every order from our webstore (7000+ orders per month). We have an existing zap that has a filter to just pass through order details when it looks like an address is wrong.  The part I’m struggling with is where a customer doesn’t enter a postcode correctly.  We have an address finder on at the checkout - but customers sometimes still manage to get it completely wrong. A correct postcode should be something like AB1 1AB, but we get AB, AB1 come through - are there any ways I can do this?

3
Troy Tessalone
1 year ago
Terms & Conditions