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

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

How Do I...? Troubleshooting 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 Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

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

Featured Articles Show & Tell AI Hub Zapier Tools Hub

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

User Groups

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

Zapier Learn 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.

25320 Topics

A
Anonymous
asked in Troubleshooting

Email id field getting appended with the letter "k"

Yesterday the integration between my google form and Salesforce was working like a dream but today there seems to be an error. the integration is happening but when a record is getting created in salesforce the email address in the email id field is getting appended with the letter “k” I tried creating a record at least 6 times and with different email addresses but each time the same error gets thrown. Any idea why ? 

1
Troy Tessalone
2 years ago
Z
zymshadyBeginner
asked in How Do I

How to update multiple rows in Google Sheets?

i only found a trigger to update a single row in googe sheets, i would like to update multiple rows at once since tasks from asana is moved from a section to another.

4
christina.d
1 year ago
D
dane78Beginner
asked in Code & Webhooks

Zap not triggering for new webhooks sent

h teamI have created a ZAP which should run a triggert by a webhook. after subscription i got the hook urlas i run the following code (same from postman) i can see the hook in the monitor but nothing actually happned in the zap (emai/goolge sheet) am i missing something? await fetch("https://hooks.zapier.com/hooks/standard/5461766/f82abd556c744950bb4804b049a13eda",     { method: "POST",       body: '[{"id":20829875,"name":"M","firstname":"m","lastname":"w","company":"S","phone":"","title":"d","location":"usa","email":"xxx"}]',      headers: { "Content-Type": "application/json", Accept: "application/json", } });   

4
T
2 years ago
A
ales4New
asked in How Do I

Segmenting new Thinkific users that don't enrol

I’ve integrated my Thinkific course with Flodesk. When students enrol, they must also sign up as a new user. However, sometimes they will sign up but then exit the page and not enrol.  The problem is, if I choose the trigger event "New User", it also includes add those who have enrolled, who I don’t to include in this segment. Is there a way to create a segment for New Users who don’t enrol? Thanks!

1
Troy Tessalone
2 years ago
F
faridNew
asked in Troubleshooting

When passcode starts with “=“ it causes #ERROR message in Google Sheets

