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.

21899 Topics

J
josephsultanBeginner
asked in How Do I

How to identify the Slack thread replies?

Hi guys! I need your help!I have an integration between slack and google sheets in which when a post is made it’s directed to a sheet called Posts, and when a reply in the thread is made it’s directed to Replies sheet in google sheets. I need to be able to define the time difference between the post and replies, I thought of making a formula to minus the time after filtering, but i am not sure how to define that a thread reply belongs to a specific post. I would truly appreciate your help with this!

1
Troy Tessalone
1 year ago
J
josephsultanBeginner
asked in How Do I

Slack timestamp sent to Google Sheets is 2 hours behind

Hi!I have an integration between slack and google sheets, in which when a post is made in slack, the data is copied to a new raw in google sheetsI noticed that the timestamp is 2 hours behind though, but my timezones are correct in slack and desktop, any ideas?

1
Troy Tessalone
1 year ago
D
DavidZapNew
asked in Troubleshooting

Firebase realtime database “Unable to verify that your connection has access” error

I have found this discussion as reference: I have created a fresh database: However I am always getting the following error: Zapier could not connect to your account.Unable to verify that your connection has access to the Firebase/Firestore project "test-pro-61103"What is the solution to connect my Real-time database to zapier?

1
Troy Tessalone
1 year ago
U
ukbirdmanNew
asked in Code & Webhooks

Using Zapier as middleware

I am interested in the architecture of Zapier first, before getting into the detail.I can see how I could use a Retrieve Poll to pick up for example a group of orders from one application. Is there a way to parse the data in Zapier, before run a POST to a second application to send the orders to that application - because the two applications refer to the data differently?Is it relevant that the first application is already connected to Zapier (but has no relevant Zaps created), but the second application is not?Is it better to use tools other than Zapier, or is this perfectly feasible?I support many customers on the first application, and have many potentially different scenarios of posting to or getting data from other applications, both already in the Zapier community (eg Shopify, WooCommerce) and also not in the community. I’m keen to understand whether Zapier represents a good potential middleware solution with hopefully replicatable code, even if this requires some coding inside

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

Asking for Facebook login when connecting Instagram account

Why is it trying to get me to sign into Facebook to connect my Instagram business account? which of course isn't going to work.

1
Troy Tessalone
1 year ago
K
kialikhon4e4Beginner
asked in Code & Webhooks

How to pull Python code from a GitHub and reformat it for Google Sheets?

Disclaimer: I am not a coder...I've tried researching how to do this on my own, but I'm too far out of my wheelhouse to figure it out. So, I'm hoping someone can show me how to use the Python actions inside of Zapier to automate a repetitive task.The Goal:I want to be able to pull the data of "new move-ins" to the area from my church's website (name, address, phone, etc) and have it put into a Google Sheet, so I can keep track of efforts to welcome them. I know how to set up everything in the Zap, except for the Python actions that pull the data from the site and then formats it the way I need it for the spreadsheet.Someone has already coded a way to pull the info I want using Python, and posted it on GitHub here: https://githubhelp.com/SpencerMKSmith/LCR-APIIt says: To Install, Run:pip3 install lcr-apiUsage:from lcr import API as LCRlcr = LCR("<LDS USERNAME>", "<LDS PASSWORD>", <UNIT NUMBER>)months = 5move_ins = lcr.members_moved_in(months)for member in move_ins:

2
K
1 year ago
Sandra Hoffmann
Sandra HoffmannZapier Expert
asked in How Do I

ActiveCampaign Double Opt-In

Hi, is there a possibility to trigger a form in ActiveCampaign to get a contact into a double optin workflow of that form? I can send contacts to AC and they subcribe immediately to a specific list. So I use automations to imitate a double optin process. But now I heard that Integromat has this function to send contact to a AC form. Maybe there’s a possibility in Zapier as well!?

10
Sandra Hoffmann
1 year ago
D
designteammNew
asked in How Do I

I can't use Text to line item outputs in Google Sheet

