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.

25637 Topics

L
LaviniaMNew
asked in Troubleshooting

Trouble automating two emails using Google Sheets and Gmail and second email not sent as expected.

Hi, I’ve been trying to figure out how to automate a series of two emails, using Google Sheets and Gmail automations in Zapier. The logic should be fairly easy, based on a sent/not sent filtering.Here is a quick explanation about how it should work:there is a Google sheet with 3 columns: Email address, Mail 1, Mail 2 An email address is added to column Email, and the text “Not sent” is inserted under both  Mail 1 and Mail 2 The email address should receive Mail 1 after 1 hour of being added to Google sheets The automation should change the status under Mail 1 from “Not sent” to “Sent” The email address should receive Mail 2 after 2 hours, from the moment when it received Mail 1The Zapier sequence I created for this is as follows:New spreadsheet row in Google Sheets Filter: Only continue if Mail 1 column exactly matches Not Sent Delay for 1 hour Send email in Gmail Update Spreadsheet row in Google Sheet Mail 1 is updated to Sent Delay for 2 hours Only continue if Mail 1 column exactly m

1
SamB
Community Manager
10 months ago
Carl Christensen
Carl ChristensenBeginner
asked in Code & Webhooks

Failed to create an HTTP request in Microsoft Team: Invalid URL

I want to send replies to a Teams Channel message.  I have surmised that I need to send an API request.My zap is all set up and working to post a Teams Channel message.I found this article:  https://learn.microsoft.com/en-us/graph/api/chatmessage-post-replies?view=graph-rest-1.0&tabs=javascriptHTTP request is formatted POST /teams/{team-id}/channels/{channel-id}/messages/{message-id}/repliesI tested this HTML code in Microsoft Graph to see if it would send a reply.(This is dummy code from the article--not my teams/channel/message ID.)POST https://graph.microsoft.com/v1.0/teams/fbe2bf47-16c8-47cf-b4a5-4b9b187c508b/channels/19:4a95f7d8db4c4e7fae857bcebe0623e6@thread.tacv2/messages/1616990032035/repliesContent-type: application/json{  "body": {    "contentType": "html",    "content": "Hello World"  }}After fiddling with permissions for Microsoft Graph, I got it to work .  The text “Hello World” posted as a Teams Channel reply to the original message.I now want to add this to my Zap as

9
Carl Christensen
10 months ago
d231d
d231dNew
asked in How Do I

Tag all assignees of a ClickUp task in a Slack channel

Hi everyone,I'm currently trying to set up an automation that tags all assignees of a ClickUp task in a Slack channel. I use Formatter to assign each ClickUp assignee the correct Slack ID (solution found here). Now the issue is that if there is more than one assignee, the output looks like this in Slack:<@U02JEFCJZ4P,@U02G5169TNX> please review the following...With the colon in between the tags, Slack does not implement it as a tag. I would need a space between the outputs, but adding a space to the output in the Formatter table breaks the tag altogether.Any idea on how to solve this?Thanks a lot for helping out here.

1
SamB
Community Manager
10 months ago
rpblock
rpblockBeginner
asked in Code & Webhooks

Response content is too large to be processed.

Hi Zapier Community,I'm currently facing an issue with my custom webhook that converts webpages to PDF and uploads them to Google Drive. Whenever I try to process a file larger than 5MB, I receive an error message from Zapier stating, "Response content is too large to be processed." I'm wondering if this is the hard limit for this type of process.It's surprising to encounter such a low file size limit, especially since I recently upgraded to the professional plan in the hopes of resolving this issue. However, it seems that the error persists even with the upgraded plan.Has anyone else experienced a similar problem with file size limitations when using custom webhooks in Zapier? I would greatly appreciate any insights, suggestions, or workarounds to overcome this limitation. Are there any ways to increase the file size limit, either through configuration or other means?Thank you all in advance for your help and support!

2
ArloBentley
10 months ago
Eyebrow Ink Styling
Eyebrow Ink StylingBeginner
asked in Troubleshooting

