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

20305 Topics

D
denmustiNew
asked in How Do I

Connect my DigitalOcean Mysql database: 225 Error

Hi,I’m trying to ad my mysql database to Zapier.The mysql database is hostedn by DigitalOcean from where i have all necesarry info to login ( works on Dbbeaver)But when wanting to establish the connection in Zapier i get an 225 error.i already chenged my passwoard encryption to lagacy (mysql5) but that doesn’t work either.Can somebody help me out? 

1
T
1 year ago
M
MagnusonNew
asked in How Do I

Updating Airtable from Google Sheet without exceeding record limit

I have a multi sheet Airtable Base and it contains multiple columns, one of which is zip code.   I have a table in Google sheets which has zip code, city, state, and country.We manually add records to our base, and we would like to be able to ‘reach’ into the gsheet and pull back the city, state, and country into the base.    I have tried many avenues, but to no avail, other than having a sheet in my base with that information listed.   That puts me past the allowed number of records in airtable.   Does anyone have a solution and/or suggestion?

1
Troy Tessalone
1 year ago
T
TdastaNew
asked in Code & Webhooks

Can I generate OAuth access tokens to make an API call in Zap?

I’m trying to make an REST API call to an app that uses OAuth2 for authentication. I need to be generate an OAuth Access Token to make an API call in Zapier. OAuth tokens expire so I would need to run it each time the zap is triggered. Is there a way to do this in Zapier?

11
mixelpix
1 year ago
A
AmiesdestinyBeginner
asked in How Do I

How do I setup payroll zap from Jobber that can handle variable rates?

I use Jobber to manage my business. But it doesn't have a way to pay my 1099 contractors a variable flat rate on jobs (the rate for each job & sometimes each visit is different)It looks like New Invoice Created is the only Jobber trigger I can use but I’m lost after that. I'd like to set up an integration between Jobber and maybe a payroll program that has the ability to pay variable flat rates to contractors. So, the Zap would look like this…Trigger-New invoice creation in jobberResult…?I’m not even sure what I could add to my invoices for Zapier to be able to identify which contractor it was. Might have to add initials or something in the job and use Zapier fields.Jobber doesnt export much into Zapier unfortunately. Only a few triggers and limited data. So even if we have to do a multi program or multi step Zap...that would work too.  I've researched how I can do that for hours now and I could really use some help :(

2
A
1 year ago
M
mnagyNew
asked in Code & Webhooks

Unable to see content or the thumbnail url server side

Dear All,we are building an application using a Zap that posts data to a webhook every time an Instagram post is created. I set up the zap and the webshook url, but I cannot see the content or the thumbnail url on our server side in the webhook.When I check the zap history, I can see proper values for most properties for “Data in”, but for the content and the thumbnail url all I see is this:caption: {{139215123__caption}}thumbnail: {{139215123__thumbnail_url}} How should I set this up so I can access these values as well, and then send them to our webhook?

2
Troy Tessalone
1 year ago
R
rshenk3New
asked in How Do I

How to import order info from Printavo into Excel and replace when updated

Hello All,I am currently using a zap to import order information from Printavo into an excel spreadsheet whenever order information is changed.  Sometimes I will make multiple changes to the same invoice number and I would like to replace the old information with the new information based on having the same Invoice #.  I do not want to have multiple rows with the same invoice number.  Is this something that can be done with Formatter or do I need a VBA macro to perform such actions.  Thanks so much for your help!

1
Troy Tessalone
1 year ago
jeffernst
jeffernstBeginner
asked in Code & Webhooks

How do I turn multiple field values into a comma-separated string

I’ve seen a ton of articles and posts on turning a comma-separated list into separate fields, but none on the opposite. I have text values in five different fields that come from columns in Google Sheets. I want to turn them into a comma-separated string to feed to my API. The challenge is that there isn’t always a value for all five fields, one or more can be empty.So if I simply do Field1Value, Field2Value, Field3Value, Field4Value, Field5Value in the zap, and Field1 and Field 4 are blank, the result is extra commas like:, Field2Value, Field3Value,, Field4Value.Any ideas? 

8
Troy Tessalone
1 year ago
Y
YanovskiBeginner
asked in Code & Webhooks

