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.

25593 Topics

C
Carly IBeginner
asked in Troubleshooting

The given data was invalid - when trying to add a subscriber in Mailerlite group from Practice better booking

I’m having all sorts of issues with this one zap.I’ve a successful zap from ‘new clients’ in Practice better zapped to a new subscriber group in Mailerlite.I’m trying to set up a new zap from Practice Better when someone confirms a ‘Masterclass booking’ and then then get zapped into a new subscriber group in Mailerlite, but the zap will not work. Even thought it’s just First Name, Last Name and Email… same as the zap that works above. It’s driving me bonkers this error - The given data was invalidI’ve tested the PB to Mailerlite is connecting - done workingBut it just will not read the data. correct email to email spot correct First name and last Name to spot ERROR 

8
C
6 days ago
MikeM M
MikeM MBeginner
asked in Troubleshooting

Unable to select OneDrive Excel file as Zap trigger: No options available for Spreadsheet

There is a shared folder in my Google Drive that was shared with me by a coworker.Inside that folder is an excel spreadsheet.When I go to create a Zap Trigger,  I select OneDrive as the Storage Source. Zapier populates the shared folder (called COMM5) as a selectable option for the Folder.But when I go to choose a value for the Spreadsheet it says “No options available”.I have tried entering the ID as a custom value. I have tried entering the path as a custom value. I have tried entering the file link as a custom value. I have tried entering the file name. Each returns it’s own error when I proceed to test (such as Object Handle is invalid). How do I find the excel file so that I can add it as the Spreadsheet and ultimately add the Worksheet for triggering?

7
Q
6 days ago
T
TSJBenNew
asked in Code & Webhooks

I need help setting up the Webhook Post API function for a website called Jboard

Here is their documentation: https://app.jboard.io/api/documentation I think I’m having an issue with the Header Authentication because all it does is return HTML from the log in page.  Any ideas? Ben

12
T
6 days ago
J
Joe The Show
asked in How Do I

How do I automate refund process for bad leads using Zapier integration?

I am trying to set up a zap to push a bad paid lead back to the lead provider for reimbursement so I dont have to manually email them every time we get a bad lead. I really need to speak to a live person because theres no way I can explain this.

1
Troy Tessalone
6 days ago
M
MyleneNew
asked in Troubleshooting

zap is not working even if the test was ok

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.Hi, i want to link my trello to my omnisend.I just need the name and the email adress from my trello card to add in my omnisend and i want it to have a certain tag (that will trigger automation )   the test is okbut when i try it directry from my trello, it doesn’t work,does someone can help me? or know what to do ? Thanks!

1
Troy Tessalone
6 days ago
J
JmartNew
asked in Code & Webhooks

Why does zapier keep concatenating array elements into one string? How do I prevent this?

I spent countless hours creating a JS function that organizes my data into array elements — clean slices of data that can be selected and inserted into my subsequent Zap steps.Now that I’m happy with the my data format, I go to select this data and it’s once again concatenated into one giant, useless string!WHY does Zapier keep doing this? What is the usecase of automatically joining array elements and concatenating them into a string at every whim?? And how I do I stop this from happening?

1
Troy Tessalone
6 days ago
N
newbieBantiBeginner
asked in Troubleshooting

Lookup Spreadsheet Row not working while matching with Jira ticket value which are exactly same

I am trying to create a zapier automation that will lookup a spreadsheet row by trying to match a column value with an input value from a jira ticket. Ex: Spreadsheet column “Rand” has value 5468       I have a jira ticket field “rand_field” with value 5468when I am using these two to match, I am getting below error Failed to find a spreadsheet row in Google SheetsError from halted execution: Nothing could be found for the search. But if I change the match value from jira ticket field to a hard coded 5468. its working. can someone help with this!

11
Troy Tessalone
6 days ago
S
splashleyNew
asked in Troubleshooting

Unable to find attachments in Asana task trigger, and no field is available to assign.

Hello, I am trying to create a zap with the trigger of a tag added in Asana to both add a line to a spreadsheet and send an email in Outlook.But Zapier is not finding attachments in the asana task, so there is no available field to assign. I created the zap, published, and ran it on a test record to check the “Data Out” fields and I don’t see an attachment field there either.

5
Troy Tessalone
6 days ago
B
Bart Velox
asked in Troubleshooting

Failed to create your Zap report: Invalid type for variable '0'. Required value type is int and passed type was str at ['data']['zap_ids'][0]

 

6
A
6 days ago
O
oneillgBeginner
asked in How Do I

How do I auto-sort my Google Sheet by a column after Zap creates a new row without relying on external tools?

Hello all,Pretty new to Zapier but I’m finding it an extremely productive tool.The last thing I need to figure out is how to automatically sort the Google sheet based on one column’s entry after the Zap has completed creating the row.Not sure if this is a Zapier question or a Google Sheets question. I have scoured YouTube and Google and all I hear is “use something else besides Google Sheets”. I have an onChange function in Google Sheets to do it but it won’t launch if Zapier creates a new row,Any help would be greatly appreciated.-Gabe

