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.

25671 Topics

R
RamzBeginner
asked in How Do I

How do I add new excel files to google sheet and filter which ones are new or updated?

Helloid like to build the following trigger: new excel file in folder action: add table from new excel file to an existing Google sheet action: remove duplicate rows from merged tables in the Google sheet  action: highlight to me which rows have changed or which rows are new in the Google sheetim new to Zapier so any help would be highly appreciated! 

5
Troy Tessalone
2 years ago
C
CurtisBeginner
asked in How Do I

Xero - Sales invoice to ClickUp

Hello, I have created a zap from Xero - Sales invoice to ClickUp but it doesn’t work after the 1st invoice is success.I have another zap from Shopify to Xero - Sales invoice, and website API from website to Xero - Sales invoice.Since all the sales invoices should be followed in ClickUp, I have separated between “Importing to Xero - Sales inovices” and “Exporting from Xero - Sales invoices” to ClickUp. 

5
jayeshkumarbhatia
2 years ago
M
maor356Beginner
asked in Troubleshooting

How to implement a delay between loop iterations?

Hello, I am trying to build a zap where given a list of customers, the loop will send an email to all those customers, however not at the same time. Between every email there will be a delay of 40 minutes. This means the first customer in the list will get the email immediately, the second after 40, and the third after 80.Tried to do this by implementing a delay after the email is sent in the loop, however it does not work.

5
christina.d
2 years ago
J
JohnatTharsternNew
asked in How Do I

Outlook events from US based account not being added to Clockify

We have created ZAPs to use Calendar Event Start in Microsoft Outlook to create Clockify entries.I have one account (the only colleague in the US) the rest of us are UK based that refuses to see any new events created in Outlook. the ZAP completes all the tests during set up but NEVER adds an entry to clockify.Any ideas on how best to trouble shoot this??

5
Troy Tessalone
2 years ago
T
The Christophe GroupNew
asked in How Do I

How do I distinguish between lists within a Trello board?

I have several list in one board on Trello. I would like to distinguish certain list with a blue pin and another list with a red pin on the map. Is this possible? 

5
AppGuyAaron
2 years ago
A
AnthonyPNew
asked in How Do I

Extract data from Google Sheet spreadsheet and add into another spreadsheet?

Summary of Project:I receive a daily email with an XLS attachment (call data for the day)I want to take that data and update an existing Google sheet with the data for that day What I have so far:I’ve created a zap that saves the XLS attachment from my Gmail to my Google DriveI have the final KPI spreadsheet created. Issue:How do I take the Spreadsheet saved into my Google Drive folder and extract the data in that saved attachment to create a new row on my KPI spreadsheet???

5
Troy Tessalone
2 years ago
A
Anup641New
asked in Code & Webhooks

Run large number of actions for paginated API?

When a large number of triggers or actions occur within a short time span, ... code rate limit after 10,000 requests in a 1-minute window as provided by zaiper , how we can handle this in zaiper , if zaiper unable to process 10000 actions and than next pulling happened before this

5
jayeshkumarbhatia
2 years ago
D
djungBeginner
asked in Code & Webhooks

Why does Zapier my datetime string to UTC?

When I normally run (e.g. in a browser console)var date = new Date('2021-10-25T08:06:08-07:00')the timezone is kept. However, in Zapier, when I do the same thing, it strips the timezone information and shows “2021-10-25T15:06:08.000Z”.  I need to know the hours in the original timezone. I’ve checked the profile settings and zap settings, and both are set to Los Angeles.

5
Troy Tessalone
2 years ago
D
dustinkayNew
asked in How Do I

Automate data from Google Form daily to new Excel spreadsheet

HelloI am new to zapier. I am trying to make my business paperless. Part of regulation in my business is to have a sign in sheet. So I created a google form for my clients to sign into, then I created a zap to upload all responses to a microsoft excel sheet stored in my one drive. Ive also created a Zap to create a new Excel sheet and to Name it : “Sign in sheet current date Office Name”. What I would like to do is to find a way to automatically alter my google form zap everyday to direct the data it is transferring to the new excel sheet. Is this possible or would I have to manually alter my google form Zap every day to direct it to send its Data to the new sheet?