I want to add comma separated data from webhook to separate columns in Google sheet.The value sent from Typeform is, for example: “FULL BODY, HOUSE, 1,”  To do this, I first split the comma-separated data into lines with text to line-item. And the output looks fine: Then, when I want to add the output to separate fields in the Google sheet, it still appears separated by commas.   How can I solve this?

4
J
1 year ago
R
RussBeginner
asked in How Do I

Multiple “Sales Tax Abbreviation” possible?

I’m setting up a Square → Wave integration, and in the “Sales Tax Abbreviation” section I’d like to include two sales taxes -- city and state, which I’ve set up in Wave. Is this possible?

2
R
1 year ago
M
MattttttttttttttttNew
asked in How Do I

Is it possible to lock or prevent changes to a zap?

Is there any way to prevent unintended changes to a Zap? There’s currently no save button so any changes are immediately applied to the zap which is a recipe for unintentional modification / makes it hard to do simple tests. There is also no way to revert to a previous version of a zap. What are the best ways to prevent or mitigate unnecessary changes. Thanks.

1
Troy Tessalone
1 year ago
R
Rachel HNew
asked in How Do I

Trigger test not showing in Mailchimp account

Hello! I have my zap set up so it sends a facebook lead to my mailchimp to become a subscriber. When I test the action I do not see the trigger test email in my mail chimp account. the zap says it’s working but it’s not showing up in mailchimp.

2
R
1 year ago
Robert_Segelquist
Robert_SegelquistTinkerer
asked in How Do I

How to line item

