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 Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

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.

25343 Topics

geneva
genevaBeginner
asked in How Do I

How do I use the time formatter to get 12 hour time (AM / PM) from 24 hour time

Is there anything I can do with the Date/Time formatter to get YYYY MM DD HHA:mm (12 hour am pm time) from YYYY-MM-DDTHH:mm:ssZ (24 hour time from Outlook) ?*edit* time format above should be YYYY - MM - DD T HH : mm : ssZ (added spaces to avoid emoji above)This article mentions that I can input an “A” in the To Format field to get AM/PM, but I don’t see this in my format options and I can’t figure out how to input custom formats. I really don’t want to have to use another formatter step to extract the 24 hour clock time and then another step to calculate the 12 hour time if possible… Please help!

4
geneva
1 year ago
S
Sonia SamoBeginner
asked in Troubleshooting

No errors but Zap isn't triggering for new leads in Facebook Lead Ads

Hi there,I have a new zapier account for one of my client, and I built a Zap that create a Spreadsheet row in a Google sheet from Facebook lead ads. All the connections are ok, and the test is ok. There are no error registered, and during the test the zap creates a spreadsheet row in the google sheet. But after I turn it on, it doesn’t work, it simply doesn’t runnig.  Although I have conversions in FB lead ads, the automation doesn’t send any information to the spreadsheet. And of course there are no Zap history data.Did anyone face the same problem? What should I do?Thank you very much,Sonia

6
H
2 years ago
A
ayoung72Beginner
asked in How Do I

Simple Convert email to PDF

Like many I was using google cloud print for PDF zaps. However, in searching the forums my issue is super basic compared to many who had highly complex zaps break with this app’s retirement.  FunctionForward an email on receipt to the zapier print email address.  Print it with Google Cloud Print.  Saving to Google Drive Save that pdf from Google Drive to drop box. Most of the new PDF apps are for actually printing to a printer  Needed Functionality: Forward an email on receipt to the zapier print email address.  Print it to a PDF or even JPG format would work.  Save it to Drop BoxIs this even possible anymore? Thank you in advance! 

6
A
3 years ago
Q
quickjeffBeginner
asked in Code & Webhooks

Best Approach for Working with an API that Uses Bearer Tokens

Hi Ya’ll,  Currently working with a client that is requiring that we use a file management systems api. The api sends a bearer token for authentication. The token doesn't change unless we force to reset.  Looking for best approach to store bearer token as this will be used in the headers later to make POST requests. Has anyone stored this inside Zapier? Do you store it outside of Zapier and then use it in the zap? Looking forward to recommendations. Thanks team! 

7
G
1 year ago
C
criscomBeginner
asked in How Do I

Strava 'rate limit exceeded' when trying to connect account

When trying to connect to Strava, on “My connections” I get “The app returned Rate Limited Exceeded” after reconnecting or testing.

30
nicksimard
2 years ago
Z
zsectionNew
asked in How Do I

Send image files to Notion database

Hi, I'm trying to send an image from this zap to Notion. Am I right in thinking you can't use Zapier to send images/attachments to a notion database? Thanks

11
Z
2 years ago
Bob
BobBeginner
asked in How Do I

Feature Request: Native integration for USAEpay (and other payment gateways)

Its becoming commonplace for Stripe and PayPal to sort of 'rule' the online payment arena, but there is a slight catch 22 in that PayPal and Stripe have such easy integration built in by design where other gateways such as USAEpay, Authorize.Net and NMI are reasonably popular with more traditional businesses and many people are unable to learn to integrate them.I'm not sure I have a whole lot of use for USAEpay integrations beyond 1 single project I'm working on now- but I know dozens of people who could benefit significantly from that particular integration.I just wanted to voice my request on that particular Zapier integration

7
Danvers
4 years ago
4
4pillarfundingNew
asked in How Do I

How to pull screenshot of table (specific cells) from Google Sheet?

