About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials Zapier University 101

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Popular Apps Q&A Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

Interest Areas User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier University Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Get Help

Find answers to your questions. Ask the Community for help or hire someone to help you.

15737 Topics

M
MathiildeBeginner
asked in Code & Webhooks

How to automatically run code from Google Sheets script?

Hi there ! I am trying to run a script (in javascript) automatically. The trigger in the google app script do not work but when I run my code manually it is correct. Here the code : function deleteRows() {var ss = SpreadsheetApp.getActiveSpreadsheet();var s = ss.getSheetByName('Feuille 1');var r = s.getRange('A:A');var v = r.getValues();for(var i=v.length-1;i>=0;i--)if(v[0,i]=='a')s.deleteRow(i+1);};I have tried to use the “code by Zapier” action bu it does not work either. Here the error message I get : Error: You did not define `output`! Try `output = {id: 1, hello: "world"};`Does someone know if it is possible to code a google sheet code in the action code by zapier ? And why does it not work ?  Thank you all for your time :) 

3
GetUWired
1 year ago
W
wannabe_erikaNew
asked in How Do I

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? 

1
AndrewJDavison_Luhhu
1 year ago
K
Karl-OttBeginner
asked in How Do I

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?

1
AndrewJDavison_Luhhu
1 year ago
S
Simon AltiNew
asked in How Do I

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,  

1
SamB
Community Manager
1 year ago
R
redrNew
asked in How Do I

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

2
R
1 year ago
S
SGSBeginner
asked in Code & Webhooks

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!

8
S
1 year ago
J
JescoMarineBeginner
asked in How Do I

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!

2
J
1 year ago
S
stuartNew
asked in How Do I

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?

1
robschmidt
1 year ago
A
a1angeles
asked in How Do I

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 

3
SamB
Community Manager
1 year ago
D
derkNew
asked in How Do I

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?

1
robschmidt
1 year ago
M
MIGlobalNew
asked in How Do I

Zap keeps turning off but doesn't error

One of my zap keeps turning off automatically, I keep switching it on and it keeps turning itself off. There are no errors reported. Please can someone help fix this issue, thanks!

16
SamB
Community Manager
1 year ago
L
LucyCCBeginner
asked in How Do I

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!

2
L
1 year ago
M
Marvin1234New
asked in How Do I

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

2
Troy Tessalone
1 year ago
A
AripBeginner
asked in How Do I

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!

3
I
1 year ago
K
Kasim21Beginner
asked in Troubleshooting

'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

2
Z
1 year ago
D
drodriguezNew
asked in How Do I

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

1
Troy Tessalone
1 year ago
M
Monica LumbusBeginner
asked in How Do I

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 

2
M
1 year ago
I
IngridesignBeginner
asked in How Do I

How to connect Zap to Stripe page payments?

Hello, I have created a Strpie page for my clients to register for a masterclass. I don’t know how to add it to the Zap so when the payment is succesful people receive an email with the webinar info.Where can I add the Stripe payment page please ?

3
Troy Tessalone
1 year ago
G
GabrielNovaskiBeginner
asked in How Do I

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

3
G
1 year ago
S
simmonetNew
asked in How Do I

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 

3
samiabid
1 year ago
B
BeerfarmIainNew
asked in How Do I

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

1
Troy Tessalone
1 year ago
S
sydq22New
asked in How Do I

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?

1
Troy Tessalone
1 year ago
G
GrizllarNew
asked in How Do I

Can’t connect Zap to different Todoist account

When creating a zap between Google Assistant and todoist. It is automatically logging me into todoist for a different account. It will not allow me to change login info for todoist

1
Troy Tessalone
1 year ago
M
MeetaYogaNew
asked in Code & Webhooks

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.

1
SamB
Community Manager
1 year ago
L
LukeSummersBeginner
asked in How Do I

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 me@xyz.ca 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 me@xyz.ca 1234567789 Jan 1, 2021 14570 1 PS03 002 - The King Jonny Rockets me@xyz.ca 1234567789 Jan 1, 2021 14570 1 PS03 002 - The King Jonny Rockets me@xyz.ca 1234567789 Jan 1, 2021 14570 1  Is there a solution to this?

5
GetUWired
1 year ago
Terms & Conditions