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.

25211 Topics

Lightspeed
LightspeedBeginner
asked in How Do I

Can I fill specific columns in Google Sheets using entries from a Google Form?

Hi All, I have a Google Form setup, and I’d like the submissions to fill out a row in Google Sheets that has 4 columns. How do I get the entries from the Google Form to fill in particular columns in this row? I’m using Create Spreadsheet Row, and I notice this is a Create Multiple Spreadsheet Rows, but what I’m looking for would be something more like Create Multiple Spread Columns, which I don’t see.

7
ken.a
10 months ago
iamdanii
iamdaniiBeginner
asked in How Do I

How to create individual subtasks in ClickUp for each loop iteration using Salesforce data?

I have successfully set up the loop so that it takes my Salesforce data that is comma delimited and outputs the appropriate information categorized by loop iteration. However, when moving to the next step of create ClickUp subtask, only one subtask is created. I would like each loop iteration to be its own subtask. I would appreciate any help in solving this!

3
ken.a
10 months ago
JimF
JimFBeginner
asked in Troubleshooting

Unable to copy PDF doc, only file name, while transferring new docs from Google Drive to Zoho Workdrive

I am trying to automatically copy new documents uploaded into Google Drive to ZoHo Workdrive, but I only seem to be able to copy the file name, not the PDF doc itself. Any suggestions?

3
ken.a
9 months ago
FIA
FIABeginner
asked in Troubleshooting

Unable to pull the address, city, or ZIP when new contacts are generated in SALT.

Hi everyone,I’ve got a zap to pull customer data after a contact has been created from SALT and create a new customer lead in Agency Zoom. The zap isn’t giving me any errors, and the test works well and fills out all info fields. However, when new contacts are actually generated in SALT, it will not pull the address, city, or ZIP. All other fields work great (email, phone number, marital status, etc.), but the address, city, and zip is left blank.I’ve tried entering different variables to where the data could be pulled from in addition to the fields I know it should pull from to no avail.Any ideas as to what would be causing this exclusion?Thanks in advance!

3
christina.d
10 months ago
ADrealty
ADrealtyNew
asked in Troubleshooting

Failed to create a card in Aptly (1.0.0): The app returned "The web server reported a bad gateway error.

Hi, I have a zap to create a card in Aptly, however the test is not working, Failed to create a card in Aptly (1.0.0)The app returned "The web server reported a bad gateway error.". But, in the Aptly app, I can see the card created.What is the errot message due to ?thank you

1
Troy Tessalone
10 months ago
debitspread
debitspreadNew
asked in How Do I

Using Zapier to share eBay listing with Facebook groups

eBay allows sellers to share their listings with a variety of other social platforms.One type of sharing is of particular interest to me; namely, Facebook Groups.Would Zapier allow me to automate the sharing process FROM eBay TO these FB groups?Here’s why I ask: I occasionally sell paintings on eBay, and would like to inform various groups about my auctions. Cross-posting these listings one-at-a-time is a really tedious thing to do.I would love to have a utility that would post the eBay listing to a variety of FB groups in one batch job. Is Zapier the tool that would let me do that?Let me know.

5
ken.a
10 months ago
Biyi
BiyiNew
asked in How Do I

How do I send automated email sequences from MailerLite to customers upon purchase in Gumroad?

I am trying to set up a zap with Gumroad and Mailerlite. I want to create a zap that takes the people that purchase on my Gumroad to receive an automated email sequence instantly.I have been unable to achieve this. Can anybody help?

1
Troy Tessalone
10 months ago
A
Anonymous
asked in Troubleshooting

Experiencing issues with Zapier's Gmail Trigger: New Email Search not retrieving data and New Labelled Email not appearing in Zap

