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

24925 Topics

M
manasijBeginner
asked in How Do I

Integrating 2 CRMs each has the same name in two different spellings

Hi Guys, I am trying to create a simple flow where I want to collate all the unique contacts from 2 CRMs into a spreadsheet and send them one email for my promotion (don’t ask why I have 2 CRMs - it is a long sob story).The issue is, there are some names that are common in both but with different spelling or with some extra notations.ExampleCRM1: Name = ABCCRM2: Name = ABC1 or ABC_XBoth are the came contact but they have no common named fields (like email, phone number etc). Is there a way for me to create a rule that ABC=ABC1 or ABC=ABC_X so that while the zaps pick them up from the CRMs, they make only one entry in the spreadsheet for my marketing promotion? Any help would be highly appreciated. 

2
AndrewJDavison_Luhhu
3 years ago
F
frsjrBeginner
asked in How Do I

Send a text alert to my phone

I have a zap set up that sends both an email and text message to potential clients who complete a form. How do I go about setting up a text alert to my phone with the clients info from the form??

2
F
3 years ago
B
briansballoonsBeginner
asked in How Do I

Quickbooks Online invoice to Google Calendar Entry. How do I enter a delivery time?

We are professional balloon decorators that use Quickbooks online for our accounting. We’d like to use Zapier to automatically create a google calendar event based on our invoices. We’ve got it mostly working. We send the client the invoice and we get a custom calendar event with all the information about that gig. Here’s the rub. QBO doesn’t actually have a “Time of delivery” field, much less a “Window of time for delivery” field. Is it possible to steal another field or two (“tracking number” and “shipping via” perhaps?) and write “9:00am to 4:00pm” as the delivery window? What is the specific way to write the times so that Google Calendar recognizes it and creates the event at the right time?Thanks so much for your help.

2
B
3 years ago
K
Kim RogersNew
asked in How Do I

Zapier not picking up data from Salesforce

I have created a zap that fires when a salesforce opportunity is Closed/Won. When the Opportunity is closed/won, it then grants an offer in Kajabi. A very straight forward zap.  I have gone through the process in the test phase of zapier and everything works perfectly - Zapier reads the opportunity in Salesforce and grants the offer.  However, when I turn the zap on it doesn’t work Zapier doesn’t seem to be picking up the data from salesforce - there are no error messages.  What i can’t understand is why it picks up data from salesforce when testing, but not when it is live. We have multiple other zaps where Salesforce is the end point, however this is the only one where salesforce is the trigger.  Is anyone able to help me work out why this isn’t working? 

2
T
3 years ago
M
Mads BollNew
asked in How Do I

How do I integrate Autopilot with Magento 2 to track newsletter signups during checkout?

I am trying to integrate from my Mangeto 2 shop to Autopilot. It is easy to get Zapier to ad customers to a list in Autopilot, when a new order i made, but I can’t fined the parameter that tells my, if the custormer has signed up for my newsletter during checkout. Can any one tell my how I can solve this?Best regardsMads

2
SamB
Community Manager
5 months ago
K
Kelly PressNew
asked in How Do I

Separate Gravity Forms into one google sheet row

I have two gravity forms which i need to extract data from and put into one excel row

2
Liz_Roberts
3 years ago
D
Diego ReppasNew
asked in How Do I

Pipedrive and google analytics

Dear Zapier-community,  I am trying to link Pipedrive deals to google analytics. Only I am not sure what to do. For now I have: → When this happens → new deal in pipedrive→ create a measurement → google analytics But what do I fill in at stage 2? Should I fill in '’run a report'’ instead? I'm a little confused here. How do I make sure all the new deals coming in through pipedrive are succesfully showcased on google analytics/google tag manager?  Thank you in advance!! Diego Reppas 

2
M
3 years ago
E
egoldenNew
asked in How Do I

Help with Slack to Google Sheets Zap

Hi there!  I’m hoping somebody can help me build my ideal scenario:  Ideal Workflow: In Slack, I reply with an emoji, which creates a Google Sheet Spreadsheet titled the name of the channel. Later in the Slack channel, If I react with a different emoji, it adds that Slack message as a row in that Google Sheet Spreadsheet. The Issue: On paper, this seems like an easy Zap, but I’m hitting bumps. Specifically, because I can’t have two triggers in one Zap, my Zap is having a hard time finding the new google sheet. Anybody have any advice?

2
AndrewJDavison_Luhhu
3 years ago
A
Anonymous
asked in How Do I