Hello all, I have a Zap set up but just running into a tiny problem that has become a head scratcher. My firm provides business financing. I have created a formula to provide prospective clients with a quote for what an offer would look like using Gravity Forms and Google Sheets. Upon submitting the Gravity Form it automatically updates a chart in Google Sheets and redirects the client to a different page showing them their quote. So all is good and fine except one tiny issue.  It is not a unique URL so every time a NEW client submits a quote request the table updates and changes.  This of course does not scale and if a client ever wants to come look at their quote later on it will likely be different. Here is a step by step of the Zap. Form Submission in Gravity Forms (http://4pillarfunding.com/quote)Create Spreadsheet Row in Google Sheets (with Gravity Form Submission Data)Lookup Spreadsheet Row in Google Sheets (find newly created row)Update Spreadsheet Row in Google Sheets (in a di

2
SamB
Community Manager
2 years ago
E
EricaBeginner
asked in How Do I

Using Google Sheets with Formulas in Zap

Here is the zap I am trying to createTrigger when any spreadsheet row (Google Sheets) is updated If the cell in column G is over 100% (this cell is a simple (=f13/d13) formula in the spreadsheet itself)… Send Channel message in Slack I have tried EVERYTHING but I cannot get the trigger to work because the row that is being updated is Row 13 which has a formula in it so when I try to do a test trigger it will not pull the data from ANY row with a formula….but every row I need data from has a formula in it. So pretty much this trigger only works with rows that are irrelevant but none of the other triggers make any sense….Someone please help! How can I get zapier to read any data within the rows that have formulas so I can trigger this thing? 

13
awilson
2 years ago
SC5
SC5New
asked in Code & Webhooks

REGEX formula to remove all text before a certain character

I’m struggling with the Regex code in a formatter Zap.I’m trying to remove all text/characters before the :   just leaving all the text that follows the :Ive tried the excel regex formula but its not computing.example:data pulled isuser.name: AcceptedI want it to only produce Accepted to push to my google sheet.can anyone help me figure out the formula?  

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

Amazon SES Authentication

Has anyone else received an error when attempting to connect to Amazon SES service?  I have verified the credentials and even used them on Integromat to successfully connect.  Zapier, on the other hand, gives me this error:  authentication failed: An error occurred (SignatureDoesNotMatch) when calling the ListVerifiedEmailAddresses operation: The request signature we calculated does not match the signature you provided. Check your AWS Secret Access Key and signing method. Consult the service documentation for details.

6
christina.d
2 years ago
B
briansballoonsBeginner
asked in Troubleshooting

Gmail sent emails are limited to 78 characters per line

Hello zappers,I’m having an issue with email formatting. It seems to be restricting the email to 68-70 characters per line… but only for the receiver. The formatting in the Sent box looks normal.Sent box (show it ought to look): Inbox of recipient (I don’t want it to look this way):Here is what it looks like in Zapier:What is going on and how can I fix it? Thanks!​

7
Nichola Mcd
1 year ago
Raoni
RaoniBeginner
asked in How Do I

Formula - How to increase a number per 1 (+1)

Hello 👋, Fisrt, Sorry for my English 😕I'm an Airbnb host and use zapier to automate a certain number of tasks.I also use Notion for accounting, stock management, and cleaning tasks.In this case I would like to count the number of guests I have per month so I know how many cleaning tasks I have to pay the cleaning lady.Do you guys, have any idea how I could increase the number of bookings per 1 (+1) each time a booking is made ? For now I've set up email parser.Each time I receive a bookings confirmation from Airbnb it creates a an event on Gcal and updates my data bases on Gsheets and Notion. But I would like to have a counting system so I don't need to manually count bookings. I'm not sure what app I should use for that, maybe using code by zapier :-> using "look up row" task on Gsheets -> getting the value on a cell made for that (let say it's 2 bookings)-> use a formula to increase the value (+1) That's the part I'm lost.-> update the same cell with the new value. I ho

12
K
1 year ago
Bruno Pagano
Bruno PaganoBeginner
asked in Troubleshooting

ChatGPT error: You exceeded your current quota. Please check your plan and billing details.

Failed to create a conversation in ChatGPTYou exceeded your current quota, please check your plan and billing details. I have a paid plan from ChatGPT, I have ChatGPT Plus, and I am on my free trial with Zapier but it is not letting me use ChatGPT in my Zap. Please help.

11
cec777
9 months ago
J
Jakub ZiolkowskiBeginner
asked in Code & Webhooks

How can I create an array of JSON objects?

Hello! I am creating a zapier integration for our invoicing software. I am however not sure how can I create a nest an array of JSON objects inside a jSON. "invoice": { "seller_name": "name1", "seller_tax_no": "123456789", "buyer_name": "name2", "buyer_email": "some@email.com", "buyer_tax_no": "987654321", "positions":[ {"name":"Product 1", "tax":23, "total_price_gross":10.23, "quantity":1}, {"name":"Product 2", "tax":0, "total_price_gross":50, "quantity":3} ] } I have no problem adding fields, I am however stumped with “positions”. I have tried making it a Line Group Item, but when I tried inputting some test data I realized it gets turned into a regular array of strings, rather than an array of JSON objects. "positions": [ "name: product 1", "vat: 23", "total_price_gross: 100", "quantity: 1" ] Is it possible to make it work in either zapier dev

4
J
3 years ago
wczapper
wczapperBeginner
asked in How Do I

Automate a daily backup of a Google Sheet

I would like to create an automated backup. At 4:00 am EST every day, I want to create a copy of an existing Google Sheet in my Google Drive, rename the file, and than move it to a specific folder in my Google Drive. I’ve searched the forum and help articles and haven’t found anything that will allow me to set a trigger without something happening in the Google Sheet first.

6
H
2 years ago
M
micheleBeginner
asked in How Do I

Apply condition IF...ELSE in Zapier

Because there is no AND condition for searching both Lead and Contact in Salesforce, is there any IF...ELSE with Zapier filter that we could use. I can adjust my current workflow to use IF...ELSE as alternatives for AND condition. My goal is to check the email does not existing in Lead and Contact in order to save a new record in Salesforce; otherwise, it will cause an error in Zapier task about duplicated records.

11
SamB
Community Manager
2 years ago
M
michaelrbowenBeginner
asked in How Do I

Google docs - create template from document - "No Options available"

I’m trying to create a new word doc from template. I have setup my trigger to be a new card in trello I select action as google docs, and then create document from template, and click on continue It then asks for my account. First note is that i see google docs show up different from google sheets and google drive. I used the same method, connected the same account, but docs doesnt show my name… every other google service does Also what i note is that when adding sheets, forms and drive, it has the blue circle, but whenever i add google docs, that blue circle and mention about spreadsheets isn't there. Its only the first part about see edit etc. I would have expected to see something that had a blue circle and allow “docs” in google drive   Back to the Zap… on the next part it asks to select template doc… but comes back with … no options available   So, i cant choose a template. nothing shows up under it   I ave removed all the google connected apps readded… same issues persists   Plea

12
AndrewJDavison_Luhhu
3 years ago
C
craiglloydBeginner
asked in How Do I

How do I change a Slack bot icon for zaps?

Hello! New Zapier user here. I’ve set up some zaps and bots for Slack, but I can’t find the option to change the icons for my Slack bots. How do I do that? I’m currently on the Starter pack. 

2
jesse
1 year ago
T
traker998New
asked in How Do I

FreshDesk to PandaDoc

Hello,   We are trying to improve our workflow from FreshDesk to PandaDoc and it currently doesnt work exactly how we want it to however Zapier has given us the information needed to complete the workflow but not speficially how to do it.   Obviously a paid position.  I think it is kinda simple but I always think that.

1
AndrewJDavison_Luhhu
3 years ago
D
DanielFBeginner
asked in How Do I

How can I use variables ( e.g. todays date) in a filter?

Hi, how can I use variables ( e.g. todays date) in a filter?I want to run the next step ONLY if the date is > today() Do I need here an extra step before this action is called to set the date?I haven’t found a way yet.

2
Troy Tessalone
2 years ago
T
TextPowerCEOBeginner
asked in Code & Webhooks

Trigger an API call when an email arrives

I need what would seem to be a simple Zap but it’s over my head.  I need to trigger an API call when an email arrives.  I have to take a variable that will appear in the Subject line of the email and then send it to a predefined URL using predefined credentials.  If you can assist I’m willing to pay.  

6
T
2 years ago
G
Gabi
asked in How Do I

Raw hooks vs web hooks

Can someone please explain the difference between a raw hook and a web hook? and when is it appropriate to use them?

1
Troy Tessalone
3 years ago
I
IT_ZachNew
asked in How Do I

Two Triggers In One Zap

Hi, I need some help making sense of Sub-Zaps. I am trying to have two triggers in one zap, new member added to Circle and event start in Google Calendar.  Here is the workflow I am trying to achieve… New member added to Circle community > Wait for Google Calendar event start > Add member to Circle space group > Wait for Google Calendar event end > Remove member from space group I cannot use Zapier’s delay action because the delay times are longer than one month.  I’ve tried setting up a Sub-Zap for both the Circle and Calendar triggers but I just don’t understand how to make the Sub-Zap behave like a trigger in my Zap.  How can I make this work? Is my desired workflow achievable? Please help!

7
Troy Tessalone
2 years ago
V
VinzNew
asked in Code & Webhooks

Convert JSON to CSV and then send by email

Hi all, I am pretty new to Zapier and I am trying to figure out if this kind of workflow is possible:   I have the end point of an API which I need to call and get a JSON as response I would like than to convert this JSON to a CSV I would like to email this CSV file this should be a recurring task (daily) and possibly I need to pass to the step # 1 a date dynamically.   I hope my question is clear and thanks a lot in advance to anyone who could help me,   -Vinz

3
TimS
3 years ago
Terms & Conditions