How to find a matching record from Airtbable using a Webhook response array

Hi !!I’m very new to this community but have been a Zapier user for years. However, I’m a no-coder so today I’m in very need of help on how to process something I want to do with a Zap. The idea here is to Find an Airtable record that matches a specific condition, the latter being pulled from a previous API Call using a Zapier Webhook. First Step, my trigger is when a new invoice is created in Airtable. No issue there :-)Second step, I’m calling Airtable API with Webhook with custom parameters. In the response, I have fields that I want to use as a filter in the 3rd step , see below :  Now,  for Step 3 I want to Find any random record in Airtable that IS NOT one of the User_ID’s from Step 2. As the result of API call is an array, I don’t quite figure how to push this array as a Filter for the records I’d like to pull from Airtable.In a Step 4, once a record is pull, I’d like to create a New record in Airtable with previous steps’ informations.I saw a couple of topics pointing in the ri

6
Y
1 year ago
P
paulinahryBeginner
asked in How Do I

Slack updates when social media posts are published via Buffer?

Hi! I would like to create a zap where whenever a social media (FB, LI, Twitter) post is published (not scheduled or in queue) via Buffer a message is sent to a Slack channel, so everyone in the company can see & react to that post. I can’t figure out how to make this work, is it even possible? Thanks in advance.

3
Troy Tessalone
1 year ago
nounaikaihooo
nounaikaihoooNew
asked in How Do I

Bad request error when connecting to Adalo

I want to connect Adalo, but it says a bad request and I can't connect successfully.  How can I solve it?Help me.

7
Troy Tessalone
1 year ago
Q
QhiliqqBeginner
asked in How Do I

Lexoffice “Unable to upload file: The file type is not supported” error

Hi,I'm using your "Email by Zapier" app with trigger of new inbound mail in combination with lexoffice.Normally everything works fine, but if a pdf file is named with a blank space the zap won't be processed cause of "Unable to upload file: The file type is not supported." from lexoffice.Anybody knowing this problem and knows how to handle it?I can’t change the pdf name, cause this are incoming invoices from companys.Best regards,Philipp 

2
Troy Tessalone
1 year ago
G
Gavin HeatonBeginner
asked in How Do I

Can’t load new Pipedrive leads - “We couldn’t find anymore leads” response

I want to send notifications to specific people when a new Pipedrive Lead is submitted via a webform.However, when I pull sample data to create the Zap, I only see old leads (that have not been submitted via webform), not the newer leads.When I try to Load More data to test the trigger, I get the response “We couldn’t find anymore leads”. But the new leads have been created.Where to from here?

7
Troy Tessalone
1 year ago
M
MartynaNNew
asked in How Do I

Can Zapier find Slack messages in a private channel?

I have a simple Salesforce → Slack Zap, that is triggered by an updated record in Salesforce. The message is posted on a private channel. I’d like to add a second Zap, that would post a message whenever the same record gets another update. However, I’d like to have this message posted in a thread. So far I’ve managed to test it on an open channel. But is there a way to search a private channel and have Zapier post in a thread there?

1
Troy Tessalone
1 year ago
siliceous
siliceousBeginner
asked in How Do I

Calculating and recording Zaps and Tasks

Hi,I am setting up a client with a couple of zaps and I need a way to record in a Google Sheet the number of times the zaps has run and how many tasks it has completed as the client needs this information for onwards billing. This could either be per zap, per week or per month.Is there a particular way to do this?Thanks.

9
siliceous
1 year ago
R
RMG1Beginner
asked in How Do I

How to stop Zap from running once I update Google Calendar?

I have a Zap that creates a Google Calendar item from an Evernote note with a certain tag. When I edit the Google Calendar record, I pay change the calendar, subject, and other details. However, the Zap runs again and adds the calendar invite again. Is there a function to add where I can tell Zapier to only send it once? 

3
Troy Tessalone
1 year ago
A
asrNew
asked in How Do I

Zapier won't move all of my files between different Airtables

I made a zapier, and am trying to move about 2500 files from one airtable to another for this initial move. When I try to move them, the zap does work, but it just stops after a certain number of files for no reason. For example, there should be 1500 runs, and it only moved 563. There are no error messages in the zap history. Tried re-running as well and nothing. Support is taking too long to get back to  me. Any tips?

