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

20270 Topics

Z
ZapiaskNew
asked in How Do I

How to split leads from Facebook Forms into 2 paths?

Hi.. May I know if there’s a way to split leads from Facebook form into 2 different paths by rotation.exfirst lead to A path2nd lead to B path3rd lead to A path and so on…Thank you in advance..

1
Danvers
1 year ago
newmag
newmagNew
asked in Code & Webhooks

How to get the JSON response from a URL?

I have this URL https://newmag.com.br/wp-json/wp/v2/media/6358which returns  from that response I need to parse it and get figure URL in the fieldmedia details: full: source_url:https://newmag.com.br/wp-content/uploads/2022/06/Winona-Ryder.pngto feed into the next action and post it to Instagram.  

3
M
1 year ago
S
stylebaseBeginner
asked in Code & Webhooks

Importing a large list onto a Python code

  Hi Zapier Community I am running a Python code on Zapier and know that I cannot use libraries beyond the native ones.I am trying to import a list of strings that I use on the Python code as ONE huge string, which is a concatenate of all rows in a mySQL database. This long string doesn’t need to be regenerated every time, it will not change.  To generate this list on mySQL workbench I use the code SET @@group_concat_max_len = 3000000;SELECT group_concat(reference_field SEPARATOR ',')FROM Items; Which doesn’t work on Zapier, I’m guessing it’s SET function that Zapier is not liking because without i, the concat field works fine. But since the total length of the list of strings is ~3M characters, I need this SET function. I was also exploring storing the list of string values (or huge string value) in another file and using it in my Python code. But I can’t figure out what’s the best way to store a list of value (HTML, JSON,??) and how to import that onto Zapier so that it doesn’t look

0
S
1 year ago
H
Harry ZBeginner
asked in How Do I

One line of data in WPForms to two rows in google sheets

Aloha. I asked this question a couple of months ago and unfortunately had to step away from my project before resolving the issue. The previous question is closed, so I cannot revive it.  Apologies for the duplicationHere’s my issue: How do I take one “entry” from WPForms (i.e.: one line of data) and create two rows in my google sheet? I’m using WPForms to capture member registration information for a club. Most of the club consists of couples (e.g.: husband and wife), so I’ve created the registration form to gather information on both of them at one time.  So far, so good.The next step is to get the information out of WPForms, and into google sheets so that I can actually use the data. I’ve set up a Zap with the trigger to be a new WPForms entry. And I’m looking at the “Create Spreadsheet Row(s) in Google Sheets” action to hopefully add two rows (one for the husband, one for the wife). But I have NO clue how to do this.Here’s a link to a gsheet where you can see the ‘before’ and ‘afte

4
H
1 year ago
L
lifeisgoodBeginner
asked in Code & Webhooks

zap is not receiving notifications.

 I'm using Google spreadsheet and messenger app in conjunction. using zapier through web hook. today, The corresponding "zap" does not receive and receive notifications. check history, The notification has been stopped since the 27th.(yesterday) I entered new data in real time, but there is no response. The spreadsheet is being input normally. Others work normally.

3
christina.d
1 year ago
S
SeldomSceneNew
asked in How Do I

Create FluentCRM contact from newly created Oncehub booking

Hello,Looking to create a contact in FluentCRM after a OnceHub booking. OR suggestions for better solution than OnceHub. Thank you in advance

2
christina.d
1 year ago
I
IAOSNew
asked in Troubleshooting

My "dateTime pretty" field adds an hour to the event time, but the "dateTime" field shows the correct time.

I have a trigger setup that looks for a new event start in Google Calendar then sends out notifications before A meeting. The problem is the “dateTime_pretty” field is adding an hour to the event time, but the “dateTime” field is showing the proper time.   

1
christina.d
1 year ago
J
JustinBeginner
asked in How Do I

Outlook: Change which email address an email is sent from

Hi, I have managed to connect Outlook to Airtable with Zapier so that I can send emails directly from Airtable. But these emails are getting sent from my Gmail address (which I used to register for Outlook).  Can I change the email address that these emails are sent from? There are multiple email addresses linked to my Outlook account that is registered to my Gmail.

7
christina.d
1 year ago
C
ClearSBeginner
asked in Troubleshooting

iAuditor "Inspection Completed" trigger not activating when a new report has been completed.

The aim of my zap is to send a PDF, an editable link & a view only link of completed reports from iAuditor to a specific record on Airtable. The Zap worked for the test template in edit mode however once the zap was published it has not been triggered despite submitting new data (inspection completed button on iAuditor). Any help or suggestions would be greatly appreciated.

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