Contacts being overwritten in Klaviyo

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.I've set up a Zapier trigger to add a contact from GetTimely when they are added (that filters out contacts that don't enter their email) Klaviyo. But the contact is being overwritten when someone else is entered. I watched my contact information be replaced by someone else information in front of my eyes.This is the zap i’ve set upThis is what the Klaviyo representative sent that they receive on there end.Any ideas our example of what the Zap should like?

3
SamB
Community Manager
10 months ago
caseyaroyer
caseyaroyerBeginner
asked in Troubleshooting

Microsoft Outlook error: Unable to retrieve the list of emails, the request user "inbox" is invalid

I’m trying to set up a new Zap that will be triggered by a new email being received in my inbox in Outlook. When I test the trigger, it returns the message “No email found.”Things I’ve tried:Leaving the “shared inbox” field under Trigger blank → “no email found.” Entering my email address in the “shared inbox” field → “no email found.” Entering the word “Inbox” in the “shared inbox” field → “unable to pull emails...error code: error while retrieving: unable to retrieve the list of emails: the requested user “inbox” is invalid.Please help. I feel like setting up a Zap with a new email as a trigger should be so simple. What am I doing wrong?Thank you. 

7
Troy Tessalone
10 months ago
D
dboBeginner
asked in How Do I

Can I automate clicking the link in Gmail to confirm receipt with Zapier?

I receive a lot of mails from a certain sender that I need to confirm I have received by opening link in the message. Can this be automated with Zapier? I just need to click the link and wait a few seconds so the click gets registered. I do have a Google for Business (or whatever it is called today) account available (the account I receive the mails on is a regular free Gmail account), if that makes any difference. Thank you

3
Troy Tessalone
10 months ago
Z
zendesk_userBeginner
asked in How Do I

How do I search only one row of Google Sheets and send Slack message

 Right now I have the following set up. So I want a slack message to send whenever one column of sheets is updated. I added the filter since my zap was in an infinite loop and I saw this message: So the filter only moves forward if the column is true the column looks like this: Problem I originally had sections in my sheets and I saw that Zapier stops when it sees a blank row so I changed that and added check boxes to my section titles which is why the top check box is highlighted blue. Once I added that the zapier trigger did work and sent a slack message based on the section title column being set to true! So I tried checking other boxes in the column but it did not work or send a slack message so now I am stuck. How do I make it so that whenever any column in that sheet is checked off and set to ‘True’ a slack message is sent?

4
Troy Tessalone
10 months ago
B2B Humans
B2B HumansBeginner
asked in Troubleshooting

Trouble Pushing a LinkedIn Lead to a GoTo Webinar Registration

I want to run a lead ad campaign on LinkedIn (In app) that pushes the registration to GoTo Webinar. I was easily able to set up a LinkedIn Event Registration integration with GoTo Webinar. A lead form is different from an event RSVP in several ways, but the most significant is that with a lead form there is no disclaimer to confirm, where the user has to agree to receive emails. For an event RSVP it’s required, making it easy to map the field. On the GoTo Webinar side this is a required field. I’ve tried using X, Y, and 1 characters in the field directly in Zapier, I tried adding a hidden field to the LinkedIn lead form and using X, Y, and 1 as values to substitute for the checkmark, all with no success. It keeps erroring out. It doesn’t specify which field is the problem, but I think my hunch that it is the disclaimer field is correct when I compare it to my other zap that works just fine. What can I put in the disclaimer field that will translate to GoTo Webinar? 400 Error: Registrat

5
Troy Tessalone
10 months ago
moorefieldha
moorefieldhaNew
asked in Troubleshooting

TicketSpice connection not pulling recent tickets

I am attempting to connect TicketSpice to ConvertKit to move over emails whenever someone purchases a ticket.I have put 2 test tickets into TicketSpice and it is showing as connected in Zapier. However, when I try to pull the most recent ticket information it is only showing a test ticket with random information that I did not enter.When I move on to the ConvertKit connection, there is no way to run a test because the information from this ticket doesn’t exist.Does anyone have any insight on why this is happening?Thanks!

1
Troy Tessalone
10 months ago
Totoro
TotoroBeginner
asked in Troubleshooting

Zaps turns off by itself when integrating into Slack and Podio.

