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.

25335 Topics

PaulKortman
PaulKortmanZapier Expert
published in Code & Webhooks

How to Count the Number of Line Items Without a Code Step

In my ongoing series of Expert Hacks/Tips (lol) I wanted to show how we use three simple formatter steps to "count" the number of line items in any situation. We can even use this same methodology to "count" the number of line items that match a specific value or condition. Here's a video walk through with text explanation below. Loom | Send a video. Not a thousand words. Scenario:So we're jumping in the middle of a zap where you already have a line item (say from a new invoice trigger in Quickbooks). And you want to count how many different products are on the invoice, or alternatively you want to count how many products of type=shoe are on the invoice. To count type=shoe linesStep 1: Formatter by Zapier: Utilities: Lookup table. Use the "Type" as the inputPut "shoe" on the left of the lookup table and 1 on the rightLeave the Fallback Value emptyStep 2: Formatter by Zapier: Utilities: Line Item to TextUse the output of the previous ste

688515
W
3 months ago
P
pjs1
asked in How Do I

quickbooks payroll items

how do i create a zap to take updated payroll items within an excel spreadsheet to modify quickbooks online records?

4
Danvers
4 years ago
BowTieBots
BowTieBotsZapier Expert
published in Code & Webhooks

Paginated requests in Code by Zapier / Hubspot Lookup by Phone Number