3
O
6 days ago
E
e_messageNew
asked in How Do I

How do I update 100+ contacts missing a custom field in CRM after a Zap transfer?

I set up a zap to update contacts between two platforms. We are seeing a discrepancy between the originating platform and the CRM. The total is about 100 entries. My theory is that same entries were not transferred due to a custom field not being set up. If contacts were not imported prior to the custom field being setup, how would I update those missing entries?Thank you for your help in advance. 

1
Troy Tessalone
6 days ago
J
Jon HallBeginner
asked in Troubleshooting

Microsoft Excel error: The app returned "You do not have permission to open this file in the browser.".

Hi, All steps that involve Excel are currently erroring in all my Zaps. It's giving the error: The app returned "You do not have permissions to open this file in the browser.". I've 'Tested' and 'Reconnected' Excel in Apps. I've tried creating a new Zap with an Excel step (using both the existing and a newly added Excel connection) and it doesn't produce anything at the 'Worksheet' stage (having successfully selected a 'Spreadsheet'). It seems to be the same error detailed at https://community.zapier.com/troubleshooting-99/connecting-to-excel-is-giving-you-do-not-have-permissions-to-open-this-file-in-the-browser-32095 I've been in contact with Zapier help and they have only been able to suggest that I check the Share setting in Excel but all that seems to do is add an email got shared access or generate a share link a I don't see how that would help. Any help with what to do to get this working would be appreciated :) Jon

29
A
6 days ago
M
Misha_KNew
asked in How Do I

How do I automatically send daily newsletters to participants confirmed for upcoming Glide sessions?

Hello. This is my first time using zapier + glide. I need a scenario that will do the following:In one of the glide tables I have a table called «sessions» and there is a column with date & time. I need zapier to take data from there once a day and check whether today’s date is there. If there is, then it should take the row id of this «session», go to another table called «participants» and look for the IDs of all participants who were recorded in this session and filter them by the status «confirmed». Then I need to then I need to send a newsletter to all filtered participantsMy steps:Step 1: Every Day in Schedule by ZapierStep 2: Get all rows from glideStep 3: Looping by Zapier – Here I choose «date&time» and «row id» as values to loopStep 4: Date / Time in Formatter by Zapier – settings: http://joxi.ru/Vm6EZNVHKwZMqr 1Step 5: Only continue if… – settings&output: http://joxi.ru/BA0J5xVcqLWEym 1Here zapier didn’t find today’s session and also I realized that next step I m

0
M
6 days ago
I
itsmkNew
asked in How Do I

How do I automate payment emails to accountant after 5 jobs with 5-day reminders in Zapier?

Hi,We have 2 sheets in an xlsSheet 1 : we add  a row when each module of work is completed. After 5 modules person will get payed.Sheet 2 : we create a row after each payment with date and amount. After 5 modules of work email is sent to the accountant for payment. After 5 days we need to send reminder if payment is still not done. how do we do this zap. Pls help ThanksIMK

0
I
6 days ago
O
oneillgBeginner
asked in How Do I

How do I remove +1 from phone numbers in Google Sheets using Triggers and Formatters?

I am trying to use Formatter to eliminate the +1 from phone numbers before they get sent to a Google sheet. The first thing it asks me is the Event. The Event list is empty and it won’t let me do anything else.Would love some insight on this. Thanks. -Gabe

9
Troy Tessalone
6 days ago
H
HikageBeginner
asked in How Do I

How do I connect both a Stripe Live account and Test Account?

I have already connected my live Stripe account.But when I go to connect my test account, I can’t find an option to add my test keys.  I even accidentally created a NEW Stripe account entirely in my attempt.When I get to the “Select the account you'd like to connect to Zapier” step, I’m given only one account option.Connecting it anyway, I have verified this is my LIVE account.I have even tried connecting while logged into Stripe with “test mode” toggled.How do I get to a step that lets me add my test keys?

90
K
6 days ago
C
campaigncreatorsBeginner
asked in Troubleshooting

HubSpot to Quickbooks Invoice Creation with Line Items

We are just trying to create a QBO invoice with line items from a HubSpot Deal and its associated line items. I’m super close to having it figured out but just not quite there yet. The way we have it set up currently, it creates a separate QBO invoice for each line item on the HS Deal, and we need it to create one invoice. I know I’m missing some kind of a Formatter step but I can’t figure out which one. Here’s the full flow of what I have right now:My Loop step pulls the list of associated Line Item IDs from the “Find Associations” step: And then it actually separates the line items into their own LineItemID on the output, but then I can only use one LineItemID in the “Find Line Items” step, and I can’t add another Loop to have it go through again, but there’s no other formatter step that I can find that actually separates them out of a comma delimited list and into their own items? Here’s my Find Line Item step:And then I’m using the Line Item Name to search for the corresponding QBO

7
Troy Tessalone
6 days ago
Z
zapyoulater222New
asked in How Do I