5
Troy Tessalone
2 years ago
T
The Hart CollectiveBeginner
asked in How Do I

Circle to ActiveCampaign to track different membership levels

I am trying to set-up zaps from Circle to Active Campaign so I can track my different levels of membership but I can’t find a way to accomplish this.  Any suggestions?

5
jayeshkumarbhatia
2 years ago
A
Academy of Music and SoundNew
asked in How Do I

Difficulty with Zapier sending form data to Freshsales Suite

Hi everyone,  In a last ditch attempt to try and resolve my woes I thought the community may be help me with some issues I’m having. I work for a small music college and we’ve been updating our systems and the data we collect (some we are legally obligated to) For the data collection we’re using JotForms, it’s really customisable and helps since we need to collect specific information and of course, sensitive information. The issue lies in when I request the data to be sent to the CRM. To test the process I had my work colleagues submit some dummy forms, now when multiple forms come in, Zapier just sticks to ‘Submission A’ for example, it wont move on to the next submissions. e.g. Submission B, Submission C. The data does get input into the system but will continue to say ‘example@example.com’ is already on the system. Does anyone know how to make this process work? 

5
Troy Tessalone
2 years ago
K
kailashcoBeginner
asked in Troubleshooting

"authentication failed: The Zapier Wordpress Plugin has not been activated"

Hi there, I am trying to create a zap between Square and Wordpress, however the wordpress activation in Zapier is not working - it is saying the Zapier Wordpress plugin has not been activated even though it definitely has. I have deactived a security plugin and I can’t see any reason why it would be showing this, Any tips? I have not been show an “Allow” or “Accept” permission popup - where would this normally show? Or is the Zapier Wordpress Integration not functional at the moment? Thank you. 

5
K
2 years ago
I
ibrahimaNew
asked in How Do I

How do I dynamically map data from Bubble to Google Sheets

Hi!So i’m basically using zapier on my bubble app to write rows on a google sheets but i can’t figure out how to dynamically insert data of the Zap Thing in the columns.Need help pls.

5
Troy Tessalone
2 years ago
C
Chris AshleyBeginner
asked in How Do I

Microsoft Dynamics 365 - Find or Create Contact “Got 400 calling GET” error

Hello. Forgive me if this is obvious, I am brand new to Zaps, in fact this is my first one. During testing, I thought I had it figured out, but in the overnight hours, it just failed.  Basically the Zap says, on a Registration to Livestorm Webinar, add people into Dynamics as a Lead if they don’t exist. First, look for a Contact (by email address), if there is no Contact look for a Lead (by email address), If there is no Lead create one.  That is where I am getting this error.  Got 400 calling GET https://ubcrm.crm.dynamics.com/api/data/v9.0/leads?%24filter=emailaddress1%20eq%20'xxxxxx.xxxxxx-xxxxxxxxxx.xxxx.xxx'%20and%20companyname%20eq%20'NASS'%20and%20firstname%20eq%20'xxxxxx'%20and%20lastname%20eq%20'xxxxx'%20and%20fullname This post has been edited by a moderator to remove sensitive information. Please remember to remove any personally identifiable information prior to posting as this is a public forum. Zap help suggests that it s looking for required fields that are not filled in

5
C
2 years ago
Curious Robot
Curious Robot
asked in How Do I

Can I use Formatter, Filter, Paths, etc. with Transfer?

In Zaps I can add helper steps, like Formatter, Filter, etc. Can I add those into a Transfer?

5
christina.d
2 years ago
Curious Robot
Curious Robot
asked in How Do I

Can I convert my existing Zaps to transfer workflows?

If I have existing Zaps that I’d like to convert to Transfers, is that possible?

5
SamB
Community Manager
2 years ago
K
KMBNew
asked in How Do I

