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 Zapier University 101

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Popular Apps Q&A 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

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

Interest Areas User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier University 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.

15165 Topics

W
westernlettingsNew
asked in How Do I

Asana and Office 365

I’m brand new here and looking for advice. I set up an account in Zapier to try to populate our shared office 365 calendar when we add/edit/delete tasks in Asana.  When I create a task in Asana I get a new task in Office 365, but when I change the due date in Asana, I get another new task in Office 365. I’m assuming that I’m not the first person to encounter such an issue but I can’t see any easy way to fix this.  There is no “when I modify in Asana then modify in Office 365” option. Can anyone help?

1
Liz_Roberts
Community Manager
2 years ago
A
alanjaramilloNew
asked in How Do I

math calculations based on inputs within other cells

I am trying to use typeform in google sheets, but I cannot figure out how to have math calculations done based off of the inputs given through the typeform survey i have created. We have tried to manually input the equations into the google sheet, but it seems to throw off zapier, so it skips the rows we need to information to go to.

1
Liz_Roberts
Community Manager
2 years ago
C
CijiCGambleBeginner
asked in How Do I

Jotform to Google Docs Template (Changing from semicolon to comma)

I have a Jotform survey with questions that allow for multiple choices. I created a Zap that goes to a Google Doc template and when I choose multiple options for a question the selections come in with semicolons (;) but I am hoping that they come in with commas instead. Is there a way to do this?

2
C
2 years ago
H
HBSMobileBeginner
asked in How Do I

Is their a way to create a Zap between Trello and my Clipboard?

Is there a way to use Zapier to take data from a Trello card and populate my clipboard? Here's what I'd like to do. When a card is moved to a Contact Client list, I'd like to contact the client. But each client has different methods of preferred contact--some want an email, some want a text, some want to be messaged back on the FB Messenger thread. Right now, I created a Zapier Zap that writes out the message I want and populating it with data from the card (i.e. Hi _Name_, the book you ordered _title_ etc etc) and creates a Draft Email in Outlook, which works only some of the time because most don't have the email field populated. So what I'm then doing is jumping over to Zapier to see the Failed Zap report and then copying the text from there to then paste into my text message or whatever. Is there a way to have that instead populated into my Clipboard so then when I move a card I can then just go to my text message or FB or whatever and paste in what it gives me?

3
Danvers
Community Manager
2 years ago
T
tiagoBeginner
asked in How Do I

Javascript Exception: `Error: certificate has expired` - I am not able to run a test, why is that?

Hi there,  I have a Zap that is connecting an Airtable base with google slides. I am constantly having this error message while performing the test:  `Javascript Exception: `Error: certificate has expired`.` Do you have any idea why?    The interesting thing is that the file get’s generated, however the slide doesn’t get populated?    Could someone point me in the right direction?

3
Danvers
Community Manager
2 years ago
M
MFRBeginner
asked in How Do I

Google sheet export to update contacts

I’ve think i have a similar problem. My question: I have a google sheet export with our customer information from our custom made CRM (kinda oldskool)  Its got 260 columns and about a 1500 rows.  I want to update my contacts in Active campaign if anything changes in our CRM. So I’ve copied alle the fields to AC, set up an export and connected through a zap. My plan is to;   -weekly export all this data.  -delete the data inside, add the fresh export -when a certain cel changed, it triggers   I dont want Zapier, thinking ive added 1500 rows (on a weekly basis) Do I just turn of the zap, do my thing, and turn it back on?  (and does every change in a cel counts as a task?)   Hope to hear from you!  Cheers, Milko Amsterdam  

1
Danvers
Community Manager
2 years ago
W
wargabBeginner
asked in How Do I

node's fields - owner ?!

Salve, I always get this message when i want to update a zap :   Problem updating Node. A node's fields may only be edited by its authentication's owner.     Can't update. Does some know why ?

4
Danvers
Community Manager
2 years ago
M
mrbreadNew
asked in How Do I

change number

I want change number original number :  010-3333-1111 change number : 01033331111   help

1
AndrewJDavison_Luhhu
2 years ago
H
hugh_hopkins123Beginner
asked in How Do I

Unable to create a lookup table

I have been using lookup tables for a while now, however, since the new Zapier user interface, i don’t understand how to create a new lookup table! I understand that you need to have a “a table that will be used for the lookup - keys on the left and values on the right” - however, in the new user interface, there is no where to enter the table? its just a free text box?   Am i being really stupid? Where do i enter the different values? All my existing look up tables are working fine, however, i can’t even see the tables for them either!  Any help would be amazing!

