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.

25199 Topics

D
Deb_MYMBeginner
asked in Troubleshooting

"Error during execution: Cannot read property 'username' of undefined"

Hello, I am currently setting up an integration for when members cancel their subscription on AC, this then removes their role within my Discord server to revoke their access to all content.I am doing this by setting up an automation in AC that when a customer cancels, they receive a specific tag. Then when this tag is applied, Zapier picks up on the AC tag and will remove the role from the Discord user.However, after connecting both ACt & Discord to my Zapier account to create the zap. I am receiving this error code: "Error during execution: Cannot read property 'username' of undefined"

5
D
2 years ago
Q
QueueNew
asked in How Do I

Xero - Account Code Integration

Hello Zapier Community, I’m trying to create a zap from Xero → Sheet, whereby a row is created in sheet if we have a bill (accounts payable) coded to account code eg “rent”. I don’t seem to be able to filter for bills with “rent” - but can only retrieve all bills. Do you know if this is possible? 

1
Troy Tessalone
2 years ago
J
jiaheNew
asked in How Do I

Issue with multistep funnel in clickfunnels

Hi all, I have a 4-step funnel inside Clickfunnels, which basically consists of opt-in, offer, application and thank you page.In the opt-in page, the leads are required to put in their name and email in exchange for a lead magnet. Once they submit the page, they will reach the offer page. If they are interested about the offer, they will click apply and fill in additional information inside the application page.Although I have set up zapier specifying to send the lead details on the application page of the funnel, however, whenever leads reached the application page, their name and email is instantly sent to my google sheets even though they have not filled in the page.I have tried a lot of ways but none worked very well. Any suggestions here from the admin and the community? 

1
Troy Tessalone
2 years ago
A
AnonimoNew
asked in How Do I

Typeform Gmail and Streak integration

So i’ve made 2 zaps. Typeform (New entry) --→ Gmail (Send and email) With a filter that sends an email when i have a specific answer. Typeform (New entry) --→ Streak (Create a new box) -→ Streak (Create a new contact). The problem is when someone fills in a typeform, they automatically recive an email and it automatically registers his/her data in streak. But the e-mail does not show in streak, it is send from me, but it’s not register by streak. I tried adding a delay to the email, it did not work.  

1
robschmidt
2 years ago
K
kmcgillNew
asked in How Do I

Imap by zapier with gmail

I’m trying to trigger zaps from new emails using imap. im getting error -2 and error-99 Help Says it cnat connect because of the name OR because their computer are taking too long

1
robschmidt
2 years ago
T
TharlinNew
asked in How Do I

Send Facebook pictures to Discord

I use Zapier to copy my posts on my facebook page into my discord server. It works very well for text. But I have big problem to get the images from facebook to discord.I only get the picture shown on discord if I add the full picture URL as TEXT into the posted message. But that does not look good.Is there no way to post the picture without having the whole URL in the message text shown?

5
christina.d
2 years ago
B
boomerangBeginner
asked in Code & Webhooks

"A validation exception occurred" error

I’m getting this error message when setting up the zap from PandaDoc to Xero :“A validation exception occurred, The line with total amount 9932399967793455.60 cannot be accepted. The maximum line amount is 999,999,999,999.99 “The unit price is pulled in as comma separate values, and there isn’t an option for a line amount.Advice would be well please.Thanks in advance

2
christina.d
2 years ago
W
wineglassmarketingBeginner
asked in How Do I

Autogenerating Sales Receipt Number in QuickBooks Online

Hi I am sending orders from Stripe to QuickBooks Online via Zapier as Sales Receipts. I would like the sales receipt number to auto generate (use the next number Quick Books is going to use). If I leave that field blank in the action then the sales receipt number is blank in QBO. Does anyone know what I can pass to QBO that will get it to generate its own sales receipt number?

3
W
2 years ago
A
AdamZapBeginner
asked in How Do I

Ad Creative for client approval Zap

