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.

25522 Topics

S
ShazedNew
asked in Troubleshooting

Facing validation error when creating a Zap for different tax rates between Shopify and Xero.

I’m trying to set up a Zap that creates a new invoice in Xero when an order is placed in Shopify. Our products have different tax rates - 95% are GST on Income and the remainder are GST Free Income. I’ve tried every tax preset from Shopify and they all cause a validation error. The specific wording of the input field in Xero is GST on Income or GST Free Income.Can anyone help problem solve this?

2
S
7 months ago
Blast Recording
Blast RecordingBeginner
asked in Troubleshooting

There was an error writing to your Google Sheets: Unable to parse range: 'Breakdown"!2023-05-09:2023-05-09

Hi,  I’ve been trying to get a Zap to work in which I:  Register an invoice has been created in Square Lookup the the spreadsheet row in Google Sheets (in this case, the date due) Fill out necessary data.I have tested the zap and cannot get past the last stage as I keep getting the error:  Failed to create a spreadsheet row in Google SheetsThere was an error writing to your Google sheet. Unable to parse range: 'Breakdown'!2023-05-09:2023-05-09 I’ve tried numerous solutions but nothing seems to be working. Any help would be appreciated!  

10
Z
7 months ago
F
flori123Beginner
asked in How Do I

Duplicate Zap

This article suggests to click on the three dots to duplicate a zap https://help.zapier.com/hc/en-us/articles/15408145778829-Duplicate-your-Zap But I can not see them when looking at the Zaps overview in my folder https://zapier.com/app/zaps/folder/  

3
ken.a
7 months ago
G
genieNew
asked in How Do I

Is Spreadsheet trigger and Sending Gmail one task for one mail?

I need some help to choose which Zapier plan to do. What I’m trying to make is mail merging zap.Auto response mail would be sent when there is a new row in specific spreadsheet. and after several tests, I wonder how to count zap tasks about my process.Is Spreadsheet trigger and Sending Gmail one task for one mail?If it’s right, with the Zapier plan the number of emails that can be sent is too limited for me,,Plz leave some advise..!

1
Troy Tessalone
7 months ago
F
flori123Beginner
asked in How Do I

How do I prevent multiple Google Calendar entries when updating Notion "follow-up" date field?

I have a simple notion customer database in with a “follow up” date field. It triggers a google calendar entry.The problem is that the google event is created everytime I update the customer (for example if I change a contact). So I end up with multiple calendar entries for the same day.How can I only have it triggered when I change the “follow-up” date field in Notion?I imagine it has something todo with the zapier-filter item, but I tried alot and cannot figure out the correct setup.Any help is appraciated

9
ken.a
7 months ago
RobertN2186
RobertN2186Beginner
asked in How Do I

How do I automate the creation of recurring events after form submission?

Hi all, I want to create some recurring events from a calendar submission. ObjectiveWhen someone submits a form on my site, I want to take the day/time that the form was submitted and create recurring events from the Monday following the form submission.  Current StatusI used some date formatters and a lookup table to take the form submission date and create an event on the Monday following the form submission. I have been able to create a subsequent event using additional date formatters based on the original event. Where I need helpCurrently I am trying to automate the process of creating more subsequent events. I would like to just be able to create some kind of loop and specify the number of times to repeat in order to create 1 years worth of recurring events. For context, the recurrence will be weekly, biweekly, and monthly; I’m hoping that I can use the same solution for all and provide a different date formatter and number of loops for each case.  ToolsWebflow: Form submissionsA

3
Troy Tessalone
7 months ago
tlchris
tlchrisNew
asked in Troubleshooting

Facebook Pages - page not selectable despite working connection

Dear Zapier community, I have a professional FB account linked to my Zapier account. This FB account owns two FB pages. Since yesterday, posting on the page in question has stopped working. As a result, I deleted the Zap and tried to recreate it. However, whenever I try to select the proper FB page while creating a new Zap, only the other page (the one I don’t want to select) shows up as available for selection. The other one is not selectable at all. Has anybody else experienced this issue? It is causing severe disruptions to my flow of content. Many thanks in advance

4
A
7 months ago
B
BillyMBeginner
asked in Troubleshooting

Recording new Stripe Invoice in google sheets

Hi there, I am new to Zapier and am working on creating a google sheet database for all of the Stripe Invoices I’ve sent out. I have a Zap in place that creates a new row in a spreadsheet ever time a new invoice is created in Stripe.  The trouble I am having is that my zap is pulling in a draft of the invoice to google sheets before I’ve inputted the amount we are charging and sent it to our customer. The record then shows an amount of zero instead of what is actually be charged to the customer. I believe this may have something to do with the Trigger being instantaneous but am unsure. Any help would be appreciate! 

6
B
7 months ago
C
ct1219New
asked in How Do I

