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

24942 Topics

E
emckin2Beginner
asked in How Do I

How Do I Create a Zap Using ServiceTitan Job Tags?

I am not seeing job tags as a filter, but I know it’s somehow possible! Any ideas on what I need to add to the zap to pull that information? Right now I just have booked job or completed job, but nothing available about the tags that exist on those jobs. 

10
E
4 months ago
A
Andrea GattiniNew
asked in How Do I

Upload ChatGPT message into Google Sheet

Hi all,I need to re-build my old chat on ChatGPT4 that was using the Zapier plug-in in order to upload some information returned by ChatGPT4 into a Google Spreadsheet.After the recent changes in ChatGPT4 (probably related to customGPT), my old chat can’t integrate anymore with Zapier and it seems ChatGPT4 is not able anymore to upload that information.Before these changes, when I asked to ChatGPT to upload that information in Google Sheet via Zapier, it sent the request in a JSON format, and Zapier had an action to do that istantly.Now I would like to build the same thing with the new AI Actions, but it turned very complicated.Any help? Thanks!

1
SamB
Community Manager
4 months ago
T
tomspaghettiBeginner
asked in Troubleshooting

HubSpot "Get Contact" fails with multiple contacts associated with deal

I have a Zap setup to find the Associated Contact on a Deal to then map the Contact fields (First Name, Last Name, Email) to Pandadoc. It works fine except when there are multiple Contacts associated with the Deal.If there are multiple Contacts associated with the Deal, the Zap fails and the message is given: “Object not found. objectId are usually numeric.”With multiple Contacts, when Get Contact runs, the output is “951,3201” with 951 being the ID of Contact #1, and 3201 being the ID of Contact #2.Keep in mind, some Deals have only 1 Contact, others have multiple. All I really need is 1 contact to be found and mapped later in the Zap (when sending on the Pandadoc contract).How do I setup the Zap to work in both scenarios (1 or Multiple Contacts associated with the Deal)?

13
ken.a
1 day ago
J
joveBeginner
asked in Code & Webhooks

Can I get the inputData with empty string

I guess I hit a bug of Zapier. In one zapier step, it returns a set of data (as an array in a output object) In the JavaScript code block, I can define a variable, and map it to the object The problem is when I was in the code editor page, I can preview the value as ,,,,,,7,,8,but in the code, if I ran console.log to debug, I found this inputData became 7,8, all those empty string is removed. As a result, when I run inputData.abc.split(‘,’), I got unexpected results. Can you confirm whether this is a bug or any workaround?  

10
J
1 month ago
T
toiee labNew
posted in Code & Webhooks

To handle Shopify order data properties and variants, you can use Code by Zapier

I referred to the following article but could not solve the problem.Shopify multiple line items properties How to Rebuild RAW JSON for Code Blocks I tried Webhoo, App Extension, and etc. Finally I tried “Code” like below.const order_id = inputData['orderid'];const res = await fetch( 'https://YOUR-STORE-SUBDOMAIN.myshopify.com/admin/api/2023-10/orders/' + order_id + '.json?fields=line_items', { headers: { 'X-Shopify-Access-Token' : 'HERE IS YOUR API TOKEN' } });const json = await res.json();let line_items = [];for( const item of json.order.line_items ) { let prop = ''; for( const p of item.properties ) { prop += p.name + ': ' + p.value + "\n"; } line_items.push({ product_id: item.product_id, name: item.name, prop: prop, variant: item.variant_title });}output = { line_items: line_items }; This code takes a Shopify order ID as input data, retrieves the data via the API, parses the line_items and converts it to the format it wants. It then sets it as output data.The line_items key i

0
T
4 months ago
S
SuaBeginner
asked in How Do I

How do I automate the extraction of .mp4 files from Zoom recordings in Dropbox and upload them to Vimeo via Zapier?

Hello, I am a teacher who teaches on Zoom. I post recorded lessons on our website after class. I want to automate this with zapier.At the end zoom class, the class file is automatically saved as a folder in the Dropbox.I want to extract only .mp4 files from these files and upload them to Vimeo account. please help me. T.T

7
Troy Tessalone
2 months ago
C
CCMABeginner
asked in How Do I

Can I trigger a URL redirect after capturing a lead's email in a spreadsheet row with a free Zapier account?

I am wanting to trigger a URL Redirect. I’m connecting a spreadsheet that is set to capture leads by creating a new row. When this new row has captured the leads email I then, want the lead to be redirected to a URL to continue their flow through a sales funnel. Is this possible with a free Zapier account? Thank you,CCMA

4
zaki_readylogic
3 months ago
L
lisa_nativegovNew
asked in Code & Webhooks

Extract name and amount from Google email using regex