3
Troy Tessalone
1 year ago
J
juankibcnBeginner
asked in How Do I

Wait for next day to send SMS

HiHow can I make a zap that wait until an specific time to run?I’m sending SMS when customers buy in my shopify shop. but, if I make a draft order, maybe I’m working at night and it’s not a good idea to send a message at 2am.. I would like to wait until 9am to send it.Delay by Zapier can send it x hours later… but this is not I’m looking for.I have an started account.Thanks

2
J
1 year ago
E
EricaBeginner
asked in How Do I

How to get files/attachments out of Slack

I am looking to create a zap that accomplishes the following:We have several programs and several team members. when we get a review /testimonial on a program it gets posted in one of several channels in Slack for the team to see. I also have an Asana project set up for all testimonials with different sections depending on what program the testimonial is for  So when someone posts a photo in a Slack channel, I want our marketing person to be able to mark that photo somehow with an emoji or a push (b/c I do not want it to trigger on EVERY photo posted in Slack or even on every photo posted in a specific channel I wan the marketing person to review them and only send the ones they like/want to Asana) and that photo/file is uploaded to a specific place in Asana (the section corresponding to the product the testimonial is for) Here are the issues I am facing….The “Zapier push” function does not pick up files/attachment data from Slack and copying and pasting the public photo URL in the tex

3
Troy Tessalone
1 year ago
T
TWMNew
asked in How Do I

How to auto respond to all RingCentral SMS messages when out of office?

Trying to create an auto responder for SMS messages that come in to my RingCentral account while I’m out of the office. What do I put in the “to number” field if I want to create an auto reply to ALL text messages that come in, not just from one specific phone number?Basically this exact same question was asked in another thread, but the response posted didn’t help me figure out how to do it. It says to paste the “from” field from the trigger, but when I do that it only sends the autoresponse to the one specific phone number that sent the message that was used in the trigger step. 

12
T
1 year ago
K
kevinwphelpsNew
asked in How Do I

Waiting or Paused Zap - Editing Data in to Continue Flow

I’m using a signed DocuSign agreement to push client data to multiple systems. The data that was entered during the DocuSign isn’t valid for upcoming steps of the Zap, so the Zap is being halted. Having the client resign the agreement is a situation I don’t care to explain.Is there a way to manually change the “data in” on certain steps of a specific Zap in progress so it can continue to run?   

3
Troy Tessalone
1 year ago
F
FunmilayoBeginner
asked in How Do I

How to add a new customer from paystack to my buyers list on aweber

Hi pals! I’m trying to trigger the automation of unsubscribing a new customer from every list on my Aweber -- then adding them to my buyers’ list when their payment go through on Paystack How do I go about it? Thank you!

2
F
1 year ago
F
FunmilayoBeginner
asked in How Do I

How to add tag to AWeber subscriber when transaction abandoned in Paystack?

Hi, I’ve noticed quite the number of my aweber subscribers abandon their transaction in paystack (due to some reasons) How can I add a tag via Zapier that will be passed to AWeber with their email address to send out transaction recovery emails ?Thanks

4
F
1 year ago
FasterMaster
FasterMasterNew
asked in How Do I

Zapier connection to exchange data with the SQLlite database

Hello. I'm asking for your help. Is there any ready-made solution for connecting Zapier and SQLlite. I couldn't find it on my own. I saw that there is integration with other databases. Is there any other way? Some kind of connectors or spacer services?  

1
Troy Tessalone
1 year ago
C
ChrisScudzBeginner
asked in How Do I

Automation with Cognito to Google Drive

Good Morning all,  So Im looking to create a zap that grabs submitted documents in a Cognito form, creates a folder in Google Drive and uploads the grabbed document into the folder created. I cant seem to get the right combination of triggers to complete this. HELP PLEASE!

3
Troy Tessalone
1 year ago
T
terrillNew
asked in How Do I

Sendinblue “Error (400) undefined” error

I am trying to integrate with SendinBue and keep getting an error 400 Please advise Thank youT  

5
Troy Tessalone
1 year ago
Terms & Conditions