4
H
2 years ago
B
BoozedBeginner
asked in How Do I

Status 400 - Trello - add member to card

Hi,  i'm running into problems building a zap that creates a Trello board and adds a member to the first card (can't find how to invite member to board, so i'll add them to the card as a headsup that the board is created). Current structure: Run Javascript (get info for board from softwares API) Filter Copy Board in Trello (I use a couple of template boards loaded with cards and power ups) Find list on a board in trello (find list name on board id from previous step) Find card in trello (find card name in list id and board id from previous steps) Lookup table in formatter by Zapier (translates user ID's from API in step 1 to name in Trello) Find Member in Trello (Searches trello for person in previous step) Add Members to Card in Trello (Board ID from step 3, Member ID (or name or handle, tried them all) from step 7, List ID from step 4, Card ID from step 5) The last step gives me the 400 errorThe app returned "invalid member". This usually happens when your Zap is missing a required f

2
B
2 years ago
A
andyNEXTNew
asked in How Do I

Airtable New Record Trigger when reaching the max record cap

Hi Everyone,   I’m creating an email digest based on the New Record trigger on Airtable. Approximately 500 new records are added a day and a dozen or so custom digests will parse through each new record, filter to match conditions, then email the correct recipient a custom digest personalized to them. I will be running into an issue with the max record cap of 50,000 records soon. One solution I thought could work was to copy and paste the data into a different table/db, then completely clear the base that the Zap is pointed to so that new records could be added from the first row. However, this doesn’t seem to trigger the New Record trigger. Does anyone have a workaround for this?   Thanks!

1
Danvers
Community Manager
2 years ago
J
JowenNew
asked in How Do I

New to Zapier: Overwrite Google Sheet with daily Gmail spreadsheet attachment in htm format

Struggling to understand the bridge I’m missing here. I receive a daily email with a Report.htm attachment. I’d like to overwrite an existing Google sheet with the detail in that attached report.   I’ve started with New Attachment in Gmail and seem to have that setup fine. then, I was moving to Update Spreadsheet Row in Google Sheets but can’t figure out how to connect the actual report data and have it fill in the sheet. I do not want to keep the previous data.  Do I need to use the Formatter as a second step or a first step? If either, which Utility option do I select? Thanks in advance for your patience!

1
Danvers
Community Manager
2 years ago
P
PM TeamNew
asked in How Do I

Trying to add a Calendly invite to another Gmail calendar

Hi,    I’m trying really stuck here and my boss definitely not happy. I’m trying to make it so that when a Calendly invite is created, she is also included in the email. I keep getting an error every time   PLEASE HELP! I need to get this set up! Moderator note: images cropped and/or obfuscated to remove personally identifiable information.

1
Danvers
Community Manager
2 years ago
M
marshallbeyerNew
asked in How Do I

Check Off Tasks in Google Tasks

Currently, I have a zap set up where if I put a task into Google Tasks it zaps it over to my Things 3 inbox. The only issue I have with this is that now I have the task in two places. Is there a way that I can have it check off the task in Google Tasks after it sends it over to Things?

1
Danvers
Community Manager
2 years ago
R
RbravoBeginner
asked in How Do I

Adding records to Airtable depending on field value

Hi! I have a Table with an “email” field already populated with some email addresses, and I would like to implement the following workflow: when a new email arrives (gmail inbox) Find the “From: email address” in the table. if there is a match, create a new record with the email content (subject, body etc.) if no match do nothing so only emails from people already on the list are stored. When using “Find in Airtable” as Step 2 and the “Create record” as Step 3, I don’t see how to do to create the record only if Step 2 found a match. Currently all emails are stored, as if the Find step was ignored.   On a different Zap I succesfully did an update of a record based on a match with the email address, but can’t figure out how to create a record instead. any clues?   thanks a lot!    

2
R
2 years ago
J
JohnLapNew
posted in How Do I

webhook POST - problem formatting raw payload

Actually, reading your example, I have it fixed.  Thank you   I have a similar problem, except, I can’t seem to get the RAW payload I create to work. It appends the “data:” &”:” before the open bracket which appears to be failing at the API on the other end.  Is there a way to remove those labels.   Thank you in advance. First time on here, so hopefully, I am not breaking any etiquette.

1
Danvers
Community Manager
2 years ago
S
SJ Innovation LLCNew
asked in How Do I

QuoteRoller trigger "Proposal Accepted" is the only trigger that would make sense