How to save PDFs from FastField Forms into specific folder in Box?

I have created a zap that creates a folder on a Box account and I created another that saves a text file on Box. What I'd really like to do is save the PDF and photos saved by Fast Field Forms and saved them to Box in a specific folder.I asked this over a year ago and got a response.  I’m trying to follow those same steps now, but I think I’m missing something.  Here is the old link:  

5
K
2 years ago
M
Mel-TBeginner
asked in How Do I

New Labelled Email or New Thread in Gmail

HiI want to send some selected email to Trello from Gmail. I initially tried “newly labeled email”, but got multiple messages. Per your documentation, I switched to “new thread” and got want I need. However couldn’t check my emails each hour!Does it have a other way to manually triggered the event without this short window of time but without sending more than one copy?Thanks 

5
Troy Tessalone
2 years ago
D
DamianoNew
asked in How Do I

Stop an ActiveCampaign when Shopify Order fulfilled

Dear all, we need to set up this Zap When Shopify Order status is set in FULFILLED, an ActiveCampaign automation stops for that contact.Do you have any suggestion to make this?For example with tag:​​​​​? Thanks a lotBest regards 

5
Troy Tessalone
2 years ago
C
CamilleGBeginner
asked in How Do I

Zapier isn't pulling custom fields from Teamwork

Hello,I’m trying to pull task info from Teamwork into a Google Sheet, but Zapier can’t see the custom fields I’ve created in Teamwork. Here’s my custom field: When I look through the fields pulled in my zap’s test trigger, there is nothing resembling my custom field, nor its value of 25. Is there anything that can be done to make Zapier see this field? Any ideas are welcome!Thanks! 

5
christina.d
2 years ago
V
vmmelioBeginner
asked in How Do I

Receive multiple records from Airtable and update them with another value?

Hello,I am trying to solve the following problem:I have several records in Airtables with two alternative values in one column that should be changed with the Slack command. (only one of the values is always used)So in this case I have to choose the value myself and post it to Slack so all Airtable records should change to match this value.I've managed to do that I have already:Slack post -> GET Webhook to get all the right records.I'm still missing a solution how to change these Webhooked records to the value I posted to Slackk.Is this possible with Zapier?

5
Troy Tessalone
2 years ago
S
ShaliniNew
asked in How Do I

Instagram setup logging into personal account vs client account

can i create a zap for my client in zapier account. As i try to create zap to integrate instagram connection for my clients account it is only directing to my instagram account

5
Troy Tessalone
2 years ago
A
AwningsAndMoreNew
asked in How Do I

What is the Task count for Google Sheet rows to GoToWebinar?

I need to create a Zap to add new registrants (contacts) to GoToWebinar from a Google Sheet. If I paste 500 new rows (contacts) in my Google Sheet at one time, does Zapier count this as 1 task or 500 tasks to add these contacts to GTW?

5
Troy Tessalone
2 years ago
E
eMoOakBeginner
asked in How Do I

Authentication failed when connecting Octoparse with Zapier

I'm unable to connect Octoparse with Zapier. I have an Octoparse standard plan and when I try to allow Zapier to access my Octoparse account I get the following error : “We hit an error adding your new account” - Authentication failed: The app returned “Unauthorized”. I don't get any permission popup. Any help would be appreciated. 

5
Troy Tessalone
2 years ago
R
ross.hopkinsBeginner
asked in How Do I

Salesforce - Create or Update Records in one Zap rather than two

Hi!I essentially have the same use-case of this post - , with the difference that my trigger is from Demio.I was hoping to have just the one Zap. In that thread there are two solutions:Simply place an Update action after the “Find or Create” Action. However, wouldn’t this always trigger an immediate Update if in the previous step a Create Action was triggered? Use a Filter to select “where zap data is found = true” - I don’t see any option like that when I add that step? Or am I just selecting “ID (Text) Exactly matches” <blank>” Thanks!Ross

5
Troy Tessalone
2 years ago
Terms & Conditions