Zapping new contact to Telegram from Keap Max Classic

May we know if there's a way to Zap new contact from Keap Max Classic to Telegram without sending a message to the new contact in Telegram?Basically, adding a new contact to Telegram directly from Keap Max Classic for us to not manually add anymore. 

7
Troy Tessalone
7 months ago
C
cassiemacfarlaneNew
asked in Troubleshooting

Zap integration between Shopify & Flodesk doesn't work

Hey there!   I’ve been trying to connect my client’s Shopify account to Flodesk using Zapier, but I’m not able to pull test triggers from shopify.  It says that there are ‘no new orders to pull so I can’t run any tests, therefore it says the event is deprecated.   I’m trying toget the zap to work as follows: once somebody orders a specific order (not just any order), I want to create/update a subscriber into a Flodesk workflow so I can send them targeted emails based off their Shopify order.  How do I get the new orders pulled to run the tests so the Zap will work?  Thank you so much in advance!

10
Troy Tessalone
7 months ago
O
OARS-accountNew
asked in Troubleshooting

task limit exceeded but can't upgrade

I am on a pro plan and received a message that we exceeded our 5000 tasks. I believe our monthly plan resets later today. In the meantime, my very urgent zaps are being held. I tried upgrading in order to get more tasks, but it says that I need to schedule a call to discuss company pricing options.I’ve filed a ticket about this issue, but they informed me I probably won’t hear back for 24 hours. What are my options here? My organization depends on these zaps. We run a crisis line, so this can’t wait. thanks. 

2
Troy Tessalone
7 months ago
S
Sergio DuqueBeginner
asked in How Do I

Delaying Email Send from a Google Sheet

Hi!I find myself having to send emails from my google account to some customers with kind of the same messaging, so i use google sheets for this.But, the issue i have is that i would like the Zap action to not attempt to send all emails (each contact is a new row) at the same time whenever i paste the database on the sheet.So, for example:- I usually copy/paste around 50/100 emails at a time, and paste them on the sheet that is being triggered when new rows appear.- I want it to take all of those contacts (rows) and send one by one, with a delay on it, lets say, 5 minutes or something like that.- I know how to set a delay between actions, but if i paste 50 contacts two times, it will attempt to send 50 contacts at the same time each time the delay time is reached.So i want for the zap to somehow drip the emails with some delay between it but dont know how.Im using Google sheet New Row Added → Send email from google accountHope this makes sense! 😁

3
Troy Tessalone
7 months ago
M
mauromarzoccaNew
asked in How Do I

How can I send a message to all users in a Telegram Bot?

Hi, i want to sent a message in a Telegram Bot to all users, but I can sent this message only to one user.

1
Troy Tessalone
7 months ago
A
Andres from IABeginner
asked in Code & Webhooks

Failed to create a request in Webhooks by Zapier: {+1XXXXXXXXXX} is not a valid phone number.

Hello!I am currently trying to link a client’s RingCentral to Gorgias using Webhooks by Zapier. After troubleshooting some early issues, this one has me stumped:Failed to create a request in Webhooks by Zapier{+1XXXXXXXXXX} is not a valid phone number. (HTTP Status Code: 400)At first I was trying to create a Zap for pulling in “Call Ended” tickets and ran into the issue with the sample numbers Zapier autofilled, so I switched to pulling in “New Voicemail”. I called and left a voicemail, updated data pulled in and now I still get the above error. Any insight would be greatly appreciated! Thank you!For reference, here is the Gorgias article on how to create the Zaps.  

8
A
7 months ago
igriboff
igriboffBeginner
asked in How Do I

How do I use automation to add new subitems in Google Docs based on unique IDs?

I would like to create an automation that pulls info from a google doc and adds a new subitem if it’s ID does not match an existing subitem.  For example below, I want to run a check against these IDs and if the new item’s ID doesn’t match them it creates a new subitem.  I’ve been trying to play around with Looper but can’t seem to figure out how to implement this since each sub-item comes in as a line item with a different name.  Please let me know if you have any suggestions, Thanks!

5
Troy Tessalone
7 months ago
Maxim
MaximBeginner
asked in Troubleshooting

Formatter by Zapier Issue: Split Text Not Mapping as Separate Fields

Hello Zapier Community,I hope someone can help me out with an issue I've been facing. I've been using the Formatter by Zapier to split text, and while it does split the text correctly, I'm having trouble using the split text as separate fields in my flow.Here's a brief overview of what I'm trying to achieve:I take an input string and split it using the Formatter. I want to use each of the split parts as separate fields in the subsequent steps of my flow.However, when I try to map these split parts in my next steps, they don't appear as individual fields. I'm not sure if I'm missing a step or if there's a configuration setting that I've overlooked.Has anyone else faced this issue or have any suggestions on how to resolve it? Any help would be greatly appreciated!Thanks in advance! 