Hello,Does anyone have a good zap that would take the data that I have in facebook and put it into a format that I could use to present to clients for approval. For example I input the creatives and campaign settings, put it on pause and then in some way present it to the clients (could be data studio, slides, etc). Thank you!Adam

1
Troy Tessalone
2 years ago
G
gregpNew
asked in Code & Webhooks

How to use Python to extract value from unparsed webhook payload?

I would like to create a python regular expression that will search through an unparsed webhook:{"Opportunity":{"Client Name" :"Mike DevTest","Client Email":"sample@gmail.com","Primary Contact":"Mike DevTest","Event Start Date/Time" : "12/24/2021 4:00 AM","Event End Time":"6:30 PM","Event Location":"Houston","Event Type":"Wedding","State" : "TX","Venue" : "Virtual Chicago","Additional Musicians" : "false","Cocktail Music" : "true","Dinner Music" : "true","Grand Piano Shells" : "false","uplights" : "false","mini piano shells" : "false","projector" : "false","Wedding Ceremony" : "false","Evening Entertainment" : "true","DJ Services" : "true","Type Of Ensemble" : "Dueling Pianos","Primary Owner Email":"sample@gmail.com","Primary Owner Mobile":"(555) 555-555","Salesforce Id":"0068F000002G5quQAC","Added To PIP":"true","Date added to PIP":"3/1/2022","Amount":"1700.00","Performers":"2","Lead Photographer":"true","2nd Photographer":"true","Lead Videographer":"false","2nd Videographer":"false",

4
G
2 years ago
M
Marta ENew
asked in How Do I

How to send an email with generated URL + trigger 2nd zap when clicked

Hi all!I would like to create a Zap to send an email with a generated URL and then to have another Zap that was triggered when the recipient of that email clicked on the URL in the email.How can I implement this?

2
Satya09
2 years ago
L
LucasSkywalkerNew
asked in How Do I

Automatically delete emails listed in a spreadsheet from gmail inbox

I have a company where some users’ emails are blacklisted. I also don’t want to receive any emails from them.All those email lists are automatically put in a google spreadsheet.I’d like Zapier to automatically erase those emails coming from those addresses .Is that possible? How would I go about creating this?Thank you!

1
Troy Tessalone
2 years ago
E
EkodelNew
asked in How Do I

How to set a Zap with retrospective date

Hello, I would like to turn on a Zap, but need to get data since 3 mouths ago.The Zap is created on Outlook.How can I get the data from the past?

1
Troy Tessalone
2 years ago
E
EddieNew
asked in How Do I

How do I add a new row below the header?

Im could add order info into Google spread sheet from Shopify.But when I get new order, it will be added on the top of the work sheet which is supposed to be added at below of the header.I've tried fixing the rows and protecting the header section, but it still gets added on top of the worksheet.Does anyone know of a solution to this problem? Thanks in advance.

2
SamB
Community Manager
2 years ago
F
footscienceNew
asked in Code & Webhooks

Validation Error when using Dynamic Data

Fairly simple problem but I can’t get around this one.When I use Dynamic Data I get a “Validation Error” response. If I hardcode everything, it works successfully.I’m using the Custom Code Webhook App to create simple POST and GET calls. It works in Postman and Zapier (with hardcoded data ofcourse). It’s really basic form data…  I do need every field to be dynamic. Including Emails, names, phone numbers, etc. I’m using Zapier’s email parser app to get most of the data, and some data also comes from returns of other API transactions (like QBO).Looking something like this...  It’s strange to me because the “data to be sent” according to Zapier appears to have the correct parsed values… Any thoughts?

2
SamB
Community Manager
2 years ago
F
FrankPBeginner
asked in How Do I

Duplicating Excel workbook and then add or update row

I am so close to getting this Zap to work but it’s failing at the end. I’ll explain the concept, how I’m attempting to solve, and what the error is. Requirement: When trigger hits (Monday.com) create a copy of an existing spreadsheet and then add data to the new spreadsheet. My Attempt:Trigger - Monday.com action Action 1 - OneDrive,  Find File Action 2 - OneDrive, Upload file- Upload a copy of the file from Action 1 Action 3 - Excel - Add or Update Row - Use the file uploaded in Action 2 and update/addError - In action 3 I come across errors. After I select the Spreadsheet it attempts to access that spreadsheet to retrieve the worksheets but errors out. I receive different errors depending on the value I insert for the Spreadsheet field, none seem to work. See screenshots below   

6
christina.d
2 years ago
B
bfpmNew
asked in How Do I

Possible to create Microsoft To Do task when HubSpot task is assigned?

Is it possible to have a MS ToDo task created when I create (or am assigned) a task in HubSpot?

1
Troy Tessalone
2 years ago
M
MDSBeginner
asked in How Do I

Dropbox Create Folder action not seeing existing folders

I have seen this asked before but no answers on a fix or workaround The error occurs with several dropbox actions, but for simplicity’s sake lets say ‘Create folder’.I pick the dropbox account, choose create folder, and on the screen where normally you could pull a drop down list of the folders from your dropbox account I get nothing, and zapier throws this error:Required field "Folder" (directory) is missing.

3
christina.d
2 years ago
D
dersheaNew
asked in How Do I

Calendly Cancellations with Google Sheets

Hi everyone, I want to setup a trigger so that when a calendly event is rescheduled or cancelled, it automaticaly updates the google sheets row of cancelled to “TRUE”. I have been trying to reference the row through the UUID (unique event id created by calendly) but I am not having any success with it. Has anyone done this before? Thanks!

19
Troy Tessalone
2 years ago
D
DenniZapBeginner
asked in How Do I

How to include column headers in Zap from Google Sheets to Salesforce?

I don’t see an option to use the sheet column header to a field in Salesforce  

3
Troy Tessalone
2 years ago
K
kevinchemidlinBeginner
asked in How Do I

Updated Task in Project in Asana has old data

I’m creating a zap that will update a Google Sheet when the due date is changed on a task in asana. The zap gets the updated task data, compares the due date to the date held in a Google Sheet, then if the due date is different, it updates the Google Sheet. When I go into test by changing a task’s due date in asana, the “Updated Task” trigger fires, but it contains the old due date. Even if I change the date 3 or 4 times, all to unique dates, the due date within the trigger data seems to be stuck on the old due date. Any advice? Why would Asana send old data? 

4
christina.d
2 years ago
B
ben burlingNew
asked in How Do I

Select Browser/Website Text, Right Click, Send To Zapier - Searched all day for the answer, can someone help?

HiI have been searching for hours to find a simple solution to this problem. The Zapier Chrome Plugin does not (100% sure on this) currently support the ability to simply select text such a “Henry Jones” and allow you to send that to Zapier.. surely this has got to be the easiest of problems to solve? Do I need to hire a programmer to write a chrome plugin to enable this? Does anyone have a solution? I will shower you with jewels and sweet meats if you can help me.RegardsBen

8
rachael.silvano
2 years ago
S
SeganevardNew
asked in How Do I

How to set up Zap to stream content from Twitch to YouTube?

So I'm attempting to set up zap for streaming from twitch to YouTube, but I have no idea how to do that, I've already gotten the accounts connected but under the video file section for YouTube what am I supposed to do?

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

Kissflow digital workplace to calendy zap

Hi,I want to make the Kissflow workplace to calendy integration by using zapier. The purpose is i have a form with Meeting date is avilable in kissflow digital workplace and that meeting date i need to assign to calendy  Please guide. Thank you

1
Troy Tessalone
2 years ago
A
AKUBeginner
asked in How Do I

Create Quickbooks invoice with different line items and tax

Hello everybody,  I try to create an invoice in quickbooks online when there is a new order on Shopify. But some of my items can be with 10% TAX or 20% TAX. Do you know how to separate different items and their own tax rate ? Have I to do the manipulation on Zapier or on Shopify ? Or on Quickbooks ? The invoice is create on shopify but every items have the same tax. Thank you for your help !  

2
A
2 years ago
Terms & Conditions