I’m pulling deal data from activecampaign and want to send in an email as  title1 - task1title2 - task2what utility should I be using? Everything I’m trying is returning the same data I’m inputting, or give me a Forbidden error.Data below is simplified just to show the necessary information.{deals    1    title: SSP Eyewear    nextTask: https://domain.api-us1.com/api/3/deals/44/nextTask    2    title: BA Direct    nextTask: https://domain.api-us1.com/api/3/deals/51/nextTask}

1
Troy Tessalone
1 year ago
D
DebsNew
asked in How Do I

Calendly and Keap - Unable to bypass optional field

I’m setting up a pretty basic Zap.  When a new event is created, Create/Update a contact in Keap with a tag, and add the event date to a custom field.  However, Zapier is insisting that I add a company to the Company Field but not from the data that is coming from Calendly.  It won’t let me save the Zap until I choose a company that exists in Keap.  I don’t want to do that. It would be incorrect information.  Anybody know why this could be happening?  (The Company field is the only field that has the green “K” indicating that it’s required) 

1
Troy Tessalone
1 year ago
M
Moritz87New
asked in Troubleshooting

Facebook Conversions API FBCLID Error

 Hi, Really don’t know why this error is shown? Any Ideas what’s wrong? Which data fields fb needs to associate the converison to an ad group → Is fb clid enough? Is fb cliid sufficient to prevent duplicates with pixel events?

3
Troy Tessalone
1 year ago
R
renkyeBeginner
asked in How Do I

Need help parsing Woocommerce product attribute

Hello everyone,so basically, as visible in my screenshot, for a known line_meta_data key, I want to access the value. And I want to send this data to Docusign, which doesn't support line items. I’m new to Zapier and I’ve tried using the Formatter but I couldn’t get it to work. Thanks for your help!

4
Troy Tessalone
1 year ago
B
bishiNew
asked in How Do I

Clickup tasks not created from spreadsheets

Hello,  I created a zap which creates a task in Clickup when a new row is added into a spreadsheet. Tested it and it worked. But after the zap was turned on, tasks werent created in Clickup even if data was added in the trigger column in a new row.  Can some one please help me out with this?  Thanks!

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

Convert Currency IF . . .

We are importing USD ($) and GBP (£) invoice data from Scoro to a Google Sheet. If the invoice values is $54,000 then Scoro exports it as 54,000. If it’s £54,000 it exports it as 54,000. What I want to do is to divide the value by 1.4 (our GBP to USD exchange rate), *IF* it is a USD value. We have a column which details ‘USD’ or ‘GBP’. Any thoughts?

2
Troy Tessalone
1 year ago
D
digitaltransformationBeginner
asked in Troubleshooting

Error turning Zap on: Unknown error when enabling Zap

Hi !I wanted to highlight this error, because it only happens to one folder of my many other folders in my Zapier account.No other folders face this issue , just this one folder, whereby i can only turn on a maximum of 3 zaps.  Please help. 

3
Troy Tessalone
1 year ago
W
weirdo85Beginner
asked in How Do I

Assistance filtering RSS feed

Hi, I need some assistance with filtering an RSS feed, or possibly create one for me. The RSS in question: http://www.reddit.com/r/kpopfap/new/.rss?sort=newI would like to create a filtered version of the above RSS, that will only output the Title, and anything that contains the URL "https://gfycat.com/" or "https://imgur.com/" from the Raw Content #Text.So an example of the output would be:<item><title>Example Title 1</title><description>https://gfycat.com/123456</description></item><item><title>Example Title 2</title><description>https://imgur.com/123456</description></item>

5
Troy Tessalone
1 year ago
U
user138Beginner
asked in How Do I

Using Airtable and Google Docs to Generate PDFs on Command

Hi all,We’re a very small company looking to generate invoices for our clients from their Airtable data. So far I’ve gathered that I need to pull the data from Airtable, send it to a Google Doc template, get a Google Drive share link for the doc, and send that via Gmail to the email in the Airtable record.There’s three things I can’t figure out how to do:I don’t want it to automatically be triggered at some specific time. I want to manually run the automation to pull the data from all records in the Airtable view and generate the Google Doc templates. How can I do this? All I’ve been able to find are triggers to do it automatically, when in my case I want to be the one to “Say Go” I want it to generate the Google Docs from all records in the Airtable. So far, all I’ve been able to figure out how to do is “Find” one Airtable record and perform the Zap on that record. I would love for it to send a PDF instead of a Google Drive link, and to reattach that PDF back to the Airtable record it

3
GetUWired
1 year ago
K
Kate from EratosNew
asked in Troubleshooting

Zendesk Sell - New Contact trigger - Is Organization filter not working

We have a Zap that is using the Zendesk Sell - New Contact trigger.In the trigger, there is a Filter for “Is Organisation”.When that is set to false, the Zap is still running for a Contact that is marked with Is Organisation = True.Any idea how we can fix that?Thanks!

2
jesse
1 year ago
J
jamesgerry2New
asked in How Do I

Is it possible to take my site backup on Centos 7?

My site is Hosted on Centos 7 i want to take its Database Backup and wordpresss backup auto , can you please guide me how can it be done Phpmyadmin is where the database and site is on centos 7 

2
jesse
1 year ago
C
Clever Money MakersNew
asked in How Do I

How to email user GoHighLevel password that is automatically generated?

Working on a Zap for our Go High level agency account Issue is i’m trying to use the auto generate password and its working.. the issue is that I cant figure out a way to send the password that was generated in the next step that is email new user.. any help would be much appreciated 

3
jesse
1 year ago
I
IainMNew
asked in How Do I

OneNote - notebooks missing

A couple of weeks ago, I got a message to refresh my OneNote app connection in Zapier.  Did so.  Seemed to succeed.  But immediately a Zap began failing.  This Zap has been working for literally years (since 2017).It is a Zap to take a recently-completed task from Toodledo (that part works fine) and append it to a page in OneNote.As I worked through editing the Zap, I found I could not see all my OneNote notebooks in the select box.  Some, but not all.  In particular, I coud not see the OneNote notebook I have been writing to via this Zap for 4 years.  I do reload, search…  The Notebook I want is just not found by Zapier.I am logged in to my Microsoft 365 account while doing this, of course, and in any case Zapier reports that the app connection to OneNote is fine.  But within Zapier I am just not seeing several of my notebooks, among them the one I want to resume writing to.Any help gratefully received.  TIA.Iain

2
jesse
1 year ago
Z
zap29550Beginner
asked in Code & Webhooks

How to transform JSON response?

I am calling an API that produces a sizable JSON response. Zapier is trying to output most of the leaf nodes as values, but I want to just take the entire body into the next step. Is this possible?

13
GetUWired
1 year ago
Terms & Conditions