Hi My zap is connected with Podio then trigger slack.  It stopped since last week, I tried to reconnect both Podio and slack but the zap still turn off itself.  Please help.ThanksToto

5
shalgrim
10 months ago
JVP
JVPNew
asked in How Do I

How do I filter Google Tasks trigger to create a task only for the last email in a thread?

Hello!I have set up a trigger with :When ‘Email Label Applied’ -→ THEN ‘Create Task’ in Google Task.However, the issue I have is that there is now an entry (or task) for every email in the thread, whereas I’d like to keep just the last email. How can I fine tune this?Thanks! 

1
Troy Tessalone
10 months ago
Brian Moran
Brian MoranBeginner
asked in Code & Webhooks

Convert XML to Json or other format to parse into Google sheet

How can I convert this xml feed below into json or another format to easily parse to a google sheet? https://backend.fr.kampajobs.ch/sites/default/files/exports/job_export.xml

4
Brian Moran
10 months ago
K
Koull86Beginner
asked in How Do I

Can I copy comments from one Podio app item to another?

Hi, Does anyone know if we can copy the comments from an item in one Podio app to an item in another Podio app? Thanks.

4
SamB
Community Manager
10 months ago
Robynne
RobynneBeginner
asked in How Do I

Creating a Zap from a Jira Service Desk to Live Excel Spreadsheet

I am trying to create a Zap that automatically extracts details from a Live Excel Spreadsheet and then will create and populate a Jira Service desk issue. 

3
Troy Tessalone
10 months ago
celine slang
celine slangBeginner
asked in Troubleshooting

OpenPhone error: The app returned "Unable to send a message from a phone number without access."

Hey all, I’m wondering if anyone else has run into this issue recently with OpenPhone where on the last test action stage, you get an error that says: Failed to create a message in OpenPhone; The app returned "Unable to send a message from a phone number without access.”I’ve set up previous Zaps using the exact same logic with no problem, and those Zaps still work. Recently when I went in to add some new Zaps tied to new users, I kept on running into this error in the test action stage with OpenPhone. Note all previous steps are good to go; it’s just this last step with OpenPhone. I’ve also double checked settings on OpenPhone, and those look good too.Zapier has already lmk that this is a newer bug I’ve encountered, but while they figure out a fix, I’m wondering if anyone has any ways of getting around this, thanks!

2
SamB
Community Manager
10 months ago
DamianD
DamianDNew
asked in How Do I

How to make payment confirmation from Stripe to Livespace CRM?

Hi there,I use Livespace CRM and Stripe for payments. I’ve created a Zap that makes products, prices and payment links in Stripe which are made from data pulled from deals made in Livespace CRM. Then it’s published as a note in that deal in CRM. Everything works fine.Nut now I would like to make a Zap triggered when a customer makes a payment from that specific payment link where tha actin part makes a note in that specifik deal in Livespace. But I have no idea how to connect that. Does anyone have an idea?

1
SamB
Community Manager
10 months ago
pjdoubleyou
pjdoubleyouBeginner
asked in How Do I

How to create a daily log of open customer service tickets from Google Drive to Google Sheets?

Hi all - new to Zapier, feel like I’ve almost got this and yet, I’m still so far away! Here’s the deal…Every night I get a count of open customer service tickets dropped in Google Drive I want to copy the number of open tickets into a new row in a Google Sheet I’m creating a daily log of open tickets. So, everyday I’d open the Google Sheet and see a new row with the prior day’s date and the number of open tickets. Seems simple, but I can’t quite come up with the right combination of triggers and actions. Appreciate the help! 

3
SamB
Community Manager
10 months ago
Illysa
IllysaBeginner
asked in How Do I

How do I change fonts and set up bullet lists in an email

Hello, I am creating Zaps that send Outlook email drafts and I would like to set up the emails to include bullet lists and to use a specific font. I don’t see these options in the editor. Any ideas?Thanks!Illysa

7
ken.a
10 months ago
Falyn
FalynBeginner
asked in How Do I

Tagging Users on Teams Chats Using Zapier