How do I update a WordPress post to add information to the bottom/top of the article instead of replacing it?

Hello,I’ve set up an automation to update an existing wordpress post with certain information I have from google sheets.Let’s say that first section of the post is one google sheet row worth of information.The issue is that when there’s a new row added, instead of adding the information BELOW the first section, it just replaces/edits the section that’s already there.Is there any way to fix this? So that when I trigger update post in wordpress option, it will actually start adding the information at the bottom (or top) of the article, instead of replacing already excisting text?Thank you

1
christina.d
1 year ago
B
BFTNew
asked in Code & Webhooks

Adding +1 to a cell.

I’m looking to have my webhook add +1 to the number already in a cell. I’ve tried =(c8)+1 but getting a #REF error. Any ideas how I can take the number already there and add 1 to it? 

2
GetUWired
1 year ago
A
AgriZapBeginner
asked in Code & Webhooks

Pick off a Child Key Syntax

I an trying to use Pick off a Child Key but when I use the syntax as below it doesn’t work:This is a subset of the payloaddata[contact]{:id=>"61d8326f88d0cd60e710e5e7", :first_name=>"TEST FIRST NAME AAABB", :last_name=>"TEST LAST NAME", and I an adding “contact” as the key

8
jesse
1 year ago
C
CtrlAltDeliriousNew
asked in How Do I

How can I send Discord messages to a Google Sheet based on the user that sent it?

Don’t know if its possible but what I am trying to do is make a chain that will see when a new discord message is sent in a channel with specific text then send the User who sent it and the date it was sent into a google doc then  populate that date into a specified cell in a roster document based on the User name and only update that persons last time they sent a message.Example: A Discord Message:Dave: Hifirst google docUsername      Date Message SentDave                   6/29/2022   <-------------------------                                                                              |    Move this date to second google docSecond Google Doc                                              |    based on the user name.Username     Blah Blah     Date                            |Dave                                 6/29/2022  <--------------Sally                                   6/14/2022

3
jesse
1 year ago
O
Optics TradeBeginner
asked in Troubleshooting

Trouble with Magento 1 and Google Sheets

Hey guys,I am trying to automatically transfer a few pieces of information from a new Magento order to a google spreadsheet. But when I want to select "payment information" (example: moneytransfer, paypal, credit card...), which is shown in Magento orders, but I can't find it as an option in Zapier when selecting which fields/elements I want to transfer to a new spreadsheet row.I hope someone can help me. Thanks, to anyone who will take the time to help me.

4
jesse
1 year ago
J
JudyNew
asked in How Do I

How to link a Jira ticket to a Zendesk ticket?

I’ve created a Zap that will create a Jira ticket every time a new Zendesk ticket is created - this works fine. However, I need my Zap to also LINK the Jira ticket that was created to the Zendesk ticket it was created from via the Zendesk- Jira integration in Zendesk.   In the screenshot below, I’d like for the Jira ticket that was created in my Zap to appear linked in the Apps section in the Zendesk ticket. Is this possible to configure my Zap to do this?  

3
christina.d
1 year ago
J
JoseDojindoNew
asked in How Do I

How do I copy all the information from the Shopify order to create a new invoice within QuickBooks Online?

Hello everyone,  We have had issues with other apps regarding the name/number given to invoices created using shopify→ QuickBooks applications. Is it possible to automate the following upon fulfillment of a shopify order? Create a new invoice within QuickBooks (this is an important first step, because we want the invoice # to be the next in the existing sequence) Copy the rest of the information from the Shopify order (including data from custom fields/metafields) And finally, would this be possible with a single multi-step Zap? I am not familiar with the Zapier system, and hopefully this is possible without requiring a large number of Zaps per order. Thank you!

5
jesse
1 year ago
R
RelliottBeginner
asked in Troubleshooting

Re-playing Zap runs through edited Zaps

Hi, I have several zap runs that have been filtered due to an error in the filter. I have edited the zap to be correct. I would like to now re-run the filtered zaps through the same (updated) zap run. Is this possible?

2
jesse
1 year ago
D
dpzapperNew
asked in How Do I

Why are jpg/png files converting to txt documents?

I upload a .jpg/.png image but I receive a .txt document instead and have no idea why/how the file conversion is happening.Please help!

2
jesse
1 year ago
H
heominNew
asked in How Do I

How to get Twitter image URL

I'd like to get the image URL of my new tweet.But I don't know what to do.Help me.

2
jesse
1 year ago
D
dianasyBeginner
asked in How Do I

Group emails notification to avoid sending multiple emails of the same topic.

Hello Community,         I have an existing Zap that looks like this: Zap IllustrationIn a scheduled basis, it sends an email to remind people (column email)  to fill up a column1 and column2 if they are blank. Pretty simple if you think about it. However, I would like to avoid sending duplicate email if the person responsible (email column) appear more than once in the row. In this example, I don’t want xyz to have 3 emails of the same topic. I just want to nudge the person to go in and fill those column up. How can I accomplish this?  In the similar case, I also have another zap that triggers when a new row is created, doing the same thing (Email the person) to fill the field. Same case, I don’t want zapier to send dup emails. Any help is appreciated.     

4
jesse
1 year ago
A
adamjubertNew
asked in How Do I

"Find Contact in HubSpot" partial match

PrefaceThis question was asked once before, with some helpful Zapier mods offering to submit a feature request. Unfortunately, the OP never responded, and it looks like this feature still doesn’t exist!BackgroundOur Sales team offered leads their “third month free” if they became a customer. After a lead is converted to customer, became_a_customer_date is filled in with a timestamp (ex. 2022-06-30T17:08:03-400). GoalIn plain EnglishEvery day, we want to find all customers in Hubspot who became a customer exactly 2 months ago and turn off their Stripe payment. (there would need to be a second Zap doing the opposite, i.e. find all customers who became a customer exactly 3 months ago and turn it back on, but I digress)In Zapier termsTrigger: Every Day Action: Formatter by Zapier: Action Event: Date/Time Transform: Add/Subtract Time Input (today’s date in timestamp form from Step 1, e.g. 2022-06-30) Expression -60 days Action: Hubspot: Action Event: Find Contact First search property

2
jesse
1 year ago
A
airelleBeginner
asked in Troubleshooting

Google Doc : Create document from template does not display any file

Hello,In my zap, I have a email parser trigger (ok), then a filter (ok), then a “Create Document from Template in Google Docs” action. In that last action, I setstep 2 : create document from template ; OK step 3 : Google doc account : I can select it : OK step 4 : I configure “Folder for new Document” and go into the folder which contains my template files, and then, I click into “Folder for new Document” : nothing is displayed. It does not show any file here. I can’t understand why because that already worked before, and :I checked the connexion of the Google Doc app : it is ok. I tried to reconnect it, without luck.  I checked the sharing permissions on the folder I want to use in my Zap at step 4 : my Google account is the owner and sharing settings are set on “everybody with the link can EDIT” so It’s the largest permissions that I can set on that folder. My template files are Google Doc files, in that folder, and I can see them, edit them. I even tried to login with Firefox or Saf

6
jesse
1 year ago
M
may2022Beginner
asked in How Do I

Department field in Quickbooks

Hi Anyone here know how to use department field in Zap, in Creating Quickbooks journal entry? We are monitoring properties in Quickbooks and I think this deprtment field is some what related in our Quickbooks set up. 

5
jesse
1 year ago
A
Anonymous
asked in How Do I

Zap action to retrieve data in sheets

Hi all. I have a zap where it insert the row to the sheets whenever there is form submission. However, I would like to create another zap to retrieve all the data of the row in the sheets.The trigger action is row inserted in sheets, then send email. But when I test trigger, it shows only the row and ID, no other data anymore. The reason for having two separate zap is because I have some columns in the sheets that set the value through the formula. Is there any suggestion or solution for this?

1
jesse
1 year ago
T
Two Wheel CompanyNew
asked in How Do I

How do I do a gross profit calculation from Pipedrive deals and product costs from within my Zap?

Hi there.We are currently using Pipedrive as our new CRM system, and have created a custom field called “gross profit” which should be a calculation of.Gross profit = Net profit - cost of products.When connecting pipedrive and Zapier i am able to retrieve the Deal Summary (total price) of a deal. And i am also able to retrieve the cost of the associated products. For example 1000,1000,5000,300Those values should be used for making a calculations:1000 + 1000 + 5000 + 300 = 7300. And after that i can make the Gross Profit calculation:Gross profit = Net profit (Summary / total price) - the calculation.But i am having trouble on how to take the numbers, and divide them and thereby making the calculations.Can someone help on this issue?

1
Danvers
1 year ago
Terms & Conditions