3
Troy Tessalone
7 months ago
tkairova
tkairovaNew
asked in How Do I

Delay popup notifications from Teams during non-business hours

Hiya! I want to know how to create a zap that blocks notifications with “new chat message” as a trigger and delay them until business hours?I don’t want to be spoiled with incoming messages when I just want to relax at home and think of something else than work ;) 

1
Troy Tessalone
7 months ago
tkairova
tkairovaNew
asked in Troubleshooting

Unable to find a Microsoft Excel spreadsheet in Sharepoint using Zapier.

Hi, I encounter a problem when wanting to use an Excel spreadsheet in a zap. They can’t find this one from my Sharepoint. When I add the link to it, it says invalid data and not possible to add customize value.What can I do to overcome this prob? Many thanks 

1
Troy Tessalone
7 months ago
R
Richard HulbertNew
asked in How Do I

How do I generate a random, unique 8-character ID for Google Sheets using Zapier?

Hi Everyone, I am brand new to this Zapping stuff so please bare with me.BackgroundI have a CRM application that I want to integrate with an AppSheet application. So I am building a Zap which triggers when a new account is added to my CRM app, which in turn adds a new row to a Google Sheet linked to my AppSheet application. A quick refresh of this application loads this new entry.ChallengeThis all works fine, however I need my Zap to send a random, unique ID number along with that row of data. This number has to be 8 characters long and ideally consist of numbers and letters.For the purposes of testing I am cheating at the moment by sending this sheet formula as a “text” string to the ID cell on the Google Sheet However, as some may know, sheet formulas of this type constantly refreshes every time the Google Sheet is updated rendering the ID number useless for referencing because it keeps changing.So, getting to the nitty grittyI think I should be putting a formula in the Formatter som

2
R
7 months ago
A
automate_with_rezwan
asked in Troubleshooting

Unable to load Sharepoint folder when adding a new row in Microsoft Excel.

I am trying to use the Add row in MS Excel action. I have selected Sharepoint as the source but when I try to select the folder, I am getting this shown only  

6
ken.a
7 months ago
Francoco_loco23
Francoco_loco23Beginner
asked in How Do I

How do I connect an Applicant Tracking System (ATS) like Workday or Darwinbox to Airtable?

Hi team, I would like to ask for your assistance on this matter. I have a client who would want to connect their Applicant Tracking System to Airtable, so basically the data that would be from the system (personal, employment, residence, references, etc.) will be seen in Airtable. I would like to know if this is possible in Zapier? ATS such as Workday and Darwinbox.  Thanks

2
ken.a
7 months ago
E
Elliott LCSBeginner
asked in Troubleshooting

Unable to detect cell modification when adding a column to trigger New or Updated Google Sheets row.

Hello,I would like to know if the "New or Updated Google Sheet Row" Google Sheet Trigger can be applied to previous rows/data.Meaning that once the Zap is published, I'd like the modification of a pre-existing row to be recognized and trigger an action (sending an email).Up to now, only very recent rows have been recognized, but not older ones.I've tried adding a column to trigger an cell's update but the modification is not detected.Thanks in advance!

7
E
7 months ago
R
RachRuNew
asked in How Do I

How can I add a custom event in BrightHR as a trigger?

Zapier currently connects with BrightHR and with Dext which is great, however, it doesn’t include the event in BrightHR that I need for my trigger. Is it possible to add an event?

4
R
7 months ago
Tictactrip
TictactripBeginner
asked in Troubleshooting

I can't create a post on WordPress - no post field

Hello ! I'm not able to create a post on Wordpress using zapier because no post proposal was made when I chose the post type. My list is empty.As I have a custom theme on Wordpress, I thought it might be related to a renaming of the different post types... Are there any other possible reasons? 

5
ken.a
7 months ago
ZapEm
ZapEmBeginner
asked in How Do I

Change the Line Item Separator from comma to another character

Hi all, this is a similar post toI have a Shopify Integration with our CRM that posts the completed Purchases.example data coming from Shopify:Customer id: 0001 Receipt No: RCP001 Total Price: 100 Line Items Name: Item1 Name, Item2 NameCustomer id: 0002 Receipt No: RCP002 Total Price: 100 Line Items Name: Item1 Name, 250grams, Item2, 50gramsWith the data above, I will post the purchase with the Line Item Names. Since Zapier automatically creates the comma separation, I will just use the .split(',') function to convert them into an array. But on this case, I will have a problem with Customer 0002 since the split function will recognize 4 records instead of 2. We do not have control over how our clients name their products so this is something we can’t avoid.Is it possible to change the line items’ separator from comma to another reserved character?example:Line Items Name: Item1 Name, 250grams | Item2, 50gramsso that I’ll use .split('|') instead.  

1
Troy Tessalone
7 months ago
Terms & Conditions