"Seeking Assistance: Integrating CallTools with HubSpot via Zapier for Complete Sync of Contacts and Interactions"

Title: Need Help Integrating CallTools with HubSpot via ZapierHello Zapier Community,I am trying to set up a comprehensive integration between CallTools and HubSpot using Zapier. I need to ensure that every upload to HubSpot is also reflected in CallTools, and vice versa. Additionally, I want all interactions like calls, emails, and any updates to be synchronized between the two systems.I'm not very familiar with setting up such integrations and would appreciate any guidance or advice. Here's what I need to achieve:Bidirectional Sync: Any contact added or updated in HubSpot should be mirrored in CallTools, and any interaction logged in CallTools should be recorded in HubSpot. Logging Interactions: All calls made through CallTools should be logged as activities in HubSpot contacts. Automatic Updates: Any changes in contact details on one platform should automatically update on the other.If anyone has set up something similar or can provide insights into the best practices for this kind

1
Troy Tessalone
7 days ago
M
MatthewSBeginner
asked in How Do I

How do I convert YouTube titles (text & numbers only) to Webflow slugs using Zapier?

I am trying to figure out the best way to approach this issue. I need a “slug” or a formatted text that works in URLs in Webflow. For example “this-is-a-slug”:https://website . com/this-is-a-slugI have text such as “The New Age of AI is here!” which is a title from Youtube and I need to remove everything except text and numbers and change spaces into a slug “the-new-age-of-ai-is-here” to add a new page to my Webflow. Is this possible with Zapier? 

5
Troy Tessalone
7 days ago
K
koneillBeginner
asked in Troubleshooting

Frame.io asset, wrong file type

I am trying to move Zoom interview recordings (around 320MB) from Zoom to Frame.io.All the connections tested work, however the file uploaded is the wrong format and size. I can’t tell where my issue is. My video is not password protected - if you get the link, you can download without any permissions needed. The video file is just one file (not multiple video files from the same meeting because someone stopped the recording). Where am I going wrong? it’s a pretty straight-forward zap.   

9
Troy Tessalone
7 days ago
B
BartcepNew
asked in How Do I

How do I extract inline images from Microsoft Outlook emails in Zapier?

In Zapier I tested two workflows:Trigger on new email in Outlook > upload attached image to Google Drive Trigger on new attachment in Outlook > upload attached image to Google DriveBoth work, as long as the image is attached to the email instead of inline. When it’s inline, Zapier doesn’t recognize it as an attachment. I tried everything, even running javascript, but I can’t find a way to extract the inline image from an email. Can you help me? 

4
B
7 days ago
S
shoshoshoNew
asked in How Do I

How can I find a Google Drive file using its URL in Zapier?

Can anyone teach meif there is a way to “find a file” in Google Drive by using the [file URL].* by [file URL] I mean the unique URL given in a google drive → https://drive.google.com/drive/folders/XXXXXXXXXXXXX Currently I can only “find a file” by using the [title] of the file.  The reason I want find a file” in Google Drive by using the [file URL]is because is want to trigger the Zap by a new row in an spreadsheet,which includes a file URL information which I want to copy to a new folder in google drive.

2
SamB
Community Manager
7 days ago
E
ereurtsNew
asked in How Do I

What is the difference between the "Changes Status" vs. "Changes Stage" in Salestrekker?

If I set up a zap with "deal changes status in salestrekker", what does the "changes status" mean? How is that different from "deal changes stage in salestrekker"?

3
Troy Tessalone
7 days ago
L
LevNew
asked in How Do I

How do I set a default action for Zapier when creating Google Tasks from Slack messages?

I have created a simple zap that creates a Google task out of a Slack message. To do that I have to click the 3 dots context menu of the message and select “Push to Zapier”. But then it asks me what is the exact action I would like to run. As this is the only use case for me, I want my default action to run immediately after I click “Push to Zapier”, rather than selecting the only available option from the dropdown menu and clicking on “Push” 

1
Troy Tessalone
7 days ago
W
WildcraftedLeslieNew
asked in How Do I

Filtering data with Multi-App Zap help!

Let me lay the ground work for what we are wanting to do.  We are an all-natural beauty company and we are wanting to utilize Zapier to pull a list to Google Sheets of our customers birthdays, addresses, and phone numbers so that we can send out hand written cards as well as give them a phone call on their birthday. There are plenty of apps that pull some of the info to automatically send emails and such, but for us to see the list with birthdates, addresses, and all the needed info I’m running into some difficulty.  We are a Shopify store, so we have integrated the Happy Birthday app to collect birthdays as they check out.  And we have also got the Helium Custom Fields that collects the birthday data, but also the up to date addresses and phone numbers available via Shopify.  I have several zaps set up to create almost a ‘master list’ of these customers in Google Sheets. (not sure if this is necessary)  I have then running in a few different ways while were in the testing period to se

1
SamB
Community Manager
7 days ago
Terms & Conditions