Hello all,I need some help please. I have a simple Zap that, among other things, takes a passcode from an email and places it in a google sheets cell.On rare occasions, the passcode starts with an equal sign “=”, which google sheets tries to interpret as a formula, and then spits out an error (#ERROR). I found this entry in the help pages, which discusses this exact issue: Information sent by the Zap appears in the spreadsheet as #ERROR If you see #ERROR in a cell where a value was sent from Zapier, it means Google is interpreting the value as a formula. Phone numbers containing a leading "+", for example, can cause this. Google Sheets then tries to calculate it and returns an error, as it's not a valid formula.This can be fixed by adding a single leading apostrophe character ' to the value being sent. This will force Google Sheets to treat the value as text. However I am not sure how I can do this How do I “add a single leading apostrophe character to the value being sent? Do I use ed

1
Troy Tessalone
2 years ago
B
bagrovBeginner
asked in How Do I

Automatically add songs from one Spotify playlist to another on a weekly basis

I travel a lot and I don’t always have the time to check my Discover Weekly and Release Radar playlists which are automatically updated by Spotify once a week. My goal is to automatically add all new tracks when the original playlists are updated so I don’t lose any new suggested tracks so I can go through new music once I get a chance.I know there’s a service called “SmarterPlaylists” but it is far from perfect: it adds some weird tracks to my playlists and there is no way to make it automatically check for the updates every week.Hopefully there’s a way to do it in Zapier or some other way.Thanks!

4
B
2 years ago
M
MoimemeNew
asked in How Do I

Send reminders with ManyChat 1 hour before the meeting

Hi all, I’m new to zapier, and I’m really struggling to create the automation described below.I want to send a reminder using manychat 1h before the meeting created with calendly.How would you do that? Thanks in advance,W 

1
Satya09
2 years ago
G
gandalfthekingBeginner
asked in How Do I

Google Sheets column headers all appearing in one field

Hi all, hopefully the screens will demonstrate the issue. everything was super smooth up to this stage. Whether all headers having a ‘1’ in front of them is creating the issue, I’m not sure. There seems no way to get rid of the numbering if this is the issue. I simply want each header to occupy its own field on the spreadsheet as it should do. Thanks

3
Troy Tessalone
2 years ago
R
Richard HHBeginner
asked in How Do I

How to send Microsoft Dynamics 365 mailing list contacts to Mailchimp?

Hi, I am new to this. I would like to send campaigns from D365 via Mailchimp. Does anyone have an idiots step by step guide to do this in Zapier please?I can set up a Mail list in D365, I can set up campaigns in Mailchimp. Can I send seemlessly from D365 via mailchimp with Zapier or do we need something like PowerMailchimp?

2
R
2 years ago
S
stumpystumpedNew
asked in How Do I

Updating multiple columns in Google Sheets based on Glide form answers?

I’m trying to create a super simple app with Glide and Zap that lets me record fertilizer sprays throughout the year. I’m using a form from glide to input the info in a google sheet and gathering daily weather data in another worksheet. The records need to have both weather and spray info in one place. So I have one worksheet that has Daily JSON updates with weather, and another with the form answers from the app. There’s row Ids on everything, and the spray info updates nicely. The weather I thought would be fairly easy to update, because its always the same row A (the information changes daily - it might make a difference in record history but I don’t know yet, haven’t been able to test) But I haven’t been able to grab any information from the weather worksheet and put it into the spray record sheet. When I do the “lookup spreadsheet row in google sheets” I get the “Bargle. We had trouble getting a matching spreadsheet row. :-(Error details:Nothing could be found for the search.”  Th

1
SamB
Community Manager
2 years ago
T
Thomas GeibBeginner
asked in Code & Webhooks

Webhook question field responses showing as containing “No data”

Our website has a web form that then sends the information to our CRM (Podio) for whatever reason one of the questions show the data the first time after deleting and reinserting the zap pull. But after the first time that one question zap will show “No Data”  This is also happening for the same question on our slack. We have questions with the same format that it always is showing data for any advice or suggestions?

3
Troy Tessalone
2 years ago
C
C123New
asked in Code & Webhooks

Webhook POST embed to Discord not including all information for the request

I have created a custom request to POST embedded messages to Discord, as per the below:Webhook is setup and working now after using Headers: Content-Type application/json to remove the bad request errorBut the message in discord only displays at the content line - can anyone help

4
C
2 years ago
G
g0wr1New
asked in How Do I

Create PDF file from emails

I am trying to create a zap where if an email with a certain subject string is sent to me, it automatically saves the body as a file in a specific folder. I could do all of this but I need those files to be in PDF format. How do I go about this?

1
Troy Tessalone
2 years ago
G
GulshanNew
asked in How Do I

Transfer from one Google Sheet to another that’s sorted by date

Hi All, I am transferring new joiners data from sheet A to Sheet B, but I want in Sheet B to be updated or transferred with a sorting by date. is it possible?  

1
Troy Tessalone
2 years ago
U
user138Beginner
asked in How Do I

Google Doc PDF not consistently being added to email as attachment

See previous post for background info: I have a Zap set up that does the following stepsChecks for New/Updated records in an Airtable view Creates a Google Doc from a template based on the info in the record Emails that Google Doc out as a PDF attachment to the email address in the Airtable record (By attaching the Export Links Application/pdf link from the previous step)Upon trying this again with a “Delay After Queue” step implemented, most of the emails sent were completely fine and attached the PDF as intended. But a random selection of records, the attachment to the email was ServiceLogin.htm, and my clients weren’t able to access the PDF.Anyone have this happen or have a workaround for how to prevent it from happening in the future? I received advice to try adding in the delay step - which didn’t work. I also tried doing smaller batches (I was initially doing 200 - I’m now only doing 40 - edit: tried it with 5 and it still happened) - and the issue still happened. I saw some post

1
Troy Tessalone
2 years ago
M
michalBeginner
asked in Troubleshooting

Custom Buffer profile not being selected

Hi, I’m trying to set it up so that a specific profile in buffer is loaded in to post to. This profile is loaded from a google spreadsheet and is selected under the custom tab in buffer profiles. When I load in the number under the profile name in the dropdown I get an permission error, when I load up the name of the profile I get a different error. How do I specify/taget the proper profile?  Any and all help is much appreciated. 

2
SamB
Community Manager
2 years ago
H
hano.intake.noammBeginner
asked in How Do I

Airtable cell reference empty

Hello, Trying to set up a zap that fills a fillable PDFfiller template when a new record is added to a specific grid in Airtable. In the action step when I reference a cell in Airtable, it only references a cell for certain records in the Airtable base. For other cells, it says “no record found,” and if I type in the name of the cell, it simply repeats what I typed in PDFfiller instead of referencing that cell. Ideas? Thanks!

4
Troy Tessalone
2 years ago
R
Raidan ANew
asked in How Do I

YouTube account expiring frequently

YouTube account expiring frequently

2
SamB
Community Manager
2 years ago
D
dschmidtNew
asked in How Do I

Uploading docs from Monday.com to Dropbox

Hello!I wanted to know how i can find a specific zap.  I am looking to integrate monday.com with Dropbox or Google Drive.  I was hoping that all of the documents from one board could be upload to Dropbox once they are uploaded to a specific board in my monday.com account.Thanks!David

1
Troy Tessalone
2 years ago
D
DarbyONew
asked in Troubleshooting

Creating New Zap error

Has anyone received this error recently and know how to fix it?I’ve been trying to create a new Zap and keep getting this error.Also some of my Zaps (that were working fine before) are not turning on.  

1
Troy Tessalone
2 years ago
E
Erwin MollerBeginner
asked in How Do I

Finding the last email received

Hey! I need a way to set up a reply to the last email (gmail) thread that was answer by a client. So i dont want to create a new email thread, i want lo reply to one that already exits, and i want to find the more recent one. I tried using the “Find email” from gmail but i dont know how to set it up to find automatically the one with the more recent answer. And then i put the “Send email” step.  Any help is appreciate! 

7
Troy Tessalone
2 years ago
M
mroseBeginner
asked in Troubleshooting

Asana New User trigger not working

Hi Zapier community!  I have a zap that’s intended to trigger whenever a new user is created in Asana.  This is part of an onboarding flow, and the idea is that once the new user logs in, the zap will find certain tasks and assign the new user to those tasks.  However, we added a new team member this week, and the zap did not even run.  How can I troubleshoot this, please?  Thank you!

5
Troy Tessalone
2 years ago
A
AshleyAFNew
asked in How Do I

Set trigger for Zaps from emails sent from Zapier

Hello I need help with setting up a trigger/event for after Zapier has sent out a confirmation email to my new subscribers. I’m not sure which option to choose from the drop down menu options.

8
Troy Tessalone
2 years ago
O
OmnaNew
asked in How Do I

Replace all text after “-” in a single text string.

Can someone share the exact regex formula? I don’t know how to code. 

1
Troy Tessalone
2 years ago
I
imercannNew
asked in How Do I

Convert Yes/No Text to Boolean Values

Hi all,I am trying to integrate Facebook Lead Ads with Workable. I have a field on facebook lead ads that returns the answer Yes or No. However, Workable needs the answer in boolean format as true or false. How can I convert the values to boolean?

2
Troy Tessalone
2 years ago
Terms & Conditions