Hey everyone, I recently created a reverse lookup step for HubSpot when you have a contact's phone number and want to get their name and email and thought I would share with the community. The request is limited to 1700 contacts due to Code by Zapier's 10 second time limit.The main guts of the code is a recursive fetch sequence for paginated responses (A common occurrence if you are using Webhooks to get data from APIs). You could take this sequence and augment it to handle what ever paginated response you want from an API. Have fun!!const obj = {    users: 'no user found'}let newUsers = await go();for(var x in newUsers){    for(var y in newUsers[x]){        if(newUsers[x][y].properties.phone && (newUsers[x][y].properties.phone.value.indexOf(inputData.phone) >  -1)){            let firstName = newUsers[x][y].properties.firstname ? newUsers[x][y].properties.firstname.value : 'No first Name',                lastName = newUsers[x][y].properti

47392
BowTieBots
4 years ago
A
Anonymous
asked in How Do I

Zoom chat integration

Hello, anybody managed to create a zap to send a message in a channel of Zoom Chat ?

2
A
4 years ago
J
JT_No_Code_Founders
posted in How Do I

Looking for startups built on Zapier

Hi all,Great to be part of this community! I run the Slack community nocodefounders.com where one of the things we do is interview founders of no code startups on how they run their business. Would love to hear any suggestions of businesses built with Zapier or using Zapier to automate their processes.Thanks!

2
Bryan_from_workload
4 years ago
constantconcepts
constantconcepts
asked in How Do I

Zapier Changing Product IDs???

Does anyone know why Zapier would change a product ID field? I am importing Shopify IDs from a custom Woocommerce field. Everything works until the end of the Zap when it sends the line items to create a Shopify order. Zapier is changing the values, thus rendering the entire Zap useless, because the IDs dont match. Can someone please tell if the screenshot is correct, and what is happening?? ThanksP.S. I am not inputting a variant ID as we are not using variants (though we will in the future), but would that have any effect?

10
Danvers
4 years ago
O
OWilde99
asked in How Do I

Facebook Messenger to Gmail not pulling in names

Hi,I have made a Zap that is meant to send all new Facebook Page messages to my Gmail account. Everything is working as expected but the names are not being pulled in from messenger. Only the time and actually message are being pulled in. I have checked the task history and I can see they are not being pulled in from messenger, so there is no error with gmail. Any idea how to fix this? It's for my company and we need it fixed soon!! Cheers

7
jesse
4 years ago
T
TOPCMBeginner
asked in How Do I

Trello and Google Sheets Question

Not sure what's going on here so hoping someone can help me. I have a Zap set up to create a new Trello Board upon the creation of a new row in my google spreadsheet. Tested it, worked perfect. Added my first new row to Google Spreadsheet and it set up the board perfectly. All good here.I have an additional Zap that @AndrewJDavison_Luhhu helped me set up that looks up that Trello board board ID and then adds cards to that board based on new rows in another tab within my spreadsheet. That was tested and worked perfectly.Now here is my problem: We input a new project into our system on 1/28/20. Trello built a new board from my Zap and everything looked perfect. However, before any cards could be created for this board, someone edited a single cell in that new spreadsheet row. No new row was added from this action, just a change to one of the cells within the row. After the cell change, the zap that creates the boards triggered again. It created a new board that Trello assigned the s

3
steph.n
4 years ago
L
lukejamison_Beginner
asked in How Do I

How to find webhook amongst zaps

Hello May be a dumb question but, I'm trying to find the zap that has a specific webhook URL inside of it. I have the URL of the zapier webhook But I just don't know how to find which zap is associated with that URL. If anyone has a suggestion on how to do this I would really appreciate it thank you

6
M
4 years ago
M
Martin
asked in How Do I

Parsing or Saving CSV Email Attachment into Google Sheets

Hi everyone, I'm hoping the community can help me with setting up my zap...I get a daily email from one of our vendors with an attached csv. I download & port the contents of this CSV over to a google sheet for records keeping / processing every day (mega repetitive). My ideal scenario would be: gets daily email > zap creates new row in google sheet from each row in attached CSV.I would also settle for a scenario where zap simply creates a new google sheet from attached CSV in a designated folder. Thus far, I've tried using the email parser, but haven't been able to get it to recognize the attachment.

8
V
3 years ago
S
Svetlana_K
asked in How Do I

Linkedin/Activecampaign

Hey! Who works integration? What features and functions does it provide for work, can I send a mailing list or save my contact information?🙂

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

Account Email Issue - Can't Change Email Address Associated with Account

Hello, I have an issue with not receiving Zapier's email that is meant to be sent to me with a link so I can click on it to change my user account email address. This is a strange issue because I receive the Zapier newsletter and other zapier notifications. But this email that is supposedly sent so I can change my account email never arrives. I have tried many times. I sent an email to support but still awaiting a reply. Not having a number to call and no reply yet to the the support ticket just has me feeling helpless :( I urgently need to make this update. If someone could reach out to assist this will be great. Thank you

7
steph.n
4 years ago
J
JeffBBeginner
asked in How Do I

Is there a Zap that lets me call/execute a PHP program?

There are a number of database operations I want to execute (create the database, create a user, set user permissions to the database) in a PHP program. Is there a way for a Zap to call a program? I need to be able to pass it parameters.Thanks!

2
DataHelp
4 years ago
constantconcepts
constantconcepts
asked in How Do I

Shopify Orders from Woocommerce

Does anyone know how to ensure products match when trying to sync orders from Woocommerce to Shopify? Does anyone know the best way to do this overall?We tried to do it with line item support directly to Shopify, and doesn't seem to work because we can't get product IDs to match. We are now attempting to do it using Google Sheets as an intermediary, which is capturing all necessary information, but we can't seem to condense the line items correctly back into a Shopify order and match products.This is an urgent need. Any help would be very much appreciated.

7
Danvers
4 years ago
constantconcepts
constantconcepts
asked in How Do I

Advanced Custom Fields in WooCommerce

Does anyone know how to get Zapier to recognize a new Woocommerce product field created with Advanced Custom Fields?

13
christina.d
2 years ago
R
RClay
asked in How Do I

Pulling in GMail Content with Zapier

I have a business account with Gmail and Zapier does not work when I want to bring in labeled emails. Help? Also can I bring in text from gmail and save in a word document ?

5
Danvers
4 years ago
J
JeffBBeginner
asked in How Do I

New or Updated Spreadsheet Row in Google Sheets only works when a new row is added?

I'm using the 'New or Updated Spreadsheet Row in Google Sheets' as the entry point to one of my Zaps.When a new row is added to the spreadsheet, the Zap triggers as expected.I have a filter as the send step in my Zap. This filter stops the following steps if a particular cell is empty in the row.For a new row to the spreadsheet, as I said this Zap is working correctly. The new row is added, the cell in question is empty, and the filter stops the Zap right there. Perfect.The problem is that when I go in later and update the cell to a value that will pass the filter, the Zap isn't triggering. It's as if the 'New or Updated Spreadsheet Row in Google Sheets' is only triggering for a new row, not an updated row.Is anyone else having this issue? Where you able to figure out what the problem was?Ideally, the Zap should trigger with the changed cell and it should pass the filter and perform the remaining steps in the Zap. I feel like I'm doing something

17
christina.d
1 year ago
C
coinbakedBeginner
asked in Troubleshooting

Discord -> Twitter (Images don't send, only text)

Any idea how to send an image from one's discord channel to their twitter feed? I added the Zapier bot to my channel in my Discord server. If I write a message to my discord channel and include a link to an image ONLY the text sends to twitter, not the image.Similarly if I post an image from file to my discord channel it never sends it to Twitter.

7
Danvers
4 years ago
A
Aaron_farmerBeginner
asked in How Do I

email issue with zapier

Hello, I have an odd issue. I can get zapiers blog emails but if I try to change my account email, I get no return email with link to change. more importantly, I have a company that has had zapier send info to get zaps started. they are not listed publicly on the site. they have to be granted by the company. the company rep has said, just wait for the email from zapier and then add the API key info.. but email never comes.. this is like the 3rd or 4th time I have reached out today and previously and I never get a response.. again, perhaps its because they reply by email and I get nothing.. not in spam either... please help. my cell is 858-344-6465 and can accept call or text.. not sure how else to get someone to help me. thank you!

10
Danvers
4 years ago
R
RClay
asked in Troubleshooting

Re: Creating a Gmail Mail Zap

Hello, I'm trying to create a gmail label zap, but when I test the label it doesn't work. Also, is there anyone at Zapier that helps you?

10
jesse
4 years ago
J
jpearl
asked in How Do I

how update lead and assign parent contact for lead in Dynamics 365

When a new contact is created in Hubspot I have a zap that creates a Dynamics 365 Contact and Lead.When the LifeCycle in the Hubspot changes to Sales Qualified Lead I want to update the Dynamics 365 lead and assign the parent contact for the lead. (And in another scenario assign the Account)The help caption on the Parent Contact for lead field says the followingProvide the Parent Contact for lead ID, not the Name here. Not sure how to use custom values? Learn more here. Choose a contact to connect this lead to, so that the relationship is visible in reports and analytics.My Zap for this is as follows:1 New Contact Property Change in Hubspot (based on LifeCycle Stage = salesqualifiedlead2 Find Lead in Microsoft Dynamics 3653 Update Lead in Microsoft DynamicsHow do I get the zapier Parent Contact field (or the Account field) to Look up the Contact or account?

5
Danvers
4 years ago
A
Amanda
asked in How Do I

Configuring Due Dates

Hi,I'm using a zap to create recurring tasks in MeisterTask. I can't figure out how to set up a due date for the future. When I set up the zap, I can only use the date that I set for the task to be sent to MesiterTask, so the due date would be the same date the task is created. I tried using Zapier's formatter, but even when I typed in +1 month or +10 days I would always get the same date. How do I make the due date a future date?

7
D
4 years ago
L
Lukasz_Walo
asked in How Do I

IS there a option to sort email in Zapier from Gmail that are older then 2 days ?

I wound like to ask if there is possible to scan emails from last 5 years with specifi label and same name and picked up some information. I make zaps that made it but gmails/zapier have option only for last 2 days ...

5
Danvers
4 years ago
B
Beth
asked in How Do I

Dealing with Salesforce Campaign Member Duplicate Rule

My Zap adds new Eventbrite Registrants to Campaign Members. The Campaign Member Object has a duplicate check on Contact ID, so if a person registers them self and then tries again with their name to register someone else or if they are buy multiple tickets and use there name with the other tickets, Campaign Member will flag a duplicate error (can consequently the Zap stops.  The client does not want another object to track Campaign Members, so I'm forced to deal with duplicate issues. Eventbrite also allows a registrant to buy multiple tickets with the same name, which also causes a duplicate error.I want to "catch" this condition i.e. see if the campaign member record exists, before Adding the Campaign Member record. I tried Find a Record, Object - Campaign Member, field - ContactID and search for the Contact ID from a previous Zap. This seems to look up the contact record, its not Campaign Member because that record does not exist (see attached screenshot). So, I swit

4
Liz_Roberts
4 years ago
L
Leo
asked in How Do I

How to map Google calendar reminders?

When I select the Google calendar app, it only shows the events, but not the reminders. Am I missing something here?I am trying to move reminders from my Gmail account to my gsuite Google Tasks.

3
AndrewJDavison_Luhhu
4 years ago
Terms & Conditions