Find answers to your questions. Ask the Community for help or hire someone to help you.
How to automatically run code from Google Sheets script?
Possible to publish Reddit posts at specific times using Excel?
New to this program and I’m wanting to make Reddit posts from an Excel spreadsheet that will post at specific times that will be noted in the spreadsheet. I don’t see a way to add this in the usual Excel > Reddit task. Is there a way to do this?
How to print custom labels in Outlook from WooCommerce orders
HeyWe are looking for the most effective way to get a custom label printed out for each new order we receive from Woocommerce.Right now the best solution seems to send the order information to an e-mail and let Outlook automatically print the mail out with the data we choose. Although we can’t format the information in mail to a “label-friendly” size. Whatever set up we choose, Outlook still wants to print A4 scale to 1.1 x 3.5 label :) Maybe there is a better way the get the custom label printed out when new order arrives?
Facebook Lead Ads data not sending to ActiveCampaign
Bonjour, Nous utilisons actuellement les 15 jours d’essai gratuit pour créer un formulaire Facebook Lead ADS. Notre CRM est Active Campaign. Les datas ne remontent pas sur Active Campaign lors de nos tests alors que notre Zap nous semble bien paramétré. Pouvez-vous nous aider à ce sujet ? Merci à vous,
When new EventBrite event is published the Zap is not creating event record in Salesforce NPSP with event details
Hi All,I’m new to Zappier so still learning. We are trying to creating an integration between Eventbrite and our Salesforce NPSP Test Org using Zappier. Basically what we want to happen is when a new event is published in Eventbrite an event record for that event should be created in Salesforce in our custom object ‘Training_Course__c’ which records training courses.A Zap has been created already between Eventbrite and Salesforce and the connection has been tested successfully with an event record successfully created in Salesforce for a selected recent event that Zappier has found from Eventbrite. See Below However, when a new Eventbrite event is published the Zap is not creating event records in Salesforce with details of the new event record but keeps creating an event record with the details of test event Zappier found that was used for the Zap connection test. See below :Is there something missing or an additional action that’s required? Any help or guidance would be great
New lines in Webhook field causing JSON payload error
I have a Zap that pulls information from a Task in Freshsales, then appends a URL to the end of the description field. It works fine MOST of the time, however it fails whenever the description has new lines in it. It reads the description just fine in the initial step, but when it PUTs the data back I get the error “The app returned "There was a problem in the JSON payload".”I assume there’s some way to translate those new lines into something Freshsales recognizes, but I have no clue how to do that, and it is strange that it outputs it in that format but won’t accept it as an input.Thanks in advance!
Looking to email Leads in ADF/XML format using Outlook
I’m new to this. Problem in need of a solution: I have a new CRM system that needs emails to be sent in a ADF/XML format. Quite a few of our lead sources do not send in that format. I’m looking for guidance on how to create a zap that will take those leads and covert them into an ADF or XML message to send into my CRM. Thank you!
Help Needed on integration between Typeform and Kajabi
HiI am in the process of completing an online training course and will be using typeform to get feedback from attendees after each lesson.I also use kajabi as a delivery platform.My question is when the attendees complete the typeform and add their email address etc and click submit is it possible to use that submit button to pass it the completed form to kajabi and it enter a kajabi email sequence through a zap? In know that there are zaps and integration between the 2 platforms but I cannot find the right one? Anyone know an answer to this?
How to extract last item from a field using Formatter?
I’m trying to work with a public RSS feed that shows weather data. The RSS feed has 1 field (called “Description”) that shows a bunch of measurements/info. The last item in that field is Water Temperature in °F and °C.I need to extract just the Water Temperature measurements and pass that along to the next step.I’m using the Formatter app → Action Event is “Utilities → Transform is “Pick from list” → Operation is “Choose last.” Next step (Insert Data) is to select the “Description” field. So far so good, but the output is, like, 90% of the measurements/info when I only need the last 10%. I don’t see a way for me to specify the last x characters or select the text immediately after the constant title “Water Temperature.” Any ideas on how to proceed?This is the link to the RSS feed: https://www.ndbc.noaa.gov/data/latest_obs/46254.rss
How to convert comma-separated values into individual fields?
How would I go about creating a Zap that dynamically adds more input fields to an action based on an unknown amount of comma separated values?What I’m looking to achieve is to convert a comma separated string of values into individual input fields, as follows: Currently this works with a known amount of comma separated urls and a Formatter module to create a list of items, which I can then add manually. This however doesn’t work if the initial comma separated url has 30 individual elements instead of just two.How would I go about creating a Zap that dynamically adds more input fields to the action based on an unknown amount of comma separated values?
Memberpress integration - trigger on new corporate subaccount?
I’m trying to integrate Hubspot and Memberpress, and running into a difficulty with updating new corporate subaccounts into Hubspot.There is a Zap trigger for a new Memberpress subscription - but this does not work (it does not pull in the data for the person who created the subscription, only the transaction information). And the trigger for ‘update a memberpress account’ does not get fired when the new corporate subaccount is created, only if the new person then goes on to update their account in some way.Has anyone come across this and figured out a way to get it to work? Thank you!
How to delay action for 90 days?
Hello community,we have a trigger that gets a date/time field, getting the data as “modified on”.I want to filter/delay or anyway, that after x amount of days, the action takes place (sending an email)How do I do this? Like for example using the filter option.Only continue if..“modified On” - “date/time” After - 90 days. Is there a solution for this? Thank you a lot
Cant Sent messages from Facebook Messenger.
I m tring to use a Jira Service Desk Integration with messenger. The issues in JSD is created from Facebook messenger perfect!But when i try to makes some updates and that update need to be infromed to the conversation always give me the error :“You can only send an automated message to the user with a PSID of '234567890123456' within 24 hours of them having sent a message to your page.”I can’t use it.Could you give me some help?Thanks uin advance.Regards!
'Search Mention in Twitter' trigger giving different results than on Twitter
Hi all, I am trying to set up a Zap using Search mention in Twitter trigger. I want the Zap to return search mentions from my followers that contain the terms ‘Paper’, ‘Article’ or ‘Study’ and that contain an URL.My problem is that the search term I have made using Twitters advanced search function (see below) returns the correct tweets in Twitter, but it doesn’t return the same Tweets (or tweets meeting that search query) in Zapier. I have tried putting these queries as plain text and as URL encoded queries (see below). In Zapier, the trigger either fails to find any mentions or it provides a mention from an account I don’t follow with none of the keywords I entered.Are there any suggestions for why this might be happening and how to fix?Search Query: paper OR article OR study filter:follows filter:linksURL encoded search query: paper%20OR%20article%20OR%20study%20filter%3Afollows%20filter%3AlinksThanks in advance, Kas
Trigger auto reply when email is clicked?
First of all, forgive me if this question has already been answered but i couldn’t find one that matches exactly what i’m trying to do (if it’s even possible)So, i know there’s different ways to set up forms to send automatic replies, but i’m trying to skip the form completely on this one. I would like to send emails to contacts that already belong to my database (not new ones) to confirm their attendance to an event. So what i need from zapier is to figure which of the contacts clicked on the email.My company uses Masterbase to manage their campaigns, so perhaps if i use a webhook to listen to a url on a button in the email...and then create an action that sends a reply to an inbox with the email it came from. That way i could store all the contacts that clicked in a spreadsheet or a crm. from that point i can look for duplicates and whatnot, but to know who clicked: that’s my goal.Would this work? Is there a proper way of doing this?All information will be greatly appreciated, thanks
MailChimp tag not found
After creating a tag in Mailchimp, it does not show up when creating the zap. In “Tag(s)” I clicked “Custom” and typed in the exact MC tag and hit “Refresh fields” but it says:“We’re having trouble loading 'Tag(s)' data (Resource Not Found - The requested resource could not be found.)”I have searched for articles about this issue, but found nothing that helps. Hoping for help here. <3
Trello card creation and update date missing
Hello, how are you?I created a Zap that whenever a Trello card is moved to a specific column, it sends a message on a Slack channel.Looking at the variables provided by Trello I couldn't find two very important variables.They would be the creation date of the card in Trello and the date the card was moved to this specific column.Can anyone tell me if these variables are available?Sincerely
Is it possible to copy worksheet into an existing Excel workbook each month?
We have an Excel spreadsheet that imports and aggregates data from multiple sources (uses Supermetrics)We want to take that processed data and copy the sheet at the end of each month into an existing Excel workbook as a new worksheet - containing all that aggregated data.We currently manually create a new sheet and copy and paste the data values.Does anyone have a solution to do this with Zapier in Excel? (Note: We moved from GSheets where we had a script that did this (mostly automagically. We’re changing all our reporting to Excel, and are hoping to automate is as well. Zapier has solved so many other problems, we’re hoping it can solve this one too!)Any help appreciated. Cheers
400 Bad Request error when setting up JotForm to Zoho Invoice Zap
Hi All, I’m trying to set up what i figure should be a pretty straightforward Zap; generating an invoice on Zoho invoice when my Jotform order form is submitted. I get the following error message: Status Code 400 Bad RequestLast updated: April 20, 2020ProblemYour Zap is likely to be missing a required field, or a field value wasn't in a recognized format. For example, if a field in your action step is expecting an email address, but the value given is a name, the app may return a 400 error.SolutionCheck that your fields are correctly set up and mapped to each other.Any advice on how to resolve this in simpleton terms?thanksIain
How to send birthday emails to clients on Monday.com board?
I have a client birthday board in Monday.com that includes the date and client email in the pulse. I am trying to automatically send client birthday emails when the date arrives using the information in the pulse. Is this possible to create with Zapier?
Linking php webApp to Zoom using Webhooks
DescriptionI have built a website for a yoga teacher.This php-based website has a bespoke class creation, online payments and booking system which manages membership and sends emails containing the appropriate Zoom sign-in credentials to authorised members for their classes.We need help because:Our Meeting creation in Zoom is manual; The website currently requires that Zoom meeting credentials are copied in manually.We want to develop our website to send details of required meetings to Zoom and in turn to receive the meeting link, class ID and password from the Zoom system.When data definitions are known, my system will be developed to provide the data required by Zoom and will handle the population of the supporting database with data received from Zoom.Can anyone help with the configuration an API to achieve this? My client is not averse to hiring to reasonably priced pro to get this done quickly.Thanks for reading.
Question about line items where more than one of the same item has been purchased
Hi all,I am using zapier to output WooCommerce orders into a google spreadsheet, but I’m looking for a way to separate quantities into individual line item entries. So far I have been using the line item feature to separate different products, but I want to go one step further so that each item has its own line.So for example, an order that looks like thisSKU ITEM NAME FIRST NAME LAST NAME EMAIL PHONE ORDER DATE ORDER ID QUANTITY PS03 002 - The King Jonny Rockets email@example.com 1234567789 Jan 1, 2021 14570 3 Would end up being outputted onto my google sheet like soSKU ITEM NAME FIRST NAME LAST NAME EMAIL PHONE ORDER DATE ORDER ID QUANTITY PS03 002 - The King Jonny Rockets firstname.lastname@example.org 1234567789 Jan 1, 2021 14570 1 PS03 002 - The King Jonny Rockets email@example.com 1234567789 Jan 1, 2021 14570 1 PS03 002 - The King Jonny Rockets firstname.lastname@example.org 1234567789 Jan 1, 2021 14570 1 Is there a solution to this?
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.