Find answers to your questions. Ask the Community for help or hire someone to help you.
How to parse HTML email to Google Sheets?
Hi, Hoping I can please ask a quick question to know whether this is possible to achieve in Zapier. I'm looking into connecting Gmail and Google Sheets.We receive a ton of sales enquiry emails and a major problem is manually inputting key details from every email into google sheets. So, I would like to transfer the relevant information into google sheets.The sales enquiry emails are in HTML format. When inspecting the source code, I believe each email has a standard setup, however with a unique user reference.Such as:m_1200445894070286815consumerm_3632404488982992166consumerm_2679513591627079049consumerI would like to parse and transfer only relevant lead details from the email and not the whole email contents into google sheets. Please find below a sample of how this email is setup in the HTML email.For example, I want to extract value from span tags with ID [m_'userref'-fieldname]Would anybody be able to confirm that this is possible with Zapier and point me in the right direction of
Zapier import from Stripe to Quickbooks adding VAT twice
We have an eCommerce website that is automated so when someone buys something they download it straight away. We want to make everything automated and have linked Stripe to the site and then used Zapier to link Stripe to Quickbooks to create a sales receipt and expense for the fee. The only issue I am coming up with is that the prices on our site and the sales Stripe takes include VAT but I can not work out how to tell Zapier to tell Quickbooks that. So when a sales receipt is created in Quickbooks it is adding VAT again - therefore all the prices are wrong i.e. £12 sale (which includes VAT) but when sent to Quickbooks the sales receipt says £14.40 with £2.20 VAT so it has added it again. Any ideas who to move this across to include VAT so that is shows up correctly on the sales receipt as being £10 services + £2 VAT = £12 total sale?
Is there a way I can add an action to delete or avoid duplicated Google Sheet rows in my Zap?
Hi,I have a zap to move reports our CRM send me regularly to a single Google Sheet. The problem is that each new report contains old data, plus new data. So every time a new reports come, all the old data that is on the spreadsheet is duplicated on the table. I want to know if there’s a way I can add to the zap an action to delete duplicates, or just to avoid adding duplicates rows.
The ability to comment on Zap steps
Coming from a programming background, I would love to see the ability to make comments directly on a zap to make it easier to come back after a while. They can get pretty complex, so trying to remember exactly what something does and why you chose to do it that way can be tough if you haven’t looked at it in 6 months or more. I think it would make sense for it to be in the outline section. It wouldn’t have to be anything complicated, just a textarea type box for either the whole thing or for each section, but just something that allows us to make notes or comments. This might be a feature of the teams version, but I couldn’t find any info on it, but it should really be for anyone, it’s such a simple but vital feature.
How do I add “all products” to the ThriveCart trigger rather than entering them individually?
I’m trying to build a Zap that triggers every time a new purchase is made in Thrivecart, regardless of the product. As I add or update products, I don’t really want to go back into the Zap to add it into the long list that’s already in there. Is there a way to add “all products” to this Thrivecart trigger rather than entering them individually?
Facebook Pages New recommendation - no user ID
How is this still not sorted? pulling reviews/recommendations from Facebook doesn’t include the user name who submitted the review/recommendation.If you thought pulling reviews to place on your website was important to have the user name who posted it... you would be correct… its very important as it shows credibility. There is no reason why the name can’t be pulled as other solutions (elfsite, embed social etc) can pull all the information.
How do I use Heroku Postgres database as a trigger?
Hi dear Zapier friends, Do you know if it is possible to connect to a Heroku Postgres database?I am trying to find whether there is a firewall or something like that that would make it impossible but couldn’t find the answer out there.Thanks for your help.
How to add a Google Sheet row to another custom sheet whose url is included in a column
Hi there, I’m trying to set up a Zap that will accomplish the following:A Google form response is submitted, which creates a new row in a spreadsheet One of the columns of this spreadsheet has a url to another Google sheet I want to add the row that was created in the first sheet to the specific Google sheet with the url indicated in the first sheet’s columnI’ve tried using the “custom” option and selecting that column of the spreadsheet as the sheet to send the action to, but I receive a 404 error message. Can anyone help with this?
Bookingsync: Retreiving commission information from AirbnB bookings
Hi Everyone,For a rental agency I am currently trying to automate some accounting things for the owners. In bookingsync, I am trying to retreive information from Booking.com and Airbnb in order to show the owners of the rentals how much money they receive from each booking. I need to retreive the rental price and commission from these platforms in order to get to the payback to owners. Unfortunately, the app can read the ‘commission’ from bookings originating from booking.com, but not from Airbnb. I can't seem to find the reason for this. Anyone maybe has experience with this and could help me out?Thank you in advance!Best regards,Baruch
Zapier triggering once then not again
Hey everyone, I’m having an issue with my workflow, which is as follows: I’ve got three zaps running to:create item in Webflow/Airtable Update item in Airtable/Webflow Update live item in WebflowSo far things have been running smoothly and when a new Item is triggered a new airtable line is created housing all the datafields, which in turn are then used to populate a new CMS item being created in Webflow. Then the next trigger also works and updates things like: selling fast: true or sold out: false on the live item no worries. However, if an item is changed back to Selling fast: FALSE it doesn’t trigger the Zap and therefore nothing gets changed in airtable etc. This is causing myself and my client a lot of headaches and I was wondering what might be happening that changing the RSS feed back to an old state wouldn’t result in the update item zap triggering. Any help would be appreciated :) Adam
Hi, I’m having some trouble with our calendar integration. We would like to connect/combine three calendars into one. Whenever we create a new event into the three different calendars, we would like that to appear in the calendar we’ve connected with. How is that possible? Thank you!
Zapier disconnecting from Marquiz as account expired
I am using Zapier to connect Marquiz with ActiveCampaign. I have created zaps which seem to do this for a while then I get an integration error. Webhooks: ["Request failed with status code 410","Request failed with status code 410","Request failed with status code 410","Request failed with status code 410","Request failed with status code 410","Request failed with status code 410"]Then when I try to test my zap my connection to Marquiz asks me to reconnect as my connection has expired. Which sometimes works easily and other times is a real pain. Why is Zapier loosing connection with this app? It seems to be a common problem. How can I stop it from disconnecting. Regards Judith
Adding Multiple products in One WooCommerce Order
Hello there Fam!I need to create an order in WooCommerce whenever a Zap action is being triggered from ManyChat, Orders are being created first in ManyChat, I’m using MC data to create an order in WooCommerce, The challenge is, How to add multiple items in one order?Here is what I did:ManyChat is the trigger step, then I’m using a formatterand on ‘create an order on WooCommerce’ action No Surprise, I’m getting an error Questions1. having ManyChat Custom Fields with ‘no data’ might cause the problem?P.S. With my current setup it’s kind of inevitable to receive data from ManyChat with null values, depends on the number of which item(s) in their cart, if makes sense!2 What’s the best way to tackle this?Much Appreciated
My .pdf attachments are getting corrupted after moving them to my Parser inbox from my email.
Hello, I have an email sent to my zapier parser box, that email has a .pdf attachment. There has been no issue with this for several months but as of just recently, the .pdf that zapier moves into the destination is corrupted and only 1KB in size. Is any one else experiencing this issue? Does any one know of a fix?
Mailchimp Tag found in Zapier but not working.
I created a Zap from Google Spreadsheet to Mailchimp. Everything works fine except for the Mailchimp tags. I had no problem finding the tags in Zapier, but every time a new subscriber appears in Mailchimp (through the google spreadsheet), it is without any tags… help ?
How to calculate time difference?
Hi how do i calculate the time difference, I’m currently creating a out of office zap and our office hours are from 09:00am to 17:00. I’m currently using Woocommerce and i would like to send an email to the customer if they order outside our operation hours and in that email i like to have a calculated field into how many hours left until we are back in office. How would i go about it, i haven’t found a solution that works yet. email templateWe are currently out of the office, however we will respond to your order as soon as we return in the next (insert calculated field ) hours.
Updating Pipedrive deal from Typeform
I’ve created a typeform to collect further information from an existing pipedrive person. I ask the person to enter in the typeform the same email that is associated with them as a pipedrive person. But I want the typeform data to update their pipedrive deal. My problem is I can’t seem to find a Deal ID field. In the zap, I have a step to find the PD person using the email address, and I thought that would be sufficient to find and update the deal on the next step. If anyone can advise me I’d be very grateful. Thanks Graham
New Outlook email triggers twice
Hi. I’ve set up a Zap to trigger on new email to my inbox in Outlook. I then have a filter (looking for a keywords in the subject line).This is working, except that the Zap is triggered twice. Not immediately, but after a number of hours. Eg: 3:30am, then 10:00am.Any thoughts as to why this would be? Any filters I could put in place to stop it?Thanks!
New contact in Klaviyo creates a new contact in Hubspot
Hello - I am having trouble connecting my Klaviyo account to my Hubspot. When there is a new profile in Klaviyo, I would like to have a contact be created/updated in my hubspot account. I already have zaps set up where if there is a new contact in Hubspot, it creates a new profile in Klaviyo, but I cannot seem to get to go the other way around. Right now, I have the trigger as a new event in Klaviyo, with the metric Subscribed to List (internal) -- [the list they subscribe to is the newsletter] -- then the action is to create a contact in HubSpot, with a few contact information details filled out.If there is something that you can tell I am doing wrong please let me know!Thanks in advance.
How to add Slack thread replies to Zendesk tickets?
How does one set up a Zap between Zendesk and Slack where the parent message and subsequent thread replies are synced over to Zendesk in the same ticket? I’ve tried two different options thus far (“New Reaction Added in Slack” and “New Message Posted in Channel”), but neither of my Zaps are pulling in any thread data for me to select. It only pulls in the parent message.
Already have an account? Login
Use your Zapier credentialsLog in with Zapier
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.