How Do I
Post here if: you're wondering how to do something, whether it's even possible, or don't know where to start.
- 15,297 Topics
- 52,793 Replies
Hi, I’m new to zapier. I have a Zapier integration with a cloud based system called Arlo. It is exporting data fine into Zapier. Zapier then sends this data to MS Excel 365 into a spreadsheet. This Spreadsheet then uploads to Brick FTP. All fine. however the format the excel file is uploaded to is .xslx Our internal sales and accounts pacakage requires this file to be in .csv format in order to pull the file in from Brick FTP. Is there any way in which I can convert the .XLSX file to CSV? there does not seem to be a way to convert it. I have seen another post where it suggests to use Google Sheets and make the sheet publically accessible for the ZAP to be able to see the document and convert it, but this concerns me as the data we are handling contains customer information and needs to be securely handled. Thank you for any tips/suggestions. Regards Dan
We are trying to connect to Azure DevOps. However we keep getting a message that our account is expired. However when we use the function of webhooks and catch hook and connect to our DevOps account manually it works. We really would like to use the functionality of Zapier to exchange information between our other apps and Azure DevOps through Zapiers connector, but we are unable to get the account to connect properly to do so. Has anyone experienced this problem and know how to fix it? I saw previously that some clients were having issues with Client Secret Expired, but that is not the message we are receiving. We are recieving this message:
Hello,We started to use Notion at home, for organisation, menus, grocery lists, etc. Wanting to go a bit further, we discovered that it was possible to use Zapier to link some databases to our Notion. Sadly, this option doesn’t seem to be available with MyFitnessPal (yet), an app that allows to track the different nutrients in your daily food consumption, among other things. Basically, what we want to do is twofold : link every ingredient we use to MyFitnessPal database and associate these products to their nutritional value (fat, protein, salt, etc).My questions are then as follow :-Do you know if it’s already possible to link Notion & MyFitnessPal ?-If not, could anyone create an API to do it, or link me to people who can do it ?We are no coder ourselves, so it’s out of our possibilities on our own.Thank you in advance
I can’t seem to get True/False fields to send properly between Airtable/Webflow via Zapier. In a zap I have set up, when a new row is created in Airtable, my second step is to Update Live Item in Webflow. One True/False field is titled “This Week?” which acts like a manual “featured” section. Below, I set it to be custom/dynamic based on the value from the first trigger: I then complete the rest of Customize Item and whenever I move to Send Data then return to Customize Item, the zap becomes overwritten with a constant value from Webflow “True” When I test the zap, the test case sends “true”. However, when I turn on the zap, every single trigger sends True rather than being based on the dynamic content of that field. If I change my test case to be false, the same thing happens but with false. My main question is how do I get the zap to be based on dynamic content rather than defaulting to a constant value. On a separate but related note, I notice that Webflow doesn’t send True/False
Hey guys,I’m hoping to get help from people more experienced than me. What I’m trying to achieve with my Zap in a simplified step by step:1. Someone submits a Google Form2. Add data from the form to a new row in the Sheet3. Update the request number +1 to the previous request number I don’t know how to get the request number from the already existing last row at the moment of creating a new row. I can’t look up the spreadsheet because I don’t have any value that I can input because none of them are known in advance. Request # Date of request Full name Email Sample column 1 6/30/2021 18:46:38 Sample Name email@example.com 2 6/30/2021 22:25:28 Sample Name 2 firstname.lastname@example.org 3 6/30/2021 22:32:48 Sample Name 3 email@example.com The number in Column 1 would need to go +1 every time a new row is created. Should I use a formula for that? I’m not familiar with them though. Sorry if there is an answer for this already but I really tried to look fo
When I post a test message the icon that I created for the bot never shows up. Its stays empty, doesn't show zapiers logo as well. I tried multiple times different icons and URLs and it stays still empty. :) Does anyone have the same issue? Would be so happy to get advise.
Is it possible to create a Zap or Zaps that will bring in attendane records from Zoom (First, Last, email address), meetings attended (e.g. meeting id, meeting date, meeting name), and total time spent in each meeting (aggregated not multiple times) per user per meeting into a Google Sheet?
I needed to run a “find” function on an app that would return an error if nothing exists. I used this clever strategy to complete the “find” using a test variable in Story by Zapier: However, my Zap will always have at least one error when it runs, so it will always turn off! I need my zap to stay on, even after it experiences an error. Is this possible? If not, is there a way to get around this? Cheers, Tristan
I get an automated email every monday, and I want to take the .png file that is embedded in the email and push it to other apps (end result will be displayed on a screen in the office). I'm hitting a snag - i tried the auto-attachments save through gmail but the email has a few inline attachments so it zips all these into a folder. I tried zapier parser but can't seem to get a URL for the .png file I want as the html uses CID. Any ideas?
Hi! I'm new to Zapier but very excited about the possibilities! I'm doing a Zap where I'm taking data from a Google form and using it to write data to Firebase. Everything works fine with just one problem -- Zapier is writing by boolean value as a string. I want false instead of "false".Is there a way to tell Zapier to create a bool instead of a string?Many thanks for your help.
Hello,I have read multiple historical posts on this issue, but I still don’t get it…What I’m trying to do: When a new event happens in Stripe, update/create a row in Google Sheets.It, of course, is asking me to map a “row ID,” but no documentation explains:Is it looking for a field literally called Row ID? Or is it simply referring to a reference or function of what field I choose to be the Row ID? Does it want the row ID that my Google Sheet has automatically created? Does it want some ID field that Stripe is creating to be imported into Google Sheet? Does this row ID info “talk” from Google Sheet to Stripe or from Stripe to Google Sheet?And, I seem to be caught up in a loop. My Zap includes:Trigger: New Event in Stripe Action: Find or Create Row in Google Sheets Action: Update Spreadsheet Row in Google SheetsBut, every time I try to complete Action: Update spreadsheet Row in Google Sheets, it always loops back to making me create a NEW action to look up the row in Google Sheets so I
Is it possible to invoke a zap via a rest endpoint? I want to create a Zap that looks up a record in Salesforce but have it invoked from a lambda function that I’ll create. From what I can tell Zapier doesn't have API endpoints for consumers, only partners, but maybe I’m wrong?
Hi, I’m extracting text from an email to send tweets. (Each tweet is about a new publication in a journal.) Problem is, each email might contain multiple matches to the pattern I’m looking for. So, I used “Text to Line-Item” to split the email into lines, and search each line for the pattern. So far, so good. E.g. I have an email that gets split into 5 lines, and of those 5 lines, 2 contain the pattern. All five lines are then output as line items. Like so: 0: _matched: false 1: 0: title of first publication 1: author of first publication 2: DOI of first publication 2: 0: title of second publication 1: author of second publication 2: DOI of second publication 3: _matched: false 4: _matched: false This is where things get difficult. I want to build a tweet from each line item that matched the pattern. But when I put in a step 4 to do this, I’m not offered the right inputs. What I get instead of items 0-4 is a dropdown showing me either “Output” (
A line item amount comes out of Stripe in cents like below for a $22 sale: 2200 How does one use the Formatter currency function to convert 2200 to $22.00. Zapier documentation directs me to this page but I can’t wrap my head around the unicode stuff. http://www.unicode.org/reports/tr35/tr35-numbers.html#Number_Format_Patterns Any help would be appreciated. Thanks!
I have a zap set up to send a message to a Discord channel with the contents of an email whenever an email with the keyword “classroom” is received, so my class can receive updates from Google Classroom on Discord. Today, it just so happened that one such email was above 2000 characters, and Zapier was unable to send it due to Discord’s character limitations. Thus, an email was sent to warn me about this problem; however, this email also contained the “classroom” keyword, and also happened to be over 2000 characters, so another warning email was sent. This process repeated itself until I woke up with 94 emails in my inbox and changed the keyword. While this may be a problem that is easily fixable by the zap owner by modifying the keyword a bit, I believe there should be some sort of system in place to prevent this type of thing from happening. Three solutions I could think of off the top of my head would be: Ignore emails from Zapier - however, some people may need these emails for
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
Hey folks, I needed your assistance with an issue. I have an Airtable base with two tables: Requirements and Clients. The Requirements table receives orders, even from Contacts who are not in our Client list yet. Once they put in a Requirement, we use Zap to create a new entry for them in the Client table. Since the Client entries are made dynamically, we cannot pre-populate the Client table. As a result, all the requirements that come through require Zap to be linked from the Requirements table to the Clients table. Now the issue is that even thoguh the Requirements column on the clients table is a field that allows linking to multiple data entries, Zap does not update the Requirements column on the clients table with multiple fields. It always replaces the old Requirement links/entries associated with any Client, with the Requirement ID for a new Requirement made by the client. I want the field to hold multiple entries for the older ones, on the basis of their business n
Log in to the Community
Use your Zapier credentialsLog in with Zapier
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.