Could this be a wierd Zapier quirk?Created a Zap which uses a Gmail Trigger.I tried the New Email Search Zap which isn’t pulling in any data that matches the search string parameters I tried the New Labelled Email   approach instead, and the new label I created when I was on a quick video call with the client isn’t showing up (I should have checked, but I wanted to give the client back his time as I’m 90% done with the automationThere’s always the option to reconnect the clients Gmail again, but I wanted to get a sense of if there’s something I could try before interrupting the clients flow again

3
ken.a
10 months ago
JTJ
JTJNew
asked in Troubleshooting

Issue importing specific fields from Airtable to MailChimp.

Hi,I have an Airtable with member data and would like to pull them into MailChimp via Zapier. It’s not letting me select all fields from the Airtable (including Organisation) or specify a country without indicating a full address (which I don’t ask members for). I’ve seen these fields added in other Zaps, but can’t figure out how to do it for mine. Any advice would be welcome!

2
christina.d
10 months ago
schmitt
schmittBeginner
asked in Troubleshooting

Zap triggering despite deletion and disabling of all Zaps in ClickFunnels.

I have zaps firing no matter what, they don’t show in my history, and I can’t turn them off.I have/had zapier connected with clickfunnels to fire when a user made a purchase. I made a completely new funnel in clickfunnels (all new URLS) without any zaps pointing to that new funnel URL and it would still fire off a zap. Oddly, they don’t show up in my history at all, so I can’t see which zap is firing, so I turned all zaps off, retested, and it’s still firing. So now I’ve gone ahead and deleted every single zap from my account, tested my funnel in a fresh browser with cookies/cache etc. cleared, and the zap IS STILL FIRING. I’ve reached out to zapier support, but they haven’t replied yet. Has anyone else had this issue? Is there caching on zapier’s end that they need to clear? I’ve cleared my browser cache, website caching, and hosting cache, so shouldn’t be any of those. I did wait 3 days from turning off all of my zaps to deleting everything in the hopes that zapier support would actu

4
shalgrim
10 months ago
Christie
ChristieNew
asked in How Do I

Can I write customer data to Google Sheets based on specific Kajabi offers without creating separate Zaps?

I am creating a zap to write out some customer data to a google sheet based on specific kajabi offers being purchased. Do I have to have a separate zap for each of the 4 offers or is there a way I can select the specific offers I need in the Trigger section of the zap? So basically if Offer 1, offer 2, offer 3 or offer 4 is purchased, write the data out to google sheet A.

1
GetUWired
10 months ago
danatfsc
danatfscNew
asked in How Do I

Is it possible to automatically refund prorated amounts for tier upgrades in WooCommerce and Stripe?

I’d like to create a relationship between two subscription products in Woocommerce, to allow for an upgrade from one membership tier to the next. User purchases new, higher-tier subscription Zapier searches for an existing, lower-tier subscription under the user’s email address If lower-tier subscription exists, Zapier calculates prorated amount for the unused duration of the lower-tier subscription, and refunds that portion of the earlier transaction. Is this possible?My credit card processor is Stripe—if not possible through Woocommerce, perhaps I could achieve it that way? I’d prefer Woocommerce to keep my accounting and reports clean in that one dashboard. 

2
SamB
Community Manager
9 months ago
tsimonelli
tsimonelliNew
asked in Troubleshooting

Error when connecting MySQL Remote account: Authentication failed. Could not connect with zap100 and provided password.

I entered all of my information correctly when attempting to authenticate the remote mysql connection and receive this error: authentication failed: Could not connect with zap100 and provided password. The response we got from the server is included below for debugging purposes. (pymysql.err.OperationalError) (1130, "ec2-54-86-9-50.compute-1.amazonaws.com' is not allowed to connect to this MySQL server") (Background on this error at: https://sqlalche.me/e/14/e3q8)I checked with godaddy and they said I have no blocked IP addresses and they could not figure out on their end why the connection was failing.  The username, password and host info was entered correctly.  mysql version is 5.6.51-cll-lve.  Any idea?

1
GetUWired
10 months ago
peter34
peter34New
asked in Troubleshooting

We hit an error adding your new account authentication failed: 403 Forbidden: Access Denied.

Hello We are having troubles connecting with Zapier to Wordpress.No Jetpack installed. And I dont connect Cloudflare Please help me to check it again!  

1
ken.a
10 months ago
mediaconnect.com
mediaconnect.comNew
posted in Troubleshooting

Issue linking Typeform to Sellsy: can't add note to opportunity based on contact's email.

Hello,I'm unable to connect Typeform and Sellsy. I'm trying to add a new note to an opportunity. I'm stuck on the last step. I want to link it to the contact's email address (associated with the opportunity), but it's not working. Can you help me?Thank you.

4
ken.a
10 months ago
chavousc
chavouscNew
asked in How Do I

How do I load a Monday.com item by its ID to avoid duplicates when adding to a board?

Scenario - CRM entry (FollowUpBoss) get status changed.Creating zap to add item to “Active Files” board.I want to make sure I’m not creating duplicates, so when initially create an item, i’m writing the ID back to FUB in a custom field.Great.  I can _get_ the item’s id when I create it, but how can I then later _LOAD_ an item from monday by its ID? The “Get Item By Column Value” action does not have “Id” as an option. I don’t see any other “Load Item” or “Get Item” or anything like that.I can UPDATE MULTIPLE using the item ID, but that seems to fail if item id is blank or doesn’t exist.  How can I search a monday board by the Item ID?  Item names change - that’s a poor “key” value to use.  Thanks!

10
Troy Tessalone
20 days ago
dm1559
dm1559Beginner
asked in Troubleshooting

Airtable error: Failed to create a record, could not update record in Airtable

I have Zapier connecting SignNow and Airtable. Once a contract is fully executed in SignNow, it triggers a “Find Record in Airtable”, searching for the applicants email, which comes back True with no issue. It then Updates the record in the next step. I want to update a “signed” status to “GOOD”, which I wrote in.  How can I fix this?? When testing, its triggering this error: Failed to create a record in AirtableCould not update record in Airtable: Airtable error  

3
ken.a
9 months ago
smombartz
smombartzNew
asked in Code & Webhooks

Parsing Webflow API request to get User ID from Email via Code Step

Hi!I’m trying to get the user id “_id” for a specific email from a Webflow Membership API call that returns a JSON list of users. I’m not quite sure how to handle the Webhook output in the code step. using the “full response data” gives me a syntax error.any help is much appreciated!  here the code im using:// inputData is provided by Zapier, and inputData.userlist should be your JSON stringconst userList = JSON.parse(inputData.userlist);// email to find is passed in as inputData.emailconst emailToFind = inputData.email;let userId;for (let user of userList.users) { if (user.data.email === emailToFind) { userId = user._id; break; }}if (userId) { console.log(`User ID for ${emailToFind} is ${userId}`); return { id: userId }; // Returns user ID in a way that it can be used in the next step of your Zap} else { console.log(`No user found with email ${emailToFind}`); throw new Error(`No user found with email ${emailToFind}`); // Stop the Zap execution if no user is found} 

4
Todd Harper
10 months ago
Digismoothie
DigismoothieBeginner
asked in How Do I

Create a new file in Google Drive - Upload a file - Rename the uploaded file to have the same name as the folder

Hello I came across a problem in the automation process, I need to set up following automation: I create a new sub-folder in Google Drive  After creation Zap uploads selected file to the new sub-folder created in Google Drive  After uploading the file to the newly created sub-folder, the selected zap should also change the name of the file to match the name of folder. (Optional)  E.G.  1. Main folder =SALES  2. I create a subfolder = CLIENT1, CLIENT 2, CLIENT 3  3. After creation of subfolder CLIENT 1,2,3 I need the zap to upload a Google document TEMPLATE_SALES, to each of the subfolder and change the name of the document to CLIENT1_SALES, CLIENT2_SALET etc.  I managed to create automation to upload the file, but I cannot figure out how to upload it to the newly created subfolder. Currently the file is only being uploaded to the main folder (SALES), when a new subfolder is created it does trigger the automation but the file is not uploaded to correct subfolder.  Anything that I am mis

7
ken.a
9 months ago
A
alphafmcNew
asked in Troubleshooting

Error connecting JotForm account: This auth is expired

I am attempting to connect a JotForm account to Zapier so that I can send prefilled forms. I have a JotForm account setup, within which I have created two forms. I managed to sign-in to JotForm via Zapier successfully earlier this year but now my previous connection is labelled with the error: “This auth is expired. Please reconnect it here.” When I click the reconnection link it opens a modal for me to sign-in to JotForm which I do, the sign-in works and the modal closes but then the error reappears again immediately. I have tried clearing the cache from my browser and reattempting the sign-in process in an incognito window but neither stops the error. I have also signed into JotForm and manually removed the Zapier permissions from the account before signing back into Zapier and restarting the account connection process, but this also does not help. I found a similar post in the JotForm community here: https://www.jotform.com/answers/4997663-unable-to-connect-with-zapier-this-account-

21
SamB
Community Manager
4 months ago
Kriss
KrissNew
asked in How Do I

How to create a Slack Zap for reminders with tagged users from the original message in the same thread?

Hello!I would like to make a Zap when bot triggers canned reply/reminders tagging Slack users from original message within same thread not to spam the channel. Example:Original message on the channel: Hi @abc @def please make an actionZapier 1st reminder: @abc @def Please follow up Zapier 2nd reminder: @abc @def Please follow up Zapier 3rd reminder: @abc @def Please follow up  The automation should tag users from original message, and they will vary from message to message. It should also have an option to manually or by some shortcut stop next reminder if an action was done by tagged user.  Many thanks in advance

1
nicksimard
10 months ago
Uop191
Uop191New
asked in Troubleshooting

Issue with populating Mailchimp email template with multiple rows from Google Sheets.

I have a Google Spreadsheet that is full of values (that I am sending from my website). I need to send an email campaign to my customers using MailChimp. Of course, I am using an email Template. The issue is populating that email template with multiple rows of different values from the Google Spreadsheet. I am sorry if this is a stupid question but I am new to this. I have sent the email and it contains dynamic values from only one row of my Google Spreadsheet. I need to basically choose more than one rows and populate those values in the template.Also, this process should be automated. For example, as the Google Spreadsheet is filled with new values, they should all be picked from the spreadsheet and populating the template and sending the fully prepared template (with updated dynamic values) to MailChimp. Thanks in advance to everyone.  You can ask me any question, if you didn't understand what I said.

1
Troy Tessalone
10 months ago
Pyon23
Pyon23Beginner
asked in How Do I

Ignore Google Sheets Column or row within Zap

Story: I created 2 zaps:1. to send myself gmail with a link to fill in google form everyday 2. when the form is filled, it creates a row of data in spreadsheet.Purpose: track my skin condition & daily habits etcProblem: I usually fill the form the next day, so when I fill in the form, the date will be the “next day date”. But I what i want is “previous day date”. See image for visual clarification. If the report date can be ignored by zapier, then I’ll list nicely all the dates prior on sheets.but no, zapier always create a new entry below.Findings:solution: not found.Any workarounds? thanks 

3
ken.a
9 months ago
atcervantes
atcervantesNew
asked in Troubleshooting

Accessing Shopify New Paid Order properties

As many in the Community, I am trying to access nested arrays (properties) from the New Paid Order (Shopify).I have different scenarios where the properties are not being properly parsed. All the properties of all items being appended to each line item. I really don’t have any control over what properties belong to what Line Item. Looping is not working, Converting Line Item to Text is not giving me the right info and now I am trying to pass the whole payload of the Trigger to the next Action so I could parse it manually but that doesn’t seem to be possible. Is there any alternative that I am missing to be able to access this custom properties coming from Shopify? 

1
Troy Tessalone
10 months ago
Scottbro
ScottbroBeginner
asked in Code & Webhooks

400 Error from POST Webhook to InvoiceXpress

Dear Automation-Masters, I’m trying to get invoiced scheduling to work, but it keeps returning a 400 with very limited information on why so. I’ve already reached out to the partner integration. Very possibly it’s just a syntax mistake or something XML-related that I can’t seem to find, but perhaps it’s also a problem with Webhooks, that’s why I wanted to ask here for guidance. I’m referring to this page: https://invoicexpress.com/api-v1/schedules/create-15  Attached some screenshots. Best,Alex  

1
Todd Harper
10 months ago
Terms & Conditions