I am trying to extract text from gmail. I have a zap started with Email Parser. Then a step using Formatter to extract separate pieces. I can extract the email address and amount with success. I’m trying to extract a FirstName LastName pattern that always comes after an exclamation point and line breaks. I cannot get this to work. I can get different versions to work in Regex101.com using Python flavor. But when I put it in the zap it includes the text I want excluded.I have no idea what I’m doing wrong. I am no expert in regex so please be kind. I’m sure there’s something very basic that I’m missing. Any help would be most appreciated. Thanks in advance! Email text: Hi name,Congratulations!FirstName LastName donated $10.00 to …..  Here’s the latest iteration of the regex I’ve been trying:\W{2}(?P<name>.+?) donated\s(?P<amount>.+)\stoWhat I want isname: FirstName LastNameamount: $10.00 What I’m getting is:name: Congratulations! FirstName LastNameamount: $10.00 I’ve also tri

1
Troy Tessalone
5 months ago
B
BquestionBeginner
asked in Troubleshooting

#ERROR formula parse error when updating google sheet row and entering a CORRECT formula into a cell

When a new row is added to the sheet, I want to update the row, so that a cell includes a formula. However, when zapier updates the sheet, the formula is inserted correctly but Google Sheets displays #ERROR in the cell.  It is saying there is a formula parse error. The formula syntax is correct though because all I have to do is click into the cell and hit enter again for the formula to work as expected.  Further more if I manually add the formula to the cell it works straight away. This is the formula I’ve added in Zapier:=DAYS(TODAY(),DATE(VALUE(MID("{{225758909__COL$A}}",7,4)),VALUE(MID("{{225758909__COL$A}}",4,2)),VALUE(MID("{{225758909__COL$A}}",1,2))) + TIME(VALUE(MID("{{225758909__COL$A}}",12,2)),VALUE(MID("{{225758909__COL$A}}",15,2)),0) This is an example of how it turns out in google sheets:=DAYS(TODAY(), DATE(VALUE(MID("09-02-2024 11:26 AM",7,4)), VALUE(MID("09-02-2024 11:26 AM",4,2)), VALUE(MID("09-02-2024 11:26 AM",1,2))) + TIME(VALUE(MID("09-02-2024 11:26 AM",12,2)), VALU

7
SamB
Community Manager
2 months ago
ivy_t
ivy_tBeginner
asked in Troubleshooting

Google Sheets number column not transferring to Trello number field

Hi,I am using Zapier to connect google sheet with Trello. However, when I link one column to a custom field on Trello (with type of ‘Number’), the value does not go through. I created this Zap 2 months ago and everything worked fine then. However, the issue came up today when I tried to transfer some of my new order. Can you please advice on that? Kind regards,Ivy

9
Troy Tessalone
6 months ago
K
KatBlackBeginner
asked in Troubleshooting

Mailchimp error: Resource Not Found - The requested resources could not be found.

Veyr new to all this technology so need some hand holding here. I’m hung up on ‘Tag’ when adding a new subscriber to MailChimp. I’m not sure what’s needed to be included there. I only want 3 pieces of information from my subscribers - First Name, Last Name and Email. That’s what I included in ‘Tag’ (see attached) but when I went to run my test, I recevied an error message (see attached). Any guidance would be greatly appreciated!

4
ken.a
5 months ago
M
MayyNew
asked in How Do I

How do I create a Zap to notify Slack channels and send emails when Google Sheets entries are updated?

I have 3 questions:I create a new flow that will replace some system we are currently using in our company, im planning to purchase a zap plan because the one I need is limited to 1000, before purchasing I want to test the flow to see that I can achieve everything I need by this new flow.I created a google form that when we filled the form the data collected in a google sheet and I integrated it with Slack channel so everyone can see the new update with all the details I need, this step works well,I need to add another level that I cant find an article about it in your help centerI would like to create a slack message with all the details when someone updating directly the google sheets , I would like anytime that some changes made in the google sheets (update\ some parameters changed etc) to notify everyone in the slack channel with all the details of each row .how can I create this automation?  can I send this notification to 2 different slack channels? Can I send an email/ private s

5
Troy Tessalone
6 months ago
M
marjetwullinkNew
asked in Code & Webhooks

ZAP Wefact

I would love to make a Zap with Plugandpay and Wefact or Exact online, is that possible?Wefact has an API but then what?

2
M
4 months ago
F
FFPT LLCBeginner
asked in How Do I

How to create a client dashboard that allows clients to view their customer data (stored in Google Sheets)?

We keep all customer data in a few different client sheets. Currently we pull that data into a “dashboard” Google sheet, publish that to the web, and then send the client the weblink. But it looks awful and doesn’t format for mobile. I’d like a way to send a new customer a temporary password so they can go to our website, enter their email and temporary password, and view their customer data (pulled from google sheets by using their email as a search key). Ideally this has protection against someone trying to brute-force the username and password box.Is this possible with zapier? Or is there some other simple way to do this?

