Find answers to your questions. Ask the Community for help or hire someone to help you.
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?
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.
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?
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?
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
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!
Status 400 - Trello - add member to card
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!
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!
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.
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?
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!
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.
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.
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.
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.
Create a Google Sheets Worksheet AND Create Spreadsheet Row(s)
Hi all,I can't seem to figure out which way to do this. I'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've got step one, but I noticed that the "Create Worksheet in Google Sheets" 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't have been created yet and Zapier seems to want an existing Worksheet during setup.I'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'm doing this incorrectly, or it won't work this way. Any ideas?cc: @AndrewJDavison_Luhhu
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).
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 <iframe src="https://docs.google.com/forms/d/e/1FAIpQLSfG_gKTyDKY3rKMZNLVEwUgFfyfM1Lf4NUKWDHuTyLzepwrNg/viewform?embedded=true" width="640" height="454" frameborder="0" marginheight="0" marginwidth="0">Loading…</iframe> 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.
Already have an account? Login
Use your Zapier credentialsLog in with Zapier
Log in to the Community
Use your Zapier credentialsLog in with Zapier
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.