About Zapier Community New to our Community? Get to know more about our space and how to make the most of your time here.
Get Started With Zapier New to Zapier? We have got you covered with our Zapier 101 Resources.
Get Support Have a question? Let's get you an answer!
Other Help Resources Wait, there's more! Check out these Community sourced spaces for additional resources.
Zapier Products Learn more about Zapier's new products.
Zapier Reading All of our best learning resources can be found here.
Learning Groups Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.
Other Learning Resources Some of our favorite additional ways to upskill your Zapier knowledge.
Product Updates Check out what is new and upcoming with Zapier with our regular product updates.
Early Access Program Want to join Early Access? Learn more here.
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
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
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
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
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?
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
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
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?
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.
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?
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.
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"?
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”
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
How can I connect Microsoft Outlook desktop calendar to google calendar?
I am trying to automate our website leads that come in from Webflow to get pushed to a Google Sheet and/or Trello Board. However, we have several different contact forms in Webflow and when I create the Zap, it will only let me choose the dynamic. For instant, “Pop-Up Form” or “Email Form.” However, we have more than 1 pop-up form for different lead sources. I cannot choose which pop-up form I actually want (they are named and have form IDs in Webflow) so all of my leads keep getting dumped to the same spreadsheet and there’s no way to differentiate where these leads are coming from. Any suggestions?
“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 have an action with “Search” type, and input all the information for this action. Then I created a Zap with this action.After the testing step, I can’t click the publish button. The button said “You must fix the issues in other steps before you can publish this Zap” However, I don’t see any errors here. The trigger event is “New Spreadsheet Row in Google Sheets”, and all the steps is validated. Everything is good until the last step. Question: How do I publish this Zap, and what is the issue?
I’m Integrating Aweber with Zapier to add a new subscriber to a list. It works just fine with I directly choose the list from the loaded selection but when I use the custom list, it returns a 404 error. This works This doesn’t Please advise.
Hi, Everyone! I would just like help on arranging all Google Calendar Leaves and Holidays integrated into Notion. Also once someone adds their Leave Date on Google Calendar it will show in Notion Calendar also. I hope someone helps me. Thank you!
Hi,I have a relatively simple Zap structure. First, I recieve some files from a wordpress website, using webhooks. Among the files, there is also a unique variable for every submitted form, serving as an id. In the second step, a folder with that id variable value is created. In the third step, I want to save the files in that recently created folder, using the same id variable.The problem is, if I just try to use that variable as a folder name, google drive can’t find that folder, as it has to be using a code like this 1H895w_I71CS9ThlVcE2SstraeSP9AHfm, not the initial folder name. Therefore, selecting that variable as a folder name achieves nothing.If you have further context questions, feel free to ask. I appreciate any help.
Hi All, I’m looking for a way to adjust who receives email notifications for particular zaps. Ex For Zap A, I want someone in marketing to receive an email notification for the error. They are a member of my Zapier account as well. Appreciate the help.
I currently use Asana for project management. Each one of my projects follow the same project milestones, and I would like to create an automation that follows this logic: Step 1) Project milestone completed in AsanaStep 2) Completion of milestone task moves the project stage in HoneyBook to the next stage in the pipeline. In other words, I want to be able to mark a milestone in Asana as complete, and this move the project stage automatically in HoneyBook. I’d like this to be automated so that I am able to automate specific emails for project stages in HoneyBook. Any help appreciated!!!!
I am setting up a zap: creating a record in Lark from Google Sheet. When connecting to the Lark base, even though I got the correct app token, the zap cannot load the corresponding base list. I really hope you guys can help me.!-->
I get an email every time a product goes in (or out) of stock on my website. I have managed to create a zap that takes info from the (gmail) email and creates a new row in a google sheet spreadsheet. Format of spreadsheet is:Date, SKU, Product-name, Brnad, Supplier, Status (out of stock OR in stock).The zap is working well and all stock movements are recorded. Now I want to create a daily summary email that lists all new rows from the spreadsheet and sends them in a single email. Completely lost trying to get it to work, if anyone can help it would be much appreciated.
So I’m creating a ZAP run from Fluent form Wordpress to create a task in clickup.When I do the run it fails and gives Error message: The app returned "Value must be an option index or uuid". But if I run the Create Task in ClickUp with the record, it creates the task with no problem…. I have created formater tables for each form field that need UIID, and everything should be fine since it can create a task in clickup when in draft, but when I go live it fails:
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
