Find answers to your questions. Ask the Community for help or hire someone to help you.
Pattern matching from Shopify
Hello,I’m hoping you can help me :)I’m connecting Shopify to my accounting software. All was pretty straightforward, the last thing to get right is the ‘Project’ so I can allocate sales properly.Each product I have has it’s own project and my book keeping software requires each to have a number prefix - e.g. ‘01 Project Name’When bringing a product in from Shopify, the product name doesn’t have the ‘01’ infront of it and so the two don’t match-up. Is there a way to add a regular expression before product name so that I’m able to get everything connected properly?Thanks in advance for your help.Ashley
Two zaps with the same trigger on one Linkedin LeadGen form
Hi,I am having issues on a Zap with a Linkedin LeadGen Form trigger:I have an older Zap activated and working on a Linkedin form. This one captures form responses and stores them in a google sheet. Now I am creating a new Zap, that has the exact same trigger (Leadgen Form Response) on the exact same Linkedin form. It passes the form response data to another platform using a custom webhook. However, when I activate this new zap, nothing happens when I get a new form response. The old zap still works though. When I test my new Zap, it does find new form responses to test with. So it looks like the connection is valid. The webhook alsio works fine. But when I activate my Zap and enter new form responses, the trigger does not get triggered. Are there limitations on the amount of identical triggers on a single Linkedin Form? Thank you.
Pipedrive - round robin where leads are not distributing evenly
Hi All, I created a zap to distribute leads across our sales team evenly through a round-robin. When I checked this on Pipedrive after a month, I could find that the lead distribution is not happening evenly. It is skewing towards a few sales agents, and some are barely getting any. I set up the zap as belowI’ve Created a zap to distribute leads evenly across our sales team We have a team of 20 sales agent and have used the appropriate formulaAdded the IDs of our sales agents Mapped the owner to Round robin output Please let me know if there are any errors and how I can rectify them.
How to add Mailchimp groups to Google Sheets?
I’m trying to add MailChimp audience to google sheet. I can select all the MailChimp columns except groups. Only way I can access groups by using these values but how can we access individual group values ? If I use Merges Groupings it insert all group values together to google sheet column.How can we add one group column of MailChimp to google sheet column ?
Regular Expression - pattern extract based on previous word?
Hi folks, I’m struggling to figure out a very specific regex pattern matcher. I need to extract some question answers from an email job application using the plain text field extracted from the email. These are single word answers as so: This is an employer-written question. You can report inappropriate questions to Indeed through the 'Report job' link at the bottom of the job description. 'Do you have experience providing care in the UK?' Yes This is an employer-written question. You can report inappropriate questions to Indeed through the 'Report job' link at the bottom of the job description. 'What is the first half of your postcode?' Wv12 This is an employer-written question. You can report inappropriate questions to Indeed through the 'Report job' link at the bottom of the job description. 'Do you drive and have access to a vehicle?' Yes This is an employer-written question. You can report inappr
Hire expert to create SMS notification when quote status is "sent" in Xero
Hi,We need the ability to send our customers SMS notifications when a new quote status is "sent" in our Xero account. Also we need the ability to do the same when a new invoice is created and status is "approved".I believe that we need to use Web hooks for this but don't have any experience with this. Can anyone help?
Add songs to different Spotify playlists based on different columns in Google Sheets
hi! I wanted to know if it’s possible to connect Zapier → Google Sheets → Spotify so that when I add certain values to a spreadsheet, for exampleAdding spotify URL to Column A → adds song to Spotify playlist AAdding spotify URL to Column B → adds song to Spotify playlist BAdding spotify URL to Column C → adds song to Spotify playlist C etc, is this possible? I spent a long time looking online but I did not find a solution
How to allow Zap to continue if no file is uploaded to Ninja Forms?
I have a zap created that sends data from a Ninja Form to a Google Drive folder and Google Sheet. There is a “non-required’ file upload field on the Ninja Form. If the user uploads a file to the Ninja Form, the file is sent to a Google Drive folder. All data from the Ninja Form is sent to the google sheet with the exception of the file upload field. I have that this mapped to the “Alternate Link” from the Google Drive. If the user uploads a file to the Ninja Form, everything works correctly. However, if they do not upload a file to the Ninja Form, then no data at all is sent to the Google Sheet. I see an error in the zap history…“Required field "file" (file) is missing.” “This Google Sheets step didn‘t run because it depended on a previous step or filter that wasn‘t successful.” How do I get the zap to accept that someone may not upload a file and still send the remaining data onto the Google Sheet?
Can’t select shared Google Form from dropdown
Hi, When I am setting up the trigger to link a google form to a google sheet I am not given an option to choose the form i need in a drop down. My email is signed in, but the shared drive option is not showing. Am I unable to link google forms in shared drives?? Thank you
Update Hubspot line items when PandaDoc is sent or completed
Hi!I am looking to have my deal’s line items in hubspot updated with the appropriate amounts, values, discounts etc. I think I may just be using the wrong steps or not enough action steps as I am continually getting errors.Current Zap-PandaDoc Trigger - Document Status Changed in PandaDoc-Hubspot Action - Find deal in Hubspot-Hubspot action - Update line-items in hubspotI saw on some other threads I may need to create an association possibly?Currently the native integration sends line items and other variables into PandaDoc so there is already an association.Any guidance on action steps or object ids would be very helpful! Thanks
Slack automated reply between certain hours
Hello everyone, I’m looking for some assistance on how to use Zapier with Slack to post an auto-reply to any Slack messages posted in a channel between 5pm-8am. Any help or direction on if this is possible and how to accomplish it would be appreciated. ExampleUser posts message in #example-channel at 5:34pm Zapier checks the message and recognizes it was posted between the hours of 5pm-8am Zapier triggers a custom auto-response message to the user in that Slack channel
Upload DocuSign to Google Drive Folder - Access Denied
I have a Zap that is designed to upload a completed DocuSign to a Google drive folder. The account I’m using for that portion is the owner of the drive/folder, yet I’m getting “Access Denied”. This Zap worked an hour ago, but now will not. I’ve tested my GDrive app authentication in Zapier via connections and that is successful, yet this Zap won’t work. Any ideas as to why?
“Request has expired” error when uploading Asana attachments to Google Drive
Hey guys, I’m getting a “The app has returned: ‘Request has expired’” error when automating uploads of my Asana attachments to Google Drive (not Google Drive to Asana).Our team does construction work in the Colorado mountains. We track each project in an Asana card and upload photos of the completed job using the attachments feature. We don’t want to have our data trapped in Asana should we ever change platforms, so we are trying to backup our projects into Google Drive. My Zap looks something like this:> When ‘TRIGGER’ in Asana> Create new Folder in Google Drive> Create text file in Google Drive (custom data from Asana fields ‘Owner’, ‘Address’, ‘Phone’, etc)> Upload attachments from Asana to Google Drive On the last step I get a “The app has returned: ‘Request has expired’” error. Our Zap is set up like this: As you can see, the Zap identifies the ID of the Google Drive folder we just created, then attempts to pull the attachments download URL from Asana.I noticed that
Xero to send SMS alert when quote is sent
Hi,I'm trying to create a Zap between Xero and ClickSend so that when a quote is sent via Xero it automatically send an SMS alert to the customer with the link to the quote. I know this is possible when a new quote is crested, but the action doesn't exist for when a quote is sent. Am I trying something which is not possible? If so, can Zapier add custom actions for us if we ask nicely? :-)
Segmenting user email into numerous constant contact lists based on form submission
Hi everyone,I want to set up a zap that pushes a user email into multiple different lists within constant contact based on what boxes the user ticked on a form built in squarespaceFor example, if a user fills out the form and ticked two boxes, one for news and one for events i’d like their email adding to the news list and events list in constant contact.Any help would be appreciated.Thanks,
New task in Asana to Google Sheets
Hi there! We’ve been using Zapier for a quite some time for transferring data from Asana to Google Sheets. The process is simple. We’ve got several projects: one project for one legal entity. We also configured two ZAPs fro each project:New Row - this Zap adds a new row to a Google Sheet when there is a new task added to the project Update Row - this Zap takes ID of the task, looks through the column with IDs on a specific Google Sheet (the one, where first Zap pastes the data), identifies required row and updates it every time the task itself is being updated. The process is very simple and straightforward. Today for some reason all our “New row” tasks for 5 projects stopped working all at once. At the same time we literally did not change a thing! In order to fix the problem we tired the following:Log out and log in: Zapier, Asana, Gmail Test trigger and test action for each “New row” Zap - everything works fine. Trigger says “we found a task!” and Action successfully adds a new row
Pardot permissions error - 'Error code: 46'
We have a Zap set up to create a prospect in Pardot whenever a LiveChat session is finished. It was set up without any problems and has been running fine for the last 2 months. The individual who set it up no longer works in my department, so I went to update the zap with the new LiveChat account and Pardot account to sync and we’ve been getting an error (46): Pardot ran into an error: This API user lacks sufficient permissions for the requested operation. Error code: 46.I’ve checked with my IT department and I have the same permissions as the previous account. Why would I still be getting this error?
Create custom Shopify order with Typeform
Hi everyone!I have a Shopify Store and want to sell a custom health product. I need to ask the customer a few questions before I can let him order my product. For that I created a Typeform that he can fill out. The idea is that the customer just answers a few questions to create an account and to get directed to the shopping basket with the product in it. He can then just click order. I on the other side can then see his product wishes attached to the order. Do you know if and how I can make it possible to:1. automatically create a user account from the information the customer provides in the form and then2. somehow attach the product relevant information to the order.
WooCommerce Subscription Rebilling Data Change
I have a client that is trying to make it so that a specific type of subscription order customer gets a free month. To do so, we need to change the re-bill date on that subscription +1moWhen trying to update the subscription for the customer, I keep getting a 400 error and cannot figure out why. This shows me manually trying to put in a date. I have tried different date formats as well. Ive tried pulling the order date and doing +1y, +1mo Even when I leave the date blank im getting the 400 error
GoogleSheets tests not successful
I’ve got a Zap set up that runs from webhook to update contact in Active campaign and then add new line in Google Sheet.Active Campaign is populating but the sheet is not. I changed to a new sheet to test it and it worked. I changed back to the original sheet and ran a test. It said the test was successful and it was not.Do I need ot create a new sheet and start over??
Shared SMS apps that integrate with Google Contacts
We have been reviewing SMS Shared text messaging apps such as Salesmsg, Text Magic, Prokeep etc What we are struggling to find is an app that allows us to integrate our google contacts such that we would us in regular texting app into a shared messaging app. We currently use google Messages on the desktop because we deal with so many contractors, but wanted to have a way to centralized those exchanges in one manageable place. that is why we are looking to shared messaging apps but we dont want to lose the integration with google contacts and have to import them all trying to keep them in sync.
Possible to only continue Zap when Asana task is complete?
Hi all! I have created the following zap: Fill out google form Form data is put into a google sheet Delay until 06:00 in the morning At 05:00 in the morning parabola does some google sheet restructuring and fills in the blanks Google doc is populated from template Task is created in Asana for approval An e-mail is sent out as a notification to check the Asana task Only continue if... Asana complete is true (so if we have completed the task) <- this is the tricky part Generate and attach pdf and send out to the right person.This is all instant, so the moment the Asana task is created and I should be checking, the zap already continues and concludes that the Asana task is not completed. So the zap run stops. Once I have completed the Asana task it doesn't continue, because it would have to re-run the whole zap. The only solution I can think of is to put a delay in there for about a day to have the time to check on an Asana task, but that's not productive for me. Is there a way to have
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.