Hello!   I was trying to connect QuoteRoller with HelloSign or other convenient online document signature service. I want my client’s to sign the proposal when they want to accept it. There is no such trigger available when I try to connect QuoteRoller through zapier. Please suggest if there is any way to achieve this through Zapier or any other platforms.   Thanks.

1
Danvers
Community Manager
2 years ago
M
mozaydevNew
asked in How Do I

Trouble loading 'Trigger Rule' data in step 1: Unexpected token < in JSON at position 0 [Woocommerce]

We’re migrating our legacy Woocommerce integrations over to the new format, and Zapier can’t retrieve any Trigger Rules after logging into our development website (which has SSL), but I have no idea what is causing this error or what to do about it.

3
nicksimard
Community Manager
2 years ago
E
EflatsBeginner
asked in How Do I

webhooks

Hi I recently started a new webhook zap with hopes to help track job costs for my company. I’m using jobnimbus as my crm where work orders are created and maintained. When a work order hits a specific status my webhook will pull specific data into a google sheet to database the info for later query. This zap is working however not pulling some critical information and the dates are showing up as an unknown 10 digit number I can’t seem to find any correlation to an actual date. Any help would be fantastic.  

3
nicksimard
Community Manager
2 years ago
R
redearmedia
asked in How Do I

Create a Google Sheets Worksheet AND Create Spreadsheet Row(s)

Hi all,I can&apos;t seem to figure out which way to do this. I&apos;d like my Zap to take some nominal form data from Gravity Forms and spit it out into a Google Sheets file. But I want each new form to create its own worksheet. I&apos;ve got step one, but I noticed that the &quot;Create Worksheet in Google Sheets&quot; step does not include the ability to input row data.Assuming I have to create another step that then creates the row data, how can I programmatically select my brand new worksheet from the last step? It won&apos;t have been created yet and Zapier seems to want an existing Worksheet during setup.I&apos;ve tried setting a Custom Value for the Worksheet ID based on the ID from the previous step, but Zapier is throwing an error. Either I&apos;m doing this incorrectly, or it won&apos;t work this way. Any ideas?cc: @AndrewJDavison_Luhhu

3
C
2 years ago
E
EmmaGandBeginner
asked in How Do I

How will a Hubspot dynamic list be managed by Zapier?

Hey there ! I’ve created a Zap to integrate my new contacts in Hubspot into a Mailjet mailing list. Question : will changes in existing contacts also be captured by Zapier and update my existing Mailjet list? Thanks a lot !

3
nicksimard
Community Manager
2 years ago
S
Shameem MoosaBeginner
asked in How Do I

Zap not populating Google Sheet

Hey there. Im trying to send zaps from clickfunnels to google sheets. The test is showing successful however the new row in the google sheet is not being populated. I have no idea what the reason is. Any advice?    

6
nicksimard
Community Manager
2 years ago
K
KrutoymushBeginner
asked in How Do I

Can Table (A) be checked for an existing email address before a zap adds a new record in Table (B) on Zoho CRM?

Can I use Zapier in this way?   I want to have zapier update Zoho Leads (leads table) with new contact records from Outlook. But before it adds the record, I want it to check the Contacts Table (different from leads) to see if the associated email address already exists. If the email address does not already exist as part of a contact record, then it should go ahead and create the new Lead record on the Lead Table. But if the email address is found in Contacts, the Zap does not occur, and no new record is made. There is a basic system in place like this, but it is creating too many duplicate records. (not duplicates in the same table, but duplicate of records in contacts in the leads table).

3
nicksimard
Community Manager
2 years ago
R
Rene DiMBeginner
asked in How Do I

Zaps don´t pass testing. Keeps Loading...

When any zap goes into the last step, sending data to the App, it freezes and stops working. This is happening since yesterday. So far, ZAPIER has not answered. Any clues?

3
nicksimard
Community Manager
2 years ago
K
KhoaDuongNew
asked in How Do I

send gmail with html

Hello everyone, I have a new here. I have a problem about send gmail by html. I have a google form with Embed HTML &lt;iframe src="https://docs.google.com/forms/d/e/1FAIpQLSfG_gKTyDKY3rKMZNLVEwUgFfyfM1Lf4NUKWDHuTyLzepwrNg/viewform?embedded=true" width="640" height="454" frameborder="0" marginheight="0" marginwidth="0"&gt;Loading…&lt;/iframe&gt;   I tried it at w3schools.com   Then, I insert it to my gmail on zapier But my result like that Anyone help me ? Thank you so much.

1
Liz_Roberts
Community Manager
2 years ago
Terms & Conditions