Find File in OneDrive

I am having issues with the OneDrive - find file - step. I am not sure if I am entering the name of the excel file correctly or if I even have the step in the correct order. Schedule - Find File- Send Email. I tried to follow one of the previous conversations with another member who had the same question but it was not clear how the issue was resolved as a Zapier support person contacted them to resolve it. Could you clarify how it was resolved?Thank you 

2
AndrewJDavison_Luhhu
3 years ago
R
remgriffBeginner
asked in How Do I

creating a summary of slack messages (channel A) and sending it to channel B

Hi! First time posting here, so please bear with me :)So I’m aiming to create the following flow: Zapier would listen to a Slack channel for a specific message (containing a certain word / a character) and would send to a daily summary of those messages to another Slack channel. I’ve looked pretty thorough and no out-of-the-box integration is able to do that. Do you have any ideas on this? Thanks! 

2
R
3 years ago
S
SibghatullahNew
asked in How Do I

Need to connect countermail with zapier

Hi, There is a requirement to connect countermail with zapier. After some research I got that countermail is not in supported apps. When I set “IMAP by Zapier”. Its required username and password. Countermail is key protected. we dont have password to connect.   

2
AndrewJDavison_Luhhu
3 years ago
S
ScottMcBeginner
asked in How Do I

Facebook Lead to email address

Hi,Iam new to Zapier. I hooked up Zapier to send leads that come in from a Facebook lead form to my clients email address. In my Zapier account it says that the test was successful and the CRM in Facebook says: Facebook app - Zapier.However, my client isn’t getting any leads sent to his email. Please help as I don’t know where I went wrong. Thank you.ScottMc

2
S
3 years ago
M
mr33Beginner
asked in How Do I

List cell values, and separate each with comma, but for last one use 'and' to separate

Hi, how would I list cell values separated by comma, but for the last value separated by the word "and".For example, 'Apple, Orange and Pear'.If the third cell is empty, then 'Apple and Orange'.Thank you.

2
M
3 years ago
T
thyngNew
asked in How Do I

WPForms - Zapier - Dropbox

Hi All, New to Zapier.  I was able to successful sync my uploads from WPforms to Dropbox.  I am wondering if there is a way to send the metadata generated by WPForms into Dropbox along with the files I am syncing.  Any help would be much appreciated! Thanks!

2
AndrewJDavison_Luhhu
3 years ago
A
amstormNew
asked in How Do I

Having trouble with Sendy integration - Test was successful! But lead would not appear.

Hello,I set up: Facebook Lead Ads -> Sendy (via Amazon)FB part works fine, and data from form is collected at the test.However the test of Zapier sending the lead to Sendy.co does not work: data is sent successfully (Test was successful!) I do not receive the lead in Sendy.Any advice what to check?Thanks

2
AndrewJDavison_Luhhu
3 years ago
3
3FIRELEGSNew
asked in How Do I

Stripe data integration into Zoho

Hi I have a Stripe USA account with issuing. So Issuing itself has about 8 tables; I can review those tables using Stripe Sigma reporting services. I need some developer to help pull all those 8 tables into my own database, be it MS SQL, or MySQL or some other database hosted online. Please call me @ 111-xxx-xxxx I know you probably have been  integrating with the Acquiring side of tables no problem; but these tables are newly added in 2019 I believe and it's quite a new dimension for Stripe.

2
ForYourIT
3 years ago
M
MattCNew
asked in How Do I

Outlook Zap to Ontraport

I am new. My first Zap set up. I have entered the company Microsoft Account email and password.However I am wanting to Zap a new email lead into Ontraport to set up a new Contact record. Why is it not prompting my business email account to allow me to do that?What do I need to do to get this working?

2
AndrewJDavison_Luhhu
3 years ago
S
SproutNew
asked in How Do I

Problem with Hootsuite body used already

Here is the error I am receiving.  I am not sure why I am getting this.It’s triggered on via schedule and then this error comes when I test.  I would love to solve this.  Any suggestions why this would come are welcome.  thanksResend Test Message to HootsuiteTo test Hootsuite, we need to create a new message. This is what will be created:  The message could not be sent to Hootsuite. body used already for: https://zapier.com/engine/hydrate/5828838/.eJwVjbEOgjAUAP_lzcRalFi6yQCTmhiNYWpIeUAFWqVPjRr-3Trf5e4LukPdqx7fIBMRC7ESEWhnCS0pet8QJOwhAmM9VVajMjXIVKy52MRxBI3BoVa2Gv_ehPcHegp2_6qm1oP8wmMaAumIbl4yVk_miYvWuXbAhXYja8yArGY8Oxacb_PPskjK...Show details