3
SamB
Community Manager
1 month ago
AlexisN
AlexisNBeginner
asked in Code & Webhooks

JSON -> Google Sheets

Hi everyone!I’m extracting Quickbooks financial report data with a custom action, but the data is coming out as a JSON and I can’t figure out how to get that into Google Sheets in appropriate columns and rows.  I’ve looked through previous posts and haven’t been able to figure out how to make this work.  Can someone please suggest a solution for this?Thank you so much!

5
Troy Tessalone
2 months ago
Tris
TrisBeginner
asked in How Do I

How can I send an attachment with Sendgrid integration?

Hi,I wanted to replace the zapier send an email action by the Sendgrid send an email action.I love zapier send an email action, with only one exception: clicking “do not receive emails” will deactivate my zapp, which is an app availability killer.Should only deactivate zap for the user in question.So I wanted to ditch zapier send an email action and replace it with Sendgrid.But sendgrid doesn’t let add attachments apparently.Did someone else already have this issue? Thanks!

3
Troy Tessalone
2 months ago
M
mhalletBeginner
asked in Code & Webhooks

Using a dynamic key in POST request - possible? (Updating Sportspress event in Wordpress)

Hey folks, hope you’re doing well! Been stepping up my Zapier automation game lately and been working on a project that essentially triggers when a spreadsheet is updated with sports event scores and automatically updates a Sportspress event hosted on a Wordpress website. I’m so close I can almost taste it! Everything works well until I need to make a dynamic reference to the two teams participating in the games. Essentially I am using a POST request through Zapier App Extensions and I can get everything to update as desired when I have hardcoded team ID numbers. But when I try to reference these variables {{home_id}} and {{away_id}} it seems to read these characters literally instead of recognizing that it should be a variable. If I use the actual IDs of these teams, everything works as intended. The challenge presents itself when I try to use these variables as it’s reading the variables literally. I’m attaching some screenshots so you can take a peek and if more information is requi

2
M
4 months ago
D
Devon McginnisBeginner
asked in Troubleshooting

Nextiva authentication disconnects daily in Zapier despite a password reset.

My Nextiva authentication keeps disconnecting every 24 hours. When I reset my password in Nextiva, I am able to connect to Nextiva in Zapier, but after 24 hours, it disconnects and won't let me in, even if I use the new password.PS: I can use the new password to access to the Nextiva app without issue. The issue is unique to Zapier.

7
J
1 month ago
A
AI AmplifiNew
asked in Code & Webhooks

Getting Error While Trying To Use "API Request (Beta)" Vision - Could not parse the JSON body of your request

Hi,As the title says, I’m getting an error message saying when I try to have OpenAI Vision extract text from a receipt:“We could not parse the JSON body of your request. (HINT: This likely means you aren't using your HTTP library correctly. The OpenAI API expects a JSON payload, but what was sent was not valid JSON. If you have trouble figuring out how to fix this, please contact us through our help center at help.openai.com.)”Here are some screenshots of the set up:  Here is the error message after running it: Thank you for your time!

1
Troy Tessalone
3 months ago
D
DataDarrenBeginner
asked in How Do I

How do I filter HubSpot Triggers by Additional Properties?

 When adding a trigger from Hubspot I am able to select “Additional Properties to Retrieve”    But when I try and add a filter based on this property is does not come up in the options:    I have made sure that the selected record has values populated for that field. I have tried searching for contact_type and other variations and it does not appear in the dropdown.  How do I filter my trigger based on the additional properties I have selected? 

12
Troy Tessalone
4 months ago
G
gnosowskiNew
asked in How Do I

Redmine - Jira comment sync

Hello, Is it possible to synchronize comments between Redmina and jira? I want every comment written in redmine ticket appeared in jira. Its possible?

1
nicksimard
4 years ago
P
PankajS
asked in How Do I

submit name and email into a website custom fields automatically

hi, I have a situation where i need to re-submit name and email address back to another website (in its custom fields - name and email address). Can I use Zapier? if yes, how?

1
AndrewJDavison_Luhhu
4 years ago
M
mattgammarayz
asked in How Do I

Finding Evernote notes and adding a tag if certain conditions are met

Hey guys, is it possible to find Evernote notes with a certain tag (e.g. Blank), parse a date out of the title, then give them a new tag (e.g. Delete) if that date is in the past?

3
Danvers
4 years ago
G
Gail BriscoNew
asked in How Do I

Integration between FB page and Email.

Hi, We would like to ask is there any way that Zapier can integrate notifications from our FB pages to our email address?  Thank You. 

1
nicksimard
3 years ago
Y
YagoNew
asked in How Do I

zap automático

Olá, como que eu faço para que meu zap seja automático? estou com um aqui que eu tenho que ficar rodando manualmente

1
Danvers
3 years ago
Terms & Conditions