Hi all,Does anyone know if there’s a way to tag Microsoft Teams users directly in chats (not channels) using Zapier? I’ve tried the code below with no luck - it posts with the <at>example</at> as is without tagging the user.Not working in Teams chats: To mention team members, put their display name, email, or userID between “at” tags. For example, you could use <at>Jane Doe</at>, <at>jane.doe@example.com</at>, or <at>jane-doe-user-id</at> to mention a team member "Jane Doe".Any help would be greatly appreciated!

5
ken.a
10 months ago
B
blueguyBeginner
asked in Troubleshooting

My Zap is triggering multiple times on a Google Sheet Row

I have a ZAP that is triggering anywhere from 2-4 times on a single row in Google Sheets; here is the ZAP run….This is the ZAP trigger on the same row about 10 minutes apart.   There are 2 Google Sheets; Google Sheet #1 is the primary sheet and in that sheet is an array formula that will complete a blank column when a “match” is found.  The second Google Sheet is just a Query function of the first Google Sheet, and when a match is found it is exported to the Google Sheet.  I chose to set up my ZAP this way because I wanted it to trigger on a ROW as opposed to triggering on a correct value in a column (ie., triggering on a change in a row).What I guess is happening is that Google Sheet #1 cycles or calculates the array formula as new data comes in and the values in the array column disappear and re-appear (which means the Query function data in Google Sheet #2 disappears too) and thus the ZAP interprets it as a new row once it is calculated again.  I don’t that should be because it is n

7
ken.a
10 months ago
M.J.
M.J.Beginner
asked in Troubleshooting

Issue with sending full event details from Notion to Microsoft Outlook.

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.LS,I want to sent Calendar items form Notion > Outlook. (New event in Notion > new calendar event in Outlook)When i look into the data which are provided by Outlook, i have a great list of items (See the end of this message, Each item is bold), i thought that i could use the most of this information to set up an new template in Notion.But: this did not work out.Here is my problem.When i make an item in my Notion calendar (with a template) see picture Item.NotionToOutlook.jpgthe trigger works but it will not sent all the information to Outlook (as an event - see picture Item.Outlook.Calendar.jpg)item.OutlookCalendar.jpgNote: if i fill in the location, this will not be sent to Outlook CalendarNote: if i give a timezone (MGT+2:00 in my Notion) it will not appear in Outlook.Then i noticed that i can only get a ce

3
ken.a
10 months ago
Xelik
XelikBeginner
asked in Troubleshooting

WooCommerce payment will not process on "Create Order"

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.I currently have a Zap to trigger on specific payments made on our products housed in stripe. These products are products of a third party we partner with. The third party uses Woo Commerce and we are able to create an order within Woo Commerce for them to see and fulfill the order for us. We are being paid when a customer fills out our stripe link but the third party does not get paid for the product when the order is created through woo commerce. The order goes through with the desired price it should cost (hardcoded into the zap) but they are not receiving payment on their books. Is there a step within the create order action within woo commerce to provide payment information for a charge to be made. An alternate solution would be to run another action after the order is placed to charge our account or our busin

1
SamB
Community Manager
10 months ago
ZoeMenendez
ZoeMenendezBeginner
asked in Troubleshooting

Act-On error: The app returned "There was an issue in upsert_record_write.

Hoping someone else here is also using Act-On and has had experience with this same issue. I keep getting the same error on a lot of my zap runs (see image below) but Act-On has not been any help and I’m not even sure what it means. Has anyone seen this same error before and if so, how did you fix it? Thanks in advance!! 

7
ken.a
10 months ago
M
MaccBeginner
asked in Troubleshooting

PDFfiller - Create Filled Documents Task

Hey Zapier community!We recently switched to using PDFfiller to fill out property-specific contracts to send out through signature. I’m having one issue and it seems minor, but I’m hoping someone here can clarify.I’m triggering from a Close CRM custom activity for all my info, but the main issue is when setting up the task to create the filled document, my fillable document is not populating as an option for a “Base Document”. I also tried doing a search step to see if that was the issue but it couldn’t find the document at all.Does PDFfiller just take awhile to speak to new documents? Or is there a setting I’m missing within PDF filler?TIA!! ☀️

7
ken.a
10 months ago
Terms & Conditions