2
steph.n
3 years ago
4
4damBeginner
asked in How Do I

Change Outlook Account used in Zaps

I am trying to create a zap so when a new record is added to a view in airtable, it sends an email from an outlook account.I have no issue in actually doing this as I already have several running. However, I am trying to create a new zap that sends an email from one of my other emails on this occasion and this is where the difficulty is occuring. If i try to +Account, it just defaults to automatically re-adding my existing account (which I feel is sort of pointless!) and I can see no way to add a 2nd or third email account.I suspect from reading other posts, this may not be even possible (which is a bit bonkers, restricting to only one email?)...but if that is the case, I will have to change everything to one generic outlook account...but again, I don’t appear to have any option to even change the current outlook email to another???Can anyone assist please? This is driving me nuts and has stopped dead a very simple couple of hours work for me which in turn is preventing a whole team co

2
nicksimard
3 years ago
A
Anonymous
asked in How Do I

How to send a list of weekly events from Google Calendar to Discord?

Hello all! I’m hoping to create a workflow that looks a little something like this.Every Monday (or whatever specified day), a message will be sent to a Discord channel that lists all of the events in a google calendar for that particular week, in a format such as:Event A, 9/15/2020, 5pmEvent B, 9/17/2020, 6pmetcDoes anybody know a way to make this happen? Thank you!

2
A
3 years ago
N
nitocaNew
asked in How Do I

Add new (but also existing) Mailchimp subscribers to a segment on LinkedIn Matched Audiences

I’ve set up the “Add new Mailchimp subscribers to a segment on LinkedIn Matched Audiences” and it is running as it should. But it is only adding NEW subscribers and I want to add all the existing Mailchimp subscribers as a one time transfer. Is that possible? NOTE: The audience is not editable in LinkedIn Campaign Manager because it is managed as a third-party list (Zapier).

2
adamsmartschan
3 years ago
K
KerryNew
asked in How Do I

Update Contact - Zapier expected ")' or ','

I have a zap from mailchimp to dynamics CRM, which creates any new subscibers in our CRM database and a return zap with the GUID for the contact. All ok so far!However, when I try to use the GUID to identify and update that CRM record later, I get an error that says zapier expected to find “)’ or ‘,’ in the contacts GUID. Can anyone shed any light on why I am encoutering this issue and what I can do to fix it please? Many thanks, Kerry

2
nicksimard
3 years ago
C
cyclemonkeyBeginner
asked in How Do I

Updating an Airtable Checkbox based on Trello Card Move

We have a list of projects in Airtable and have a Zap setup to create a Trello card for our technician to perform a job.  The Zap creates a card under a “New Jobs” list.  Once that project is completed and the tech moves the card to the “Finished Jobs” list, I would like to setup a Zap that marks a checkbox in the Airtable dashboard that the job is finished.  I’m running into two issues when trying to set this up - 1) The Zap is asking me to select a specific record in AT.  I need it to choose the record based on information on the Trello card.  2) It is unclear how to tell the Zap activate a check box in AT. Has anyone been able to do this?

2
C
3 years ago
C
ChaqkenBeginner
asked in How Do I

Questions

So Im trying to do a google forms to trello, so if someone fills in a google form it will send it to trello and it worked nice, but one issue is there a way so it can show the question as well on the trello?

2
C
3 years ago
H
HaseokZapier Expert
asked in How Do I

Invalid API Response: - Results must be an array error

Hi guys I am working on an app to get integrated with an e-commerce platform in Zapier. With the integration, I am trying to pull the data of order details from the resource server.I have checked some similar cases on community but it seems like the codes used don’t wok on my case. I am using Code Mode in Zapier. Here is my code: const options = { url: `https://clothshop1.cafe24api.com/api/v2/admin/orders/${bundle.inputData.order_id}/buyer`, method: 'GET', headers: { 'Content-Type': 'application/json', 'Authorization': `Bearer ${bundle.authData.access_token}` }, params: { 'order_id': bundle.inputData.order_id }}return z.request(options) .then((response) => { response.throwForStatus(); const results = response.json; // You can do any parsing you need for results here before returning them return results; });Invalid API Response: - Results must be an array, got: object, ({"buyer":{"shop_no":1,"member_id":"79254573@n","me) What happened (You are seeing this

2
H
3 years ago
Terms & Conditions